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.
