PostgreSQL Consultant

Experience: 8 to Not Available years

Location: Noida, India

Skills: PostgreSQL, pgAdmin, psql, PostGIS, TimescaleDB, Linux, RHEL, Ubuntu, Shell scripting, MongoDB, Ansible, PuppetDB, AWS, Azure, Google Cloud

Job Summary
We are seeking an experienced PostgreSQL Consultant to join our team. As a PostgreSQL Consultant, you will work with clients to design, implement, and optimize PostgreSQL-based solutions. You will be responsible for ensuring seamless integration, scalability, and performance of PostgreSQL databases along with automation of repetitive tasks.

Key Responsibilities
• Collaborate with clients to understand their requirements and provide solutions using PostgreSQL features like replication, partitioning, and window functions
• Design, develop and implement highly available solutions using logical and streaming replication tools.
• Troubleshoot and resolve PostgreSQL-related issues using PostgreSQL logs, monitoring tools like pg_stat_statements, and performance metrics
• Develop and deliver PostgreSQL training and workshops covering topics like PostgreSQL security, backup and recovery, and scalability




• Stay up-to-date with PostgreSQL advancements and best practices, including new features and releases

Skill Requirements
• 8+ years of experience with PostgreSQL
• Robust understanding of PostgreSQL data modeling, indexing, query optimization, and performance tuning
• Experience with PostgreSQL deployment, scaling, security, and backup and recovery strategies
• Proficiency in PostgreSQL tools and frameworks like pgAdmin, psql, and PostgreSQL Extensions (e.g., PostGIS, TimescaleDB)
• Extensive experience of working with Linux- RHEL or Ubuntu for managing database servers
• Proficient with Shell scripting
• Strong problem-solving and communication skills
• Experience working with clients and teams

Nice to Have:
• Experience with MongoDB
• Knowledge of Ansible and PuppetDB
• Knowledge of cloud platforms (e.g., AWS, Azure, Google Cloud) and PostgreSQL-as-a-Service offerings
• Certification in PostgreSQL or related technologies like PostgreSQL Certified Developer or PostgreSQL Certified DBA
Other Requirements
null

📌 PostgreSQL Consultant (Noida)
🏢 HCL Technologies
📍 Noida