Work Mode: Work from Office

Position Overview

We are looking for a PostgreSQL Database Administrator with 10–15 years of hands-on experience, responsible for managing mission-critical PostgreSQL databases in offline / air-gapped, highly secure environments. The role requires deep technical expertise, ownership of database architecture, performance, sharding, disaster recovery, and data restoration, and the ability to support large-scale enterprise systems. 

Mandatory Skills & Expertise 

Core Requirements 

• PostgreSQL expertise (Mandatory) 

• Experience in offline / air-gapped / restricted network environments 

• Strong ownership of Disaster Recovery (DR) and data restoration 

• Experience handling large databases (10M+ records) 

PostgreSQL Technical Skills (Required) :

• PostgreSQL installation, configuration, upgrades, and maintenance 

• Advanced SQL expertise including: 

• Complex joins 

• Subqueries, CTEs, window functions 

• Strong experience with: 

• Views 

• Materialized Views 

• Stored Procedures 

• Functions (PL/pgSQL) 

• Triggers 

• Performance tuning using EXPLAIN / EXPLAIN ANALYZE 

• Indexing strategies and bloat management 

Advanced Database Design :

• Sharding strategies (application-level / logical) 

• Table partitioning and archival strategies 

• Schema design and optimization 

Backup, Disaster Recovery & Restoration (Mandatory) :

• Backup strategies using: 

• pg_dump, pg_dumpall 

• pg_basebackup 

• WAL archiving 

• Point-in-Time Recovery (PITR) 

• Hands-on experience in database restoration 

• RPO / RTO planning and DR drills 

High Availability & Scaling :

• PostgreSQL replication (Streaming / Logical) 

• High Availability setups (Patroni or equivalent) 

• PgBouncer for connection pooling 

• High-concurrency database environments

OS & Environment :

• Strong Linux experience (RHEL 8/9 preferred) 

• Offline package installation and system administration 

• systemd, storage, disk I/O, and log management 

Responsibilities :

• Own PostgreSQL & Mongo database architecture and operations 

• Ensure performance, availability, security, and scalability 

• Lead database upgrades, migrations, and DR activities 

• Support application teams (Java / Spring Boot / .NET) 

• Troubleshoot production issues and perform RCA 

• Maintain documentation, SOPs, and DR runbooks 

• Mentor junior DBAs and enforce best practices