Job description

The health and safety of our employees and candidates is very important to us. Due to the current situation related to the Novel Coronavirus (2019-nCoV), we’re leveraging our digital capabilities to ensure we can continue to recruit top talent at the HSBC Group.  As your application progresses, you may be asked to use one of our digital tools to help you through your recruitment journey.  If so, one of our Resourcing colleagues will explain how our video-interviewing technology will be used throughout the recruitment process and will be on hand to answer any questions you might have.

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  Consultant Specialist

Principal responsibilities

  • Experience in

    • Oracle Real Application Clusters ,

    • Oracle Recovery Manager ,

    • Oracle DataGuard ,

    • Oracle Enterprise Manager (OEM) 12c

  • Experience in configuring GoldenGate to support ongoing replication of large Oracle databases (thousands of tables each) within a complex architecture

  • Experience in performing GoldenGate upgrades, replication, error resolution, and restarts without data loss

  • Strong Unix Administration (Linux)

  • Exposure to Mongo/PostgreSQL DB

  • Hands-on in-depth experience of Veritas Cluster Server and SRDF.

  • Strong experience of planning and implementing production service architectures in a multi-domain, multi-platform and multi-site environment

  • Strong scripting skills – Perl/Python to perform automation, maintenance tasks and review code

  • Implementing Patching and Upgrade cycles

  • Hands on in-depth experience with hardware clustering and disk technologies

  • Good working knowledge of job scheduling & monitoring tools - preferably BMC Control-M scheduling, and BMC Patrol monitoring

  • Exposure to DevOps Tools

  • Good to have experience on Cloud (AWS / GCP)

Requirements

Requirements:

  • Overall 8+ years of experience in Oracle database administration
  • In-depth knowledge of Oracle 19c and 12c with good support experience in a multi-project environment
  • 5+ years hands-on experience using and supporting GoldenGate 12c and higher version
  • Experience in Oracle Performance and Tuning skills including SQL, PL/SQL and database/instance tuning, Server configuration and tracing facilities, interpretation of tkprof files and event traces.