PL/SQL Developer
Irving, USA-TX, USA, 14081On-siteFull-timeSoftware Development
Description
Job Description
Role: PL/SQL Developer
Location: Jersey City, NJ / Tampa, FL / Irving, TX (3 Days on-site/ week)
Job Description:
Looking for an experienced Oracle PL/SQL Developer to work on mission-critical banking applications supporting highvolume transactional systems. The role involves developing and optimizing Oracle PL/SQL components with a strong focus on performance, stability, data integrity, security, and regulatory compliance. The candidate will collaborate closely with application teams, business analysts, QA, and production support teams in a highly controlled enterprise environment.
Key Responsibilities
• Design, develop, and maintain Oracle PL/SQL procedures, packages, functions, triggers, and views for core banking and enterprise platforms
• Write and optimize highperformance SQL queries supporting large data volumes and nearrealtime processing
• Perform PL/SQL and SQL performance tuning, execution plan analysis, and indexing strategies to meet SLA requirements
• Support business-critical batch jobs, endofday (EOD) processing, and scheduled data flows
• Collaborate with Business Analysts and Upstream/Downstream application teams to interpret functional requirements
• Provide production support, incident resolution, and root cause analysis for datarelated issues
• Ensure adherence to Citi SDLC, change management, security, audit, and compliance standards
• Support data migration, data reconciliation, and ETL processes
• Prepare and maintain technical documentation, code reviews, and release artifacts
• Work in Agile / Scrum or controlled waterfall delivery models as per Citi program governance
Mandatory Technical Skills
• Strong hands-on experience in Oracle PL/SQL & SQL
• Experience with Oracle Database (12c / 19c)
• Advanced knowledge of stored procedures, packages, triggers, cursors, collections
• Performance tuning using explain plans, indexes, partitions
• Experience in Unix/Linux environments
• Proficiency with Oracle SQL Developer / TOAD
• Experience supporting production systems in a regulated environment
Banking Specific Experience ( Preferred )
• Experience working in Banking or Financial Services domain
• Exposure to highavailability systems, data controls, reconciliation, and audit requirements
• Understanding of SOX, data security, segregation of duties, and change governance
• Familiarity with large transactional datasets and batch processing architecture
Good to Have
• Exposure to ETL tools, control M / Auto Sys / scheduler tools
• Shell scripting (Unix)
• Data modeling and schema design
• Experience working with global teams and offshore–on-site delivery model
Education
• Bachelor’s degree in Computer Science / Engineering / Information Technology or equivalent
Soft Skills
• Strong analytical and problem-solving skills
• Excellent communication and stakeholder coordination
• Ability to work under strict SLAs and production deadlines
• Attention to detail and compliance mindset