Postgresql DBA

Talentola; Virginia; Remote; USD 83,000 - 165,000; Full time

Job summary

GlobalLogic iCIMS is seeking a PostgreSQL/Aurora DBA for a remote engagement to optimize production workloads and diagnose complex performance issues. You will tune queries, use AWS telemetry to identify bottlenecks, and develop automation and proactive monitoring to reduce recurring incidents.

Expert PostgreSQL/Aurora experience, strong AWS RDS for PostgreSQL or Aurora PostgreSQL, and a track record of performance troubleshooting are required.

Qualifications

• Expert PostgreSQL/Aurora skills with production-scale experience.
• Strong AWS RDS/Aurora PostgreSQL hands-on proficiency.
• Ability to diagnose and fix complex performance bottlenecks.

Responsibilities

• Diagnose production performance issues and tune PostgreSQL/Aurora workloads.
• Leverage AWS telemetry to identify bottlenecks and optimize queries.
• Build proactive monitoring and automation to prevent incidents.
• Develop permanent fixes to reduce recurring operational issues.

Skills

PostgreSQL

Aurora PostgreSQL

AWS

Performance tuning

SQL optimization

EXPLAIN ANALYZE

Monitoring

Automation

RDS PostgreSQL

Backup/Recovery

Troubleshooting

High-volume production

Performance Insights

Aurora architecture

Tools

AWS Performance Insights

Database Insights

Job description

Role: PostgreSQL/Aurora DBA

Client: GlobalLogic iCIMS

Location: Remote

Rate: Open as per market standards

Duration: 3 month

No. of positions: 5

Job Description:

We need someone who can serve as a PostgreSQL/Aurora subject-matter expert and actively improve the production environment. The person should be capable of diagnosing difficult production performance issues, tuning PostgreSQL and Aurora workloads, using AWS telemetry to identify bottlenecks, building proactive monitoring, and developing automation and permanent fixes that reduce recurring operational issues.

Expert PostgreSQL expertise, particularly supporting high-volume, business-critical production environments.

Strong AWS experience, with hands-on expertise supporting Amazon RDS for PostgreSQL or Aurora PostgreSQL.

Ability to troubleshoot complex PostgreSQL performance issues and rapidly determine whether the bottleneck is query, database, infrastructure, or application related.

Advanced SQL/query tuning, including execution-plan analysis using EXPLAIN / EXPLAIN ANALYZE, indexing strategies, join optimization, statistics, and identifying inefficient queries.

Strong understanding of PostgreSQL configuration and parameter tuning, including memory, WAL, checkpoints, autovacuum, connection management, planner settings, and workload-specific optimization.

Hands-on experience with AWS Performance Insights / Database Insights to identify database load, expensive SQL, waits, locking, and other performance bottlenecks.

Strong understanding of Aurora PostgreSQL architecture, including clusters, reader/writer instances, replicas, failover, scaling, parameter groups, maintenance, and backup/recovery.

Ability to develop proactive monitoring and alerting that identifies developing problems before they become production incidents