16 Nov
|
Habilelabs
|
Jaipur
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
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 effective 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 : Solid 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
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 advantages.
📌 Postgresql Developer Jaipur
🏢 Habilelabs
📍 Jaipur