Postgre Database Administrator

Winjit Technologies; Mumbai; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Winjit Technologies in Mumbai seeks a seasoned PostgreSQL DBA to manage installation, upgrades, patching, and ongoing maintenance for production and non-production environments.

You will drive Oracle-to-PostgreSQL migrations, optimize SQL/PL/pgSQL, design backup/restore and DR strategies, and implement robust monitoring with Prometheus, pgBadger and ELK/OpenSearch.

Qualifications

• Proficient PostgreSQL DBA with hands-on installation, upgrades, patching, and ongoing maintenance.
• Experience migrating Oracle to PostgreSQL including assessment, schema conversion, data migration, validation, and live cutover.
• Strong SQL development skills (SQL, PL/pgSQL) with proficiency in performance tuning and query optimization.
• Ability to analyze execution plans using EXPLAIN and optimize queries, indexes, and data structures.
• Experience in designing and implementing backup/restore strategies and PITR, including WAL archiving and DR testing.
• Automation and scripting for DB administration and migration tasks (Shell/Bash).

Responsibilities

• Lead Oracle-to-PostgreSQL migration projects end-to-end, ensuring data integrity and minimal downtime.
• Develop and optimize SQL/PL/pgSQL code; troubleshoot slow queries and performance bottlenecks.
• Design, implement, and validate comprehensive backup, restore, and DR procedures, including cross-DC replication.
• Monitor DB health with Prometheus/Grafana, pg_stat_statements, and ELK/OpenSearch; set up alerts.
• Coordinate with DevOps, security, and application teams for deployment validation and rollback planning.
• Provide RCA for production incidents and implement preventive measures.

Skills

PostgreSQL

Oracle to PostgreSQL migration

SQL/PL/pgSQL

Performance tuning

Backup/Recovery

DR/ DC failover

Replication

Monitoring tools

Shell/Bash scripting

Security & access control

Automation

Tools

pg_stat_statements

pgBadger

Prometheus/Grafana

CloudWatch

ELK/OpenSearch

PITR tooling

Job description

• Strong hands-on experience in PostgreSQL database administration, installation, configuration, upgrades, patching, and maintenance.
• Experience in Oracle to PostgreSQL migration, including database assessment, schema conversion, data migration, validation, and production cutover.
• Convert and optimize Oracle SQL, PL/SQL, procedures, functions, packages, triggers, sequences, and data types for PostgreSQL.
• Strong expertise in SQL query development, query analysis, troubleshooting, and performance tuning.
• Analyze execution plans using EXPLAIN / EXPLAIN ANALYZE and optimize queries, indexes, joins, and database structures.
• Develop SQL, PL/pgSQL, Shell/Bash scripts for database administration, migration, monitoring, and automation.
• Design and execute database backup and restore strategies for production and non-production environments.
• Configure and manage automated PostgreSQL backups, WAL archiving, retention, and backup monitoring.
• Perform regular restore and recovery testing to validate backup integrity and recovery procedures.
• Hands-on experience with Point-in-Time Recovery (PITR) and database recovery from backup/WAL.
• Manage DC (Primary) to DR replication and ensure database synchronization between environments.
• Perform DC to DR failover/switchover activities and validate application/database connectivity after DR activation.
• Perform DR to DC failback/switchover and ensure data synchronization before restoring the primary environment.
• Monitor replication health, replication lag, WAL, database availability, and recovery status across DC and DR.
• Experience with PostgreSQL streaming replication, physical replication, logical replication, and HA configurations.
• Plan and execute DR drills, including database failover, recovery, validation, and rollback activities.
• Monitor database performance, availability, capacity, and health using PostgreSQL and enterprise monitoring tools.
• Configure alerts for CPU, memory, disk utilization, connections, locks, deadlocks, slow queries, replication lag, WAL growth, and database availability.
• Use tools such as pg_stat_statements, pgBadger, Prometheus/Grafana, CloudWatch, ELK/OpenSearch, or equivalent monitoring solutions.
• Troubleshoot slow queries, database locks, deadlocks, connection issues, replication failures, storage issues, and performance bottlenecks.
• Perform database capacity planning, storage forecasting, and database growth analysis.
• Manage PostgreSQL users, roles, privileges, authentication, and database security.
• Implement and maintain least-privilege access, auditing, encryption, and security controls.
• Manage VACUUM, ANALYZE, autovacuum, table/index maintenance, partitioning, and database housekeeping.
• Perform PostgreSQL version upgrades, patching, configuration changes, and extension management.
• Support production deployments and database changes, including deployment validation and rollback planning.
• Maintain database SOPs, backup/restore procedures, DR runbooks, migration documents, monitoring dashboards, and troubleshooting guides.
• Work closely with application, DevOps, infrastructure, security, and architecture teams for database-related activities.
• Provide root cause analysis (RCA) for production database incidents and implement corrective/preventive actions.
• Ensure database operations comply with availability, performance, security, backup, and DR requirements.
• Experience with large-volume/high-transaction PostgreSQL databases is preferred.