Job Description

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

1. 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.
2. Automation & IaC: Use tools like AWS CloudFormation, Terraform, or CDK to automate database provisioning, configuration, and scaling.
3. Performance Tuning: Monitor system health using Amazon CloudWatch and RDS Performance Insights. Tasks include query optimization, index tuning, and rightsizing instance types.
4. 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.
5. 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).
6. Backup & Disaster Recovery: Design and test high-availability (Multi-AZ) and disaster recovery (Cross-Region) strategies using AWS Backup and snapshots.
7. DevOps Integration: Collaborate with developers to integrate databases into CI/CD pipelines using tools like AWS CodePipeline or Jenkins.

Qualifications

1. High Availability & Disaster Recovery (HA/DR)

• Always On Availability Groups : Architecting and maintaining Multi-AZ deployments. On RDS , this is automated; on EC2 , you must manually configure Windows Failover Clustering and AGs.
• Backup Management : On RDS, managing automated snapshots and point-in-time recovery. On EC2, scheduling native .bak backups to Amazon S3 and managing transaction log truncation.
• DR Drills : Periodically testing cross-region failover and restoration to ensure compliance with Recovery Time Objectives (RTO).

1. Performance Tuning & Monitoring

• Query Optimization : Using SQL Server Management Studio (SSMS) , Execution Plans, and Extended Events to identify and fix slow-running queries.
• Index & Statistics Maintenance: Scheduling jobs to rebuild/reorganize indexes and update statistics to prevent performance degradation.
• Cloud-Specific Tuning : Monitoring Provisioned IOPS (PIOPS) and storage throughput to ensure the underlying AWS EBS volumes are not bottlenecking the database.

2. Security & Compliance

• Identity Management : Integrating SQL Server logins with AWS Managed Microsoft AD (Active Directory) for Windows Authentication.
• Encryption : Implementing Transparent Data Encryption (TDE) and managing encryption keys via AWS KMS.
• Auditing : Configuring SQL Server Audit specifications to track sensitive data access, with logs offloaded to Amazon CloudWatch Logs.

3. Migration & Upgrades

• Schema Conversion : Using the AWS Schema Conversion Tool (SCT) for heterogeneous migrations or migrating from on-premises to AWS.
• Patch Management : Testing and applying Cumulative Updates (CUs) and Service Packs. On RDS, you define maintenance windows for AWS to apply these; on EC2, you handle the full installation.

4. Cost & License Management

• License Optimization : Choosing between License Included (LI) and Bring Your Own License (BYOL) models to minimize costs.
• Consolidation : Using AWS Optimization and Licensing Assessment (OLA) to right-size instances and reduce core-based licensing expenses