Join to apply for the Junior Database Administrator role at ACE Money Transfer.
Who we are: 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, real estate, advertising businesses, and software solutions in Pakistan.
Junior Database Administrator: We are looking for a talented individual to join our team as a Junior Database Administrator, focusing on improving the efficiency and availability of our databases. The candidate must have strong analysis and troubleshooting skills; experience managing enterprise-class databases will be an added advantage.
Duties and Responsibilities:
1. Ensure that databases are optimally configured and collaborate with the development team to optimize database use, including query profiling, table indexing, and file layout.
2. Perform database performance tuning and optimization, such as improving queries, rebuilding/updating indices, performing database cleanups, and reconfiguring settings.
3. Set up and manage replication topologies for high availability.
4. Manage database security by granting/revoking permissions, ensuring security practices, and conducting periodic audits.
5. Establish and maintain highly available database architectures.
6. Utilize SQL tools effectively.
7. Implement operational automation.
8. Design, test, and implement disaster recovery plans to minimize RTO and meet RPO objectives.
9. Ensure database backups are current and available, with policies in place to minimize data loss.
10. Participate in on-call rotation schedules.
11. Assist the team with application issues.
12. Support application development, deployment, and system support functions throughout the development lifecycle.
13. Manage large-scale complex database projects into manageable deliverables.
Required Skills:
* Bachelor's or master's degree in computer science, computer engineering, or information systems.
* At least 1 year of experience in database administration.
* Proficiency in T-SQL programming, including writing functions, procedures, and complex queries.
* Knowledge of database clustering technologies (AlwaysOn, failover clusters, mirroring, log shipping, etc.).
* Experience with data conversion technologies.
* Strong analysis and troubleshooting skills, including familiarity with profiling tools.
* Proactive, self-starting attitude with the ability to drive projects to completion.
* Understanding of database optimization for functionality, reliability, supportability, availability, scalability, and integrity.
For more information, visit www.acemoneytransfer.com.
#J-18808-Ljbffr