PostgreSQL/Aurora DBA

Highbrow LLC; United States; Remote; USD 130,000 - 190,000; Full time

Job summary

GlobalLogic is seeking a PostgreSQL/Aurora DBA for remote work to support a high-volume production environment. You will diagnose complex performance issues, tune PostgreSQL and Aurora workloads, and use AWS telemetry to identify bottlenecks while building proactive monitoring and automation to prevent recurring incidents.

The role requires expert PostgreSQL knowledge, hands-on AWS experience with RDS/Aurora, and the ability to analyze query plans with EXPLAIN ANALYZE, adjust memory and

Qualifications

• Expert PostgreSQL expertise in production environments.
• Advanced SQL and query tuning skills with EXPLAIN ANALYZE.
• Strong AWS experience with RDS/Aurora PostgreSQL and monitoring tools.

Responsibilities

• Diagnose production performance issues and tune PostgreSQL/Aurora workloads.
• Use AWS telemetry to identify bottlenecks and implement automation to prevent recurring incidents.
• Develop proactive monitoring and alerting for early problem detection.

Skills

PostgreSQL

Aurora PostgreSQL

AWS

Performance tuning

Query optimization

EXPLAIN ANALYZE

Monitoring/alerting

Tools

Amazon RDS

Aurora

Performance Insights

Job description

PostgreSQL/Aurora DBA (Client: GlobalLogic – iCIMS) [Location: Remote]

Location: Remote

No. of positions: 5

Visa: No H1B’s

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