About Standard Chartered We are a leading international bank focused on helping people and companies prosper across Asia, Africa and the Middle East.
To us, good performance is about much more than turning a profit. It's about showing how you embody our valued behaviours - do the right thing, better together and never settle - as well as our brand promise, Here for good.
We're committed to promoting equality in the workplace and creating an inclusive and flexible culture - one where everyone can realise their full potential and make a positive contribution to our organisation.
This in turn helps us to provide better support to our broad client base. The Role Responsibilities Demonstrate good attitude, ownership and responsibility Should have innovative mindset Excellent attention to details and passionate about problem solving Should have excellent motivation, communication (oral & written), facilitating and inter-personal skills Minimum 8 years of hands-on experience with Java / J2EE Must have strong hands-on experience with SQL and PL / SQL Experience with database development & design including experience with Oracle 11g Key Responsibilities - Ability to design and develop applications with strong focus on performance and security for the application Adhere to group standards, risk management and security policies Translate functional specifications into technical specifications Perform application development build tasks and perform application coding using Oracle RDBMS technologies Responsibility conduct performance tests and fix application performance related issues Understand how products & key technologies interface with each other and fit with strategy and business needs Responsible for Schema Design, indexing strategy for performance and scalability Mentor / Guide junior developers and ensure team is able to consistently deliver outcomes Develop high complex code / frameworks as per quality bench marks Constantly endeavour to improve the code quality and the process within teams Work with technical / solution / enterprise architects in defining product roadmaps Provide L3 support for applications once delivered to production Communicate timely build status on development items delivery managers, as well as raise / work to resolve issues impacting development Our Ideal Candidate Key Skills 8 years of strong programming skill in Java,J2EE, Spring, SpringBoot ,Oracle PL / SQL Procedures, Functions, Cursors.
Strong knowledge of writing complex SQL Queries. Experience in bulk collect, bulk bind operators and collections, Exception Handling.
Good knowledge on Explain plan Strong Experience in SQL Queries performance tuning using Explain plan Experience in using Materialized Views Good Exposure in XML Handling using Oracle PL / SQL Experience in SQL Loader, External Table and UTL FILE package.
Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shells scripting, SQL, PL / SQL and SQL Loader.
Good knowledge in understanding AWR Report and provide optimal solution to resolve performance issues