A CLEARANCE IS REQUIRED TO BE CONSIDERED FOR THIS ROLE
Clearance required: Active TS/SCI clearance with Polygraph
Location: Annapolis Junction, MD
Job Description
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.
- Transition/ingest legacy data.
- 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.
- At least 4 years of experience. Additional experience may be substituted for a bachelor’s degree.
- Must have demonstrated experience as a Database Administrator.
- Must have Oracle Database Administration experience.
- Must have experience implementing and maintaining database security.
- Must have experience troubleshooting and resolving database problems/issues.
- Must have experience installing, configuring, and upgrading RDBMS software.
- Must have experience with procedural languages, for example: PL/SQL.
Preferred Qualifications:
- 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.
- Experience with database design and development
- Experience with the 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.
- Bachelor of Science in a Technical field
Entry Level 120K- 129K
Mid Level 180K- 191K
(The compensation of this position starts at the lower amount of the stated salary range while higher amounts may be achieved by the candidate accepting less PTO, waiving Healthcare, or both.)
Benefits:
- Healthcare for Employee and Spouse and/or Children that is fully funded by Prodigy One
- 10% Employer Contribution to 401K; Immediately Vested
- 7 Weeks Paid Time Off (PTO)
- $2500 for Professional Development
Prodigy One, LLC provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.