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

2 year(s) of experience is required


Educational Qualification :15 years full time education

Summary:As an Infrastructure Engineer, you will assist in defining requirements, designing and building data center technology components, and testing efforts. You will play a crucial role in ensuring the smooth functioning of our data center infrastructure.
Roles & Responsibilities:

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 SOP's up to date

Daily Checklist /health report/Backup/productivity report

Weekly highlights and low lights.
Professional & Technical Skills:

Must To Have Skills:Proficiency in Microsoft SQL Database Administration.

Good To Have Skills:Experience with MySQL and MongoDB.

Strong understanding of database administration principles.

Experience in performance tuning and optimization of database systems.

Knowledge of backup and recovery strategies for database systems.

Familiarity with database security best practices.

Ability to troubleshoot and resolve database-related issues.

Excellent analytical and problem-solving skills.
Additional Information:

The candidate should have a minimum of 2 years of experience in Microsoft SQL Database Administration.

This position is based at our Gurugram office.

A 15 years full-time education is required.

Qualifications
15 years full time education