Oracle Database Administrator

**Why Kyndryl**

Kyndryl

**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.

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.

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**
- Experience in Experience in Oracle 11G, 12C & above.
- Must have done Oracle Certification
- Must have RAC & ASM environment experience.
- Performance tuning.

**Required Education**

Bachelor's Degree

**Preferred Education**

Master's Degree

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**

**Primary Job Category**

Technical Specialist

**Role (Job Role)**

Systems Management Specialist

**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