SQL Server Oracle DBA

L7Commerce; Ernakulam; On-site; INR 1,500,000 - 2,500,000; Full time

Job summary

L7Commerce in Kochi/Bangalore is seeking a SQL Server DBA with Oracle as a secondary skill to manage global databases across on-prem and cloud.

You will optimize performance, ensure HA/DR, monitor with Quest Spotlight and OEM, and collaborate with development and BI teams.

The role requires 3–4 years SQL Server, 1–2 years Oracle, and readiness for 24x7 shifts across APAC/EMEA/Americas.

Qualifications

• 3–4 years of hands-on SQL Server administration experience, including HA/DR, tuning, and scripting.
• 1–2 years of Oracle DB experience, including DataGuard concepts and RMAN.
• Proven experience in performance optimization for SQL Server (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 (e.g., 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 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 database-related requests such as user management, data refreshes, schema changes, and security audits.
• Participate in Oracle AWR/ASH/Statspack analysis as required.
• Monitor systems using Quest Spotlight, OEM, and custom alerting tools.
• Support HA/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.

Skills

SQL Server

Oracle DB

Performance tuning

Monitoring tools

T-SQL

PowerShell

Cloud SQL

Tools

Quest Spotlight

Oracle OEM

DataGuard

Job description

Kochi | Bangalore

Experience - 5 plus years

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.