Database Administrator (Junior)

Aegis Corps, Inc. Washington , DC 20147

Posted 2 months ago

ACI is seeking a Junior Database Administrator to provide the organizational support necessary to meet the needs of a high profile project. Job location is Washington DC. The Jr. Database Administrator will be responsible for testing, implementing, maintaining and controlling the organizations databases across multiple platforms and technologies (e.g., physical, relational and object oriented) in an Azure cloud environment. Ability to apply comprehensive functional and technical knowledge and programming skills in a team setting to ensure data quality of the highest level and for problem resolution is key.Job Description:
  • Perform disciplined, auditable execution of established data warehouse ETL (extract/transform/load) programs and refresh procedures
  • Execute disciplined, recurring manual data extractions, downloads, and pre-processing of FTP data files as inputs to datamart
  • Test and implement new releases to data mart
  • Contribute to the development of new methods, procedures, processes or systems and understand the impact of these changes.
  • Provide support and expertise in investigation and resolution of performance related issues for warehousing environments.
  • Proactively monitor and remedy data quality failures in recurring data mart ETL and refresh processes
  • Provide support in installing & upgrading database software and resolving database software problems
  • Perform evaluations of potential tools & utilities
  • Automate database tasks via scripting or through the use of tools
  • Proactively configure, monitor, and review statistics for errors, capacity and performance issues
  • Tune and troubleshoot software & database performance issues
Qualifications:
  • College degree in computer science from accredited university,
  • Basic knowledge and experience in SQL Server programming is mandatory
  • Some experience in other programming languages such as Python, Java, PL/SQL, .net, SASis highly preferred the more languages the better
  • Background and prior experience in working with databases in data warehousing environments is desirable
Salary will be commensurate with experience. Aegis Corps, Inc. is a growing company and there may be opportunities for advancement. We have a generous benefits package including health, dental, and disability insurance, paid time off, 10 holidays, company provided life insurance and a 401K.Aegis Corps, Inc. is an Equal Opportunity Employer.
icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Junior Oracle Database Administrator

Saic (Science Applications Int.)

Posted 2 weeks ago

VIEW JOBS 11/17/2022 12:00:00 AM 2023-02-15T00:00 <p>Job Description</p><p>Description</p><p>SAIC is looking for a Junior Oracle DBA to join our team in the Washington D.C. area supporting a federal financial client. This individual will be repsonsible for the following:</p><ul><li><p>Performs physical database administration (DBA) tasks in Oracle. Also performs basic DBA tasks in SQL Server and DB2 environments as necessary.</p></li><li><p>Designs and builds simple to complex database structures from data models.</p></li><li><p>Installs, configures and patches Oracle database and fusion middleware.</p></li><li><p>Implements HA and DR systems using Oracle Replication, Dataguard and RAC.</p></li><li><p>Builds and manages Data Guard Physical/Logical Standby Databases using Data Guard Broker</p></li><li><p>Provides rotating 24x7 on-call support for company's Oracle, SQL Server, and DB2 environments as necessary.</p></li><li><p>Participates in design reviews as required to ensure database design meets application requirements.</p></li><li><p>Designs, maintains, documents and executes database utilities to provide information regarding database activity.</p></li><li><p>Proactively performs database monitoring and performance tuning tasks.</p></li><li><p>Identify and provide solutions to performance issues in multiple database environments.</p></li><li><p>Provides automation to standard DBA tasks. Able to develop scripts on UNIX and Windows platforms as necessary.</p></li><li><p>Reviews and enforces adherence to the company's Architecture, as well as database design and usage standards.</p></li><li><p>Understands database high availability technologies and guides the company in implementing appropriate solutions.</p></li><li><p>Performs other duties as assigned.</p></li></ul><p>Qualifications</p><ul><li><p>B.S. degree from an accredited university.</p></li><li><p>Must have solid Oracle high availability and Data Guard experience.</p></li><li><p>Azure Infrastructure as a Service , Managing Oracle DB's in the cloud environment</p></li><li><p>4+ years of extensive experience with Oracle database installation / configuration best practices and Database upgrade/migration approaches.</p></li><li><p>2+ years of experience installing, building, upgrading and supporting Oracle RAC environment, ASM, Grid/Cluster.</p></li><li><p>2+ years of experience with Data Replication - configuration, maintenance and troubleshooting.</p></li><li><p>In-depth knowledge and hands-on experience in the installation, configuration and troubleshooting of Oracle products and patches, including Oracle 12c through 19c Dataguard, Oracle Enterprise Manager 12c through 19c.</p></li><li><p>Oracle WebLogic and Fusion Middleware experience 12c and above desired.</p></li><li><p>Experience or exposure to data masking desired.</p></li><li><p>Experience in Oracle 12c through 19c. based environment - architecture, installation, building, upgrading and maintenance of Oracle replication based environment in production.</p></li><li><p>Extensive experience in Oracle Data Guard replication and physical standby for Disaster recovery</p></li><li><p>Working experience of Oracle Database Appliance.</p></li><li><p>Strong knowledge of OEM Oracle 12c through 19c grid monitoring configuration.</p></li><li><p>Strong working experience with RMAN configuration, Job maintenance and backup &amp; recovery</p></li><li><p>4+ years of experience in database/application performance tuning and monitoring tools within Oracle as well as others.</p></li><li><p>Experience in database problem identification, problem diagnosis and resolution.</p></li><li><p>Experience in building data architecture models and enforcing enterprise architecture standards and guidelines.</p></li><li><p>Excellent communication - ability to explain a technical problem to management.</p></li><li><p>Ability to work on high performing teams and deliver under pressure situations.</p></li></ul><p>Covid Policy: SAIC does not require COVID-19 vaccinations or boosters. Customer site vaccination requirements must be followed when work is performed at a customer site.</p><p>Overview</p><p>SAIC® is a premier Fortune 500® technology integrator driving our nation's technology transformation. Our robust portfolio of offerings across the defense, space, civilian, and intelligence markets includes secure high-end solutions in engineering, digital, artificial intelligence, and mission solutions. Using our expertise and understanding of existing and emerging technologies, we integrate the best components from our own portfolio and our partner ecosystem to deliver innovative, effective, and efficient solutions that are critical to achieving our customers' missions.</p><p>We are approximately 26,000 strong; driven by mission, united by purpose, and inspired by opportunities. SAIC is an Equal Opportunity Employer, fostering a culture of diversity, equity, and inclusion, which is core to our values and important to attract and retain exceptional talent. Headquartered in Reston, Virginia, SAIC has annual revenues of approximately $7.4 billion. For more information, visit saic.com. For ongoing news, please visit our newsroom.</p><br> Saic (Science Applications Int.) Washington DC

Database Administrator (Junior)

Aegis Corps, Inc.