Senior Database Administrator

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:

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.
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.
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.
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.
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.
Monitoring and Alerts:
- Set up monitoring tools to proactively detect issues and respond to alerts promptly.
- Establish and maintain database performance and health dashboards.
Capacity Planning:
- Forecast future database capacity requirements and plan for scaling as needed.
- Allocate and manage storage resources effectively.
Documentation and Reporting:
- Maintain comprehensive documentation of database configurations, procedures, and policies.
- Generate and share regular reports on database performance and utilization.
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.
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).

Skills

MySQL Microsoft SQL PostgreSQL Kubernetes Docker Cassandra MongoDB SQL Azure AWS RDS

Job Details

Industry:

Banking/Financial Services

Functional Area:

Database Administration (DBA)

Total Positions:

1 Post

Job Shift:

First Shift (Day)

Job Type:

Full Time/Permanent

Job Location:

Lahore, Pakistan

Gender:

Male

Minimum Education:

Bachelors

Career Level:

Experienced Professional

Minimum Experience:

6 Years

Apply Before:

May 31, 2024

Posting Date:

Apr 30, 2024

Aftab Currency Exchange Ltd

Banking/Financial Services · 201-300 employees - Lahore

Aftab Currency Exchange Ltd. is a UK incorporated Company that is part of the well-established Aftab group companies and has been operating in the North West of England since 2002. Our head office was the starting point of the UK success story when we commenced business with retail clients and two business associates we now have our London branch in South West London and have over the past 9 years expanded our coverage through the use of agents across the UK and now boosts a network of more than 280 business associates and agents using the Aftab Currency Exchange name which we have worked hard to maintain our credibility and trusts within the Pakistani community.