Postgres Developer

Corporate Infotech (CIPL); Sector 10; On-site; INR 1,000,000 - 1,500,000; Full time

Job summary

Corporate Infotech Pvt. Ltd. (CIPL) is seeking an experienced PostgreSQL Database Developer for the BiharOne project. The role focuses on designing, developing, optimizing, and maintaining robust PostgreSQL databases for enterprise applications.

The candidate should have 5+ years of hands-on PostgreSQL experience, expertise in PL/pgSQL, and a strong background in performance tuning and security. Location: Noida or Patna; not specified as remote.

Qualifications

• 5+ years hands-on experience with PostgreSQL database development.
• Strong knowledge of PostgreSQL 11+ and PL/pgSQL.
• Expertise in SQL query optimization and performance tuning.

Responsibilities

• Design, develop, and maintain PostgreSQL databases, schemas, tables, indexes, and partitions.
• Develop stored procedures, functions, triggers, and views using PL/pgSQL.
• Optimize complex SQL queries and tune database performance.
• Implement MVCC, VACUUM, ANALYZE, and indexing strategies.
• Support ETL pipelines and data integration processes.
• Develop and manage backup, restoration, replication, and DR processes.
• Monitor health and troubleshoot performance issues.
• Collaborate with developers, architects, and BI teams.
• Enforce database security, access control, and data governance.

Skills

PostgreSQL Database Development

PostgreSQL 11+

PL/pgSQL

SQL performance tuning

MVCC/VACUUM

Backup/Recovery

Partitioning

Replication

Data security & governance

ETL tooling / Python

Education

MCA / MSc (IT) / B.Tech / B.E.

Tools

pg_dump

pg_restore

AWS RDS / Azure PostgreSQL

GCP Cloud SQL

Job description

Were Hiring | PostgreSQL Database Developer

Corporate Infotech Pvt. Ltd. (CIPL) is looking for an experienced PostgreSQL Database Developer to support the BiharOne Project.

The ideal candidate will have strong hands-on experience in designing, developing, optimizing, and maintaining robust, secure, and high-performing PostgreSQL databases for enterprise applications.

Location: Noida / Patna
Experience: 5+ Years
Qualification: MCA / M.Sc. (IT) / B.Tech / B.E.

Key Responisbilities

Design, develop, and maintain PostgreSQL databases, schemas, tables, indexes, and partitions.

• Develop stored procedures, functions, triggers, and views using PL/pgSQL.
• Optimize complex SQL queries and improve database performance and scalability.
• Implement database health practices including MVCC, VACUUM, ANALYZE, and advanced indexing.
• Support ETL pipelines and data integration processes.
• Develop and manage database backup, restoration, replication, and disaster recovery processes.
• Monitor database performance and troubleshoot database-related issues.
• Identify and resolve performance bottlenecks proactively.
• Work closely with application developers, data architects, and BI teams.
• Implement database security, access control, and data governance best practices.

Key Responsibilities:

• Design, develop, and maintain PostgreSQL databases, schemas, tables, indexes, and partitions.
• Develop stored procedures, functions, triggers, and views using PL/pgSQL.
• Optimize complex SQL queries and perform database performance tuning.
• Work with MVCC, VACUUM, ANALYZE, indexing, and partitioning.
• Manage database backup, restoration, replication, and disaster recovery processes.
• Monitor database health and troubleshoot performance-related issues.
• Analyze execution plans and identify performance bottlenecks.
• Support ETL pipelines and data integration activities.
• Implement database security, access control, and data governance best practices.
• Collaborate with application developers, architects, infrastructure teams, and project stakeholders.

Required Skills:

• 5+ years of hands-on experience with PostgreSQL Database Development
• Strong knowledge of PostgreSQL 11+ & PL/pgSQL
• Expertise in SQL query optimization and performance tuning
• Good understanding of stored procedures, functions, triggers, constraints, indexing, and partitioning
• Hands-on experience with pg_dump, pg_restore & Point-in-Time Recovery (PITR)
• Experience with PostgreSQL replication
• Experience handling large-scale production databases
• Knowledge of database security, backup/recovery, and troubleshooting

Cloud & Additional Skills:

Exposure to cloud-hosted PostgreSQL services such as AWS RDS, Azure Database for PostgreSQL, or Google Cloud SQL will be an advantage.

Experience with ETL tools, Python-based solutions, DevOps/CI-CD pipelines, MySQL, Oracle, or NoSQL databases will be an added advantage.

We are looking for someone with strong analytical and problem-solving skills, good communication, a proactive approach, and the ability to work collaboratively in a fast-paced environment.

About Us:

Corporate Infotech Pvt. Ltd. (CIPL) was incorporated, in 2007, with the underlying objectives of honesty, transparency, accountability and sublime business ethics. Since then, it has carved out a niche in the market and established itself as the largest solution provider and rapidly expanding company. We are total employee strength of 2000+ across pan India and our Head Office is located as Sector 138, Noida. We are CMMI ML Level 5 Certified Organization, and we have also got certification from Great Place to Work which clearly indicates the culture built in this organization. We at CIPL focus more on the Talent & Development of every employee. The current employees we have are all certified resource who are currently deployed for all projects, working with CIPL has always helped every employee to enhance their career in terms of Technology.

https://cipl.org.in/