2270759-Lead Assistant Manager

EXL Talent Acquisition Team; Dadri; On-site; INR 900,000 - 1,300,000; Full time

Job summary

EXL Talent Acquisition Team seeks a SQL Server DBA for production support across OLTP/OLAP/BI environments. The role involves performance tuning, query optimization, and HA/replication tasks to ensure smooth operations and high availability.

You will collaborate with onshore teams, review business requirements, and coordinate issue resolution with product and operations. Strong scripting and database administration experience are essential.

Qualifications

• Strong production support experience with SQL Server in OLTP/OLAP/BI environments.
• Experience with database installation, upgrades, migration and tuning.
• Proficient in tuning queries and using SQL Server tools.
• Able to coordinate with onshore teams and resolve DBA issues quickly.
• Knowledge of high availability, replication, log shipping.

Responsibilities

• Anticipate production issues and implement preventive measures.
• Troubleshoot application and platform specific DBA issues.
• Ensure bug fixes are tested with minimal defects before releases.
• Collaborate with operations to review business requirements.
• Coordinate with onshore DBA team for coverage and rapid resolution.

Skills

SQL Server

OLTP/OLAP/BI

Query optimization

Performance tuning

DB migration

Tools

SSMS

PerfMon

SQL Profiler

DTA

SSCM/SAC

Job description

Basic Function

• Technical & Application Database related Production Support
• Database Performance Analysis - Understand and resolve slow queries/processes
• Database Archival, Tuning, and Maintenance
• On-site coordination with Technical / Product Team and help resolve DBA Issues

Essential Functions

• Anticipate production issues and take steps to make sure they do not arise
• Help & Troubleshoot Application and Platform specific issues
• Ensure that bug fixes releases are fully tested with minimal defects before releases
• Understand and review the business requirements working with operations / functional teams
• Coordinate all activities with Onshore DBA Team to ensure coverage and speedy time to resolution

Technical Skills

• Strong production support experience in Development, Design and Maintenance of relational databases using SQL Server 2016/2017/2019/2022 in OLTP/OLAP/BI environment
• Working experience in+ Database installation, Database maintenance, Upgradation, Migration, Server/database Tuning, Backup & Recovery operations + Experience in Query Optimization and efficiency on database performance improvement using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor + Knowledge of SQL Server tools (DTA, SSMS, SAC, SSCM, PerfMon)+ Hands On Experience on writing complex queries/ stored procedures / triggers / tables / views / indexes / constraints and functions.
• Knowledge on High Availability (HA), DB mirroring, log shipping, Replication & always on SQL server+ Hands on Experience in user creation / access delegation / auditing.
• Knowledge on SSRS AND SSAS (MDX Query) + Hands on Experience in Tuning T-SQL queries to improve performance + Knowledge of 3rd party DBA tools and applications (SolarWinds DPA, RedGate, SCOM)
• Install and configure new SQL Servers
• Strong experience in DB migration from Oracle to SQL ServerWhen performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes.

Process Specific Skills

• Basic understanding of Insurance business vertical
• Ability to understand the business processes and associated Application functionalityIndependently analyze, solve, and correct issues in real time,providing problem resolution end-to-endExcellent documentation, communication and customer service skillsStrong organization and time management skillsTeam-oriented work ethic that includes willingness to help othersExperience performing resource and capacity planningExperience writing implementation plans

Soft skills (Desired)

• Good listening and consultative skills
• Able to provide constructive Feedback
• Negotiation and persuasion

Soft Skills (Minimum)

• Strong Technical Curiosity – does not have to be asked to show
• initiative and investigate to find the root problems and suggest
• resolutionsStrong communication skillsGood analytical skillsStrong Team player & ability to build & sustain the team