Skip to content
Talento
Sign inGet started

Talento

Upload your CV, set your preferences, and find jobs that fit.

PrivacyTermsCookiesAccessibility

← All roles

Senior Oracle + SQL Server SME – Track Lead

at Iqhired

Kochi, senior, full time, 10–14 years

seen 31d ago

Apply for this roleSign in to track your application
  • 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.

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.

Job Category: Oracle Database

Job Type: Full Time

Job Location: Kochi

Min Experience: 10 years

Max Experience: 14 years