Senior Database Administrator

Peraton; Washington, Northern (District of Columbia, KY); Hybrid; USD 120,000 - 165,000; Full time

Job summary

Peraton is seeking a Senior Database Administrator to join a DoS DT CAEIO program, focusing on Oracle RDBMS, RAC, Data Guard, and GoldenGate across global DA applications.

The role emphasizes performance tuning, backup recovery, security controls, and mentoring a team. Remote work is allowed with occasional onsite requirements in the DMV area.

Qualifications

• Bachelor's degree or higher required with extensive Oracle DBA experience.
• Active SECRET clearance with ability to obtain TOP SECRET.

Responsibilities

• Implement and maintain smooth operation and physical design of databases.
• Conduct performance tuning of indexes and databases.
• Review database designs and integration of systems; provide backup recovery and enhancements.
• Maintain security and integrity controls.
• Manage day-to-day enterprise security hygiene and remediations for high-severity CVEs.
• Formulate policies and standards for database management; monitor transaction activity.
• Develop stored procedures and triggers.
• Oversee diverse DBMS including Oracle, MS SQL Server, and PostgreSQL.
• Audit and modify data using SQL commands; enforce standards.
• Coordinate scheduling of database projects and backups; manage replication.
• Assist in SQL and Web-based database development; review designs and docs.
• Create high-level reporting using Oracle OEM BI; explore new DB/online tech.
• Apply DBA skills to Oracle RAC and Data Guard installation/troubleshooting.
• Apply advanced methods to resolve complex system requirements.

Skills

Oracle DBA

Leadership

Communication

Performance tuning

Backup recovery

Security hygiene

Problem solving

Mentoring

Education

Bachelor's degree in Computer Science or related field

Tools

Oracle 19c

GoldenGate

RAC

Data Guard

RMAN

Oracle OEM

MS SQL Server

PostgreSQL

Job description

Basic Qualifications

• Bachelors degree and 12 years of experience or a Masters degree and 10 years of experience or an Associates degree and 14 years of experience or a High School diploma/equivalent and 16 years of experience.
• U.S. citizenship and minimum active SECRET clearance with the ability to obtain a TOP SECRET clearance.
• Hands-on experience with full-life cycle implementation of Oracle 19c RDBMS and 19c/21c hub Oracle GoldenGate for production environments.
• Experience upgrading Oracle RDBMS from 11g to 19c as well as the Transparent Data Encryption.
• Experience writing custom monitoring reports for 12c OEM.
• Strong communication skills to communicate systems proposals to management and customers and provide systems diagnoses and resolution for current systems.
• Strong organization skills to prioritize work, balance, and lead complex projects.
• Leadership skills to guide and mentor less experienced team members.
• At least 7 years’ experience as an Oracle DBA or Oracle-related area, including at least 5 years’ experience as an Oracle 11g or 12c DBA applying knowledge of RAC, ASM, GoldenGate, Data Guard, RMAN, Patching, AND/OR Security.
• Experience writing custom monitoring reports for 12c OEM.

Preferred Qualifications

• Experience with Oracle RDBMS upgrade from 11g/12c to 19c and Containerization.
• Experience working with Oracle Cloud Computing (private or public).
• Experiences with an Oracle Engineered System, such as Exadata and Sun Super Cluster.
• Experience as an operational DB Ops lead.

Peraton is seeking a Senior Database Administrator (DBA) to join our team of qualified and diverse individuals on our Department of State (DOS) Bureau of Diplomatic Technology (DT) Consular Affairs Enterprise Infrastructure Operations (CAEIO) program. CAEIO provides IT Operations and Maintenance to modernize the legacy networks, applications, and databases supporting consular applications and services globally.

The Senior DBA will implement and optimize the computerized database systems that support the CA’s ability to function daily and, therefore, enable its mission.

Core Work Schedule: Sunday - Thursday, approximately 8:00 AM ET - 4:00 PM ET (flexible)

Location: This position is fully remote; however, the DBA must reside in the Washington, DC, Metropolitan Area (DMV) to accommodate occasional onsite meetings, training, or customer support activities at the Washington, DC, customer location or the Peraton office in Sterling, VA. The number of days the DBA works on-site in Washington, DC, or Sterling, VA, is subject to change based on government/program requirements (for example, surge support might require the individual to be in the office five days per week).

Roles and Responsibilities

• Implement and maintain smooth operation and physical design of databases.
• Conduct performance tuning of indexes and databases.
• Review database designs and integration of systems, provide backup recovery, and recommend enhancements.
• Maintain security and integrity controls.
• Manage day-to-day enterprise security hygiene, rapidly executing remediations for high-severity CVEs and actively exploited KEVs to protect core systems and applications.
• Formulate policies, procedures, and standards related to database management, and monitor transaction activity and utilization.
• Develop stored procedures and triggers.
• Administer a variety of database systems, such as Oracle RDBMS, MS SQL Server, Postgres DB, and other Database Management Systems (DBMS).
• Develop and enforce database administration and user standards and procedures; audit, modify, and amend data in systems using SQL commands.
• Oversee the scheduling of database projects, database and transaction log backups, notifications, and database replication between multiple SQL servers and remote sites.
• Help database designers/information system analysts develop and create SQL and Web-based databases and database systems.
• Review technical designs, reports, and documentation, and other materials produced by staff.
• Create and maintain high-level reporting systems using products, such as Oracle OEM BI reports; research and implement new database and online technology.
• Apply solid DBA skills to Oracle RAC and Data Guard installation, configuration, and troubleshooting production issues.
• Apply advanced methods, theories, and research techniques to investigate and resolve complex system requirements and issues.