Oracle DBA

December 2, 2021
Urgent
Application deadline closed.

Job Description

Job Description

Location: Kanjurmarg, Mumbai.

Experience required: 4+ Yrs

Qualification: Graduate

Salary:  6- 8LPA

Job Function:

Detailed Job description:


Oracle Database (commonly referred to as Oracle DBMS or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP & DW) database workloads. Oracle Database is available by several service providers on-prem, on-cloud, or as hybrid cloud installation.

Skills and Requirement: Oracle DBA
 

Responsibilities


Incident and service request monitoring
• Application Patch Deployment (DDL, DML queries deployment based on scripts provided).
• Tablespace resize.
• Database housekeeping activity (purging, index rebuilding, reorganization, gathering statistics).
• DR sync issue check and 1st level of action (transferring of missing archive files).
• Deadlock issue check and escalate to application/development team.
• Handle L1 tickets like tablespace, disk space, and lock issues.
• Performance issue L1 check.
• User, profile creation and management.
• Monitor DB services via an alert.
• Provide timely escalation of complex problems to a technical support resource and/or to the appropriate level of senior staff.
• Monitor failed database jobs and take appropriate action and escalate to the next level.
• DB – Filesystem Space monitoring.
• ASM filesystem space monitoring.
• Database startup and shutdown.
• Initiating backups at disk level on a scheduled or Adhoc basis.
• Performance – ORA errors handle as per knowledge base availability.
• Starting and stopping database
• Incident and Request Fulfillment Management
• Vendor coordination
• Incident monitoring.
• DR sync issue 2nd level resolution.
• Backup and restoration in supported assets- scheduled or Adhoc.
• Performing export and import activities – scheduled or Adhoc.
• Handling issues related to performance.
• Database security patch application, hardening and Auditing
• Log calls with the vendor for product bugs.
• Provide timely escalation of complex problems to a technical support resource and/or to the appropriate level of senior staff
• Perform DR, backup restoration drill.
• Cloning database for supported assets.
• Database job creation and configuration.
• DB – Instance Hung/Terminated unexpectedly
• DB – Crash
• DR reconfiguration for existing setup.
• DB – Flashback configuration and restoration
• Performance – ORA errors – resolve or escalate to SME or vendor appropriately.
• ASM monitoring and space addition.
• Starting and stopping database, ASM, RAC services.
• Necessary support for restoration or drill

Benefits and About NetConnect Global: 

Why NCG?

WHO WE ARE DRIVES WHAT WE DO!

We Don’t build the organization; we create an everlasting family. Our people express a sense of winning together when times are good—and sticking together when times are tough.

Are you a Doer or Achiever?

Well, at NCG, our doors are Open for Doers and Achievers alike. We are a Cult where we create, innovate, learn and Contribute in a comfortable, transparent, and fair environment.

Joining NCG means contributing to a shared ambition for reliable work culture, tackling extraordinary technological challenges in multicultural teams, preserving your work/life balance, and more!