AWS Cloud Database Administrator DBA

JAM Recruitment; Birmingham; Hybrid; GBP 45,000 - 75,000; Full time

Job description

Do you want to work at the forefront of Technology and Software? Are you passionate about working with cutting-edge technology and self-motivated to find innovative solutions to complex challenges as part of a team who help keep the UK safe? If so, the following role may be right for you…

We are looking for a DV Cleared AWS Cloud Database Administrator to join the existing team in London, Birmingham, or Glasgow on an initial 12-month contract, mostly working from home with meetings onsite 2 days per quarter.

The Cloud DBA will be responsible for the maintenance and optimization of our PostgreSQL databases hosted on the AWS Cloud platform. The successful candidate will collaborate with cross-functional teams to ensure database reliability, availability, and performance, while also contributing to the overall architecture and strategy of our cloud-based database solution.

As an AWS Cloud DBA, your responsibilities include, but are not limited to:

1. Database Design and Architecture:
   Collaborate with software engineers, DevOps, and infrastructure teams to design and implement optimal database solutions for various applications.
   Participate in database schema design, indexing strategies, and query optimization to ensure efficient data storage and retrieval.
2. Database Deployment and Management:
   Deploy and configure PostgreSQL database instances on AWS RDS, considering factors such as instance sizing, storage, and security.
   Implement and manage replication, clustering, and backup/recovery strategies to ensure high availability and disaster recovery.
3. Performance Monitoring and Optimization:
   Monitor database performance, proactively identifying and resolving performance bottlenecks, slow queries, and other issues affecting system responsiveness.
   Tune database parameters, indexes, and queries for optimal performance.
4. Security and Compliance:
   Implement and enforce security best practices for PostgreSQL databases, including user access controls, encryption, and data masking as needed.
   Ensure compliance with industry standards and regulations related to data security and privacy.
5. Backup and Recovery:
   Develop and maintain backup and recovery strategies, including regular backups, automated recovery testing, and data retention policies.
6. Troubleshooting and Issue Resolution:
   Investigate and resolve database-related incidents, working closely with development and operations teams to diagnose and rectify issues.
7. Automation and Scripting:
   Develop automation scripts and tools for routine database tasks, deployments, monitoring, and scaling.
8. Documentation:
   Maintain comprehensive documentation for database configurations, processes, and procedures.
9. Collaboration and Training:
   Collaborate with cross-functional teams to provide database expertise and guidance.
   Provide training and guidance to junior members of the team as needed.

You

To succeed within the role of an AWS Cloud DBA, you'll have experience in a similar position and you'll have the following skills and experience:

• Proven experience as a Cloud Database Administrator, with a focus on PostgreSQL.
• Strong experience with AWS cloud services, particularly RDS.
• In-depth knowledge of PostgreSQL database internals, architecture, and best practices.
• Proficiency in SQL, PL/pgSQL, and query optimization.
• Experience with database performance tuning and monitoring tools.
• Familiarity with database security practices and compliance standards.
• Scripting and automation skills using languages like Python, Bash, JavaScript, or similar.
• Strong problem-solving skills and the ability to work effectively in a fast-paced environment.
• Excellent communication and teamwork skills.

Please note that due to security and urgency for this role, we can only consider those with live and transferrable MOD/UKSV DV clearance.

This is an exciting opportunity to work for a global business that has developed a strategy of working closely with its contingent workforce. Within the role, you can expect to:

• Achieve a work/life balance
• Increase earning potential
• Develop your skills
• Be appreciated and valued

If this sounds like the role for you, apply now as a start date is fast approaching!