Data EngineeringFull-timeOn-site

Senior Database Administrator (PostgreSQL)

Manage, optimize, and scale PostgreSQL database infrastructure supporting mission-critical enterprise applications at APPIT Software in Hyderabad.

Hyderabad, India

Full-time

Data Engineering

Responsibilities

Administer and maintain PostgreSQL database clusters across development, staging, and production environments
Perform advanced query tuning, index optimization, and execution plan analysis for high-traffic systems
Design and implement high availability solutions using streaming replication, Patroni, and pgBouncer
Plan and execute database migrations, major version upgrades, and schema changes with zero downtime
Implement backup and disaster recovery strategies using pg_basebackup, WAL archiving, and point-in-time recovery
Monitor database health, resource utilization, and performance metrics using pg_stat_statements and Grafana

Requirements

6-10 years of database administration experience with at least 4 years focused on PostgreSQL
Deep knowledge of PostgreSQL internals including MVCC, WAL, vacuum, and buffer management
Experience with connection pooling (pgBouncer, PgPool-II) and query load balancing
Proficiency in writing advanced SQL, stored procedures, and PL/pgSQL functions
Hands-on experience with PostgreSQL on cloud platforms (RDS, Aurora, Cloud SQL, or Azure Database)
Strong understanding of database security including role management, SSL, and row-level security

Nice to Have

Experience with PostgreSQL extensions (PostGIS, TimescaleDB, Citus)
Knowledge of database-as-code tools like Flyway or Liquibase
Familiarity with other RDBMS (MySQL, Oracle) for migration projects

Skills

PostgreSQLSQLLinuxpgBouncerPatroniAWS RDSShell ScriptingGrafana

Apply for this position

Fill in your details below to submit your application.

Related Positions

Data EngineeringOn-site

Senior Database Administrator (PostgreSQL)

Manage, optimize, and scale PostgreSQL database infrastructure supporting mission-critical enterprise applications at APPIT Software in Hyderabad.

Hyderabad, India

Full-time

Data Engineering

Responsibilities

Administer and maintain PostgreSQL database clusters across development, staging, and production environments
Perform advanced query tuning, index optimization, and execution plan analysis for high-traffic systems
Design and implement high availability solutions using streaming replication, Patroni, and pgBouncer
Plan and execute database migrations, major version upgrades, and schema changes with zero downtime
Implement backup and disaster recovery strategies using pg_basebackup, WAL archiving, and point-in-time recovery
Monitor database health, resource utilization, and performance metrics using pg_stat_statements and Grafana

Requirements

6-10 years of database administration experience with at least 4 years focused on PostgreSQL
Deep knowledge of PostgreSQL internals including MVCC, WAL, vacuum, and buffer management
Experience with connection pooling (pgBouncer, PgPool-II) and query load balancing
Proficiency in writing advanced SQL, stored procedures, and PL/pgSQL functions
Hands-on experience with PostgreSQL on cloud platforms (RDS, Aurora, Cloud SQL, or Azure Database)
Strong understanding of database security including role management, SSL, and row-level security

Nice to Have

Experience with PostgreSQL extensions (PostGIS, TimescaleDB, Citus)
Knowledge of database-as-code tools like Flyway or Liquibase
Familiarity with other RDBMS (MySQL, Oracle) for migration projects

Skills

PostgreSQLSQLLinuxpgBouncerPatroniAWS RDSShell ScriptingGrafana

Senior Database Administrator (PostgreSQL)

Responsibilities

Requirements

Nice to Have

Skills

Apply for this position

Related Positions

ETL/Data Pipeline Engineer

Senior Data Engineer (Apache Spark)

Site Reliability Engineer (SRE)

Senior Full Stack Developer (React & Node.js)

Senior Database Administrator (PostgreSQL)

Responsibilities

Requirements

Nice to Have

Skills

Apply for this position

Related Positions

ETL/Data Pipeline Engineer

Senior Data Engineer (Apache Spark)

Site Reliability Engineer (SRE)

Senior Full Stack Developer (React & Node.js)