PostgreSQL Database Developer

Job Description

PostgreSQL Database Developer

The ideal candidate should have a strong background in database development, performance optimization, and data modeling.

• Database schema design, implementation, and maintenance will be performed in PostgreSQL, along with data modeling to ensure efficiency, reliability, and scalability.
• SQL query optimization and tuning for improved performance are essential, including identifying and resolving performance bottlenecks in database systems.
• Data migration and integration processes between different systems will be managed, ensuring data consistency and integrity during migration.
• Stored procedures, functions, and triggers will be developed and maintained to support application requirements and implement business logic within the database layer.
• Database security policies will be implemented and maintained, managing user roles, permissions, and access control within the database.
• Database backup and recovery processes will be implemented and overseen to ensure data availability and reliability.
• Collaboration with cross-functional teams, including application developers, system administrators, and business analysts, is crucial for understanding database requirements.
• Documentation creation and maintenance related to database design, processes, and best practices are required.

• Proven experience as a Database Developer with a focus on PostgreSQL is mandatory.
• In-depth knowledge of database design principles, normalization, and data modeling is essential.
• Strong proficiency in writing and optimizing SQL queries is required.
• Experience with performance tuning and query optimization techniques is a must.
• Familiarity with database security best practices and access control is necessary.
• Hands-on experience with data migration, integration, and ETL processes is essential.
• Proficiency in scripting languages (e.g., Python, Bash) for automation tasks is required.
• Knowledge of backup and recovery processes is necessary.
• Excellent communication and collaboration skills are vital.
• Ability to work independently and as part of a team is expected.

• A Bachelor's degree in Computer Science, Information Technology, or a related field is required.
• Any Graduate degree is acceptable.

• Employment Type: Permanent, full-time position.

• Experience with PostgreSQL replication and clustering is a plus.
• Familiarity with NoSQL databases is beneficial.
• Knowledge of cloud database solutions (e.g., AWS RDS, Azure Database for PostgreSQL) is an advantage.
• Understanding of DevOps practices and tools is preferred.