Kyndryl, Inc. Hiring for Oracle Database Administrator at MUMBAI, India Full Time

Your Role and Responsibilities

Database administration involves checking health of database, monitoring the data base; perform database backup and day-to-day database management activities.

Database binary Installation, Configuration, User Management, Data file, Re-do logs, Table space management, Query tuning etc on all CBS databases.

Database Backup and restoration as per Bank requirement & maintaining the backup tape inventory.

Replication of Database to NDR & DR sites & keeping the same in sync.

Import and Export of data as per bank requirement.

Time to time application of patches released by Oracle.

Attending and Closing IS Audit/ VAPT observations

Conducting DR Drills on periodical basis(Quarterly).

Performance tuning of production databases on regular basis.

Co-ordinate with Bank’s security team for Implementation of Oracle Security products like Advance Security Option (ASO), Oracle Audit Vault & Data base Firewall (AVDF), Data base Vault (DV), Data Masking etc. Follow Std operating procedures as applicable for the managed databases. It is assumed that the security products are implemented, and the features are enabled. Scope of bidder will be to maintain as per SOP provided by IT Security team.

Database patch update / version upgrade from time to time.

Addition of Real Application Cluster (RAC) nodes in production CBS Data bases as per requirement.

Performance tuning & query tuning of Core Banking Database.

Database administrator should have expertise in Database tuning, Performance Tuning / Query optimization in Core Banking Solution (CBS) environment.

Tune the Database to optimize and harmonize the performance of CBS database (Oracle – RAC environment) on regular basis.

Performance Tuning / Query optimization to reduce system resource requirement of CBS database in tune with Finacle – Core Banking Application in co-ordination with application team.

Find queries, which are creating latches / locks or consuming higher system resource in CBS database and tune the same in co-ordination with in-house scripting team / CBS vendor to improve the transaction response time and avoid any latches / locks.

Study the logic in the custom queries, verify the change to be implemented in CBS and ensure that queries are optimized before deploying in productions environment. Any downtime or Channel transaction decline due to improper tuning of custom query logic will be attributable to the bidder.

Study the invalid objects in CBS Production database and validate the same on regular basis

Indexing / Re-indexing of tables/objects to be carried out on regular basis.

Bidder need to submit a report on the queries tuned to optimize the performance to Bank on monthly basis and its impact analysis.

Required Technical and Professional Expertise

Experience in Experience in Oracle 11G, 12C & above.

Must have done Oracle Certification

Must have RAC & ASM environment experience.

Performance tuning.

Preferred Technical and Professional Experience

Oracle 11g, 12 C. RAC & ASM

Oracle certification

RAC & ASM

Fair knowledge on Oracle security products – ASO, AVDF

Performance tuning

Required Education Bachelor’s Degree

Preferred Education Master’s Degree

Country/Region India

State / Province MULTIPLE

City / Township / Village MULTIPLE CITIES

Being You @ Kyndryl

Kyndryl is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, pregnancy, disability, age, veteran status, or other characteristics. Kyndryl is also committed to compliance with all fair employment practices regarding citizenship and immigration status.

Other things to know

When applying to jobs of your interest, we recommend that you do so for those that match your experience and expertise. Our recruiters advise that you apply to not more than 3 roles in a year for the best candidate experience.

For additional information about location requirements, please discuss with the recruiter following submission of your application.

Primary job category Technical Specialist

Role ( Job Role ) Customer Service Representative

Employment Type Full-Time

Contract type Regular

Position Type Early Professional

Travel Required No Travel

Company (Y030) Kyndryl Solutions Private Limited

Is this role a commissionable/sales incentive based position? No