Cloud Database Administrator

Job Description

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.

Qualifications

• 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.