Microsoft SQL Database Administrator

Responsibilities

1. SQL Server Administration:Install, configure, and maintain SQL Server instances.
   Manage and monitor SQL Server clusters for high availability.
   Perform SQL Server patches and updates, including Azure SQL databases, to address security vulnerabilities and performance improvements.
2. Performance Monitoring and Optimization:Monitor database performance, resource utilization, and system health.
   Optimize SQL queries and troubleshoot database performance issues.
3. Security and Backup Management:Implement security measures to protect data integrity and confidentiality.
   Perform regular backups and restorations to ensure data availability and disaster recovery.
4. Issue Resolution and Support:Troubleshoot and resolve issues related to database performance, availability, and security.
   Provide support for bug fixes, vulnerability issues, and other related tasks.
   Assist in resolving issues related to the Microsoft SQL setup, including network, software, hardware, and operating systems.
5. Collaboration and Documentation:Work closely with application developers to understand and address their database requirements.
   Maintain up-to-date documentation related to the database environment, including configurations, procedures, and troubleshooting guides.
6. Reporting and Communication:Provide monthly work progress reports to the Polytechnic’s representative.
   Ensure effective communication and collaboration within the team and with stakeholders.

Qualifications and Requirements:

• Educational Background:Degree/Diploma in Computer Science or relevant certification courses.

Experience:

• At least 5 years of experience as a Microsoft SQL Database Administrator.
• Experience with PeopleSoft and Azure Cloud is an added advantage.
• Strong knowledge and experience in managing Windows operating systems and PowerShell scripting is beneficial.

Skills and Competencies:

• Strong technical and analytical skills, with a meticulous and organized approach.
• Excellent interpersonal, written, and oral communication skills.
• Ability to work independently and as part of a team.
• Positive work attitude with a proactive and problem-solving mindset.