HSBC Group
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
168 HSBC Group Jobs
4-8 years
Pune
1 vacancy
SQL Database Administrator DevOps/Senior Consultant Specialist
HSBC Group
posted 54min ago
Flexible timing
Key skills for the job
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:
SQL Database Administrator for a DevOps infrastructure delivery role; configuring, delivering, and supporting SQL server environments and services.
Work across one or more application development DevOps pods to consume and deploy centrally provided services from Distributed Compute.
Responsible for implementation of new technologies and the on-going support of hardware and software solutions across both live and non-live environments.
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.
Actively participate to achieve organisation objectives for efficiency. Perform pro-active analysis on day-to-day work to obtain automation on deliveries thereby reducing repetitive and standardised tasks/processes.
Advise on SQL Database design, development and best practice for Distributed Compute, throughout project lifecycles from build through to ITSA and implementation processes.
Write Windows / PLSQL scripts to automate and streamline BAU tasks. Building automation capabilities to support the execution of operational activities.
Draft and maintain standards and procedures for service component capacity management. Ensures the correct implementation of standards and procedures.
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.
Asses, analyse, develop, document, and implement changes based on requests for change. Understanding of functional requirements and translation of business requirements into technical specifications
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.
Provide consultancy, guidance and collaborate with other infrastructure, application, support and engineering teams.
To be successful in this role, you should meet the following requirements:
Managing SQL Server databases.
Extensive experience of 7+ years with MY SQL Server Administration, Configuring and maintaining database servers and processes, Performance Tuning/Optimization, Backups, restores and recovery procedures, High Availability (HA) and Disaster Recovery (DR) options for SQL Server, Windows server administration and Active Directory knowledge.
Monitoring system's health.
Ensuring high levels of performance, availability, sustainability, and security.
Analysing solving and correcting issues in real-time.
Providing suggestions for solutions.
Refining and automating regular processes, tracking issues, and documenting changes.
Assisting developers with query tuning and schema refinement.
Performing scheduled maintenance and supporting release deployment activities after hours
Experience with Dev-ops automation tools like Jenkins/Ansible /GITHUB etc.
Ability to cross skill across platforms /database technologies.
Experience of writing complex SQL queries with knowledge do SQL tuning.
Excellent 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
A track record of gaining an understanding of customers' needs and delivering excellent customer service.
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.
A track record of constantly looking for ways to do things better and an excellent understanding of the mechanism necessary to successfully implement change.
Excellent written and spoken communication skills; an ability to communicate with impact, ensuring complex information is articulated in a meaningful way to wide and varied audiences.
Contributed productively to team objectives, sometimes supporting and sometimes leading activities to achieve shared goals.
Experience of making prompt and practical business decision, even in times of ambiguity, considering various perspectives and taking responsibility for outcomes.
You ll achieve more when you join HSBC.
.
Employment Type: Full Time, Permanent
Read full job descriptionPrepare for Senior Consultant Specialist roles with real interview advice
Nothing
Horrible culture and horrible people
Read 55 reviews7-12 Yrs
Hyderabad / Secunderabad