PostgreSQL Developer

Habilelabs


Date: 3 weeks ago
City: Jaipur, Rajasthan
Contract type: Full time
About HabileLabs HabileLabs is a premier software development and consulting company dedicated to delivering high-quality technical solutions. We pride ourselves on engineering excellence and a culture that fosters innovation and continuous learning. We are looking for a disciplined PostgreSQL Developer who is passionate about database performance and scalable architecture Role Objective As a PostgreSQL Developer, you will be the backbone of our data layer. You will design, develop, and optimize complex database systems that support high-traffic applications. Your goal is to ensure data integrity, security, and peak performance across all our PostgreSQL environments Key Responsibilities
  • Database Development: Design and implement robust database schemas, tables, and dictionary structures.
  • Programming: Write and maintain high-performance PL/pgSQL, including complex stored procedures, triggers, and views.
  • Performance Engineering: Analyze query execution plans using EXPLAIN ANALYZE and implement optimizations such as indexing (B-tree, GIN, GiST) and partitioning.
  • Data Integrity: Ensure the consistency and reliability of data through proper normalization and constraint management.
  • Maintenance: Monitor database performance, perform regular vacuuming, and manage bloating issues.
  • Collaboration: Work closely with Backend Engineers and PMO to translate business requirements into efficient data models.
  • Migration: Manage data migration, transformation, and scripting using Git for version control.
Technical Skills & Requirements
  • Education: B.Tech or M.Tech in Computer Science, IT, or a related Engineering discipline.
  • Core Experience: 3 to 5 years of dedicated experience in PostgreSQL development and administration.
  • SQL Mastery: Expert-level knowledge of SQL, including window functions, CTEs, and complex joins.
  • Optimization: Strong experience in tuning slow queries and understanding PostgreSQL internals (WAL, Buffer Cache).
  • Tools: Proficiency with pgAdmin, DBeaver, and command-line psql.
  • Security: Knowledge of Role-Based Access Control (RBAC) and data encryption practices.
  • Advantageous: Experience with cloud databases (AWS RDS/Aurora) or NoSQL features within PostgreSQL (JSONB).
Preferred Attributes
  • Immediate Availability: Candidates who can join immediately or within 15 days.
  • Analytical Mindset: Ability to troubleshoot complex data issues and provide scalable solutions.
  • Communication: Strong verbal and written communication skills for internal team coordination.
Why Join Us?
  • Engage with cutting-edge technologies and diverse project domains.
  • A transparent work culture focused on objective performance and growth.
  • Competitive compensation package and employee-centric benefits.

How to apply

To apply for this job you need to authorize on our website. If you don't have an account yet, please register.

Post a resume

Similar jobs

Field Executive | Executive - Logistics | Logistics | Jaipur | On site

Unipath Specialty Laboratory, Jaipur, Rajasthan
1 week ago
Job Type Intern Job Qualification Any Graduate Workplace type On Site Required Skills He must be demonstrate strong operational understanding, adaptability, and a client-focused approach to ensure timely and safe delivery of lab samples and supplies. Executive - Logistics Intern Job Description Job Title: Executive - Logistics (Intern) Department: Logistics Job Type: Intern Qualifications: Any Graduate Skills Required: Strong operational...

Branch Credit Manager

IDFC FIRST Bank, Jaipur, Rajasthan
2 weeks ago
Job RequirementsJob Requirements Role/ Job Title: Recovery Manager – Business Installment Loan, Personal Loan, and Micro Business LoanFunction/ Department:CollectionsJob Purpose: The role bearer has the responsibility to plan, organize, direct and oversee the activities of the collections department. It also includes managing the agencies associated with the company in their assigned territory. The role bearer is responsible for the efficiency...

Mechanical Engineer

Nexmec Automation, Jaipur, Rajasthan
2 weeks ago
Job Description We are looking for a skilled and detail-oriented Mechanical Engineer to join our team. The candidate will be responsible for designing, developing, testing, and maintaining mechanical systems and equipment. The ideal applicant should have strong technical knowledge, problem-solving skills, and the ability to work in a team environment. Responsibilities Design and develop mechanical components and systems Perform testing,...