AWS Database Engineer

Job Description: AWS Database Engineer

Join our AWS team as an AWS Database Engineer at the Consultant level, where you will focus on designing, migrating, and optimizing database solutions in AWS cloud environments. This role requires deep technical expertise to support complex AWS projects, ensuring data integrity, performance, and scalability. Candidates should have at least 8 years of experience in database engineering, with specialized knowledge in AWS migrations and related tools to handle enterprise-level deployments.

Key Responsibilities

Architect and implement AWS database solutions using services like Amazon RDS, Aurora, DynamoDB, Redshift, and DocumentDB, tailored for high-performance and resilient applications.

• Lead database migrations to AWS using Terraform for IaC, DMS (Database Migration Service), and Schema Conversion Tool, minimizing data loss and downtime in complex scenarios.
• Optimize database performance through indexing, query tuning, partitioning, and integration with caching services like ElastiCache.
• Configure AWS Connect integrations with databases for real-time data handling in contact centers, such as storing call logs in S3 or querying customer data from RDS.
• Manage infrastructure aspects of databases, including storage (EBS, S3), backups, replication (cross-region/global), and disaster recovery using services like AWS Backup.
• Collaborate with network and application teams to ensure secure data access, implementing VPC endpoints, IAM roles, and encryption (KMS) for compliance.
• Develop automation scripts and pipelines for database provisioning, scaling, and monitoring using Terraform, Lambda, and CloudFormation.
• Perform security assessments, implement access controls, and monitor database health with CloudWatch, Performance Insights, and AWS Trusted Advisor.
• Troubleshoot complex issues in hybrid environments, including on-premises to AWS migrations and multi-database integrations.
• Contribute to best practices for data modeling, ETL processes, and big data handling with services like Glue and Athena.

Required Qualifications

• Bachelors degree
• Minimum 8 years of experience in database engineering, with at least 5 years in AWS environments.
• Expert-level proficiency in AWS migrations, including homogeneous/heterogeneous database transfers and post-migration optimizations.
• Strong hands-on experience with Terraform for managing database infrastructure as code, including drift detection and version control.
• Knowledge of AWS Connect for database-driven applications, such as integrating with Lex for chatbots or Kinesis for streaming data.
• Comprehensive infrastructure knowledge, including storage types, IOPS provisioning, and integration with compute services like EC2 and Lambda.
• Expertise in network configurations for databases, such as private subnets, NAT gateways, and peering for secure connectivity.
• Demonstrated ability to manage complex AWS projects, including data warehousing, real-time analytics, and serverless data solutions.
• Proficiency in SQL/NoSQL databases (e.g., MySQL, PostgreSQL, MongoDB) and tools like pgAdmin or DynamoDB streams.
• Excellent analytical skills and experience with data migration tools like AWS SCT and third-party ETL software.

Preferred Skills

• Familiarity with containerized databases in EKS and orchestration with Kubernetes.
• Background in data governance and compliance (e.g., GDPR, SOC 2).

This role offers the chance to work on innovative AWS database projects in a collaborative team.

Certifications

• AWS Certified Data Engineer – Associate (Mandatory)
• AWS Certified Solutions Architect – Associate (Mandatory)
• AWS Certified Database – Specialty

  *

  (Important)
• Terraform Associate certification (Important)
• AWS Certified DevOps Engineer – Professional (Recommended)
• AWS CloudOps Engineer Associate (Recommended)
• ITIL Foundations certification (Optional)