PostgreSQL Database Developer
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.
Key Responsibilities
- 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.
Technical Skill Requirements
- 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.
Education
- A Bachelor's degree in Computer Science, Information Technology, or a related field is required.
- Any Graduate degree is acceptable.
General Requirements
- Employment Type: Permanent, full-time position.
Preferred Skills
- 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.
