What are the responsibilities and job description for the Sr Cloud Database Engineer position at Surge IT?
We are looking for a Senior Cloud Database Engineer to lead migration from a monolithic database to a modern, cloud-native platform. This role focuses on database design, schema conversion and data migration to PostgreSQL. You will work with Solutions Architects, DevOps, and CloudOps teams to design migration strategies, manage AWS RDS and Aurora PostgreSQL databases, and ensure data integrity, performance, scalability, and reliability.
Key Responsibilities
Key Responsibilities
- Lead schema conversion and data migration from legacy databases (e.g., Sybase, Oracle, SQL Server) to PostgreSQL
- Design and execute migration strategies and workflows
- Provision and manage databases on AWS RDS and Aurora PostgreSQL
- Collaborate with Solutions Architects, DevOps, and CloudOps teams
- Ensure data integrity, performance, and reliability during and after migration
- Experience in database engineering or related field
- Strong experience with database design, schema conversion and data migration
- Handson experience with AWS RDS PostgreSQL in production environments
- Experience with migration tools (e.g., AWS DMS, Flyway)
- Proficiency in Python and shell scripting
- Experience with secure database access and authentication mechanisms
- Experience with Amazon Aurora PostgreSQL
- Experience with database design, instance sizing, backup, and high availability
- Experience migrating from legacy databases (Sybase, Oracle, SQL Server)
- Familiarity with infrastructureascode (Terraform, CloudFormation)
- Experience with CI/CD and DevOps practices