PLSQL Oracle Data SME / Sr. Associate Director, Software Engineering

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 PLSQL Oracle Data SME In this role, you will: Design, implement and maintain database system to meet business requirements. Convert the Business need into technical complex queries/procedures. Own, manage and support data designs and solutions for Data platform project. Own, manage and support Oracle databases. Own, manage and support data change release automations (CICD). Write complex sql queries/PLSQL Code for reporting and other business purpose. Monitor Database performance and troubleshoot issues Support all day to day activities related to database like data consolidation, data migration scripting, performance tuning. Responsible for performance tuning activities in the project. Providing technical expertise in finding root cause of major system problems, automation and data issues. Fix problems of Data quality. Continuously improve data quality. Reviewing, designing and re-engineering processes with new technologies to improve performance. Responsible for adapting and implementing data governance guidelines of the organization. Requirements To be successful in this role, you should meet the following requirements: 15+ years of strong expertise in PL/SQL programming, DB Design/Architecture & Normalization. Strong experience of creating PL/SQL Packages, Procedures, Functions, Triggers, Views, Materialized views and Exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle. Strong experience with Oracle 12c/19c and knowledge of Oracle database features Experience in data migration/conversion. Experience in Data migration using import and export. Expertise in creating the indexes on tables and partitioning the table for SQL tuning purpose. Proficient in DB performance tuning & optimization Techniques Experience with Datawarehouse & ETL process is preferred Expertise in Data Modelling Expertise in Unix Shell Scripting Secondary skills: Data ETL with IBM Datastage Added advantage: Knowledge in DevOps, CICD automation 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.