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 Temp tables, in-memory tables, and materialized viewsCollaborate 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 optimizationConcurrency handling, locking mechanisms, and transaction isolation levelsExcellent problem-solving and communication skills.(ref : hirist.tech)