Job Description
Key Roles and Responsibilities
I. Database Administration & Maintenance
a. Installation & Configuration: Install, configure, and maintain database software across multiple environments (development, staging, production) for both MS SQL Server and MySQL.
b. Monitoring & Optimization: Proactively monitor database system performance, identify bottlenecks, and implement solutions for performance tuning, including query optimization, index management, and server configuration adjustments.
c. High Availability & Disaster Recovery: Implement and manage High Availability (HA) and Disaster Recovery (DR) solutions, such as SQL Server's Always On Availability Groups, Log Shipping, Mirroring, and MySQL Replication/Clustering, to ensure business continuity.
d. Backup & Recovery: Define, implement, and test robust backup and recovery strategies for all databases to ensure data integrity and minimal data loss in case of failures.
e. Patch...