Basic Function Technical Application Database related Production Support Database Performance Analysis - Understand and resolve slow queries processes Database Archival Tuning and Maintenance In office 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 Server When 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 functionality Independently analyze solve and correct issues in real time providing problem resolution end-to-end Excellent documentation communication and customer service skills Strong organization and time management skills Team-oriented work ethic that includes willingness to help others Experience performing resource and capacity planning Experience 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 resolutions Strong communication skills Good analytical skills Strong Team player ability to build sustain the team

📌 Lead Assistant Manager (Uttar Pradesh)
🏢 EXL Service
📍 Uttar Pradesh