EXL

Analyzes business data and runs outsourced operations

Lead Assistant Manager

Database AdministrationConfirmed live in the last 24 hours

Full-timeNoida, Uttar Pradesh, IndiaNo salary listedIn-person

About the Job

Requirements

Strong production support experience in development, design, and maintenance of relational databases using SQL Server 2016, 2017, 2019, or 2022 in OLTP, OLAP, or BI environments.
Experience with database installation, maintenance, upgrades, migration, server and database tuning, and backup and recovery operations.
Experience optimizing queries and improving database performance using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
Knowledge of SQL Server tools, including DTA, SSMS, SAC, SSCM, and PerfMon.
Hands-on experience writing complex queries, stored procedures, triggers, tables, views, indexes, constraints, and functions.
Knowledge of high availability, database mirroring, log shipping, replication, and SQL Server Always On.
Hands-on experience with user creation, access delegation, and auditing.
Knowledge of SSRS and SSAS (MDX Query).
Hands-on experience tuning T-SQL queries to improve performance.
Knowledge of third-party DBA tools and applications, including SolarWinds DPA, RedGate, and SCOM.
Strong experience migrating databases from Oracle to SQL Server.
Basic understanding of the insurance business vertical and ability to understand business processes and associated application functionality.
Ability to independently analyze, solve, and correct issues in real time, providing end-to-end problem resolution.
Experience performing resource and capacity planning and writing implementation plans.
Strong technical curiosity, initiative, and ability to investigate root problems and suggest resolutions.
Strong communication skills, analytical skills, and ability to work as part of a team.
Good listening and consultative skills, ability to provide constructive feedback, and negotiation and persuasion skills.
Strong organization and time management skills and willingness to help others.

Responsibilities

Anticipate production issues and take steps to prevent them.
Help troubleshoot application- and platform-specific issues.
Ensure bug-fix releases are fully tested and have minimal defects before release.
Understand and review business requirements while working with operations and functional teams.
Coordinate activities with the onshore DBA team to ensure coverage and speedy resolution.
Install and configure new SQL Servers.
When performance issues arise, determine effective ways to improve performance, including hardware purchases, server configuration changes, or index and query changes.
Coordinate onsite with technical and product teams to help resolve DBA issues.

Desired Qualifications

Good listening and consultative skills; ability to provide constructive feedback; negotiation and persuasion skills.

Basic FunctionTechnical & 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 IssuesEssential Functions ;Anticipate production issues and take steps to make sure they do not ariseHelp & Troubleshoot Application and Platform specific issuesEnsure that bug fixes releases are fully tested with minimal defects before releasesUnderstand and review the business requirements working with operations / functional teamsCoordinate all activities with Onshore DBA Team to ensure coverage and speedy time to resolutionTechnical SkillsStrong 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 plansSoft skills (Desired) ; Good listening and consultative skills ;Able to provide constructive Feedback ;Negotiation and persuasionSoft 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 ;

About the Company

EXL

Analyzes business data and runs outsourced operations

EXL analyzes business data and runs outsourced operations for insurers, healthcare payers, banks, retailers, and other large organizations. Its teams combine industry expertise with data engineering and AI to handle tasks such as claims processing, payment reviews, customer service, and finance within existing technology environments. The company also builds software, including LifePRO, which manages insurance policies, and EXLdata.ai, which connects fragmented data for use in AI systems. Clients pay for consulting projects, ongoing managed services, and software delivered through the cloud. EXL was founded in 1999 and is headquartered in New York City.

Company size: 10,001+
Company stage: IPO
Headquarters: New York City, New York
Founded: 1999

Recently Posted Jobs

Explore more opportunities at EXL

See more jobs