[Hiring] Mid-Level Oracle DBA @AET FEDERAL INC

Role Description

AET Federal is seeking a Mid-Level Oracle DBA to join a four-person team supporting a federal agency's server-based applications, which run on SQL Server and Oracle databases across every business unit. The team has a Senior and a Mid-Level DBA for Oracle and the same pair for SQL Server.

The Mid-Level Oracle DBA handles day-to-day Oracle Database operations and provides support for Microsoft Access databases. Responsibilities include:

• Handling ServiceNow tickets, change requests, database monitoring, RMAN backup and recovery, patching, maintenance, and production support.

Key Responsibilities

• Operations, monitoring and issue triage
  • Run daily health checks on Oracle database environments, including database availability, RMAN backups, failed jobs, tablespace usage, alert logs, errors, and performance.
  • Troubleshoot, set up, triage errors, and configure Oracle database environments.
  • Manage ServiceNow requests from submission to closeout.
  • Monitor database health, performance, storage, and capacity and respond proactively to potential issues.
  • Troubleshoot database and application connectivity issues.
• Maintenance and change management
  • Carry out assigned Requests for Change (RFCs), including implementation, validation, and backout steps.
  • Apply Oracle database patches and security updates during scheduled maintenance windows.
  • Perform routine database maintenance, including tablespace management, statistics maintenance, user administration, storage management, and database health checks.
  • Support Oracle software installation, configuration, upgrades, and maintenance.
  • Resolve ServiceNow tickets within the customer's operational SLAs.
• Database and application support
  • Administer and support Oracle databases and related applications.
  • Support Microsoft Access databases and troubleshoot corruption, performance issues, linked tables, ODBC connections, and database connectivity.
  • Perform user and role administration, access management, and database security tasks.
  • Use SQL and PL/SQL to support database administration, troubleshooting, and application requirements.
  • Assist users and application teams with database-related issues and configuration.
• Backup, recovery and disaster recovery
  • Monitor and verify nightly Oracle RMAN backups and troubleshoot failed backup jobs.
  • Perform RMAN restores and recovery testing to verify database recoverability.
  • Support Oracle failover and disaster recovery activities.
  • Execute DR runbooks under the direction of the Senior Oracle DBA.
  • Participate in disaster recovery testing and document recovery results and issues.
  • Support database refreshes, restores, and other recovery activities as needed.
• Reporting and collaboration
  • Contribute to the weekly support activity report delivered to the customer's COR.
  • Work closely with the Senior Oracle DBA, application teams, infrastructure staff, and other technical teams.
  • Maintain database procedures, troubleshooting documentation, and operational runbooks.
  • Stay available on Microsoft Teams during core hours.
  • Cover for the Senior Oracle DBA as needed.

Qualifications

• 4+ years of hands-on database administration experience, with Oracle as the primary platform.
• Experience administering and supporting Oracle databases in production environments.
• Experience with SQL and PL/SQL.
• Hands-on experience with Oracle RMAN backup, restore, and recovery procedures.
• Experience monitoring nightly backups, troubleshooting backup failures, and validating database recoverability.
• Experience with Oracle database patching, maintenance, software installation, and upgrades.
• Experience with tablespace management, user administration, database security, and routine Oracle operations.
• Experience supporting failover and disaster recovery activities, including executing database recovery procedures.
• Experience supporting and troubleshooting Microsoft Access databases.
• Experience working tickets and change requests in ServiceNow or a comparable ITSM tool.
• Demonstrated experience with issue triage, production support, server maintenance, and troubleshooting.
• Ability to work independently, collaborate across teams, and communicate clearly with staff and management at all levels.
• 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.

Benefits

• Health insurance
• Paid time off
• Competitive salary