Senior Lead Database Engineer
India
I am a seasoned professional with a broad range of skills and experience in the field of SQL development and database administration. Here are some key highlights:Worked with Gateway to refresh and schedule jobs, ensuring efficient data updates.Proficient in query optimization, performance tuning, and deadlock analysis using Extended Events.Experienced in product build management for databases and an expert user of SQL Server Data Tools.Possess a good understanding of… Show more I am a seasoned professional with a broad range of skills and experience in the field of SQL development and database administration. Here are some key highlights:Worked with Gateway to refresh and schedule jobs, ensuring efficient data updates.Proficient in query optimization, performance tuning, and deadlock analysis using Extended Events.Experienced in product build management for databases and an expert user of SQL Server Data Tools.Possess a good understanding of execution plans and the ability to address performance issues effectively.Expertise in automating database deployment using PowerShell scripting.Strong background in database administration activities, including database creation, maintenance, performance monitoring, tuning, troubleshooting, disaster recovery, backup/restore, and migration. Familiar with technologies such as Always On and Mirroring.Skilled in creating SQL Server jobs, Alerts, SQL Mail Agent, Database Mails, and Extended Events within databases.Worked in various environments, including development, staging, and production.Proficient in Extraction, Transformation, and Loading (ETL) using SSIS. Experienced in creating mappings/workflows to extract data from various sources such as Oracle, SQL Server, Flat Files, and legacy systems, and loading it into different business entities.Experience in SSRS and Power BI reporting tools to design and develop extensive reports.Excellent verbal and written communication skills, strong analytical abilities, and the ability to work independently and as part of a team.Well-versed in working within an agile model, including activities such as planning, grooming, and delivering sprints with proper methodologies.Experience in designing reports with Crystal Reports, deploying reports into PROD and UAT servers, and providing support to end users.Proficient in preparing builds for multiple versions using DACPAC with dynamic builds.Exposure to POWER BI development in a cloud environment. Show less