Job Description

ACE Money Transfer is UK based company with its headquarters in Manchester, United Kingdom. The company is an online remittance service provider for customers out of the UK, Canada, Australia, and the European Union, including Switzerland. The company is a parent company in a group of companies with a diversified portfolio including digital wallet services in the UK and real estate, advertising businesses, and software solutions in Pakistan.

Job Title: Senior Database Administrator (DBA)

Job Summary:

As a Senior MySQL Database Administrator, you will be responsible for overseeing the design, implementation, maintenance, and optimization of MySQL database systems. You will work closely with development teams, system administrators, and other stakeholders to ensure the availability, security, and performance of MySQL databases.

Key Responsibilities:

1. Database Design and Planning:
   • Collaborate with application developers and architects to design and plan database solutions that meet business requirements.
   • Define database schemas, tables, indexes, and relationships for optimal performance and scalability.
2. Installation and Configuration:
   • Install and configure database software and related tools on various platforms.
   • Implement and maintain high availability solutions such as database clustering and replication.
3. Performance Tuning:
   • Monitor and analyze database performance using tools and techniques to identify and resolve bottlenecks.
   • Optimize SQL queries, database schema, and configurations for improved performance.
4. Security and Access Control:
   • Implement and enforce security measures to protect sensitive data.
   • Manage user accounts, roles, and permissions to ensure data access control.
   • Regularly apply security patches and updates.
5. Backup and Recovery:
   • Develop and maintain backup and recovery strategies to safeguard data against loss or corruption.
   • Test and execute backup and recovery procedures regularly.
6. Monitoring and Alerts:
   • Set up monitoring tools to proactively detect issues and respond to alerts promptly.
   • Establish and maintain database performance and health dashboards.
7. Capacity Planning:
   • Forecast future database capacity requirements and plan for scaling as needed.
   • Allocate and manage storage resources effectively.
8. Documentation and Reporting:
   • Maintain comprehensive documentation of database configurations, procedures, and policies.
   • Generate and share regular reports on database performance and utilization.
9. Troubleshooting and Problem Resolution:
   • Investigate and resolve database-related issues, such as data corruption or performance degradation.
   • Participate in on-call support and respond to critical incidents.
10. Collaboration and Teamwork:
    • Collaborate with cross-functional teams, including developers, system administrators, and network engineers.
    • Mentor and provide guidance to junior database administrators.

Qualifications and Skills:

• Bachelor’s degree in Computer Science, Information Technology.
• 4 to 6 years of experience in database administration, with a focus on MySQL/ PostgreSQL / Microsoft SQL Server.
• Proficiency in SQL query optimization and performance tuning.
• Strong knowledge of database security best practices.
• Experience with database clustering, replication, and high availability solutions.
• Familiarity with scripting languages (e.g., Bash, Python) for automation.
• Excellent problem-solving and communication skills.
• Relevant certifications, such as MySQL Certified Database Administrator (CMDBA), are a plus.

Preferred Additional Skills:

• Experience with cloud-based databases (e.g., AWS RDS, Azure SQL Database).
• Knowledge of NoSQL databases (e.g., MongoDB, Cassandra).
• Familiarity with containerization and orchestration tools (e.g., Docker, Kubernetes).

Work Environment:

The DBA typically works in an office or IT environment. Depending on the organization’s needs, there might be occasional requirements for off-hours support and on-call duties, especially during critical database incidents or

Minimum Experience 5 years

Apply before 26th Nov – 2023