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. Skills :Experience with PostgreSQL replication and clustering.Familiarity with NoSQL databases.Knowledge of cloud database solutions (e.g., AWS RDS, Azure Database for PostgreSQL).UnderstandingofDevOpspractices and tools(ref : hirist.tech)