Aurora PostgreSQL Database Administrator; DBA)

Aurora PostgreSQL Database Administrator (DBA)

Experienced Aurora PostgreSQL DBA responsible for designing, administering, optimizing, and supporting highly available PostgreSQL databases on Amazon Aurora PostgreSQL.

Responsible for:

• Database reliability
• Performance
• Security
• Backup and recovery
• Monitoring
• Production support

Support database environments across:

• Development
• Test
• Production

Strong hands-on PostgreSQL and AWS/Amazon Aurora experience required.

Strong understanding of:

• Database performance
• High availability
• Automation
• Troubleshooting

Administer and support Amazon Aurora PostgreSQL database environments.

Install, configure, upgrade, patch, and maintain PostgreSQL/Aurora systems.

Manage:

• Aurora clusters
• Read replicas
• Failover
• Parameter groups
• Subnet groups
• Endpoints

Perform database performance tuning, including:

• Query optimization
• Execution plan analysis
• Index optimization
• Connection and memory tuning
• Lock and wait-event analysis
• Vacuum/autovacuum optimization

Monitor database:

• Health
• Capacity
• Performance
• Availability

Use AWS and PostgreSQL monitoring tools.

Implement and maintain:

• Backup and restore strategies
• Disaster recovery (DR)
• Business continuity strategies

Perform Point-in-Time Recovery (PITR).

Support database recovery exercises.

Troubleshoot production issues, including:

• Database incidents
• Performance problems
• Connectivity issues
• Replication issues
• Database failures

Manage database security:

• Users
• Roles
• Permissions
• Encryption
• Auditing
• Access controls

Work with application and development teams on:

• SQL queries
• Schema design
• Indexes
• Database-related application issues

Support migrations to Aurora PostgreSQL from:

• On-premises DB2
• Other database platforms

Develop automation and operational scripts using:

• Python
• AWS Lambda
• AWS CLI

Establish and maintain:

• Database standards
• Operational procedures
• Documentation
• Runbooks

Participate in on-call rotations.

Provide production support for critical database environments.

Assist with:

• Capacity planning
• Cloud cost optimization
• Database modernization initiatives

5+ years of database administration experience with PostgreSQL.

2+ years of hands-on experience with Amazon Aurora PostgreSQL.

Strong understanding of:

• PostgreSQL architecture
• PostgreSQL administration
• PostgreSQL internals

Strong experience with:

• SQL
• PL/pgSQL
• Indexes
• Transactions
• Locking
• Query execution plans

Experience with:

• PostgreSQL backup and recovery
• Replication
• High-availability strategies

Strong AWS knowledge, particularly:

• Amazon Aurora
• Amazon RDS
• EC2
• IAM
• Cloud Watch
• S3
• Airflow
• Lambda

Experience troubleshooting database performance using:

• EXPLAIN
• EXPLAIN ANALYZE
• PostgreSQL statistics views
• AWS Performance Insights
• Cloud Watch

Experience with database monitoring and alerting.

Strong scripting and automation skills using Python or similar languages.

Experience working with:

• Production-critical databases
• Incident management processes

AWS Certified Database – Specialty or comparable AWS certification.

PostgreSQL certification or equivalent professional experience.

Experience migrating databases to Aurora PostgreSQL using AWS Database Migration Service (DMS).

Experience with CI/CD pipelines.

Experience with database observability tools such as Datadog, Grafana, or similar platforms.

Experience with:

• PostgreSQL version upgrades
• Aurora major-version upgrades

Databases:

• PostgreSQL
• Amazon Aurora PostgreSQL
• Amazon RDS

AWS:

• Aurora
• RDS
• EC2
• VPC
• IAM
• Cloud Watch
• S3
• KMS
• DMS
• Lambda
• Airflow

Performance Tuning:

• EXPLAIN / EXPLAIN ANALYZE
• Query tuning
• Indexing
• Wait-event analysis
• Lock analysis
• Vacuum/autovacuum
• Connection management

High Availability & Disaster Recovery:

• Aurora replication
• Read replicas
• Failover
• Backup/restore
• Point-in-Time Recovery
• Disaster recovery

Automation:

• Python
• AWS CLI
• Lambda
• Airflow

Monitoring & Observability:

• AWS Performance Insights
• Cloud Watch
• PostgreSQL monitoring
• Grafana
• Prometheus
• Datadog

Strong analytical and problem-solving skills.

Excellent troubleshooting skills.

Strong incident-management capabilities.

Ability to work