Required
• Three to five years of database administration or database engineering experience in a medium-to-large production environment.
• Strong hands-on administration of Amazon Aurora PostgreSQL-Compatible Edition, including cluster configuration, parameter groups, monitoring, backup and recovery, upgrades, security, and production support.
• Successful delivery of at least one end-to-end migration from a different database engine, such as Oracle, Sybase, SQL Server, MySQL/MariaDB, Db2, or a comparable platform, to Aurora PostgreSQL.
• Practical experience with AWS DMS full load and change data capture, schema and code conversion, migration troubleshooting, data validation, cutover, and rollback planning.
• Advanced PostgreSQL performance knowledge, including MVCC, locking, query planning, indexing, statistics, VACUUM and autovacuum, WAL, memory and connection management, and query-level diagnostics.
• Hands-on replication experience with Aurora Replicas and PostgreSQL logical replication, including lag monitoring, replication slots, WAL retention, failover, and recovery considerations.
• AWS experience with RDS/Aurora, CloudWatch Database Insights, IAM, KMS, Secrets Manager, VPC and security groups, snapshots, events, logs, and related networking.
• Scripting experience with Python, Bash or shell, and SQL, along with working knowledge of Linux/Unix and AWS CLI/SDK.
• Working knowledge of TCP/IP, DNS, ports, TLS, firewalls, and cloud network connectivity.
• Strong troubleshooting, documentation, communication, teamwork, and customer-service skills.
• Experience following production change, incident-management, security, and operational-control processes.
• Bachelor’s degree in computer science, information systems, engineering, or a related discipline, or equivalent practical experience.
Preferred
• Deep source-platform knowledge in Sybase, SQL Server, MySQL/MariaDB, Db2, or another enterprise database engine used in heterogeneous migrations.
• Experience using DMS Schema Conversion or AWS SCT for complex database-code conversion, assessment reports, transformation rules, and remediation planning.
• Experience with Aurora Global Database, cross-Region disaster recovery, RDS Proxy, pglogical, advanced partitioning, or Aurora query plan management.
• Experience with infrastructure as code, Git, CI/CD, AWS CloudFormation, Terraform, and automated database deployment or validation pipelines.
• Familiarity with ServiceNow, Jira, Agile delivery, and structured incident, problem, and change management.
• Knowledge of regulated-environment controls such as HIPAA, SOX, or PCI DSS.
• Relevant AWS, PostgreSQL, or database-administration certification.
Work Expectations
• Support after-hours migrations, cutovers, maintenance, upgrades, recovery tests, and production incidents.
• Manage multiple priorities while maintaining disciplined change controls, clear documentation, and timely stakeholder communication.
Regards,
Puneet.
Never miss an opportunity! Create an alert based on the job you applied for.
