PL/SQL Developer

1 day ago

India, IN Blue Spire Inc Full time

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

  • 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).

  • SQL Engineer

    1 day ago

    Bangalore Urban, Karnataka, India, IN Insight Global Full time

    Insight Global is seeking an SQL Engineer for one of their premier financial services clients in Bengaluru. This person will be expected to uunderstand the Loyalty and Benefits domain and how it powers the experience for the client's customer. He or she will learn and support the legacy applications and modern platforms to develop a deep understanding of all...

  • BRM Developer

    3 days ago

    india, IN Penta Consulting Full time

    Tenure: 6 MonthsWork mode: RemotelyClient site: KSADesign, develop, and implement Oracle BRM applications.Customize and configure Oracle BRM based on business requirements.Collaborate with cross-functional teams to understand billing needs and translate them into technical solutions.Troubleshoot and resolve issues related to Oracle BRM applications.Ensure...

  • Powerapps Developer

    2 weeks ago

    Gurugram, Haryana, India, IN Deloitte Full time

    Notice Period - Immediate Joiner to 30 DaysLocation - GurgaonExperience - 5+ YearsJob Description:-Support and development delivery of MS Power Apps, Power Automate Development as per engagement modelOptimize the Automation code to make sure the process is working at the highest efficiencyIdentify the re-usability of components and update the Object library...

  • Oracle Technical Consultant

    3 days ago

    india, IN Recro Full time

    Job Title: Oracle Apps Technical ConsultantExperience: 8+ YearsWork Mode: RemoteJob Summary:We are looking for a highly skilled Oracle Apps Technical Consultant with strong hands-on experience in Oracle E-Business Suite (R12 or later). The ideal candidate will have deep technical expertise in PL/SQL, Forms, Reports, Workflows, and custom...

  • Oracle APEX Developer

    1 day ago

    india, IN Absolute Applications Full time

    Job title: Oracle APEX ConsultantDuration: Initial 6 month ContractDaily Rate: Circa 7000 INR per dayJob description:We are looking for an Oracle Application Express (APEX) developer to join our rapidly growing Oracle Consultancy. The ideal candidate will have a strong background in Oracle APEX, with a specific focus on the development of applications...

  • Avaloq Developer

    1 day ago

    india, IN Hyper Lychee Labs Full time

    CLIENT TIME ZONE: Thailand/Philippines EXPERIENCE: Minimum 2 years (Avaloq Development)BUDGET: As per Industry Standard CONTRACT DURATION: Minimum 6 months (with high likelihood of extension)JOB DESCRIPTION: About the RoleWork in Avaloq parameterization, develop software changes, and perform unit testing.Understand user requirements and provide solutions via...

  • Oracle Fusion Cloud-Oracle Integration Cloud

    1 day ago

    , India, IN Extreme Networks Full time

    Job DescriptionExperience: 4-7 YearsOracle Cloud Software as a Service (SaaS) Technical DevelopmentOIC development and deployment using various connectors and adapters.Expertise with Web Services and the use of Oracle Cloud delivered Web Services (SOAP & REST)Experience Extending Oracle SaaS Applications with PaaSWriting complex SQL queries and optimization...

  • IICS/IDMC Developer

    2 weeks ago

    Bangalore Urban, Karnataka, India, IN Infogain Full time

    Informatica PowerCenter 9.x & onwards experienceIICS/IDMC experience with or without CAI experienceDatabase - Oracle, SQL server, DB2 etcUnix Scripts/commands/file handlingPython exposure at least basic knowledgeSQL/PL-SQL queries/code writing experience Data Testing/Validation experienceCode Deployment , CI/CD pipelines exposureAWS/Azure Data engineering...

  • Senior Software Engineer

    3 days ago

    Mohali district, India, IN Americana Restaurants Full time

    Position Title: Senior Software Engineer - Oracle Process Cloud About Americana Restaurants International PLCAmericana Restaurants International PLC is a pioneering force in the MENA region and Kazakhstan's Out-of-Home Dining industry, ranking among the world’s leading operators of Quick Service Restaurants (QSR) and casual dining establishments. With an...

  • Oracle Technical Support – Sales

    2 weeks ago

    india, IN Best Infosystems Ltd. Full time

    Oracle Technical Support – Sales & Distribution_Contract (6 Months)_Pan India(Remote)Job Title: Oracle Technical Support – Sales & DistributionDuration : 6 Months (Contract)Experience: 7+ YearsLocation: Pan IndiaMode of work: RemoteJob Description:Must-Have Skills:Proven experience in Oracle EBS R12 Tech Support, especially across multiple modules in...