Senior Oracle PL/SQL Developer

Scadea Software Solutions; Dallas (TX); On-site; USD 120,000 - 170,000; Full time

Job summary

Scadea Software Solutions in Dallas, TX seeks a Senior Oracle PL/SQL Developer with 8+ years of hands-on experience in Banking & Financial Services. You will design, optimize, and maintain complex database solutions for core banking applications.

The role requires expert SQL/PLSQL skills, deep knowledge of performance tuning, indexing, and data integrity, plus collaboration with analysts, developers, and QA across the development lifecycle.

Qualifications

• Expert-level Oracle SQL/PL/SQL development
• Strong understanding of indexing, execution plans, and performance tuning
• Experience with large data volumes and high-performance DB solutions
• Banking/financial services domain experience preferred

Responsibilities

• Design, develop, test, and maintain complex Oracle SQL queries, procedures, functions, packages, triggers, and DB objects.
• Write advanced SQL queries with complex joins, analytical functions, subqueries, and bulk processing for large datasets.
• Perform SQL/PLSQL performance tuning and index optimization.
• Develop database components supporting banking applications, transactions, payments, and core banking functions.
• Translate complex business requirements into efficient DB solutions and ensure data integrity.
• Troubleshoot defects, resolve data inconsistencies, and optimize DB logic.
• Collaborate with business analysts, developers, QA, and stakeholders throughout the lifecycle.
• Participate in code reviews, unit testing, and deployment activities.

Skills

Oracle SQL

PL/SQL

Query optimization

Performance tuning

Data modeling

Banking domain

Job description

Job Description: Senior Oracle PL/SQL Developer

Experience: 8+ Years

Domain: Banking & Financial Services

Job Summary

We are looking for a highly experienced Senior Oracle PL/SQL Developer with 8+ years of strong hands-on development experience and proven expertise in the Banking and Financial Services domain. The ideal candidate must possess excellent SQL/PLSQL programming skills, strong problem-solving abilities, and experience developing and optimizing complex database solutions for banking applications.

Candidates must be strong individual contributors with extensive hands-on coding experience. Profiles focused primarily on DBA activities, production support, or maintenance without substantial development experience will not be considered.

Key Responsibilities

• Design, develop, test, and maintain complex Oracle SQL queries, stored procedures, functions, packages, triggers, and database objects.
• Write advanced SQL queries involving complex joins, analytical functions, subqueries, bulk processing, and large datasets.
• Perform SQL and PL/SQL performance tuning, execution plan analysis, indexing, and query optimization.
• Develop and enhance database components supporting banking applications, financial transactions, account processing, payments, and other core banking functions.
• Analyze complex business requirements and translate them into efficient, scalable database solutions.
• Troubleshoot coding defects, resolve data inconsistencies, and optimize database logic while maintaining data integrity.
• Collaborate with business analysts, application developers, QA teams, and banking stakeholders throughout the development lifecycle.
• Participate in code reviews, unit testing, technical documentation, and deployment activities.

Mandatory Technical Skills

• Oracle SQL and PL/SQL: Expert-level hands-on development experience.
• Strong expertise in complex queries, joins, analytical functions, stored procedures, packages, functions, and triggers.
• Proven experience in query optimization, execution plans, indexing strategies, and performance tuning.
• Strong understanding of relational database concepts, data modeling, transactions, and data integrity.
• Experience handling large volumes of data and developing high-performance database solutions.
• Proficiency in debugging, root-cause analysis, and writing clean, maintainable code.

Mandatory Banking Domain Experience

• Strong, demonstrable experience working on banking or financial services applications.
• Good understanding of banking business processes, financial data, transaction processing, and data accuracy requirements.
• Ability to understand banking-specific requirements and implement them through efficient SQL/PLSQL solutions.
• Experience working on enterprise-scale banking systems is strongly preferred.