Senior Oracle Database Administrator

Responsibilities

Peraton is seeking a Senior Oracle Database Administrator (“Oracle DBA”) to join our team of qualified and diverse individuals. The Senior DBA will be a member of the Department of State (DOS) Bureau of Consular Affairs Enterprise Infrastructure Operations (CAEIO) Program. CAEIO provides IT Operations and Maintenance to the legacy networks, applications, and databases supporting CA services globally.

 

The Oracle DBA will be a member of the Database Support team. This team provides support for Consular Consolidated Database (CCD), overseas posts, DMZ, Passport, and Consular One systems. Support functions include operational management of SQL database systems and Database Infrastructure, as well as Tier 2 support for Oracle databases in administrative activities, such as backups, recovery, monitoring, patching, performance tuning, replication, upgrades, and deployments. The team also provides operational support for Oracle, SQL Server, Datashare partners, and other relational and non-relational database systems.

 

An Oracle DBA who thrives on the CAEIO Program has extensive experience with DBA front-end and back-end tools, excellent problem-solving skills, and hands-on experience with Oracle database management; works efficiently under pressure and adapts readily to changing priorities; collaborates with cross-functional teams; and stays current with emerging database technologies.

 

Responsibilities

• Implement and maintain smooth operation and physical design of databases.
• Conduct performance tuning of indexes and databases.
• Review database design and integration of systems, provide backup recovery and make recommendations regarding enhancements and improvements.
• Maintain security and integrity controls.
• Develop stored procedures and/or triggers.
• Audit, modify, and amend data in systems using SQL and PL/SQL commands.
• Manage database and transaction log backups, notifications, and database replication between multiple Oracle RDBMS Servers and remote sites.
• Lead and maintain the integrity, security, and availability of a true global 24x7 OLTP database(s) environment. Duties include disaster recovery, performance analysis and tuning, index maintenance, monitoring database health, and troubleshooting critical incidents.
• Perform upgrades from Oracle 19c to 21c/23ai with RDBMS containerization via DBCA utility.
• Participate in and facilitate the full life cycle implementation of Oracle 19c RDBMS and 19c Oracle GoldenGate data replication for production environments.
• Leverage experience with:
  • Upgrading the Oracle RAC database from 19c to 21c/23ai, containerization of the 19c DB to CDB/PDB, configuring the Oracle GoldenGate replications from 19c to 21c HUB, and deploying OEM 13.5 agents.
  • Managing Oracle Exadata Engineering systems from X2-8 to X8M-8 and ZDLRA backup engineering systems.
  • Upgrading the Oracle RDBMS system from 19c to 21c/23ai as well as the Transparent Data Encryption.
  • Applying database administration skills to Oracle Real Application Cluster (RAC) and Data Guard installation, configuration, and troubleshooting production issues.
• Perform database and software life-cycle activities to ensure the highest level of system performance and availability and compliance with business requirements.
• Apply advanced methods, theories, and research techniques in the investigation and solution of the complex system requirements and problems.

 

Core Work Schedule: Monday - Friday, 7:30 AM ET - 4:00 PM ET (flexible)

Location: This position is hybrid with remote work and up to one day per week in the office in Sterling, VA. The number of days the Oracle DBA works onsite is subject to change based on government/program requirements (for example, surge support might require the individual to be in the office more than two days per week).

 

This position is hybrid after the individual completes a 1-week New Hire Training Program conducted Monday through Friday from 7:30 AM to 4:00 PM in Sterling, VA. After completing the training program, the Oracle DBA will work their assigned schedule.

Qualifications

Basic Qualifications

• U.S. citizenship and an active SECRET government security clearance with the ability to obtain Top Secret government security clearance.
• At least seven years of experience in a role with responsibilities similar to those defined for this position.
• Experience as an Oracle 11g, 19c, 21c, and 23ai database administrator with specific knowledge of RAC, ASM, GoldenGate, Data Guard, RMAN, Patching, AND/OR Security.
• Experience upgrading/migrating Oracle 1