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:
- Designing,Implementing and Managing complex database systems,Ensuring high availability,Performance and security of databases.
- Performing database backups using RMAN and EXPDP utility.
- Monitoring database health and Troubleshooting issues.
- Stay up to date with latest RU patch.
- Configuring and managing the standby database's replication using DATAGUARD BORKER.
- Proficient in Backup & Restore Methodologies.
- Perform bug fixes,root cause analysis,trouble shooting and incident resolution.
- Proficient in tuning Databases,Refreshes etc.
- Monitoring performance of a database, checking for long running queries, identifying blocking sessions and killing them.
Requirements
To be successful in this role, you should meet the following requirements:
Essential Skills
· 5-10 years Experience.
· Experience in Shell scripting for Database Activities.
· Hands-on-Knowledge on Oracle Database Migration/upgradation.
· Gathering statistics information on tables, indexes through OEM.
· Managing users and user security
· Making use of Oracle’s SQL Tuning advisor and fixing performance issues.
· Monitoring Tablespace usage and File system usage of Oracle DBs.
· Checking Backup Reports and scheduling backup jobs (both RMAN and EXPDP)
· OCR and Voting disk backup and recovery.
· Involved in Database Migrations from on-prime (Oracle) to Aurora Postgres (AWS Cloud) with AWS SCT, DMS and HVR.
· Administration of RAC Resources using ‘srvctl’ utility.
· Database and schema Refreshes using Datapump(EXPDP) utilities.
· Creation of oracle RAC Databases.
· Migrating NON-PLuggable database to Pluggable Database.
· Monitoring the performance of the databases on daily basis by resolving the issues related to SGA components, Filesystems usage, releasing blocking sessions, lock waits undo, temp space issues etc.
· Configuring the RAC for 3 Node RAC.
· Troubleshooting performance Issues using OEM.
Good to have
· Experience in Installation, configuration of Postgres 9,10 to 13.4 databases.
· Involved in PG Logical Creation in Postgres.
· Experience in upgrade of Postgres databases 12 to 13.4,13.6
· Experience in Taking Physical and Logical database backups.
· Experience in Configuring the Replication between the Database's.
· Experience in Creating Database,Objects etc.
· Implement and maintain high availability and disaster recovery solutions.
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 – HSDI