PL/SQL Developer

3 weeks 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

    3 weeks 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

    4 weeks 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...


  • india, IN KPG99 INC Full time

    Role- Oracle Data Integrator (ODI) DeveloperLocation- Remote (India)Duration- 6+ monthsREQUIRED SKILLSRequired Qualifications5+ years of hands-on experience with Oracle Data Integrator (ODI).Strong expertise in PL/SQL, Oracle databases, SQL Developer, and TOAD.Proven experience in data integration, ETL development, and backend database programming.Strong...


  • 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

    3 weeks 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

    3 weeks 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...


  • india, IN Recro Full time

    Role : Oracle Application Technical ConsultantProven experience (8+ years) as an Oracle Apps Technical consultant for Oracle E-Business Suite (R12 or later).Strong expertise in Oracle PL/SQL, SQL, Oracle Forms, Reports, Workflow, triggers, and custom interface/integration development.Deep knowledge of Oracle EBS modules (Supply Chain, Finance).Experience...


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


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

  • Dotnet Developer

    2 weeks ago


    Bangalore Urban, Karnataka, India, IN Tata Consultancy Services Full time

    Preferred Candidate Profile: Experience:5 to 7 YearsNotice Period: 60 Days.Must Have:Framework: .Net, .Net Core,Web API and Entity FrameworkArchitecture: MicroservicesLanguage: C#, ReactJSPL SQLGood To Have:SSISAzureDevops