Database Administrator

Navstar Inc.; Maryland; On-site; USD 120,000 - 180,000; Full time

Job summary

Navstar Inc. seeks a Database Administrator to maintain the integrity, security, and availability of multiple databases within a large, fast-paced program.

The role covers disaster recovery, performance analysis and tuning, and policy implementation for database security. A TS/SCI clearance with Polygraph and 5+ years of DBA/Oracle DBA experience are required.

Qualifications

• Active TS/SCI clearance with Polygraph.
• 5+ years as a database administrator.
• 5+ years as an Oracle DBA.
• Experience implementing and maintaining database security.
• Experience performance tuning and monitoring.
• Experience troubleshooting/resolving database problems.
• Experience installing, configuring, upgrading RDBMS software.
• Experience with PL/SQL.

Responsibilities

• Perform daily database administration, monitoring, and troubleshooting of system databases and replication issues.
• Monitor database performance and memory allocations using standard tools.
• Perform system updates and IAVA patching.
• Troubleshoot and resolve database problems.
• Perform database recovery actions.
• Modify existing database scripts and create new scripts for recurring issues.
• Develop and execute SQL queries for routine and ad hoc requests.
• Translate requirements into usable database schemas and queries.
• Recommend design and implementation practices to optimize performance of databases and applications.
• Assist in developing databases, database parser software, and loading software.

Skills

Security clearance

Database performance tuning

Troubleshooting

SQL/PLSQL

RDBMS administration

System updates / IAVA patching

SAFe / Agile experience

Education

Bachelor's degree in a technical discipline

Tools

Oracle Database

Oracle Data Guard

Oracle Streams

Oracle GoldenGate

Sybase Replication Server

PostgreSQL

MongoDB

Job description

A Database Administrator is needed to support a large, complex, fast-paced, operational program. The selected individual will maintain the integrity, security, and availability of multiple databases. Duties include disaster recovery, performance analysis and tuning, index maintenance, and monitoring of data, as well as administering, maintaining, developing, and implementing policies and procedures for ensuring the security and integrity of the database. The selected individual will evaluate and recommend available database management system products; perform database and software lifecycle activities to ensure the highest level of system performance, availability, and compliance with business requirements; and will organize and format data for efficient query and storage processes.

Primary Responsibilities:

• Perform daily database administration, monitoring, and troubleshooting of system database and replication issues.
• Monitor database performance and memory allocations using standard tools.
• Perform system updates and Information Assurance Vulnerability Alert (IAVA) patching.
• Troubleshoot and resolve database problems.
• Perform database recovery actions.
• Modify existing database scripts to enhance systems support and create new database scripts for recurring database issues.
• Develop and execute SQL queries for routine and ad hoc requests.
• Translate requirements and data into usable database schemas by creating or recreating ad hoc queries, scripts and macros, making updates to existing queries, and creating new queries to manipulate data into a master file.
• Recommend design and implementation practices that optimize the performance of GOTS/COTS databases and applications.
• Assist in the development of database structures that fit into the overall architecture of the system under development.
• Assist in developing databases, database parser software, and database loading software.

Required Skills and Qualifications:

• To be eligible for this position you must hold an active TS/SCI clearance with Polygraph.
• Must have at least five (5) years of hands-on, dedicated experience as a database administrator.
• Must have at least five (5) years of hands-on, dedicated experience as an Oracle Database Administrator.
• Must have in-depth experience implementing and maintaining database security.
• Must have in-depth experience conducting database performance tuning and monitoring.
• Must have in-depth experience troubleshooting and resolving database problems/issues.
• Must have experience installing, configuring, and upgrading RDBMS software.
• Must have experience with procedural languages such as PL/SQL.

Desired Skills and Qualifications:

• Bachelor's degree in a technical discipline.
• Experience with real time highly available data replication technologies such as Oracle Data Guard, Oracle Streams, Oracle Golden Gate, Sybase Replication Server.
• Experience with the Scaled Agile Framework (SAFe) methodology and/or as a member of an Agile team.
• Extensive, in-depth experience with database design and development.
• Extensive, in-depth understanding of databases, primarily Oracle and/or other relational and non-relational/NoSQL databases such as PostgreSQL and MongoDB.
• Experience using Oracle SQL/PLSQL, and SQL in general.