PostgreSQL Developer

Company: Novaklick Global Private Limited

Junior PostgreSQL DBA Developer (1–3 Years)

Positions: 4

About the Role:

We are hiring a Junior PostgreSQL DBA Developer who can support both database development and database administration activities. The ideal candidate should have strong SQL skills, practical PostgreSQL experience, and an eagerness to grow into a full-fledged DBA.

Key Responsibilities (Development + Administration)

Database Development - Write and optimize SQL queries for applications and reporting. - Create and maintain tables, views, indexes, triggers, functions, and procedures. - Assist in schema design, data modeling, and normalization. - Support developers by reviewing and improving database-related code.

Database Administration - Assist in installation, configuration, and upgrades of PostgreSQL databases. - Monitor database performance, logs, connections, and resource usage. - Support backup & restore operations (pg_dump, pg_restore, pg_basebackup). - Troubleshoot slow queries, locks, deadlocks, and connectivity issues. - Manage user roles, access control, and basic security configurations. - Support database maintenance activities across dev/staging/production.

Required Skills (Technical + Core Competencies)

Technical Skills - 1–3 years of hands-on experience with PostgreSQL. - Strong SQL and solid understanding of RDBMS concepts. - Knowledge of indexing, execution plans (EXPLAIN), and query optimization. - Practical experience with PostgreSQL tools (pgAdmin, psql). - Basic Linux command-line skills (Ubuntu/CentOS). - Familiarity with backup/restore tools: pg_dump, pg_restore, pg_basebackup. - Understanding of replication basics, WAL, and HA concepts (good to have). - Scripting knowledge (Shell/Python) is a plus.

Senior PostgreSQL DBA Developer (5–8 Years)

Positions: 2

About the Role

We are hiring a Senior PostgreSQL DBA Developer with strong expertise in both database development and database administration. The ideal candidate should have deep hands-on PostgreSQL experience, advanced SQL skills, and the ability to manage complex production environments while guiding junior team members.

Key Responsibilities (Development + Administration)

Database Development - Design scalable database architectures and optimize schema structures. - Develop and fine-tune complex SQL queries, indexes, functions, triggers, and stored procedures. - Analyze and optimize query execution plans for performance improvements. - Collaborate with development teams to ensure efficient database access patterns. - Create and maintain database migration scripts and version control processes.

Database Administration - Install, configure, patch, and upgrade PostgreSQL servers across environments. - Monitor performance and troubleshoot issues related to resource usage, locks, replication lag, and WAL. - Implement and oversee backup/restore strategies using pg_dump, pg_restore, pg_basebackup, and PITR. - Configure and manage high-availability setups (Streaming Replication, Logical Replication, Failover tools). - Ensure database security, role management, encryption, and audit compliance. - Automate operational tasks using Shell/Python scripts. - Lead root cause analysis and resolve critical production issues.

Required Skills (Technical + Leadership)

Technical Skills - 5–8 years hands-on experience with PostgreSQL in production environments. - Strong expertise in query optimization, indexing, execution plans (EXPLAIN/ANALYZE), and PostgreSQL internals. - Experience with Streaming & Logical Replication, high availability clusters (Patroni, EFM), and WAL tuning. - Solid Linux administration skills (Ubuntu/CentOS). - Scripting knowledge (Shell/Python). - Experience with monitoring tools (pg_stat_statements, Prometheus, Grafana). - Cloud database experience (AWS RDS, Azure PostgreSQL, GCP Cloud SQL) is a plus.

Why Join Us

• Lead mission-critical PostgreSQL initiatives. - Work with a dynamic and growth-focused engineering team. - Freedom to propose improvements in performance and architecture. - Opportunity to scale your expertise with real production challenges.

How to Apply: Apply directly via Indeed or send your CV to

Job Types: Full-time, Permanent

Pay: ₹400, ₹2,000,000.00 per year

Work Location: In person