Responsibilities:
- Installing, configuring, and maintaining SQL Server instances.
- Knowledge in Microsoft SQL cluster for high availability.
- Monitoring database performance issues, resource utilization, optimizing SQL queries, and system health.
- Implementing security measures to protect data integrity and confidentiality.
- Backing up and restoring databases to ensure data availability and disaster recovery.
- Troubleshooting issues related to database performance, availability, and security.
- Support, bug fixes, addressing vulnerability issues/fixes of existing systems.
- Perform Microsoft SQL patches and updates for Azure SQL databases to address security vulnerabilities, bug fixes, and performance improvements.
- Perform Database restore and refresh.
- Troubleshoot and resolve any issues related to the Microsoft SQL setup which include networks, software, hardware, and operating systems.
- Maintain documentation related to the Database environment, including configurations, procedures, and troubleshooting guide and keep documentation up-to-date with any changes or enhancements.
- Work closely with application developers to understand and address their requirements.
- Implement scripting for routine maintenance, monitoring, and reporting.
- Provide monthly work progress report records.
Requirements:
- A Degree/Diploma in Computer Science or relevant certification courses.
- At least 5 years’ experience in Microsoft SQL Database Administrator.
- Strong technical and analytical skills, meticulous and organized.
- Experience in PeopleSoft and Azure Cloud would have an added advantage.
- Good knowledge and experience in managing Windows operating systems would have an added advantage.
- Good knowledge in PowerShell script would have an added advantage.
- Good interpersonal, written, oral communication skills and ability to work both independently and in a team environment.
- A positive work attitude.