What are the responsibilities and job description for the DS Database Administrator position at Probity Inc.?
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