Jobs · Information Technology · Missouri

Senior Oracle Database Administrator

Capstone IT · Springfield, MO · 4 wk ago
On-siteInformation TechnologyContract

About the role

This is an opportunity to join a mature infrastructure team responsible for the reliability, performance, and scalability of large Oracle database platforms supporting thousands of users across the enterprise.

Responsibilities

  • Administer large-scale Oracle 19c production databases supporting critical enterprise applications
  • Install, configure, patch, upgrade, and maintain Oracle environments using OPatch and Oracle Release Updates (RUs)
  • Manage Oracle RAC, Grid Infrastructure, Clusterware, ASM, and Oracle Multitenant (CDB/PDB) environments
  • Design, implement, and support Oracle Data Guard solutions, including switchover and failover operations
  • Develop and execute high availability, disaster recovery, backup, and recovery strategies using RMAN
  • Monitor and optimize database performance utilizing AWR, ASH, ADDM, SQL Trace, execution plans, and SQL Plan Management
  • Tune SQL, PL/SQL, indexes, partitioning strategies, optimizer statistics, memory allocation, and storage utilization
  • Administer Oracle Enterprise Manager (OEM) Cloud Control and enterprise monitoring solutions
  • Automate routine database administration tasks using Bash, SQL*Plus, SQLcl, Python, Perl, or similar scripting tools
  • Support database cloning, refreshes, migrations, upgrades, and provisioning activities
  • Manage database security, auditing, user access, roles, privileges, and compliance with enterprise security standards
  • Troubleshoot complex production issues involving locking, wait events, concurrency, networking, replication, and performance bottlenecks
  • Participate in on-call production support while maintaining high availability and service level objectives
  • Partner closely with infrastructure, application development, security, and operations teams to deliver reliable database services
  • Contribute to operational documentation, disaster recovery procedures, automation initiatives, and mentoring of junior DBAs

Requirements

  • Extensive experience administering Oracle Database 19c within large, enterprise production environments
  • Deep expertise with Oracle RAC, Grid Infrastructure, Clusterware, ASM, and Data Guard
  • Strong experience with RMAN backup and recovery, including point-in-time recovery and database duplication
  • Advanced Oracle performance tuning experience using AWR, ASH, ADDM, SQL Trace, execution plans, and SQL Plan Management
  • Strong SQL and PL/SQL performance tuning skills
  • Experience administering Oracle Enterprise Manager (OEM) Cloud Control
  • Solid Linux administration skills with experience developing automation through Bash, Python, Perl, PowerShell, or similar scripting languages
  • Experience supporting Oracle Multitenant architecture (CDB/PDB)
  • Knowledge of Oracle networking including Oracle Net, Listeners, and TNS configuration
  • Experience with Oracle Flashback technologies, Resource Manager, and memory optimization (SGA, PGA, HugePages)
  • Familiarity with Oracle GoldenGate and enterprise database migration strategies is highly preferred
  • Experience supporting virtualized or cloud-hosted Oracle environments including Oracle Cloud Infrastructure (OCI), AWS, Azure, or VMware
  • Strong understanding of high availability, disaster recovery, business continuity, and enterprise change management practices
  • Excellent troubleshooting, analytical, communication, and documentation skills
  • Experience supporting environments with stringent uptime requirements (99.99% availability or greater)

Similar jobs