Senior-Level Oracle DBA

AET FEDERAL INC; United States; Remote; USD 120,000 - 180,000; Full time

Benefits offered by this job

Health insurance

Paid time off

Competitive salary

Job summary

AET Federal is seeking a Senior Oracle DBA to join a four-person team supporting a federal agency's server-based applications. The Senior Oracle DBA serves as the Oracle Team Lead and is responsible for Oracle database administration, performance, availability, backup and recovery, disaster recovery, patching, and critical incident response.

The role also provides technical guidance to the Mid-Level Oracle DBA.

Qualifications

• 8+ years of hands-on Oracle DBA experience.
• Strong experience with Oracle Database, Grid Infrastructure, ASM, and RAC.
• Strong SQL and PL/SQL skills.
• Experience with Oracle RMAN backup, restore, and recovery.
• Experience with database recovery, failover, and disaster recovery testing.
• Strong performance tuning using AWR, ASH, ADDM, and execution plans.
• Experience with patching, upgrades, maintenance, and production support.
• Experience leading critical database incidents and root-cause analysis.
• Experience with ServiceNow or similar ITSM tool.
• Strong communication, documentation, and collaboration skills.
• Willing to pass a federal background check.
• Able to work 8 hours/day within 7:30 AM–6:00 PM ET, with after-hours as needed.
• Willing to sign a letter of commitment for this proposal.

Responsibilities

• Administer and monitor production and non-production Oracle environments.
• Support Oracle Database, Grid Infrastructure, ASM, and RAC.
• Monitor health, availability, storage, backups, and performance.
• Troubleshoot complex database, application, and connectivity issues.
• Manage ServiceNow incidents, requests, and changes.
• Plan and perform Oracle patching, upgrades, installations, and maintenance.
• Perform routine maintenance: tablespace, statistics, storage, security, and user administration.
• Diagnose and resolve performance issues using AWR, ASH, ADDM, and execution plans.
• Tune SQL/PLSQL, indexes, optimizer stats, and configs.
• Lead incident response and root-cause analysis; coordinate with teams.
• Maintain documentation, procedures, and recovery plans.
• Contribute to weekly support reporting; be available on Teams during core hours.

Skills

Oracle DBA expertise

Leadership

Incident response

Collaboration

Documentation

Communication

Tools

Oracle RMAN

Grid Infrastructure

ASM

RAC

SQL

PL/SQL

ServiceNow

AWR

ASH

ADDM

Data Guard

Job description

Benefits:

• Health insurance
• Paid time off
• Competitive salary

AET Federal is seeking a Senior Oracle DBA to join a four-person team supporting a federal agency's server-based applications. The team includes a Senior and Mid-Level DBA for Oracle and the same pair for SQL Server.

The Senior Oracle DBA serves as the Oracle Team Lead and is responsible for Oracle database administration, performance, availability, backup and recovery, disaster recovery, patching, and critical incident response. The role also provides technical guidance to the Mid-Level Oracle DBA.

Key Responsibilities

Oracle administration and monitoring

• Administer and monitor production and non-production Oracle database environments
• Support Oracle Database, Grid Infrastructure, ASM, and RAC
• Monitor database health, availability, storage, backups, and performance
• Troubleshoot complex database, application, and connectivity issues
• Manage ServiceNow incidents, requests, and changes

Maintenance and performance

• Plan and perform Oracle patching, upgrades, installations, and scheduled maintenance
• Perform routine database maintenance, including tablespace, statistics, storage, security, and user administration
• Diagnose and resolve performance issues using AWR, ASH, ADDM, alert logs, and execution plans
• Tune SQL/PLSQL, indexes, optimizer statistics, and database configurations

Backup, recovery and disaster recovery

• Manage and validate Oracle RMAN backup and recovery procedures
• Perform RMAN restores, recovery testing, and point-in-time recovery
• Lead failover and disaster recovery testing and execute recovery procedures
• Support high-availability environments using RAC and Data Guard
• Maintain DR runbooks and document recovery testing

Leadership and collaboration

• Lead response to critical production incidents and perform root-cause analysis
• Provide technical guidance to the Mid-Level Oracle DBA
• Coordinate with application, infrastructure, and technical teams
• Maintain database documentation, procedures, and recovery plans
• Contribute to weekly support reporting and remain available on Microsoft Teams during core hours

Required Qualifications

• 8+ years of hands-on Oracle database administration experience
• Strong experience with Oracle Database, Grid Infrastructure, ASM, and RAC
• Strong SQL and PL/SQL skills
• Hands-on experience with Oracle RMAN backup, restore, and recovery
• Experience executing database recovery, failover, and disaster recovery testing
• Strong Oracle performance tuning experience using AWR, ASH, ADDM, and execution plans
• Experience with Oracle patching, upgrades, maintenance, and production support
• Experience leading critical database incidents and root-cause analysis
• Experience with ServiceNow or a comparable ITSM tool
• Strong communication, documentation, and collaboration skills
• Willing and able to pass a federal background investigation
• Able to work 8 hours per day within 7:30 AM--6:00 PM ET, with occasional scheduled after-hours work
• Willing to sign a letter of commitment for this proposal

This is a remote position.