Oracle DBA(Onsite)

Position:Oracle DBA
Location:St louis, MO(Onsite)
Duration:Long term
Job Description:
Database Administration
Install, configure, and maintain Oracle databases (11g / 12c / 19c) on Linux/Unix platforms
Perform database creation, configuration, cloning, and decommissioning
Manage tablespaces, datafiles, redo logs, control files, and storage growth
Perform routine maintenance activities such as space management and housekeeping
Backup & Recovery
Design and implement backup and recovery strategies using RMAN
Perform database restores and recoveries (complete and point‑in‑time recovery)
Test backup and recovery procedures regularly to ensure DR readiness
Handle archive log management and retention policies
Performance Monitoring & Tuning
Monitor database performance using AWR, ADDM, ASH, OEM
Identify and resolve performance issues related to CPU, memory, I/O, SQL
Tune SQL queries, indexing strategies, and optimizer statistics
Manage Oracle initialization parameters for optimal performance
High Availability & Disaster Recovery
Implement and support Oracle Data Guard (Physical / Logical Standby)
Manage Oracle RAC environments for high availability
Perform planned and unplanned failover and switchover operations
Support DR drills and business continuity testing
Security & Compliance
Manage database users, roles, profiles, and privileges
Ensure database security standards and compliance requirements are met
Implement auditing, password policies, and access controls
Apply security patches and CPU updates
Upgrades, Patch & Migration
Perform Oracle patching, PSU/CPU upgrades, and version upgrades
Support database migrations across platforms or versions
Coordinate with application and infrastructure teams during releases
Follow change management and release processes
Production Support
Provide 24x7 on‑call support for production databases
Troubleshoot database incidents and perform root cause analysis
Work with vendors and internal teams to resolve complex issues
Maintain SOPs, runbooks, and operational documentation
Roles & Responsibilities
Install, configure, and administer Oracle databases (11g, 12c, 19c) in development, test, UAT, and production environments
Perform day‑to‑day database administration including creation, configuration, cloning, and deletion
Monitor database health and availability; proactively identify and resolve issues
Execute backup and recovery operations using RMAN, including restore and point‑in‑time recovery
Manage database storage: tablespaces, datafiles, redo logs, archive logs, and control files
Ensure optimal database performance through SQL tuning, index management, statistics gathering, and parameter tuning
Monitor and tune database resources using AWR, ADDM, ASH, OEM, and performance views
Implement and support High Availability and Disaster Recovery solutions using Oracle RAC and Data Guard
Perform Data Guard switchover and failover operations during planned and unplanned events
Apply Oracle patches, CPUs, PSUs, and perform version and platform upgrades
Support database migrations across environments and Oracle versions
Manage database security, including users, roles, privileges, profiles, and auditing
Ensure compliance with security standards, operational policies, and regulatory requirements
Troubleshoot production incidents, perform root cause analysis, and implement preventive measures
Coordinate with application, system, and network teams during deployments and outages
Automate routine DBA tasks using shell scripting where applicable
Maintain DBA documentation, SOPs, and operational runbooks
Participate in 24x7 support and on‑call rotations for critical production systems.