Senior Oracle + SQL Server SME – Track Lead
at Iqhired
Kochi, senior, full time, 10–14 years
seen 31d ago
- Exadata
- PostgreSQL
- SQL Monitor
- SQL Server
- Golden Gate
- SQL Trace
- Oracle 19c
- Stats pack
- ADDM
- Shell
- Qlik Replicate
- ODI
- ASH
- EBS
- Ansible
- Oracle Data Guard
- Oracle
- AWR
- Python
About the role
* 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.
What you would do
* 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.
What they are looking for
* 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.
Read from iqhired.com, last seen 2d ago.