Database Developer - PostgreSQL

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

Database Schema Management: You'll design, implement, and maintain database schemas in PostgreSQL, performing data modeling to ensure efficiency, reliability, and scalability.
Performance Optimization: You'll optimize and tune SQL queries for improved performance, as well as identify and resolve performance bottlenecks in database systems.
Data Migration & Integration: You'll manage data migration and integration processes between different systems, ensuring data consistency and integrity throughout the migration.
Stored Procedures & Functions: You'll develop and maintain stored procedures, functions, and triggers to support application requirements, implementing business logic within the database layer.
Database Security: You'll implement and maintain database security policies and manage user roles, permissions, and access control within the database.
Backup & Recovery: You'll implement and oversee database backup and recovery processes, ensuring data availability and reliability.
Cross-functional Collaboration: You'll collaborate with cross-functional teams, including application developers, system administrators, and business analysts, to understand database requirements.
Documentation: You'll create and maintain documentation related to database design, processes, and best practices.

Qualifications

Education: Bachelor's degree in Computer Science, Information Technology, or a related field.
PostgreSQL Expertise: Proven experience as a Database Developer with a focus on PostgreSQL.
Database Design: In-depth knowledge of database design principles, normalization, and data modeling.
SQL Proficiency: Strong proficiency in writing and optimizing SQL queries.
Performance Tuning: Experience with performance tuning and query optimization techniques.
Security Best Practices: Familiarity with database security best practices and access control.
Data Migration: Hands-on experience with data migration, integration, and ETL processes.
Scripting: Proficiency in scripting languages (e.g., Python, Bash) for automation tasks.
Backup & Recovery Knowledge: Knowledge of backup and recovery processes.
Communication: Excellent communication and collaboration skills.
Teamwork: 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.

Analyst /Finance Business Partner

IT QA Lead - Tester - Offshore

Windchill Customization

Biztalk + ESB Professional

Database Developer - PostgreSQL

eCRF / Database Developer

Oracle HCM Technical