Team Lead - PostgreSQL

Designation : Team Lead-Postgresql

Location : Bangalore

Years of Experience : 10+ Years

Position : Permanent

Mode : WFO

Our dynamic and growing company is actively seeking an experienced PostgreSQL Database Developer to join our team. As a PostgreSQL Database Developer, you will play a crucial role in designing, implementing, and maintaining our database systems. The ideal candidate should have a strong background in database development, performance optimization, and data modeling.

Job Responsibilities :

- Responsible for designing, implementing, and maintaining database schemas in PostgreSQL and performing data modeling to ensure efficiency, reliability, and scalability.

- Responsible to optimize and tuneSQL queries for improved performance , and also identify and resolve performance bottlenecks in database systems.

- Responsible for managing data migration and integration processes between different systems and ensuring data consistency. Also, integrity during the migration process.

- Responsible for developing and maintaining stored procedures, functions, and triggers to support application requirements and Implement business logic within the database layer.

- Responsible for implementing and maintaining database security policies and managing user roles, permissions, and access. Control within the database.

- Responsible for implementing and overseeing database backup and recovery processes and also ensuring data availability and reliability.

- Responsible for collaborating with cross-functional teams, including application developers, system administrators, and business analysts, to understand database requirements.

- Responsible for creating and maintaining documentation related to database design, processes, and best practices.

Requirements Qualifications :

- Bachelors degree in Computer Science, Information Technology, or a related field.

- Proven experience as a Database Developer with a focus on PostgreSQL.

- In-depth knowledge of database design principles, normalization, and data modeling.

- Strong proficiency in writing and optimizing SQL queries.

- Experience with performance tuning and query optimization techniques.

- Familiarity with database security best practices and access control.

- Hands-on experience with data migration, integration, and ETL processes.

- Proficiency in scripting languages (e.g., Python, Bash) for automation tasks.

- Knowledgeofbackupandrecovery processes.

- Excellent communication and collaboration skills.

- Ability to work independently and as part of a team.

Preferred Skills :