Windows and MsSQL database administrator

Role & responsibilities

1. Manage Active Directory user accounts, groups, and permissions.

2. Handle user provisioning and de-provisioning as per organizational policies.

3. Monitor system performance, uptime, and availability.

4. Proactively identify and address potential issues before they impact users.

5. Provide timely resolution for escalated incidents, focusing on root cause analysis.

6. Conduct root cause analysis (RCA) for critical incidents and implement preventive measures.

7. Install, configure, optimize and upgrade SQL Server instances.

8. Perform database backups, restorations, and data recovery operations.

9. Analyze and optimize SQL queries for performance improvements.

10. Monitor and resolve deadlocks and blocking issues.

11. Implement data encryption and access control measures.

12. Ensure compliance with data protection regulations and internal policies.

13. Maintain comprehensive documentation of system configurations, procedures, and updates.

14. Ensure compliance with data protection regulations and internal policies.

15. Work closely with cross-functional teams to ensure alignment on projects and initiatives.

16. Plan and execute MsSQL database upgrades to newer versions.

17. Perform data migrations from legacy systems to MsSQL databases.

18. Ensure compatibility and proper testing of applications after database upgrades or migrations.

19. Implementation of audit recommendations which will be done in discussion with Bank team and respective application team.

20. Manage Active Directory user accounts, groups, and permissions.

21. Handle user provisioning and de-provisioning as per organizational policies.

22. Monitor system performance, uptime, and availability.

23. Proactively identify and address potential issues before they impact users.

24. Provide timely resolution for escalated incidents, focusing on root cause analysis.

25. Conduct root cause analysis (RCA) for critical incidents and implement preventive measures.

26. Install, configure, optimize and upgrade SQL Server instances.

27. Perform database backups, restorations, and data recovery operations.

28. Analyze and optimize SQL queries for performance improvements.

29. Monitor and resolve deadlocks and blocking issues.

30. Implement data encryption and access control measures.

31. Ensure compliance with data protection regulations and internal policies.

32. Maintain comprehensive documentation of system configurations, procedures, and updates.

33. Ensure compliance with data protection regulations and internal policies.

34. Work closely with cross-functional teams to ensure alignment on projects and initiatives.

35. Plan and execute MsSQL database upgrades to newer versions.

36. Perform data migrations from legacy systems to MsSQL databases.

37. Ensure compatibility and proper testing of applications after database upgrades or migrations.

38. Implementation of audit recommendations which will be done in discussion with Bank team and respective application team.

39. Coordinating with other Vendors/Teams as specified by the bank.

40. Mitigating all audit observation within one month of audit and enable audit closure.

Preferred candidate profile

Must have the certification of Windows Azure or SQL