HSBC Group

Some careers shine brighter than others.

If you’re looking for a career that will help you stand out, join HSBC and fulfil your potential. Whether you want a career that could take you to the top, or simply take you in an exciting new direction, HSBC offers opportunities, support and rewards that will take you further.
HSBC is one of the largest banking and financial services organisations in the world, with operations in 64 countries and territories. We aim to be where the growth is, enabling businesses to thrive and economies to prosper, and, ultimately, helping people to fulfil their hopes and realise their ambitions.

We are currently seeking an experienced professional to join our team in the role of Associate Director, Tech SME

Department: - Fin Data Reg Reporting Tech, Markets & Sec Services Tech

Infrastructure and Service Delivery IT aka ISDI (under FDR) department serves multiple sub asset classes in FDR. It has a significant presence in all major sites. ISDI department operates with multiple functional lines including Unix, Windows, Oracle, PostgreSQL,SQL WAS.
Infrastructure and Service Delivery IT
We manage the completed infrastructure under FDR and provide our expertise to all sub asset classes. We are a niche team with subject matter experts in various areas

Responsible for the design build and day to day support of the Oracle databases. These databases sizes are 1TB to 100TB in size(and growing) , hold over 13 Billion rows of data each and together process circa 1 billion SQL statements per day. As part of a DevOps team you will work closely with the application and infrastructure POD SME’s to ensure these critical services function to the required standards. Maintain and improve SLA’s and always ensure compliance to HSBC policies. Actively participate to achieve organization objectives for efficiencies, innovations, and quality delivery.
Perform pro-active analysis on day-to-day work, identify areas for automation, report and follow up on process or technical gaps, reduce repeat or false incidents, and standardise tasks/processes.
Support is required 24 hrs x 7 days in week x 365 days from office or on-call depending on business needs (usually 1 week in 4 on-call) . Required to work on weekends (usually 1 in 4) often at short notice. Resource will get compensatory time- off for as per HR guidelines

In this role, you will:

All aspects of the Oracle Databases performance tuning, Oracle Instance Tunning, Host Tunning, SQL Tunning, Query rewriting with PL SQL blocks. Including db / apps project design, build, ongoing enhancements (e.g. automation) and 24* 7 support

• Strong knowledge on solution architect level.
• Must have strong experience of Oracle Performance tuning, SQL tunning
• Must be aware about SQLT, RAT , SPA testing. Application load testing.
• Performance stability in oracle migrations & upgradations.
• RAC node tunning, RAC performance matrixes knowledge,
• Good knowledge on the profiling, sql plan reading, SQL baselines
• Must have solutions-oriented knowledge on performance improvement or fixing any performance incident or problem.
• Perform Database software installation, upgrades and apply relevant patches
• Perform Database migrations – intra platform or inter platforms
• Build and Deploy/Implement Solutions. Perform Capacity Planning and DR Planning.
• Troubleshooting and fixing incidents
• Database backup / restore
• Assist the development community with the resolution of miscellaneous queries and problems
• Implementing releases / service requests
• Server monitoring including health checks at server level and database level
• Timely escalation of issues to Team Lead
• Scripting Skills
• Customer Service and Problem Resolution

To be successful in this role, you should meet the following requirements:

• Good analytical and problem-solving skills..
• Strong teamworking skills including working with remote teams
• Must be flexible in a dynamic and demanding business environment (high rate of change in business).
• Demonstrate role model behaviours of “can do” attitude, positive motivation.
• Ability to work with development teams, both on a horizontal basis (front office to front office) as well as on a vertical basis (front to back office).
• Ability to manage relationships with various stakeholders.
• Ability to work on complex parallel projects.
• Demonstrate role model behaviours of “can do” attitude, positive motivation.
• Excellent communication skills – both oral and written.
• Efficient time management
• Be the go-to expert for Oracle and PL/SQL
• Participate in coding and enhancements
• Tune, script, and extract, transform, and load
• Experience using Oracle Packages.
• SQL development, SQL analytics and tuning skills;

Ideal Skills / Compentencies:

• Experience of contributing to the continuous improvement of the end to end design/build/support process
• Experience of working closely with other teams and liaising with developers to provide input to the IT requirements
• Understand those business parameters which could influence performance, e.g. data sizes, network bandwidth, scalability, etc

Candidate User Guide: India HTC - IND HSDI : IJP candidate user guide (service-now.com)

You’ll achieve more when you join HSBC.
www.hsbc.com/careers 

HSBC is committed to building a culture where all employees are valued, respected and opinions count. We take pride in providing a workplace that fosters continuous professional development, flexible working and opportunities to grow within an inclusive and diverse environment. Personal data held by the Bank relating to employment applications will be used in accordance with our Privacy Statement, which is available on our website.

Issued by – HSBC Software Development India