Cloud DevOps Database Engineer( Cloud DBA/ Database Admin/PostgreSQL DBA)

Ace Technologies - Denver, CO

Full-time

Denver, CO

Professional, Scientific, and Technical Services

About the position

The Cloud DevOps Database Engineer will be responsible for designing and maintaining scalable, secure, and high-performance database solutions in AWS. This role involves collaboration with DevOps, security, and development teams to ensure the reliability and optimization of cloud-based databases during the migration of an enterprise SaaS product from Oracle Cloud to AWS. The position requires expertise in AWS technologies and database management, particularly with PostgreSQL.

Responsibilities

• Manage and optimize the migration of databases from Oracle Cloud to AWS, ensuring minimal downtime and data integrity throughout the process.
• Create mechanisms for capturing snapshots of specific databases within an RDS instance and for rehydrating those snapshots in other DB instances.
• Create mechanisms and workflows for doing granular backups of specific databases within an RDS/AURORA instance and allow for rehydrating those backups.
• Propose solutions that leverage AWS serverless solutions as well as help design database solutions that optimize availability, cost, and performance dimensions.
• Design and implement database automation processes for provisioning, scaling, and monitoring AWS RDS and Aurora PostgreSQL instances.
• Ensure database security by implementing encryption, access control, and monitoring mechanisms in line with AWS best practices.
• Collaborate with development and DevOps teams to troubleshoot database-related issues, optimize query performance, and ensure high availability and disaster recovery strategies are in place.

Requirements

• 5+ years of experience with cloud databases like AWS RDS PostgreSQL and AWS Aurora PostgreSQL.
• Proficiency in database performance tuning, query optimization, and troubleshooting in cloud environments.
• Hands-on experience with AWS database security features, including encryption, IAM roles, and fine-grained access control.
• Experience with database migration strategies, particularly migrating databases from Oracle Cloud to AWS RDS or Aurora PostgreSQL.
• Experience in automating infrastructure and application workflows using Python, with a strong focus on developing and maintaining GitOps pipelines for continuous deployment.
• Experience in automating database management tasks, including backups, monitoring, and disaster recovery, using tools like Terraform, GitLab, or other infrastructure-as-code solutions.
• Ability to work collaboratively in teams, while communicating thoughts, concerns, and ideas professionally.
• Willingness to work with stakeholders to help clarify requirements and to positively influence technical direction through technical designs.
• Ability to be flexible to changing priorities.