PL/SQL Developer

Blue Spire Inc

0 years

0 Lacs

Hyderabad Telangana India

Posted:1 day ago| Platform:

Apply

Skills Required

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

Work Mode

On-site

Job Type

Full Time

Job Description

Role Overview:

PostgreSQL Developer

Key Responsibilities:

Analyze payment systems including batch processing and transaction flow.
Review and enhance existing PostgreSQL procedures, functions, and triggers related to data processing.
Develop, debug, and optimize PostgreSQL stored procedures, functions, and scripts.
Analyze and tune SQL queries for high-performance large-scale payment processing.
Automate data processing and reconciliation workflows using PostgreSQL and shell scripting.
Identify and resolve database bottlenecks, deadlocks, and performance issues.
Monitor and troubleshoot batch jobs and system logs to identify failures.
Ensure data integrity, consistency, and compliance with regulatory requirements (ACH, NACHA, PCI-DSS).
Participate in data migration and ETL processes for system upgrades.
Work closely with business teams, payment domain experts, and application support teams.

Required Skills & Experience:

Strong expertise in
PostgreSQL
programming, including stored procedures, functions, triggers, and performance tuning.
Hands-on experience with PostgreSQL database administration and query 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.
Hands-on experience in BFSI (Banking & Financial Services) domain, specifically 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.