SENIOR ORACLE DBA

NorthHill Technology Resources has a need for a Senior Oracle Database Administrator to support a Federal Program in either Sterling, VA or Washington DC. This is a direct-hire role with our client, a fast-growing Federal Integrator.

Location: This position is hybrid with remote work and up to two days per week in the office in Sterling, VA or Washington, DC. Core Work Schedule: Monday - Friday, 8AM - 4PM.

(U776A) Senior Database Administrator (“Senior DBA”) will be a member of the Department of State (DOS) Consular Affairs Enterprise Infrastructure Operations (CAEIO) Program for the Bureau of Consular Affairs (CA). The CAEIO Program provides IT Operations and Maintenance to modernize the legacy networks, applications, and databases supporting CA 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.

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.

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, 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. QUALIFICATIONS

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 organizational skills to prioritize work, balance, and lead complex projects.

Leadership skills to guide and mentor less experienced team members.

Experience as an Oracle DBA.

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. Desired Qualifications

Experience with Oracle RDBMS upgrade from 11g/12c to 19c and Containerization.

Experience working with Oracle Cloud Computing (private or public).

Experience with an Oracle Engineered System, such as Exadata and Sun Super Cluster.

Experience as an operational DB Ops lead. Education and Experience Requirements:

Bachelor's degree in systems engineering, computer science, management information systems, or related field and 8 years’ experience or MS degree in related field and 6 years’ experience or high school diploma/equivalent and minimum 12 years’ experience.