Jobs → Engineering → PL/SQL Developer

About the Role We are looking for a PL/SQL Developer to join our team. This role focuses on enhancing and maintaining application SQL and PL/PGSQL performance. Key Responsibilities • Provide performance tuning best practices to enhance and maintain application SQL and PL/PGSQL performance • Work closely with application teams to resolve performance-related issues • Measure database performance and troubleshoot complex database issues Requirements • 7+ years of professional experience as a Postgres code development and migrations • In-depth knowledge of the PostgreSQL architecture and application data lifecycle management • Experience in implementing Security Guidelines of Postgres STIG, testing, and other vulnerability remediation • Experience in working closely with the application teams to resolve any performance related issues • Measure database performance and troubleshoot complex database issues, I/O bottlenecks and SQL Tuning • Proven experience in working in a mission critical environment in a multi-terabyte database platform • Working knowledge of Database Security mechanism, data encryption, obfuscation, auditing using tools • Experience with automation using Python, Ansible, etc. • In-depth knowledge of IT industry database technologies and processes and business applications integrated with database technologies • Ability to develop efficient data models • Ability to write optimized SQL queries and PL/PGSQL code • Experience in triggers and constraints • Strong experience in SQL and Database performance tuning • Experience in developing and managing table and index partitioning • Strong experience in writing complex JOINS and Sub Queries • Extensive experience in using extensions and all available functions • Knowledge in Agile Scrum Framework