• Responsible for physical database architecture and design, capacity planning, development, performance tuning, implementation, and support of the applications from a database perspective.

• Conduct T- SQL Code Reviews to ensure coding standards, best practices and avoid potential performance issues.

• 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.

• Hands on Experience in on Always on and DB Mirroring

• 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.

• Having good communication skills and ready to train the junior associates.

• To have good soft skills to engage with customers and end users for the project works.

• Willingness to work in 24X7 projects (Shifts)

Added Advantage:

• Any of the following certificate:

• SQL Server certifications.

• SQL Cloud based solutions and experience.

• Hands on experience with Other Databases like Oracle/MySQL

• Experience operating and scaling a service in AWS/Azure/Open stack i.e. S3, EBS, EC2, ELB, RDS, EMR.

• Programming (Perl, power shell)