Oracle DBA III – 21c, RMAN, High Availability

Chenega Professional Services Strategic Business Unit; Colorado; On-site; USD 100,000 - 150,000; Full time

Job summary

Chenega Professional & Technical Services, LLC seeks a Database Administrator III - Oracle to support the Department of the Interior with enterprise-level Oracle databases, RMAN backups, and high-availability architectures. The role requires strong PL/SQL scripting, MySQL experience, and U.S.

work authorization. You will design, implement, and maintain database systems, perform capacity planning, participate in DR exercises, and coordinate with security teams to meet STIGs and SLA requirements.

Qualifications

• Must have at least eight years of progressive database administration experience.
• Expert-level experience with Oracle version 21c and Multi-Tenant Architecture.
• Expert-level experience with Recovery Manager (RMAN).
• Expert-level experience with MySQL 8.0.42 and above on Linux and Windows servers.
• Proficiency in PL/SQL programming concepts, including cursors, triggers, stored procedures, and packages, and the ability to create and maintain scripts for ad hoc reporting and gathering database information.
• Authorization to work in the United States without sponsorship.
• Ability to pass the Public Trust Government background investigation.
• Successfully pass background and drug screening

Responsibilities

• Participate in the analysis and design of new application database systems and/or modifications or changes to existing systems.
• Perform database research and analysis and provide recommendations for the most productive use of available computer resources.
• Perform capacity planning and management of database environments and recommend expansion or replacement of existing hardware and software components.
• Design and implement high-availability, clustered database systems in conjunction with other application technical representatives.
• Install, upgrade, patch, maintain, monitor, and tune all databases using database management and monitoring tools.
• Design and implement database backup, recovery, and daily operational procedures in support of hosted database systems.
• Perform database restores and recovery, participate in annual Disaster Recovery exercises, and document procedures and test results.
• Troubleshoot and resolve technical problems and provide second-level on-call support.
• Assist security staff in conducting internal system reviews and audits to ensure alignment with security guidelines and STIGs.
• Document the resolution of security findings.
• Perform and document database-level auditing and tracking.
• Maintain required audit review logs.
• Ensure the availability SLA is met for all databases.
• Write and submit after-action reviews for database outages outside maintenance window.
• Manage and respond to IT requests through the Trouble Ticket System in accordance with customer SLA requirements.
• Manage and maintain IT system changes through the Change Request System in accordance with NBC Change Management Policy and Procedures.
• Be available to participate in the on-call schedule for technical out-of-hours support.
• Other duties as assigned

Skills

Oracle 21c

Multi-Tenant Architecture

RMAN

MySQL

PL/SQL

Education

Bachelor's degree in Computer Science

Job description

Chenega Professional & Technical Services, LLC seeks a Database Administrator III - Oracle to support the Department of the Interior with enterprise-level Oracle databases, RMAN backups, and high-availability architectures. The role requires strong PL/SQL scripting, MySQL experience, and U.S.

work authorization. You will design, implement, and maintain database systems, perform capacity planning, participate in DR exercises, and coordinate with security teams to meet STIGs and SLA requirements.