About Habile Labs
Habile Labs 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 Postgre SQL Developer who is passionate about database performance and scalable architecture.
Role Objective
As a Postgre SQL 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 Postgre SQL environments.
Key Responsibilities
Database Development: Design and implement robust database schemas, tables, and dictionary structures.
Programming: Write and maintain high-performance PL/pg SQL, 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, Gi ST) 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 Postgre SQL 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 Postgre SQL internals (WAL, Buffer Cache).
Tools: Proficiency with pg Admin, 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 No SQL features within Postgre SQL (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.
or continue with email
Habile Labs 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 Postgre SQL Developer who is passionate about database performance and scalable architecture.
Role Objective
As a Postgre SQL 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 Postgre SQL environments.
Key Responsibilities
Database Development: Design and implement robust database schemas, tables, and dictionary structures.
Programming: Write and maintain high-performance PL/pg SQL, 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, Gi ST) 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 Postgre SQL 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 Postgre SQL internals (WAL, Buffer Cache).
Tools: Proficiency with pg Admin, 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 No SQL features within Postgre SQL (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.
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
Similar jobs
Show more