Database Administrator II

Prodigy One, LLC. is a systems and software engineering services firm providing more than 45 years of service to state and federal customers. By combining unparalleled experience and capabilities, our company provides big data, cloud development, and enterprise management solutions. We are focused on product usability and end user presentation to help our customers make the best decisions possible. Given our length of service in the industry, Prodigy One knows the importance of a competitive salary and benefits package. That's why our total compensation package can be tailored to meet employees personal needs. 

A CLEARANCE IS REQUIRED TO BE CONSIDERED FOR THIS ROLE  

Clearance Required: Active TS/SCI clearance with Polygraph
Location: Annapolis Junction, MD

Salary Information: 124K - 208K

Compensation and labor categories are defined in accordance with program requirements and government guidelines. Salary within the posted range is determined based on an individual’s experience, education, certifications, and overall qualifications, and may be further adjusted based on benefit selections.

Job Description:
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.

Basic Qualifications:

• 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.

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

Education Requirements: Bachelor's degree in a technical discipline preffered.

Benefits:

• 10% Employer Contribution to 401K; Immediately Vested
• 5 Weeks Paid Time Off (PTO) up to 7 weeks 
• Access to Premium Healthcare/Dental/Vision Available 
• $2500 Training Paid 
• Referral Company Profit Sharing

We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by applicable law.