Job Description
Overview
- We are seeking a Senior Oracle and SQL Server SME to serve as the Track Lead within a global database managed services engagement.
- This is a hands-on leadership role involving performance tuning, optimization, HA/DR planning, and managing operations across a heterogeneous enterprise DB environment, including Oracle (EBS/Exadata), SQL Server, PostgreSQL (on-prem and AWS).
- The ideal candidate will have a deep understanding of enterprise performance diagnostics, observability tooling, compliance standards, and team coordination in a 24×5 support model.
Key Responsibilities: Track Leadership & Oversight
- Lead and mentor the DBA team delivering 24×7 on-desk support across all platforms.
Ensure SLA compliance for all database support tickets. - Serve as the escalation point for P1/P2 incidents and drive root cause analysis.
- Coordinate daily operations, performance health checks, and scheduled activities including DR drills, code deployments, and database cloning.
- Performance Tuning & Optimization
- Perform deep-dive performance analysis using tools like AWR, ASH, ADDM, and SQL Trace/Monitor.
- Review and interpret AWR/ASH reports to identify inefficient SQL, wait events, I/O bottlenecks, and system load issues.
- Tune problematic queries, optimize indexes, analyze execution plans, and make schema design recommendations.
- Partner with development and application teams to implement long-term performance improvements.
- Monitoring, Automation & Observability
- Monitor database health using OEM, Quest Spotlight, and custom scripts.
- Establish and continuously refine baselines, KPIs, and automated alerts for availability and performance anomalies.
- Drive automation of routine DBA tasks including backups, patching, and reporting.
Administration & Lifecycle Management - Oversee patching, cloning, upgrades, and regular maintenance across ~220 databases.
- Manage backup/recovery strategies, database provisioning, and access control in accordance with SOX compliance.
- Maintain DR and HA setups, including Oracle Data Guard, SQL Server clustering, and storage replication for EBS. EBS & Middleware Stack
- Administer Oracle E-Business Suite (EBS) Database Environment
- Ensure database support for applications like ODI, STAT, and replication tools like Oracle Golden Gate and Qlik.
Required Skills & Experience
- 10+ years DBA experience, including Oracle 19c/Exadata/EBS and SQL Server
- Hands-on tuning expertise using AWR, ADDM, ASH, Stats pack, and advanced troubleshooting techniques.
- Strong knowledge of PostgreSQL (AWS-hosted administration is preferred.
- Expertise in Golden Gate, ODI, Qlik Replicate, and replication troubleshooting.
- Experience with HA/DR architecture, capacity planning, and SOX-compliant auditing.
- Scripting/automation using Shell, Python, Ansible, or similar tools.
Soft Skills
- Proven leadership in managing global delivery models and multi-vendor teams.
- Strong communication skills and ability to interface with business, security, and application owners.
- Structured thinker with a focus on continuous improvement and automation-first mindset
Work Conditions & Expectations
- Responsible for 24×5 support, including failover drills, backups, and code deployment cycles.
- Coordination with OEM, Rimini, and Oracle Support for escalations and patching.