Senior Oracle + SQL Server SME - Track Lead
Job Description Experience: 10+ years Role Type: Full-time Location - Kochi Role 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 24x5 support model. Key Responsibilities: Track Leadership & Oversight • Lead and mentor the DBA team delivering 24x7 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 DataGuard, SQL Server clustering, and storage replication for EBS. EBS & Middleware Stack • Administer Oracle E-Business Suite (EBS) Database environments ( • Ensure database support for applications like ODI, STAT, and replication tools like Oracle GoldenGate and Qlik. Required Skills & Experience: • 10+ years DBA experience, including Oracle 19c/Exadata/EBS and SQL Server administration. • Hands-on tuning expertise using AWR, ADDM, ASH, Statspack, and advanced troubleshooting techniques. • Strong knowledge of PostgreSQL (AWS-hosted administration is preferred. • Expertise in GoldenGate, 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 24x5 support, including failover drills, backups, and code deployment cycles. • Coordination with OEM, Rimini, and Oracle Support for escalations and patching.