AWS Cloud Engineer – Database Migration & DevOps (SCT, Liquibase, AWS DMS, DBA)
Experience Level Senior (8–14 yrs) profiles.
Role Summary
We are seeking an AWS Cloud Engineer with deep hands-on experience in database migration and schema/version management using Liquibase, AWS Database Migration Service (DMS), and solid DBA fundamentals (performance, security, backup/restore, HA/DR). The ideal candidate can design and execute end-to-end migration strategies from on-prem/other clouds to AWS, automate database change delivery pipelines, and ensure operational excellence across production workloads.
Key Responsibilities
Plan, Execute Data Migrations & Performance Tuning.
Assess source/target databases (e.g., Oracle/PostgreSQL/MySQL/MS SQL) and design AWS DMS migration jobs (full load + CDC). Perform pre-migration readiness: connectivity, sizing, parameter tuning, character sets/collations, LOB handling, constraints & triggers. Validate migration cutovers with data reconciliation, checksum/row counts, and rollback strategies.
Database DevOps / Liquibase Implement Liquibase changelog strategy (XML/SQL/YAML/JSON) with versioning, rollback, tagging, and release notes. Build CI/CD pipelines integrating Liquibase (e.g., Jenkins/GitHub Actions/Azure DevOps) to automate schema changes across environments.
Enforce governance: change approvals, drift detection, policy-as-code, and audit trails. AWS Architecture & Operations Design and manage RDS/Aurora (PostgreSQL/MySQL/SQL Server), EC2-hosted DBs, Parameter groups, Subnet groups, Security groups. Implement backup/restore, multi-AZ, read replicas, failover, monitoring (CloudWatch/Performance Insights), and cost optimization. Use IAM, KMS, Secrets Manager for secure credential and key management.
DBA Performance & Reliability Query tuning, indexing strategies, execution plan analysis, vacuum/analyze, temp space/IO considerations. Setup HA/DR, runbooks, incident response, and root cause analysis (RCA). Capacity planning and performance baselining. Automation & Observability Write infra-as-code (Terraform/CloudFormation) for RDS/DMS resources. Build dashboards/alerts (CloudWatch, Grafana, Prometheus) and SLOs/SLIs for DB services.
Stakeholder Collaboration Work with application teams, security, and infra ops to align releases, SLAs, and platform standards. Document architecture, migration playbooks, and operational procedures. Converting schema from heterogeneous databases using SCT tools(e.g., Oracle → PostgreSQL/MySQL). Integrating SCT with AWS DMS for end-to-end migration workflows.
Required Qualifications
1. Architects complex migration programs across multiple applications.
2. Establishes standards for Liquibase governance & release mgmt.
3. Designs HA/DR across regions, cost/perf optimized architectures.
4. Leads incident response, RCAs, and mentors team members.
5. Liquibase: Explain contexts vs labels; rollback strategies; handling hotfixes; managing drift; diffChangeLog for legacy DBs.
6. AWS DMS: CDC internals; task tuning (memory, commit rates); handling LOBs; table/column transformations; resolving latency; cutover plan.
7. DBA: Index design trade-offs; troubleshooting slow queries; deadlocks; isolation levels; storage parameters; backup verification strategies.
8. Architecture: RDS Multi-AZ vs Read Replicas vs Aurora; cross-region DR; cost-aware storage/IO choices.
9. Ops: Designing datadog alerts, SLOs; blue/green DB deployment; secrets rotation; parameter groups governance.
10. Deployment frequency for schema changes via Liquibase, with zero drift.
11. Query/performance improvements (e.g., p95 latency, CPU/IO reduction).
12. Cost optimization outcomes (storage/IO savings, instance rightsizing).
13. AWS DMS, Liquibase, AWS RDS, Aurora, PostgreSQL, MySQL, Oracle, SQL Server, DBA, Database Migration, CDC, CI/CD, Terraform, CloudFormation, Performance Tuning, HA/DR, CloudWatch, IAM, KMS, Secrets Manager, DevOps, Data Migration
14. Converting schema from heterogeneous databases using SCT tools(e.g., Oracle → PostgreSQL/MySQL).
15. Identifying incompatibilities and generating conversion reports.
16. Applying schema changes and validating converted objects.
17. Integrating SCT with AWS DMS for end-to-end migration workflows.
18. Exposure to zero-downtime cutover patterns and blue/green deployments for DB.
19. Aurora PostgreSQL/MySQL advanced features (Global DB, Parallel Query).
20. Knowledge of networking basics in AWS: VPC, subnets, SGs, NACLs, PrivateLink/Endpoints, Route 53.
21. Familiarity with monitoring & logging: CloudWatch Logs/Metrics, alarms, event-driven notifications.
22. Strong DBA skills in one or more: PostgreSQL, MySQL, Oracle, MS SQL Server (install, configure, backup/restore, security, performance tuning).
23. Solid understanding of AWS RDS/Aurora internals (parameters, storage, performance insights, multi-AZ, replicas).
24. Experience with CI/CD (Jenkins/GitHub Actions/Azure DevOps) and Git workflows.
25. Scripting proficiency: Python/Shell/SQL
26. Knowledge of security/compliance (encryption at rest/in transit, audit logs, least privilege IAM).
Never miss an opportunity! Create an alert based on the job you applied for.
