Senior Oracle SQL Server SME Track Lead

17 hours ago

Ernakulam, India Litmus7 Full time

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

    17 hours ago

    Ernakulam, India Litmus7 Full time

    Experience:6 plus years Role 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

    7 days ago

    Ernakulam, India Talent Basket Full time

    **Hiring for leading US Company** **Position: SQL Server DBA** **Experience : 8Years Minimum** **Budget: Open** **Work From Office : Cochin** **Notice : Immediate - 30 days** **Desired Experience and Skills**: - Experience with SQL Server 2014 onwards - Excellent verbal and written communication skills - Experience troubleshooting performance issues,...

  • SSIS/SQL Developer

    18 hours ago

    Ernakulam, India GEETHA TECHNOLOGY SOLUTIONS PRIVATE LIMITED Full time

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

  • SQL Developer

    18 hours ago

    Ernakulam, India Origent Technologies Full time

    Job description for SQL developer Origent 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...

  • PL/SQL Developer

    19 hours ago

    Ernakulam, India PracticeSuite, Inc. Full time

    Overview PracticeSuite, 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 Database Engineer

    18 hours ago

    Ernakulam, India Velodata Global Pvt Ltd Full time

    Job Opening: Lead/Senior Oracle/PostgreSQL Developer Location: Trivandrum / Kochi / Remote Budget: ₹12 – 20 LPA Experience: 6+ years Mandatory Skills PostgreSQL / Oracle (Lead / Developer role) AWS Primary Skills Oracle / PL-SQL PostgreSQL / PL-pgSQL AWS Good to Have Amazon Aurora Python Scripting (Shell / Python) Monitoring tools (Prometheus, Grafana,...

  • Oracle EBS Technical Consultant

    17 hours ago

    Ernakulam, India Litmus7 Systems Consulting Full time

    6-8 years of experience Deep hands-on experience in PL/SQL, SQL, APIs (standard & custom) Oracle Reports, BI Publisher Oracle Forms, Oracle Workflow OAF (Oracle Application Framework), ADF (preferred) Strong understanding of EBS data models across: SCM: Order to Cash, Procure to Pay, Shipping, Inventory, BOM, WMS Finance: AR, AP, GL, Fixed Assets Experience...

  • Technical Lead

    19 hours ago

    Ernakulam, India Inspired Entertainment Full time

    Department: Technology Reporting to: Development Manager Overview of Role Inspired 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...

  • Senior Java Developer

    16 hours ago

    Ernakulam, India Inspired Entertainment Full time

    Overview of Role Inspired 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...

  • Oracle Trainer

    19 hours ago

    Ernakulam, India networkacademy Full time

    Company Description Since our inception in 2001, has been dedicated to innovation, adaptation, and a relentless pursuit of excellence. As a fully focused educational network academy, we prioritize providing placement-assured opportunities across various industry domains. Our platform offers a comprehensive array of courses, both online and offline, covering...