Database Engineer is responsible for designing, implementing, and managing data storage solutions on the Amazon Web Services platform and traditional DBAs activities of managing databases on physical hardware
Core Roles & Responsibilities related to cloud databases on AWS
- Database Architecture & Design: Define and implement scalable, resilient data architectures. This includes selecting the right engine for the workload, such as Amazon RDS, Postgres, Aurora, DynamoDB, or Redshift.
- Automation & IaC: Use tools like AWS CloudFormation, Terraform, or CDK to automate database provisioning, configuration, and scaling.
- Performance Tuning: Monitor system health using Amazon CloudWatch and RDS Performance Insights. Tasks include query optimization, index tuning, and rightsizing instance types.
- Security & Compliance: Implement least-privilege access using AWS IAM, manage encryption with KMS, and ensure compliance with standards like SOC 2 or HIPAA using AWS Config and Audit Manager.
- Data Migration: Plan and execute migrations from on-premises environments to the cloud using tools like AWS DMS (Database Migration Service) and the Schema Conversion Tool (SCT).
- Backup & Disaster Recovery: Design and test high-availability (Multi-AZ) and disaster recovery (Cross-Region) strategies using AWS Backup and snapshots.
- DevOps Integration: Collaborate with developers to integrate databases into CI/CD pipelines using tools like AWS CodePipeline or Jenkins.