PostgreSQL Database Developer

Job Description

Key Skills : PostgreSQL, Pl/SQL Education Qualification : Any Graduate Minimum Years of Experience : 3+ Years Type of Employment : Permanent 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 tuneSQL 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 and 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 : Bachelors degree in Computer Science, Information Technology, or a related field. Proven experience as a Database Developer with a focus on PostgreSQL. In-depthknowledge 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 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 (ref:hirist.tech) Show more Show less