Database Administrator (MySQL)

ACE Money Transfer is looking for a motivated Database Administrator (DBA) to help maintain reliable, secure, and high-performing database environments. The role focuses primarily on MySQL and Microsoft SQL Server (MSSQL).

The DBA will be responsible for supporting database availability, performance, security, and reliability across Development, Staging, and Production environments. The role will work closely with Development, DevOps, Operations, Infrastructure, and Security teams on database provisioning, monitoring, maintenance, troubleshooting, and incident response.

Responsibilities

• Install, configure, maintain, and administer MySQL and MSSQL database instances across self-managed and managed environments such as AWS RDS.

• Manage database users, roles, privileges, schemas, and routine configuration changes.

• Perform routine database administration tasks, including backups, restores, schema changes, and database maintenance.

• Troubleshoot database connectivity, availability, and configuration-related issues.

• Set up and maintain database environments across Development, Staging, and Production.

• Maintain consistent database configurations across environments and follow defined change-management processes.

• Manage database schema changes and ensure database changes are maintained through appropriate version-control processes.

• Support reliable movement of database schemas and required data between environments.

• Monitor database health, performance, resource utilization, storage capacity, and availability.

• Identify and troubleshoot slow queries, blocking, locking, resource constraints, and other database performance issues.

• Review execution plans, indexing, and query performance, and implement basic database tuning recommendations.

• Use centralized monitoring and logging tools such as PMM, Prometheus, Grafana, and CloudWatch to monitor database health and respond to actionable alerts.

• Conduct regular database health checks and support capacity planning activities.

• Configure, monitor, and maintain database backup schedules in accordance with defined policies and recovery requirements.

• Validate backups regularly and perform restore testing to ensure successful data recovery.

• Support database replication, failover, and basic high-availability configurations.

• Investigate and remediate failed backups, replication issues, and database recovery-related incidents.

• Participate in disaster recovery and business continuity activities related to database environments.

• Implement and maintain database security practices, including access control, user privileges, encryption, auditing, and secure configuration.

• Conduct periodic access reviews for database users and privileges, removing inactive or unauthorized access where required.

• Apply database patches, security updates, and version upgrades in coordination with Security and Infrastructure teams.

• Support IT security audits, compliance activities, and reporting related to database infrastructure.

• Ensure database administration activities follow defined security and change-control policies.

• Develop and maintain automation scripts using Python, Bash, PowerShell, or SQL for routine database administration tasks.

• Automate database health checks, backup validation, monitoring, reporting, and routine maintenance activities where practical.

• Support continuous improvement of database administration processes through automation and standardization.

• Provision, configure, monitor, and maintain managed database services such as AWS RDS for MySQL.

• Support database scaling, storage management, monitoring, backups, and ongoing maintenance within AWS environments.

• Work with Cloud and Infrastructure teams on networking, security groups, connectivity, and database infrastructure requirements.

• Monitor cloud database resource utilization and support capacity planning and optimization activities.

• Resolve assigned database support incidents and requests within defined SLA and priority timelines.

• Perform initial triage and troubleshooting of database incidents, including connectivity issues, performance degradation, replication lag, failed jobs, and backup failures.

• Coordinate with Software Development, DevOps, Operations, Infrastructure, and Security teams to troubleshoot database and application-related issues.

• Participate in incident response, root-cause analysis, and remediation activities for database-related incidents.

• Escalate complex or high-impact database issues to the Senior DBA / Database Lead when required.

• Maintain accurate documentation for database configurations, environments, access controls, backup procedures, recovery processes, and operational runbooks.

• Document database changes, incidents, troubleshooting procedures, and known issues.

• Follow defined database administration, change-management, security, and operational standards.

• Continuously develop expertise in MySQL, MSSQL, database administration best practices, cloud database services, and emerging database technologies.

• Bachelor’s degree in Computer Science, Information Technology, Software Engineering, or a related field.
• 2–4 years of hands-on experience specifically in database administration or database support, with practical experience managing production database environments.
• Strong hands-on experience with MySQL administration, including installation, configuration, user management, backups, restores, monitoring, and troubleshooting.
• Practical experience with Microsoft SQL Server (MSSQL) administration and support.
• Hands-on experience with AWS RDS, preferably RDS for MySQL, including provisioning, configuration, monitoring, backups, and maintenance.
• Solid understanding of relational database concepts, including indexing, normalization, transactions, locking, constraints, and query optimization.
• Practical experience troubleshooting database performance issues, slow queries, blocking, and resource utilization.
• Experience with database backup, recovery, replication, and high-availability concepts.
• Working knowledge of database security, access control, auditing, patching, and secure configuration practices.
• Experience with database monitoring and observability tools such as PMM, Prometheus, Grafana, AWS CloudWatch, or equivalent platforms.
• Scripting experience in Python, Bash, PowerShell, or SQL for automation and routine administration tasks.
• Good understanding of Linux/Windows server administration and basic networking concepts relevant to database connectivity and infrastructure.
• Certifications such as Oracle MySQL Database Administrator, Microsoft SQL Server, AWS Database Specialty, or equivalent are strongly preferred.
• Exposure to NoSQL technologies such as MongoDB, Redis, or DynamoDB is a plus.