Sr. Assoc, Prod Specialist - Switching & Cards, WRB Tech

Job Summary

We are looking for a Senior PL/SQL Developer with 10+ years of experience in Postgres/Oracle database development, preferably in the banking or financial services domain. The role requires strong expertise in PL/SQL programming, SQL performance tuning, data processing, and support for enterprise-grade transactional systems. The candidate should be capable of working on complex banking applications, understanding business-critical data flows, and delivering stable, high-performance database solutions. 

Key Responsibilities

Design, develop, enhance, and maintain complex Postgres PL/SQL objects including packages, procedures, functions, triggers, views, and cursors. 
Work on core banking, payments, settlements, reconciliation, accounting, regulatory reporting, or similar banking systems. 
Analyze business and functional requirements and translate them into efficient database solutions. 
Optimize SQL queries and PL/SQL code for high-volume transactional systems. 
Perform data analysis, troubleshooting, and root cause investigation for production issues. 
Support batch processing, end-of-day processing, reconciliations, and reporting workflows. 
Ensure data accuracy, integrity, security, and compliance across banking applications. 
Collaborate with business analysts, application developers, QA teams, and production support teams. 
Participate in code reviews, design reviews, and release planning activities. 
Lead defect fixes, performance improvements, and production deployment support. 
Mentor junior developers and guide the team on coding standards and best practices. 
Prepare and maintain technical documentation, impact assessments, and deployment documents. 

Skills and Experience

10+ years of hands-on experience in SQL and PL/SQL development. 
Strong experience in the banking or financial services domain. 
Proven expertise in developing complex PL/SQL packages, procedures, functions, triggers, and bulk processing logic. 
Strong knowledge of Oracle database performance tuning, query optimization, indexing strategies, and execution plan analysis. 
Experience in handling large-volume transactional data and mission-critical production systems. 
Strong understanding of data modeling, normalization, referential integrity, and database design principles. 
Experience with exception handling, debugging, code migration, and release support. 
Ability to work on production incidents, defect analysis, and root cause resolution. 
Strong knowledge of Unix/Linux shell scripting and job scheduling concepts. 
Experience with tools such as ADO, TOAD, OEM, Git, Jira, and deployment tools. 
Good understanding of SDLC, change management, and audit/compliance requirements in banking environments. 

Banking Domain Experience Required 
Candidate should have experience in one or more of the following areas: 
Core banking 
Payments and settlements 
Cards and transaction processing 
Reconciliation systems 
Preferred Skills 
Exposure to ETL and reporting systems. 
Familiarity with SWIFT, ISO 8583, ISO 20022, or other financial messaging standards. 
Experience working in high-availability and disaster recovery environments. 
Exposure to Agile, Scrum, or DevOps delivery models. 
Knowledge of data security, encryption, and access control in financial systems. 
Leadership Expectations 
Ability to lead technical discussions and provide solution guidance. 
Mentor junior and mid-level developers. 
Review code for quality, performance, and maintainability. 
Coordinate with stakeholders across business, development, QA, and production support. 

Qualifications

Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field. 
Nice to Have 
DB certification 
Exposure to banking product implementation or modernization programs 
Key Competencies 
Strong analytical and problem-solving ability 
Attention to detail 
Ownership and accountability 
Ability to work in high-pressure production support environments 
Strong communication and stakeholder management skills 

About Standard Chartered

We're an international bank, nimble enough to act, big enough for impact. For more than 170 years, we've worked to make a positive difference for our clients, communities, and each other. We question the status quo, love a challenge and enjoy finding new opportunities to grow and do better than before. If you're looking for a career with purpose and you want to work for a bank making a difference, we want to hear from you. You can count on us to celebrate your unique talents and we can't wait to see the talents you can bring us.

Our purpose, to drive commerce and prosperity through our unique diversity, together with our brand promise, to be here for good are achieved by how we each live our valued behaviours. When you work with us, you'll see how we value difference and advocate inclusion.

Together we:

• Do the right thing and are assertive, challenge one another, and live with integrity, while putting the client at the heart of what we do
• Never settle, continuously striving to improve and innovate, keeping things simple and learning from doing well, and not so well
• Are better together, we can be ourselves, be inclusive, see more good in others, and work collectively to build for the long term

What we offer

In line with our Fair Pay Charter, we offer a competitive salary and benefits to support your mental, physical, financial and social wellbeing.

• Core bank funding for retirement savings, medical and life insurance, with flexible and voluntary benefits available in some locations.
• Time-off including annual leave, parental/maternity (20 weeks), sabbatical (12 months maximum) and volunteering leave (3 days), along with minimum global standards for annual and public holiday, which is combined to 30 days minimum.
• Flexible working options based around home and office locations, with flexible working patterns.
• Proactive wellbeing support through Unmind, a market-leading digital wellbeing platform, development courses for resilience and other human skills, global Employee Assistance Programme, sick leave, mental health first-aiders and all sorts of self-help toolkits
• A continuous learning culture to support your growth, with opportunities to reskill and upskill and access to physical, virtual and digital learning.
• Being part of an inclusive and values driven organisation, one that embraces and celebrates our unique diversity, across our teams, business functions and geographies - everyone feels respected and can realise their full potential.