Senior Oracle Dba

Collaborate with application teams on data modeling, schema design, and deployment of complex PL/SQL packages, procedures, triggers, and views.Analyze execution plans, tune SQL queries, and optimize indexes for high-throughput transactional environments.Lead database release automation, code reviews, and schema migrations across Development, Staging, and Production.Monitor database health and troubleshoot lock contention, deadlocks, latency, and performance issues.Partner with infrastructure and cloud teams to design and execute on-premises to AWS database migrations.Support Oracle and PostgreSQL databases within AWS environments.Participate in database capacity planning, failover testing, and disaster recovery design.Integrate database deployments with CI/CD pipelines and Agile delivery processes.Collaborate with offshore teams for maintenance and production support.Provide occasional weekend and after-hours support for deployments and maintenance activities.Core Qualifications
8-10 years of Oracle Database Administration experience.Strong expertise with
Oracle Database 12c/19c+ .Advanced experience with:PL/SQLSQL Performance TuningAWRASHADDMHands-on experience administering AWS database services, including:Amazon RDS for OracleAmazon RDS for PostgreSQLAmazon AuroraHands-on knowledge of PostgreSQL architecture, schema design, and performance optimization.Experience with AWS migration tools such as:AWS DMSAWS SCTNative Database Migration UtilitiesStrong experience with database release management and CI/CD integration.Experience supporting high-availability and disaster recovery environments.Strong troubleshooting, analytical, and performance optimization skills.Preferred Qualifications
Knowledge of Exadata performance features including Smart Scan and Hybrid Columnar Compression.
#J-18808-Ljbffr