Postgres Developer

Headsbase Select; Chennai District; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Headsbase Select is seeking a Senior Database Developer in Chennai to design and implement high-performance database solutions using PostgreSQL, MySQL and Oracle. The role requires strong expertise in query optimization, data modeling and ETL processes.

The ideal candidate will have 3-7 years of experience as a database developer, hands-on experience with stored procedures, triggers and ensuring robust security and permissions management.

Qualifications

• 3-7 years of experience as a Database Developer.
• Expertise in query optimization, stored procedures, data modeling and ETL processes.
• Hands-on experience with ETL and data transformation techniques.
• Knowledge of database security, user roles and permissions management.
• Basic knowledge of NoSQL databases (optional).

Responsibilities

• Design and develop high-performance database solutions.
• Optimize queries and indexing for performance.
• Model data with proper schema design and normalization.
• Develop stored procedures, triggers and functions.
• Implement ETL processes and data transformations.
• Ensure security and permissions management.
• Collaborate in Agile/DevOps environments.

Skills

PostgreSQL

MySQL

Oracle

Query optimization

Data modeling

ETL processes

Stored procedures

Triggers

Database security

NoSQL basics

Education

Bachelor's degree in CS/Engineering

Postgraduate qualification (preferred)

Tools

PostgreSQL tools

MySQL Workbench

Oracle SQL Developer

ETL tools (Talend/Informatica)

Job description

Job Summary

We are looking for a Senior Database Developer with3- 7 years of experience in designing and developing high-performance database solutions using PostgreSQL, MySQL and Oracle. The ideal

candidate should have expertise in query optimization, stored procedures, data modeling and ETL

processes.

Required Experience

• 3-7 years of experience as a Database Developer.

Skills and Expertise

Technical Skills

• Mandatory experience in PostgreSQL.
• Proficiency in PostgreSQL, MySQL and Oracle.
• Strong understanding of query optimization, indexing and execution plans.
• Experience with data modeling, schema design and normalization techniques.
• Ability to write complex stored procedures, triggers and functions.
• Hands-on experience with ETL processes and data transformation techniques.
• Knowledge of database security, user roles and permissions management.
• Basic knowledge of NoSQL databases (optional).

Development Practices & Methodologies

• Familiarity with Agile development and DevOps best practices.
• Ability to write efficient, maintainable and scalable database code.
• Experience with automated database testing and validation.

Soft Skills

• Strong analytical and problem-solving skills.
• Excellent communication and teamwork skills.
• Ability to learn and adapt to new technologies quickly.
• Strong attention to detail in writing efficient and optimized queries.

Qualifications

• Bachelors degree in Computer Science, Engineering, or a related field.
• Post-graduate qualification (preferred).