Sql Server Dba Lead

Litmus7 Systems Consulting Ltd.; Ernakulam; On-site; INR 900,000 - 1,800,000; Full time

Job summary

Litmus7 Systems Consulting Ltd. seeks a dynamic SQL Server-focused DBA with Oracle as a secondary skill. You will administer, tune, monitor, and support SQL Server environments while assisting Oracle as needed, across on‑premises and cloud platforms as part of a global team.

The role requires hands-on experience with HA/DR, backups, replication, AlwaysOn, and performance tuning using DMVs and tools like Quest Spotlight and OEM. collaboration with development and infrastructure teams is essential.

Qualifications

• 8 years of hands-on SQL Server administration experience including HA/DR, tuning, and scripting.
• 12 years of Oracle DBs experience, including DataGuard concepts and RMAN.
• Proven experience in SQL Server performance optimization (queries, indexes, plans).
• Familiarity with monitoring/observability tools such as Quest Spotlight and OEM.
• Knowledge of T-SQL, PowerShell scripting, and automation of routine maintenance tasks.
• Understanding of cloud-hosted SQL Server (AWS EC2/RDS or Azure).

Responsibilities

• Provide end-to-end support for SQL Server environments including installation, configuration, security, patching, and upgrades.
• Administer and troubleshoot SQL Server Agent jobs, backup/restore, replication, clustering, and AlwaysOn availability groups.
• Lead or assist in performance tuning using SQL Profiler, Execution Plans, Index Optimization, Wait Stats, and DMVs.
• Generate and interpret Performance Baselines, Monitoring Dashboards, and Health Reports.
• Support database-related requests such as user management, data refreshes, schema changes, and security audits.
• Monitor Oracle environments during cross-functional sessions as needed.
• Monitor systems using Quest Spotlight, OEM, and custom alerting tools.
• Support high availability and disaster recovery readiness and drills.
• Collaborate with development, BI, and infrastructure teams to resolve performance/integration issues.
• Ensure compliance with SOX controls, database access standards, and audit logs.

Skills

SQL Server administration

Oracle DBs

Performance tuning

T-SQL

PowerShell

Cloud SQL Server

Tools

Quest Spotlight

Oracle OEM

SQL Server Profiler

RMAN

DataGuard

Job description

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 managing business-critical databases across on-premises and cloud platforms.

Key Responsibilities

• Provide end-to-end support for SQL Server environments including installation, configuration, security, patching, and upgrades.
• Administer and troubleshoot SQL Server Agent jobs, backup/restore operations, replication, clustering, and AlwaysOn availability groups.
• Lead or assist in performance tuning using: SQL Profiler, Execution Plans, Index Optimization, Wait Stats, and Dynamic Management Views (DMVs)
• Generate and interpret Performance Baselines, Monitoring Dashboards, and Health Reports.
• Support database-related requests such as user management, data refreshes, schema changes, and security audits.
• Participate in AWR/ASH/Statspack analysis for Oracle environments as required.
• Monitor systems using Quest Spotlight, OEM, and custom alerting tools.
• Support high availability and disaster recovery (DR) readiness and drills.
• Collaborate with development, BI, and infrastructure teams to analyze and resolve performance or integration issues.
• Ensure compliance with SOX controls, database access standards, and audit logs.

Required Technical Skills

• 8 years of solid hands-on experience in SQL Server administration, including HA/DR, tuning, and scripting.
• 12 years of working knowledge of Oracle DBs, including DataGuard concepts and RMAN.
• Proven experience in performance optimization in SQL Server (queries, indexes, plans).
• Familiarity with monitoring and observability tools such as Quest Spotlight, OEM.
• Knowledge of T-SQL, PowerShell scripting, and automation of routine maintenance tasks.
• Understanding of cloud-hosted SQL Server (e.g., in AWS EC2/RDS or Azure).

Preferred/Good to Have

• Exposure to Oracle EBS environments or Oracle patching basics.
• Knowledge of Qlik Replicate, ODI, or GoldenGate.
• Hands-on with DataGuard, OEM performance packs, or clustered Oracle environments.

Soft Skills

• Comfortable with 24x7 rotational shifts, collaborating across APAC, EMEA, and Americas.
• Strong analytical and troubleshooting skills, with ability to communicate clearly.
• Ownership mindset, willingness to automate and document frequently executed tasks.