SQL Server Oracle DBA

Litmus7; Ernakulam; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Litmus7 is seeking a dynamic SQL Server-focused DBA with experience in Oracle as a secondary skill. The role covers administration, performance tuning, monitoring, and support of SQL Server environments while assisting Oracle when needed.

It is part of a global team managing critical databases across on-premises and cloud platforms. Applicants should have 5+ years of experience, strong scripting with T-SQL and PowerShell, and familiarity with monitoring tools like Quest Spotlight and OEM.

Qualifications

• 5+ years of SQL Server DBA experience with HA/DR, tuning and scripting.
• Working knowledge of Oracle DBs, including DataGuard concepts and RMAN.
• Proven ability to optimize SQL Server performance and indexes.
• Familiarity with monitoring tools such as Quest Spotlight and Oracle OEM.
• Proficient in T-SQL, PowerShell, and automation of routine tasks.
• Understanding of cloud-hosted SQL Server in AWS 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 Profiler, execution plans, index optimization, and DMVs.
• Generate performance baselines, dashboards, and health reports for databases.
• Support user management, data refreshes, schema changes, and security audits.
• Collaborate with development, BI, and infrastructure teams to resolve performance or integration issues.
• Assist in Oracle environments as required and participate in DR readiness drills.

Skills

SQL Server administration

Oracle DBs (secondary)

T-SQL

PowerShell scripting

Automation

Cloud-hosted SQL Server

Tools

Quest Spotlight

Oracle OEM

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.

Experience - 5 plus years

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

• 3-4 years of solid hands-on experience in SQL Server administration, including HA/DR, tuning, and scripting.
• 1-2 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.