Experience Inc. Jobs

Job Information

IBM Oracle DBA in Mumbai, India


At IBM, work is more than a job - it's a calling: To build. To design. To code. To consult. To think along with clients and sell. To make markets. To invent. To collaborate. Not just to do something better, but to attempt things you've never thought possible. Are you ready to lead in this new era of technology and solve some of the world's most challenging problems? If so, lets talk.

Your Role and Responsibilities

Should have experience in Oracle Database various versions i.e 11g, 12c & above. Should be well familiar with RAC & ASM environment.

Your Roles & 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 Expertise

  • Oracle 11g, 12 C. RAC & ASM

  • Oracle certification

  • RAC & ASM

  • Fair knowledge on Oracle security products - ASO, AVDF

  • Performance tuning

About Business UnitThis position currently sits within Global Technology Services (GTS) Infrastructure Services (IS) or a shared services function supporting GTS.

As announced in October 2020, IBM intends that its managed infrastructure services business of the GTS organization will become an independent company named Kyndryl by the end of 2021, creating two distinct and powerful market-leading companies.

Together, we will advance the vital systems that power the digital economy. Serving over 4,600 technology-intensive, highly regulated customers, including over 75% of the Fortune 100, our people will design, run, and manage the most modern and reliable technology infrastructure that the world depends on today.

We will work flexibly and in partnership with our customers to amplify business outcomes while always pushing ourselves to improve and meet all opportunities. Come join our team of diverse, devoted, and empathetic technology experts who are at the center of discovering what's next.

Please note: The final decision if this position will transition from IBM to Kyndryl is yet to be confirmed.

Your Life @ IBMWhat matters to you when you're looking for your next career challenge?

Maybe you want to get involved in work that really changes the world? What about somewhere with incredible and diverse career and development opportunities - where you can truly discover your passion? Are you looking for a culture of openness, collaboration and trust - where everyone has a voice? What about all of these? If so, then IBM could be your next career challenge. Join us, not to do something better, but to attempt things you never thought possible.

Impact. Inclusion. Infinite Experiences. Do your best work ever.

About IBMIBM's greatest invention is the IBMer. We believe that progress is made through progressive thinking, progressive leadership, progressive policy and progressive action. IBMers believe that the application of intelligence, reason and science can improve business, society and the human condition. Restlessly reinventing since 1911, we are the largest technology and consulting employer in the world, with more than 380,000 IBMers serving clients in 170 countries.

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

Being You @ IBMIBM 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. IBM is also committed to compliance with all fair employment practices regarding citizenship and immigration status.