PostgreSQL Performance Audit Expert

Role Overview

We are seeking an experienced PostgreSQL Performance Audit Expert to join a technical audit team assessing a large-scale distributed application platform. The role focuses on analyzing database performance, query optimization, indexing strategies, locking issues, data consistency, and overall database architecture within a complex microservices environment.

Key Responsibilities

• Conduct in-depth audits of PostgreSQL databases and application data access patterns.
• Analyze query performance, indexing strategies, locks, and database bottlenecks.
• Assess database schemas, data models, replication mechanisms, and reporting structures.
• Identify performance, scalability, maintainability, and data consistency risks.
• Review integration patterns involving REST APIs, event-driven architectures, and batch processing.
• Contribute to technical findings, risk assessments, a...