PL / SQL Developer (Immediate Start)

Role Overview

Blue Spire is seeking a PL / pgSQL Developer with 2+ years of dedicated experience in PostgreSQL for banking applications. The ideal candidate will have strong expertise in PL / pgSQL development, query optimization, and batch job analysis. This role involves working on payment processing workflows, troubleshooting issues, and enhancing database performance to ensure secure, efficient, and accurate transaction processing.

Key Responsibilities

• Analyze and enhance payment systems, including batch processing and transaction flows.
• Design, develop, and optimize PL / pgSQL procedures, functions, and triggers for data processing.
• Debug and tune SQL queries for high-performance, large-scale payment processing systems.
• Automate data processing and reconciliation workflows using PostgreSQL and Unix / Linux shell scripting.
• Identify and resolve database bottlenecks, deadlocks, and performance issues.
• Monitor and troubleshoot batch jobs and system logs to proactively identify failures.
• Ensure data integrity, consistency, and compliance with regulatory standards (ACH, NACHA, PCI-DSS).
• Support data migration and ETL processes during system upgrades.
• Collaborate with business teams, payment domain experts, and application support teams.

Required Skills & Experience