Job Description

About the Role:

We are looking for an experienced

Database Administrator (DBA)

with deep, hands-on expertise in

AWS RDS Aurora PostgreSQL

. The ideal candidate is not only proficient in general PostgreSQL operations and tuning, but also has a strong command of

AWS RDS-specific configurations

,

monitoring

, and

performance optimization

.


This role is critical in ensuring the stability, performance, and scalability of our production databases that support mission-critical applications in the supply chain and enterprise domain.

Key Responsibilities:

1. Health Monitoring

Review and interpret

CloudWatch alarms

and

Performance Insights

dashboards. Monitor

database connections

,

CPU utilization

, and

storage I/O

metrics. Ensure proactive issue detection and alert configuration to maintain database health.

2. Log Analysis

Regularly review

PostgreSQL error logs

for warnings, errors, and abnormal patterns. Identify and resolve

authentication failures

or

connection issues

. Analyze

slow query logs

to identify and resolve performance bottlenecks. Monitor

autovacuum activities

and manage table/index bloat effectively.

3. Capacity Planning

Analyze historical trends in

storage growth

,

compute resource utilization

, and

connection load

. Forecast future capacity needs and recommend scaling strategies. Review and optimize

backup storage

plans to balance cost and availability.

4. Performance Analysis and Optimization

Conduct deep-dive

database performance reviews

and tuning exercises. Identify and optimize

resource-intensive queries

and stored procedures. Monitor

wait events

,

lock contention

, and

long-running transactions

. Assess

connection pooling

strategies (e.g., PgBouncer, RDS Proxy) for effectiveness. Review and fine-tune

PostgreSQL parameters

for optimal throughput and latency. Provide

monthly performance reports

and recommend improvement actions.

Requirements:

Technical Skills

5+ years

of experience managing

PostgreSQL

databases in production.

3+ years

of hands-on experience specifically with

AWS RDS Aurora PostgreSQL

. Strong understanding of: + RDS performance tuning and parameter groups
+ Read replica and failover configuration
+ IAM authentication and encryption (KMS)
+ Backup, snapshot, and PITR strategies
+ Security, compliance, and maintenance best practices
Deep expertise in

AWS RDS advanced configuration

, including parameter groups, option groups, and Aurora-specific features like serverless scaling and global databases. Proven experience in

PostgreSQL tuning

and analyzing execution plans, including query optimization, indexing, and vacuuming. Strong proficiency in

AWS services

: CloudWatch, Performance Insights, IAM for database access, and VPC configurations. Excellent problem-solving skills and ability to work in a fast-paced, collaborative environment.

Preferred Qualifications:

AWS Certified Database - Specialty (or equivalent hands-on experience). Experience with

Aurora Global Database

,

multi-AZ

deployment, and

cross-region replication

. + Knowledge of CI/CD pipelines and infrastructure as code (e.g., Terraform, CloudFormation) for database provisioning. * Experience supporting databases in

high-availability enterprise environments

.