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.

System Senior Analyst

AppSec Engineer

Senior Manager/Senior Vice President/VP - Wealth Management

Java Drive Professional

PostgreSQL Database Developer

BIM Architect / BIM Engineer (Preferably experienced in US project)

Business Administration (MBA)