Database Developer - PostgreSQL

Job Description

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 to design, implement, and maintain database schemas in PostgreSQL and perform data modeling to ensure efficiency, reliability, and scalability. - Responsible to optimize and tune SQL queries for improved performance , and also identify and resolve performance bottlenecks in database systems. - Responsible to manage data migration and integration processes between different systems and ensure data consistency and integrity during the migration process. - Responsible to develop and maintain stored procedures, functions, and triggers to support application requirements - Implement business logic within the database layer. Responsible to Implement and maintain database security policies and manage user roles, permissions, and access control within the database. - Responsible to implement and oversee database backup and recovery processes and also ensure data availability and reliability. - Responsible to collaborate with cross-functional teams, including application developers, system administrators, and business analysts, to understand database requirements. - Responsible to create and maintain documentation related to database design, processes, and best practices. Qualifications : - Bachelor's 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. - Knowledge of backup and recovery processes. - Excellent communication and collaboration skills. - Ability to work independently and as part of a team. Preferred Skills: - Experience with PostgreSQL replication and clustering. - Familiarity with NoSQL databases. - Knowledge of cloud database solutions (e.g., AWS RDS, Azure Database for PostgreSQL). - Understanding of DevOps practices and tools.