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, and actionable recommendations.
* Participate in workshops and present audit results to technical and management stakeholders.
Required Skills & Experience
* Expert-level PostgreSQL performance analysis and optimization.
* Strong experience diagnosing queries, indexes, locks, and database contention issues.
* Proven experience auditing application databases in complex enterprise environments.
* Strong analytical, documentation, and communication skills.
* Ability to provide independent, fact-based technical assessments and recommendations.
Languages
* French: Professional proficiency (C2)
Work Environment
* Hybrid working model.
* Location: Namur, Belgium.