SQL Server Oracle DBA

Litmus7 Systems Consulting Ltd; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Litmus7 Systems Consulting Ltd. is seeking a dynamic SQL Server DBA with Oracle RMAN exposure to manage and optimize SQL Server environments across on-prem and cloud platforms.

You will handle installation, security, patching, upgrades, and AlwaysOn configurations while collaborating with BI and infrastructure teams to ensure high performance and DR readiness.

Qualifications

• 3–4 years of hands-on SQL Server administration experience including HA/DR, tuning, and scripting.
• 1–2 years working knowledge of Oracle DBs, including DataGuard concepts and RMAN.
• Proven experience in performance optimization for SQL Server (queries, indexes, plans).

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 DMVs.
• Generate and interpret performance baselines, monitoring dashboards, and health reports.
• Support DB-related requests such as user management, data refreshes, schema changes, and security audits.
• 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.

Skills

SQL Server DBA

Oracle RMAN

Performance tuning

PowerShell scripting

Cloud SQL Server

Monitoring tools

Tools

Quest Spotlight

OEM

DMVs

PowerShell

RMAN

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

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