PostgreSQL Developer

Job Summary :

We are looking for an experienced PostgreSQL Developer to lead the migration of SQL Server stored procedures to PostgreSQL, while ensuring high performance, security, and scalability.

The candidate sould have 3+ years of experience in database development, with a strong focus on PostgreSQL, SQL, and PL/pgSQL.

This role demands deep expertise in relational databases, query optimization, concurrency management, and encryption. The ideal candidate will have experience in secure data handling, including column-level encryption and database encryption at rest and in transit.

Key Responsibilities :

- Design, develop, and maintain PostgreSQL databases and related applications, ensuring adherence to best practices and industry standards.

SQL and PL/pgSQL Expertise :

- Develop and optimize SQL queries, stored procedures, functions, and triggers using PL/pgSQL.

- Analyze and convert complex SQL Server stored procedures and functions to PostgreSQL, including built-in functions and procedural logic.

- Design and implement secure, optimized, and scalable SQL queries.

Manage and optimize database performance using :

- Indexes (clustered/Non-Clustered)

- Temp tables, in-memory tables, and materialized views

- Collaborate with development teams to integrate database logic with application architecture.

- Document converted procedures, security implementations, and optimization strategies.

- Follow and enforce database best practices, coding standards, and security protocols.

Required Skills and Qualifications :

- 2-3 years of hands-on experience in PostgreSQL development.

- Demonstrated experience in migrating SQL Server logic to PostgreSQL, including translation of procedural and built-in functionality.

- Strong foundation in RDBMS concepts, including data normalization, constraints, and data modeling.

Proven expertise in :

- SQL query tuning and performance optimization

- Concurrency handling, locking mechanisms, and transaction isolation levels

- Excellent problem-solving and communication skills.