Position: Senior PostgreSQL DBA & SQL Performance Specialist

Engagement Mode: Remote

7 YOE

Position Overview:

IDCUBE Identification Systems is seeking a highly skilled Senior PostgreSQL DBA & SQL Performance

Specialist to manage, tune, secure, and troubleshoot PostgreSQL databases across both client on-premise

installations and cloud environments. This role is ideal for someone who excels in database administration,

advanced SQL programming, performance tuning, backup/restore strategy, troubleshooting, and enforcing

security frameworks. The ideal candidate will act as a PostgreSQL subject matter expert (SME)—guiding

developers with best practices, reviewing queries, advising on schema design, and ensuring optimal

performance for high-volume, mission-critical systems. The role involves working with IDCUBE's

next-generation cloud-native platform (Access360 / Access360 AI) that leverages AI-driven access control,

real-time insights, and contemporary microservices architecture.

Key Responsibilities:
Install, configure,



and maintain PostgreSQL databases in cloud and on-premise client environments
Manage database version upgrades, patches, maintenance, and monitoring
Ensure high availability (HA), failover, and replication setups (Streaming Replication, Logical Replication,

etc.)
Oversee backup, restore, PITR (Point-in-Time Recovery), and disaster recovery planning
Perform deep-dive query tuning using EXPLAIN / EXPLAIN ANALYZE
Optimize schemas, indexes (B-Tree, GIN, GiST, BRIN), materialized views, and partitions
Identify and resolve performance bottlenecks related to I/O, CPU utilization, connection pooling, or

mis-configured parameters
Tune PostgreSQL configuration parameters for production workloads
Develop, optimize, and troubleshoot SQL queries, functions, and triggers using PL/pgSQL
Review developer queries and recommend best practices for optimal performance
Guide teams on productive data modeling, normalization, partitionin

📌 Postgresql Dba Uttar Pradesh
🏢 Sparix Global
📍 Uttar Pradesh