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.