MSSQL MYSQL DBA
- Location
- Across Malaysia
- Salary
- Not specified
- Company
- Akash pawar
Job description
### Role & Company / Project Overview Zentact Systems is hiring a highly skilled MSSQL & MySQL Database Administrator for an onsite opportunity in Malaysia. The candidate will manage and maintain enterprise databases across on-premises, Microsoft Azure, and Amazon Web Services (AWS) cloud environments. ### Key Responsibilities & Daily Duties • Database Administration: - Administer and support Microsoft SQL Server and MySQL databases in on-premises and cloud environments. - Perform database installation, configuration, upgrades, patching, and migrations. - Manage database backup, restoration, cloning, and refresh activities. - Monitor database health, availability, and capacity utilization. - Ensure database security, data integrity, and compliance with organizational policies. • Performance Monitoring & Optimization: - Identify and resolve database performance bottlenecks. - Optimize queries, indexes, and stored procedures. - Monitor resource utilization, blocking, deadlocks, and replication issues. - Conduct capacity planning and performance forecasting. • High Availability & Disaster Recovery (HA/DR): - Configure and manage SQL Server Always On Availability Groups. - Configure and manage SQL Server Failover Clustering. - Configure and manage MySQL Replication, MySQL Group Replication, and MySQL InnoDB Cluster. - Implement and test Disaster Recovery (DR) solutions, conducting periodic DR drills and recovery validations. • Cloud Database Administration & Migration: - Administer AWS RDS for SQL Server and MySQL, and AWS EC2-hosted database environments. - Manage AWS Backup, monitoring services, and CloudWatch monitoring and alerting. - Administer Azure SQL Database, Azure SQL Managed Instance, Azure Virtual Machine-based SQL deployments, and Azure Database for MySQL. - Utilize Azure Monitor and Log Analytics. - Develop automation scripts using PowerShell and Shell Scripting for database operations and data protection controls. ### Required Qualifications, Skills & Experience • Mandatory Technical Skills: - Microsoft SQL Server Administration: SQL Server 2016 / 2019 / 2022. - Strong expertise in SQL Server Always On Availability Groups and SQL Failover Clustering. - Proven hands-on experience in Backup & Recovery, Performance Tuning, SSMS, and Query Optimization. - Hands-on experience with MySQL administration and clustering. - Cloud database management experience across AWS and Microsoft Azure platforms. - Scripting skills in PowerShell and Shell Scripting. ### Working Hours, Shifts & Location Details • Location: Malaysia (Onsite opportunity) • Work Mode: Onsite ### Application Instructions Interested candidates who meet the profile requirements are encouraged to submit their updated resume for consideration.