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

In this role, you will:

  • Oracle /PostgreSQL DBA for a DevOps infrastructure delivery role; configuring, delivering, and supporting Oracle/PostgreSQL server environments and services.
  • Linux Administration and troubleshooting
  • Deliver and provide technical support for CTO technologies while conforming to high quality standards and best practices, maintaining and improving SLA’s, and ensuring compliance to HSBC policies at all times.
  • Provide troubleshooting support in incident and perform root cause analysis to prevent problems happening. Appropriate measures are taken to improve and sustain high quality and prevent recurrence.
  • Actively participate to achieve organisation objectives for efficiency.
  • Advise on Oracle /PostgreSQL design, development, and best practice for Distributed Compute, throughout project lifecycles from build through to ITSA and implementation processes.
  • Write Linux /Python scripts to automate and streamline BAU tasks. Building automation capabilities to support the execution of operational activities. Perform pro-active analysis on day-to-day work to obtain automation on deliveries thereby reducing repetitive and standardised tasks/processes.
  • Pro-actively review information in conjunction with service level agreements to identify any capacity issues and specify any required changes. Work with application teams to agree and implement short- and medium-term modifications to demand.
  • Provide consultancy, guidance and collaborate with other infrastructure, application, support and engineering teams.
Requisitos

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

  • Oracle, PostgreSQL and OracleDB knowledge and experience between 6{+ years
  • Hands on experience on Oracle database builds (12c and above), PostgreSQL v13 +, configuration, upgrade, Migration, patching and troubleshooting all issues, strong knowledge of RDBMS and clustering concepts.
  • Administrative Knowledge with practical hands-on Linux platform with VCS clustering, patching, performance troubleshooting, access control and scripting knowledge
  • Level 3/excellent troubleshooting skills on Linux platform.
  • Performance tuning, Analysis of AWR, ADDM, ASH reports, RAC, ASM, Data-guard
  • Dev-ops tooling knowledge like Jenkins, Ansible, GitHub and at least one scripting language like Python/Shell
  • Good working knowledge of Unix platforms. Strong knowledge on Backup/Recovery RMAN & OEM and Strong shell scripting skills.
  • Good understanding of PL/SQL, Awareness of monitoring and scheduling tools.
  • Candidate should have sense of ownership and urgency, attention to detail, flexibility, process orientation, strong analytical skills, sense of vigilance and adherence to all compliance procedures and policies.
  • Excellent Leadership and communication skills, with ability to describe complex technical scenarios in a concise manner, both verbally and written, and articulating the content depending on the audience
  • Handson experience on PostgreSQL / Oracle to PG migration tools
  • Handson experience on python/Shell scripting

     

     

    You’ll achieve more when you join HSBC.

     

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

    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