Infrastructure Engineer

Project Role : Infrastructure Engineer
Project Role Description : Assist in defining requirements, designing and building data center technology components and testing efforts.
Must have skills : Microsoft SQL Server Administration
Good to have skills : MySQL, MongoDB
Minimum 3 year(s) of experience is required
Educational Qualification : 15 years full time education

Summary: As an Application Tech Support Practitioner, you will act as the ongoing interface between the client and the system or application. You will be dedicated to quality, using exceptional communication skills to keep our world-class systems running. With your deep product knowledge, you will accurately define client issues and interpret and design resolutions. Your typical day will involve providing ongoing support to clients, troubleshooting technical issues, and ensuring the smooth functioning of the system or application. Roles & Responsibilities: - Expected to perform independently and become an SME. - Required active participation/contribution in team discussions. - Contribute in providing solutions to work-related problems. - Provide ongoing support to clients, addressing their technical issues and ensuring their satisfaction. - Troubleshoot system or application issues and provide timely resolutions. - Collaborate with the team to identify and implement improvements to enhance system performance. - Stay updated with the latest industry trends and technologies to provide effective support. - Assist in the development and execution of test plans to ensure system functionality and performance. - Conduct training sessions for clients to enhance their understanding and usage of the system or application. Professional & Technical Skills: Installation/Upgradation/Migration of SQL Servers (2012 to 2022) Should have good knowledge on configuring High Availability/Disaster recovery solutions which includes (Log shipping, Replication, SQL Cluster, Always on availability Group) Responsible for physical performance tuning, implementation, and support of the applications from a database perspective. Attend CAB (Change Advisory Board) meeting and get proper approvals from product owners to implement DB changes. Document operational or newly engineered solutions properly to educate and inform the clients and DBAs from the various levels of the organization. Work on Writing custom stored procedures, t-sql queries, PowerShell scripts, views, and triggers based on requirements for DB maintenance and automate tasks. Work on writing technical and RCA (Root Cause Analysis) documentation. Join bridge calls to troubleshoot and fix P1(SEV1) and P2 (SEV2) incidents. work on performance tuning like provide suggestions to create indexes and tune stored procedures. Troubleshoot recurring problems and fix them permanently. Conduct DB DR Drill activity, ensure to bring the DR site online if any outage at Primary site. Maintaining SOPs up to date Daily Checklist /health report/Backup/productivity report Weekly highlights and low lights Additional Information: - The candidate should have a minimum of 3 years of experience in Microsoft SQL Server Database Administration. - This position is based at our Gurugram office. - A 15 years full-time education is required.