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 efficient data modeling, normalization, partitionin

📌 PostgreSQL DBA (Uttar Pradesh)
🏢 Sparix Global
📍 Uttar Pradesh