Job Description

PLEASE NOTE:

This position requires an

ACTIVE

Top Secret/SCI Clearance with Polygraph. To be considered for this position, you

MUST

have an

ACTIVE

Clearance Level of

Top Secret/SCI with Polygraph

Position Code: 04-SA0619-1

Location: Chantilly or McLean

Summary

The successful candidate will work as part of the overall DBA team to determine, implement, and maintain the most efficient ways to ingest, organize and store petabytes of data from disparate system.

Duties, Tasks & Responsibilities

Participating and leading in the design, development, and administration of Oracle 19c databases Designing and developing database code for ETL of data from multiple sources Conducting performance tuning and forecasting system scalability Recommending appropriate procedure, query, or package changes and optimizations to ensure and improve system performance and reliability Installing and configuring database environments Performing database backups and restores Managing, monitoring, and administering of Oracle database systems Participating in server and storage capacity management and planning Providing technical support in the evaluation of database systems and database design. Recommending and implementing approved process and tool improvements

Required Experience, Skills, & Technologies

Significant experience with Oracle 19c+ architecture and database design, and related Oracle technologies (Partitioning, Encryption, Pluggable Database, etc.) on Linux systems Significant Oracle Exadata experience Significant PL/SQL developer experience Significant Oracle Label Security (OLS) experience Significant experience and knowledge in methodologies to improve database query performance. Ability to work with multiple teams to enhance their code and improve performance. Significant experience in the optimization of database environments Strong understanding of high-availability solutions and architecture Strong understanding of backup methodologies and their implementation (RMAN, Data Guard) Experience managing and tuning very large databases (terabytes and petabytes) Strong documentation skills Experience automating, scripting, and streamlining processes for efficiency and accuracy

Desired Experience, Skills & Technologies

Experience with PostgreSQL architecture, database design, administration, and related technologies. Knowledge of Oracle Cloud Technology Oracle OCP or OCM certification(s) Linux experience as relevant to database O&M * Knowledge of multiple data-storage technologies