Sr. Assoc, Prod Specialist - Switching & Cards, WRB Tech
Standard Chartered India
Stand out for this role — generate a tailored resume and cover letter in about a minute.
Benefits offered by this job
Job summary
Standard Chartered India is seeking a senior PL/SQL Developer with 10+ years of Postgres/Oracle database development experience, preferably in banking or financial services. The role demands expert PL/SQL programming, SQL performance tuning, data processing, and support for enterprise-grade transactional systems.
You will work on complex banking applications, ensuring data flows, accuracy, security, and compliance while delivering high-performance database solutions and collaborating with
Qualifications
- 10+ years of hands-on SQL/PL/SQL development in banking or financial services.
- Strong Oracle tuning, indexing, and execution plan expertise.
- Experience with large-volume transactional systems and production incidents.
- Able to mentor junior developers and drive best practices.
Responsibilities
- Design, develop, enhance, and maintain complex PL/SQL objects (packages, procedures, functions, triggers, views, cursors).
- Analyze requirements and translate them into efficient database solutions for core banking systems.
- Optimize SQL queries and PL/SQL code for high-volume transactions and performance.
- Support batch processing, end-of-day processing, reconciliations, and reporting workflows.
- Lead code reviews, design reviews, and release planning; mentor team on coding standards.
- Prepare technical documentation, impact assessments, and deployment documents.
- Collaborate with analysts, developers, QA, and production support for incident resolution.
Skills
Education
Tools
Job description
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.
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.
- 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.
- 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.
Candidate should have experience in one or more of the following areas:
- Core banking
- Payments and settlements
- Cards and transaction processing
- Reconciliation systems
- 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.
- 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.
Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.
- DB certification
- Exposure to banking product implementation or modernization programs
- 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
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.
- 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
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.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
