Note: The job is a remote job and is open to candidates in USA. Confidential company is seeking a Junior Cloud Database Engineer / Junior Data Consultant to modernize and optimize its cloud data architecture. The role focuses on integrating Amazon Aurora DSQL, validating globally distributed application patterns, designing primary writer failover scenarios, and optimizing database resiliency and performance.
Responsibilities
- Database Modernization: Update and configure the application tier to seamlessly integrate with Amazon Aurora DSQL, optimizing distributed queries and ensuring transactional consistency across shards
- Architecture Validation: Partner with the Principal Infrastructure Architect to review, validate, and stress-test the distributed application architecture against Aurora Global Database deployment patterns
- Resiliency & Failover Planning: Collaborate with the DevOps engineering team to design, automate, and document disaster recovery protocols, specifically focusing on primary writer failover scenarios to minimize Recovery Time Objectives (RTO) and Recovery Point Objectives (RPO)
- Performance Tuning: Monitor and optimize cross-region replication lag, write throughput, and connection pooling within the distributed database cluster
- Best Practices & Governance: Establish configuration standards, schema migration strategies, and deployment pipelines tailored for distributed SQL workloads
Skills
- Exp needed: 4-6 years
- Proven experience designing and managing AWS database services, with specific, deep knowledge of **Amazon Aurora** , **Aurora Global Database** , and **Distributed SQL (DSQL)** concepts
- Strong understanding of distributed application patterns, cross-region replication, consensus protocols, and data consistency models (e.g., eventual vs. strong consistency)
- Familiarity with Infrastructure as Code (Terraform, AWS CloudFormation) and CI/CD pipelines to assist DevOps in automating database failovers and environment provisioning
- Experience simulating multi-region infrastructure failures, split-brain scenarios, and database cluster recovery
- Excellent technical consulting skills, with the ability to align development teams, architects, and operations engineers toward a unified infrastructure goal
Benefits
- Remote work arrangement
Company Overview