Junior Database Administrator

Overview

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

Junior Database Administrator

We are looking for a talented individual to join our team in the role of a Junior Database Administrator who will focus on improving the efficiency and availability of our databases. This candidate must have strong analysis and troubleshooting skills; experience managing enterprise-class databases will be an added advantage.

Duties and Responsibilities

• Ensure that databases are optimally configured, and work with the development team to optimize the use of the database from the application perspective, including query profiling, table indexing, and file layout.
• Perform database-related performance tuning and optimization as suggested by statistics, including improving and revising poorly written queries, rebuilding / updating table indices and statistics, performing database cleanups and archives, reconfiguring defaults, and other tuning processes to improve system performance.
• Set up and manage replication topologies for high availability.
• Manage database security, granting / revoking permissions, and ensuring security practices are in place as part of IT security initiatives. Make recommendations for ongoing security and dual-control aspects of database operation. Perform periodic audits of database access rights to prevent unauthorized access and ensure regulatory compliance.
• Set up and maintain highly available database architectures.
• Knowledge of SQL tools.
• Implement operational automation.
• Design, implement, and test disaster recovery scenarios to minimize RTO and meet RPO goals.
• Ensure that database backups are current and available for all production databases; implement testing policies and practices to minimize data loss risk.
• Participate in on-call rotation schedule.
• Assist the team with application issues.
• Participate in the analysis and staging process of application developments, application deployments / installations through a release process, and other support functions in the system development life cycle.
• Organize large-scale complex DB projects into manageable deliverables and activities.

Required Skills

#J-18808-Ljbffr