Responsibilities
- To manage and administer the organisation’s MSSQL Database infrastructure to ensure high availability, security and performance.
- Configuring, administrating, securing and maintaining MSSQL Server 2014, 2016 instances and databases in all respects.
- Upgrading/Migrating SQL Server DBMS to higher versions and applying service packs and hot fixes.
- Managing High Availability solutions like MS Clustering and Always-on.
- Monitoring and Managing server and database level performance.
- Monitoring and Managing database space requirement.
- Monitoring and Performing database backups and restoration.
- Managing database security aspects, including creating groups, database users, roles, granting permissions.
- Managing and Refresh database user passwords regularly according to agency security policy
- Managing database encryption technology like Microsoft TDE, etc
- Monitor databases for errors and perform problem determination when necessary.
- Responding to alerts and incidents according to SLA
- Working closely with team members to support project assigned.
Requirements
- Diploma / Degree in Information Technology, Information Systems or equivalent discipline or database certification with 3-5 years experience in MS SQL database administration.