PostgreSQL Database

Job Description :

We are looking for an experienced PostgreSQL Database Developer to join our dynamic team. The ideal candidate will be responsible for the design, development, and maintenance of PostgreSQL databases in a high-performance, scalable environment. You will work closely with other teams to build, manage, and optimize databases to meet business needs and ensure system efficiency.

Key Responsibilities :

Design and implement efficient database structures using PostgreSQL, ensuring scalability, availability, and security.

Write complex SQL queries, stored procedures, and triggers to support business logic and application performance.

Design and implement database schemas and data models for enterprise-level applications.

Optimize queries and database performance using techniques such as indexing, partitioning, and query rewriting.

Collaborate with development teams to integrate PostgreSQL with applications and resolve data issues.

Maintain and enhance PostgreSQL databases, ensuring they run efficiently, are properly maintained, and meet the required SLAs.

Develop backup and recovery strategies to ensure data integrity and system reliability.

Monitor database performance, troubleshoot issues, and implement tuning strategies.

Work on database migrations, including data migration, schema changes, and version control for databases.

Provide expert-level support in PostgreSQL architecture, maintenance, and troubleshooting.

Ensure database security by implementing access controls, encryption, and backup / recovery solutions.

Collaborate with DevOps teams to automate and manage database deployments in cloud environments like AWS, Azure, or GCP.

Implement data integrity and ensure adherence to data governance standards.

Skills & Qualifications :

Proven experience as a PostgreSQL Database Developer / Administrator.

Strong knowledge of PostgreSQL architecture and management.

Proficient in writing advanced SQL queries, PL / pgSQL, and developing stored procedures and triggers.

Experience with performance tuning, query optimization, and database indexing strategies.

Knowledge of database replication, clustering, and high-availability setups in PostgreSQL.

Experience with backup and recovery solutions, including PITR (Point In Time Recovery).

Proficiency in data modeling and schema design.

Experience working with PostgreSQL on cloud platforms (AWS, Azure, GCP) is a plus.

Familiarity with PostgreSQL extension tools like PostGIS (for GIS applications) or Foreign Data Wrappers.

Experience with CI / CD pipelines for database changes using tools like Jenkins, GitLab CI, etc.

Familiarity with Linux / Unix environments and shell scripting.

Good understanding of database security principles, including user roles, permissions, and encryption.

Excellent problem-solving skills and the ability to work in a fast-paced, collaborative environment.

Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).