AmbitionBox
Search
Jobs
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Employer? Claim Account for FREE
HSBC Group
Compare
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
All Filters
226 HSBC Group Jobs
Lead Consultant Specialist
10-12 years
Hyderabad / Secunderabad
1 vacancy
Lead Consultant Specialist
HSBC Group
posted 1hr ago
Job Role Insights
Flexible timing
Key skills for the job
Job Description
- Installation of Oracle on Linux /IBM-AIX / Sun Solaris / Windows HP-UX.
- 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.
- 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.
- Hand on experience of PL/SQL coding.
- Should have knowledge of Linux / Unix shell scripting, python etc.
- Should have experience in developing automation and using Jenkins, puppet , ansible , git and other automation frameworks .
- 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 analyse 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)
Requirements
To be successful in this role, you should meet the following requirements:
- A minimum of 10+ years experience as DBA with experience in automation and scripting.
- Open-minded, reliable, independent, enthusiastic and self-motivated with excellent time management skills and strong initiative
- Able to work independently and effectively under pressure.
- Ability to work in Devops/SRE framework and contribute towards it .
- Should have experience of working on production issues related to Oracle Database including tuning of complex SQL queries.
Employment Type: Full Time, Permanent
Read full job descriptionHSBC Group Interview Questions & Tips
Prepare for HSBC Group Lead Consultant Specialist roles with real interview advice
What people at HSBC Group are saying
Rating based on 5 Lead Consultant Specialist
reviews
Anonymous · Engineering - Software & QA
in Pune
Likes
Company culture, Learning Opportunities, Fast Growth
- Salary - Good
+4 more
Dislikes
Too much emphasis on processes
Lead Consultant Specialist salary at HSBC Group
reported by
83
employees
with 13-18
years exp.
₹28
L/yr - ₹56
L/yr
10%
more
than the average Lead Consultant Specialist Salary in India
View more details
What HSBC Group employees are saying about work life
based on 4.7k employees
Flexible timing
Monday to Friday
No travel
Day Shift
HSBC Group Benefits
Submitted by Company
Pay and benefits Flexible working Career development
Submitted by Employees
View more benefits 
Compare HSBC Group with
Standard Chartered
Compare
ICICI Bank
Compare
Axis Bank
Compare
HDFC Bank
Compare
State Bank of India
Compare
Kotak Mahindra Bank
Compare
IndusInd Bank
Compare
Yes Bank
Compare
RBL Bank
Compare
Wells Fargo
Compare
JPMorgan Chase & Co.
Compare
Cholamandalam Investment & Finance
Compare
Citicorp
Compare
BNY
Compare
American Express
Compare
UBS
Compare
State Street Corporation
Compare
IDFC FIRST Bharat
Compare
HDFC Sales
Compare
Aditya Birla Capital
Compare
Similar Jobs for you
HSBC Group Hyderabad / Secunderabad Office Location
Hyderabad Office
The Hongkong and Shanghai Banking Corporation Limited,
Private Banking Department, 1st Floor 6-3-1107 & 1108, Rajbhavan Road, Somajiguda, Hyderabad
Hyderabad
500 082
500 082
Assistant Vice President-Regulation Management
6-10 Yrs
Bangalore / Bengaluru
Share an Interview