About this role
About the Role HCL Technologies is seeking an experienced PostgreSQL Consultant to join our team. You will work with clients to design, implement, and optimize PostgreSQL-based solutions, ensuring seamless integration, scalability, and performance of PostgreSQL databases along with automation of repetitive tasks. What You'll Do
- 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 What We're Looking For
- 8+ years of experience with PostgreSQL
- Strong 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 (AWS, Azure, Google Cloud) and PostgreSQL-as-a-Service offerings
- Certification in PostgreSQL or related technologies like PostgreSQL Certified Developer or PostgreSQL Certified DBA