Jobs
Interviews
Litmus7 logo

Senior Oracle SQL Server SME Track Lead

10 years

0 Lacs

Kochi Kerala India

Posted:18 hours ago| Platform: Linkedin logo

Apply

Skills Required

oracle sql server database engagement leadership tuning optimization planning exadata postgresql aws diagnostics tooling compliance coordination support escalation drive checks code analysis reports indexes analyze design development monitoring automation patching management maintenance backup strategies provisioning clustering storage replication middleware stack goldengate troubleshooting qlik architecture scripting python ansible communication interface security failover deployment

Work Mode

On-site

Job Type

Full Time

Job Description

Experience: 10+ yearsRole Type: Full-time

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 24x7 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 in 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 24x7 support, including failover drills, backups, and code deployment cycles.
  • Coordination with OEM, Rimini, and Oracle Support for escalations and patching.

More Jobs at Litmus7

UX Designer (R&D)

Kochi, Kerala, India

Experience: Not specified

|

Salary: Not disclosed

HCL Commerce

Kochi, Kerala, India

Experience: Not specified

|

Salary: Not disclosed

HCL Commerce

Kochi, Kerala, India

Experience: Not specified

|

Salary: Not disclosed

Academic Technical Trainer

Kochi, Kerala, India

5 - 8 yrs
|

Salary: Not disclosed

Senior Research Engineer AI

Kochi, Kerala, India

5 - 8 yrs
|

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Google Play App Store
coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now
Litmus7 logo
Litmus7

RecommendedJobs for You

Litmus7 logo

Senior Oracle SQL Server SME Track Lead

Litmus7

Kochi, Kerala, India

Litmus7 logo

Senior Oracle SQL Server SME Track Lead

Litmus7

Kochi, Kerala, India