2270759-Lead Assistant Manager

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 ;EXL is the indispensable partner for leading businesses in data-led industries such as insurance, banking and financial services, healthcare, retail and logistics. We bring a unique combination of data, advanced analytics, digital technology and industry expertise to help our clients turn data into insights, streamline operations, improve customer experience, and transform their business. Our partnerships with clients are built on a foundation of collaboration - and we've been chosen as a partner by nine of the top ten leading US insurance companies, nine of the top 20 global banks, and six of the top ten US health care payers. We function as one team to make your goals our goals, whether that's unlocking the value of generative AI or embedding analytics into workflows that reduce risk or power your growth. Clients choose EXL as their transformation partner for many reasons. Our geographic diversity make talent all over the world instantly accessible. Digital accelerators enable unmatched speed-to-value, letting you realize results fast. It's our people that truly set us apart, though, including the 1,500 data scientists we have dedicated to our generative AI practice. And our more than twenty years of experience in delivering business services, garnering stellar client references, and maintaining a solid balance sheet are reassuring to our C-suite clients. Find out for yourself why clients, employees, and analysts think we're some of the best in the business. Contact us to see how we can help you achieve your goals.