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 robust 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 pranali novaklickglobal gmail com Job Types Full-time Permanent Pay 400 000 00 - 2 000 000 00 per year Work Location In person

📌 Postgresql Developer (Maharashtra)
🏢 Novaklick Global
📍 Maharashtra