PL/SQL Developer

Blue Spire Inc

2 years

0 Lacs

hyderabad telangana india

Posted:4 hours ago| Platform:

Apply

Skills Required

sql developer development query optimization analysis processing troubleshooting database analyze design data automate reconciliation postgresql unix linux resolve integrity consistency support migration etl kafka payments compliance

Work Mode

On-site

Job Type

Full Time

Job Description

Role Overview

PL/pgSQL Developer with 2+ years of dedicated experience in PostgreSQL

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

2+ years of hands-on PostgreSQL/PL/pgSQL development
experience (procedures, functions, triggers, query tuning).
Practical knowledge of
PostgreSQL database administration
and performance optimization.
Proficiency in
Unix/Linux shell scripting
for job automation.
Experience with
ETL tools, data migration, and batch job scheduling
(Control-M, Autosys, or Crontab).
Understanding of
message queues
(Kafka, IBM MQ) for payment processing.
Prior work in the
Banking & Financial Services (BFSI) domain
, preferably ACH payments processing.
Familiarity with
regulatory and compliance standards
(ACH, NACHA, PCI-DSS, SOX).

More Jobs at Blue Spire Inc

Node.js developer

Hyderabad, Telangana, India

5 - 8 yrs

Salary: Not disclosed

Business Intelligence Analyst

Hyderabad, Telangana, India

3.0 - 3.0 yrs

Salary: Not disclosed

Frontend Developer

Hyderabad, Telangana, India

3.0 - 3.0 yrs

Salary: Not disclosed

Deployment Engineer

Hyderabad, Telangana, India

3.0 - 5.0 yrs

Salary: Not disclosed

Data Engineer

Hyderabad, Telangana, India

3.0 - 3.0 yrs

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.