Senior Oracle SQL Server SME Track Lead

1 week ago

Cochin, Kerala, India Litmus7 Full time ₹ 15,00,000 - ₹ 20,00,000 per year

Experience: 10+ years

Role 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.

  • SQL Server Oracle DBA

    1 week ago

    Cochin, Kerala, India Litmus7 Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Experience:6 plus yearsRole OverviewWe are looking for a dynamic and detail-oriented SQL Server-focused DBA with experience in Oracle as a secondary skill. The ideal candidate will handle the administration, performance tuning, monitoring, and support of SQL Server environments primarily, while also assisting in Oracle environments when needed. This role is...

  • SQL Server DBA

    2 weeks ago

    Cochin, Kerala, India Litmus7 Systems Consulting Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Role Overview:We are looking for a dynamic and detail-oriented SQL Server-focused DBA with experience in Oracle as a secondary skill. The ideal candidate will handle the administration, performance tuning, monitoring, and support of SQL Server environments primarily, while also assisting in Oracle environments when needed. This role is part of a global team...

  • SSIS/SQL Developer

    6 days ago

    Cochin, Kerala, India GEETHA TECHNOLOGY SOLUTIONS PRIVATE LIMITED Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    We are seeking an experienced SSIS/SQL Developer with strong technical expertise in ETL processes, database development, and data transformation. The ideal candidate will have 4 to 6 years of hands-on experience and a proven track record of working on global development projects in fast-paced, Agile environments.As an SSIS/SQL Developer, you will be...

  • Oracle PL/SQL Developer

    2 weeks ago

    Cochin, Kerala, India Panasa Tech Full time ₹ 8,00,000 - ₹ 12,00,000 per year

    Job Position: Oracle PL/SQL DeveloperDescriptionAs an Oracle PL/SQL Developer, you will be a member of back-end programming.The PL/SQL Developer will be responsible for properly maintain source code sets andnecessary technical documentation.In this role, you will leverage your knowledge of Oracle database development and be ateam member in the successful...

  • Senior Database Engineer

    1 week ago

    Cochin, Kerala, India Velodata Global Pvt Ltd Full time ₹ 12,00,000 - ₹ 20,00,000 per year

    Job Opening: Lead/Senior Oracle/PostgreSQL DeveloperLocation: Trivandrum / Kochi / RemoteBudget: ₹12 – 20 LPAExperience: 6+ yearsMandatory SkillsPostgreSQL / Oracle (Lead / Developer role)AWSPrimary SkillsOracle / PL-SQLPostgreSQL / PL-pgSQLAWSGood to HaveAmazon AuroraPythonScripting (Shell / Python)Monitoring tools (Prometheus, Grafana,...

  • SQL Developer

    1 week ago

    Cochin, Kerala, India Origent Technologies Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Job description for SQL developerOrigent Technologies is dedicated to crafting customized Software-as-a-Service (SaaS) solutions for childcare and after-school programs, with a focus on seamless functionality across desktops, tablets, and mobile phones.We are currently seeking skilled SQL Server developers to take charge of writing complex stored procedures...

  • PL/SQL Developer

    1 week ago

    Cochin, Kerala, India PracticeSuite, Inc. Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    OverviewPracticeSuite, a leading SaaS company providing cloud-based practice management and medical billing solutions.We are looking for a PLSQL Developer to join us. This role is focused on database development, performance optimization, and ensuring that data systems meet the business needs of the organization. It requires a mix of technical expertise in...

  • Senior Java Developer

    1 week ago

    Cochin, Kerala, India Inspired Entertainment Full time US$ 1,50,000 - US$ 2,00,000 per year

    Overview of RoleInspired is looking for an enthusiastic and ambitious individual who has at least 5 years + in the field of software development with at least 2 + years of senior level experience.Strong Java / J2EE and SQL skills are required as well as demonstrable experience of MVC frameworks, Spring/ Hibernate and client-side in JavaScript.Working closely...

  • Technical Lead

    1 week ago

    Cochin, Kerala, India Inspired Entertainment Full time US$ 1,25,000 - US$ 1,75,000 per year

    Department: TechnologyReporting to: Development ManagerOverview of RoleInspired is looking for an enthusiastic and ambitious individual who has hands-on team-leading experience in the field of software development.Strong Java / J2EE and SQL skills are required as well as demonstrable experience in MVC frameworks, Spring/ Hibernate, and client-side in...

  • Oracle EBS Technical Consultant

    1 week ago

    Cochin, Kerala, India Litmus7 Systems Consulting Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    6-8 years of experienceDeep hands-on experience in PL/SQL, SQL, APIs (standard & custom)Oracle Reports, BI PublisherOracle Forms, Oracle WorkflowOAF (Oracle Application Framework), ADF (preferred)Strong understanding of EBS data models across:SCM: Order to Cash, Procure to Pay, Shipping, Inventory, BOM, WMSFinance: AR, AP, GL, Fixed AssetsExperience in...