Cloud DBA

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. 1. Database Design and Architecture:

• Collaborate with software engineers, DevOps, and infrastructure teams to design and implement optimal database solution 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.
  
  Proven experience as a Cloud Database Administrator, with a focus on PostgreSQL.
• Strong experience with AWS cloud services, particularly RDS. AWS certification (e.g., AWS Certified Database - Speciality).
• 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.
• Knowledge of containerization and orchestration technologies (Docker, Kubernetes).
• Familiarity with database security practices and compliance standards.
• Scripting and automation skills using languages like Python, Bash, JavaScript or similar.
• Familiarity with version control systems (Git) and CI/CD pipelines.
• Strong problem-solving skills and the ability to work effectively in a fast-paced environment.
• Excellent communication and teamwork skills.
  
  For more than 20 years, Talan has been advising companies and administrations, supporting them, and implementing their transformation projects in the UK and abroad. With a presence on four continents and a headcount of 6000 consultants, our ambition is to reach a billion turnover by the end of 2025.
In the UK, Talan counts 500 employees on several sites, the main being: London, Birmingham, Edinburgh and Chester, Leeds.