Job Responsibilities
Design, implement, and maintain database schemas in PostgreSQL; perform data modeling to ensure efficiency, reliability, and scalability.
Optimize and tune SQL queries for improved performance; identify and resolve performance bottlenecks in database systems.
Manage data migration and integration processes between different systems; ensure data consistency and integrity during migration.
Develop and maintain stored procedures, functions, and triggers to support application requirements and implement business logic within the database layer.
Implement and maintain database security policies; manage user roles, permissions, and access control within the database.
Implement and oversee database backup and recovery processes; ensure data availability and reliability.
Collaborate with cross-functional teams—including application developers, system administrators, and business analysts—to understand database requirements.
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.

PostgreSQL Database Developer

Job Description

Required Skills