Job Description

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 Senior Consultant Specialist   In this role, you will: - Responsible for the design build and day to day support of the DSL Oracle databases. These databases are each 70TB 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 ensure compliance to HSBC policies at all times. 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. To be successful in this role, you should meet the following requirements: - Must have strong experience of Oracle (v19c) RDBMS, RAC and Dataguard on a LINUX platform including: 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 - Creating / altering / dropping tablespaces - Clone one environment from another - Database backup / restore - Data Archival activities - Assist the development community with the resolution of miscellaneous queries and problems - Database space management - Implementing releases / service requests - Server monitoring including health checks at server level and database level - Keeping the systems up and running cleanly - Timely escalation of issues to Team Lead - Performance and Tuning of database - Scripting Skills with Ansible Tower - Ansible playbook knowledge, Ansible Tower Administration - Should have OEM knowledge, adding targets, setup incident rules, OEM patching, Upgrade etc. - Customer Service and Problem Resolution - Actively participate in crisis calls taking the lead from an Oracle DB perspective - Participate in identifying problem situations and resolve to give maximum customer satisfaction  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