Bayt.com
https://bayt.page.link/DaubRLN9vmt1DYoe7
Back to the job results
Other Business Support Services
Create a job alert for similar positions

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 organizations 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 realize 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:


  • Database Management & Optimization, Administer and maintain PostgreSQL, Oracle, and other relational databases, ensuring optimal performance, high availability, and data integrity. Knowledge about non-relational databases.
  • SME level knowledge in optimising query and performance latency as developer to review and apply for various applicatiom services.Strong knowledge of infrastructure in general including Operating System, Clustering, Storage, network etc
  • Provide Architecture design and support for development projects from a database perspective. Experience in handling multiple databases medium to large databases (multi terabyte).
  • Plans and implements backup and recovery of the Oracle database. Excellent knowledge of Oracle backup and recovery scenarios.
  • Solid understanding of database security best practices, including encryption, access control, and auditing. Strong hold on role, user group based IAM segregration.
  • Repair corrupts databases (logical exports and imports, restore from backups). Upgradations, applying new patches. Developed backup & restore strategies for Hot & offline backups. Disaster Recovery planning & Implementation Oracle Dataguard.
  • Strong knowledge of Oracle RAC Database , Datagaurd, Exadata , Partitioning Compression, RMAN, ASMM and AMM.
  • Should have excellent knowledge of tools like AWR, ADDM, OEM, SQL Plan baselining, Trace files , tkprof and autotrace. SQLT ASH , expdp / Impdp  SQL loader SQL Plus.
  • Knowledge and experience in Oracle Golden gate and basic understanding of VCS is desirable. Hands on experience of PL/SQL coding.
  • Should have experience in developing in DevOPS automation tools like Jenkins, Ansible Unix shell, GITHUB, API development using Mule/Kong framework, Go-LANG, Python and PowerShell with working knowledge of AI/ML technology and tools. Working knowledge of SRE framework
  • Experience in working on other databases, like Postgres , MongoDB, SQL Server, Public cloud AWS , GCP etc. Coordinate the implementation of process controls in the team.
  • Basic understanding of Change management process and raise the change orders on need basis. Provide L3 production support – analyze cases reported by L1, possible solutions and fixes.
  • Creates and maintains all databases required for development, testing and production usage. Administers all database objects, including tables, indexes, views, sequences, packages and procedures.
  • Participate in Production Release and Changes during Weekends. (on a need basis). Knowledge in data analytics, data lake, predictive forecasting tools adaptation over data lake,
Apply on company site Email to Friend Complete Questionnaire
You have reached your limit of 15 Job Alerts. To create a new Job Alert, delete one of your existing Job Alerts first.
MANAGE
Similar jobs alert created successfully. You can manage alerts in settings.
MANAGE
Similar jobs alert disabled successfully. You can manage alerts in settings.
MANAGE