Oracle Developer - Cards & Payments (TSYS PRIME)

About the role

The Oracle Developer is responsible for designing, developing, testing and supporting Oracle SQL and PL/SQL components in the bank's Cards Technology environment, including the card management system (TSYS PRIME), interfaces, batch jobs and reporting for credit, debit and corporate card products. The role works with Business, Operations, Risk, Compliance and IT teams to turn business and regulatory needs into database solutions covering authorization, transaction processing, billing, posting, reconciliation, settlement and reporting. It also supports scheme compliance (Visa/Mastercard), system upgrades and production support.

Key responsibilities

• Develop, test and maintain Oracle SQL and PL/SQL code for card processing systems and reporting
• Document technical designs, code and procedures to support knowledge sharing and future maintenance
• Participate in code reviews and contribute to continuous improvement of development processes
• Collaborate with cross-functional teams to align with project timelines and priorities
• Provide production support and troubleshooting for Oracle-based card applications
• Stay up to date with emerging payment technologies and their impact on card platforms

Required profile

• Bachelor's or Master's degree in Information Technology, Software Engineering or Computer Science
• 5+ years of hands-on Oracle SQL and PL/SQL development, preferably in banking, cards or payments
• Ability to work in a team and communicate with stakeholders; thoroughness in coding and testing
• Familiarity with version control systems and code repositories

Required skills

• Advanced PL/SQL: triggers, functions, procedures, packages, performance tuning and exception handling
• Advanced SQL: complex queries, joins, subqueries, analytical functions and query optimization
• Oracle DBMS: data modeling, indexing, performance tuning and troubleshooting
• Querying, manipulating and validating large volumes of transactional data
• Oracle SQL / PL/SQL certification (OCA/OCP) preferred
• Experience with TSYS PRIME (Prime 3/4 Issuer/Acquirer, Job Admin, Report Manager) or other card systems (CTL, Way4, SmartVista, Vision Plus) is a strong plus