Database Administrator II

Prodigy One•Annapolis Junction, MD

21h•$124,000 - $208,000

About The Position

The Database Administrator supports a large, complex, and fast-paced operational program, ensuring the reliability, security, and performance of critical database systems. This role is responsible for maintaining the integrity, availability, and security of multiple databases while applying best practices in database administration and governance. The Database Administrator performs a broad range of functions, including daily administration, monitoring, and troubleshooting of system databases and replication processes. This includes monitoring database performance and memory utilization using standard tools, executing system updates and Information Assurance Vulnerability Alert (IAVA) patching, and performing database recovery actions when necessary. The role also involves troubleshooting and resolving database issues, as well as modifying existing scripts and developing new scripts to address recurring challenges. In addition, the Database Administrator develops and executes SQL queries to support both routine and ad hoc data requests, and supports the transition and ingestion of legacy data into modern database environments. The position requires translating requirements into effective database schemas by creating or updating queries, scripts, and macros, and ensuring data is structured for efficient storage and retrieval. The role also includes recommending design and implementation practices to optimize the performance of GOTS and COTS databases and applications, assisting in the development of database structures aligned with overall system architecture, and supporting the development of database parser and loading solutions. Through these efforts, the Database Administrator ensures systems operate efficiently, securely, and in alignment with mission and business requirements.

Requirements

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.
CLEARANCE IS REQUIRED TO BE CONSIDERED FOR THIS ROLE Clearance Required: Active TS/SCI clearance with Polygraph

Nice To Haves

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.
Experience with Mongo and/or Cassandra.

Responsibilities

daily administration, monitoring, and troubleshooting of system databases and replication processes
monitoring database performance and memory utilization using standard tools
executing system updates and Information Assurance Vulnerability Alert (IAVA) patching
performing database recovery actions when necessary
troubleshooting and resolving database issues
modifying existing scripts and developing new scripts to address recurring challenges
developing and executes SQL queries to support both routine and ad hoc data requests
supporting the transition and ingestion of legacy data into modern database environments
translating requirements into effective database schemas by creating or updating queries, scripts, and macros, and ensuring data is structured for efficient storage and retrieval
recommending design and implementation practices to optimize the performance of GOTS and COTS databases and applications
assisting in the development of database structures aligned with overall system architecture
supporting the development of database parser and loading solutions