Description

 

We are seeking a hands-on database administrator with a minimum of 4+ years on Oracle DBA. You will be responsible for installation, Configuration & managing database servers, and applying security patches & other Patches for upgrading versions of the Oracle database on different platforms. In addition, you shall also do High-Availability (clustering), and BCP/Disaster Recovery database solutions and will be providing operations support for mission-critical, high-availability systems.

 

No Of Positions 1

 

Skills Required

  • Oracle DBA with 11g, 12c &19c experience on UNIX (Solaris/Aix /RHEL/Linux) and Windows Operating system. Working experience on Oracle/AWS Cloud is desirable
  • Experience in core DBA & RAC, Data Guard implementation, monitoring activities & troubleshooting (RAC,ASM & DG), Strong experience in monitoring and managing large database setups
  • Experience in core DBA & RAC, Data Guard implementation, monitoring activities & troubleshooting (RAC & DG), Strong experience in monitoring and managing large database setups
  • Good in Oracle RDBMS 11g/12c/19c architecture concepts
  • Usage of data dictionary views
  • Space management, Undo Management, User management
  • Partitioning of tables
  • Experience in database patching.
  • Experience in migrating & upgrading databases
  • Managing Redo log and Archive log files
  • Backup and recovery methods
  • Logical backup and recovery using data pump, export/import
  • Working experience in RMAN, SQL loader & Data Pump
  • Oracle network configuration (listener and tnsnames)
  • Trouble shooting database issues
  • Strong experience SQL and PL/SQL knowledge
  • Shell scripting shell, Born & c shell.
  • Should be good in Performance tuning using AWR, Explain Plan and TKprof.
  • Should have experience in RAC configuration & administration
  • Data Guard (physical standby) administration & implementation

Roles & Responsibilities 

  • Installation and maintenance of database server
  • Work closely with different development teams to understand database requirements and provide support
  • Responsible for ensuring availability and performance of the databases that support the system
  • Monitoring & responding the database systems incidents to ensure secure production services to business
  • Responsible for improvement and maintenance of the databases to include rollout and upgrades
  • Responsible for implementation and release of database changes, as submitted by the development team
  • Support for Development environments Refresh of UAT/Staging/pre-prod environments
  • Database troubleshooting and problem root cause analysis
  • Experience in performance monitoring, reporting and tuning of Oracle databases
  • Work with infrastructure team (co-ordinate with application support team) to ensure that the associated hardware resources are allocated to the database to ensure high availability and optimum performance
  • Proactive Maintenance of the database servers
  • Monitoring of the database servers
  • Trouble shooting activities
  • Implementing Backup policy as per MVML project requirement
  • Database recovery services
  • Database Performance tuning activity
  • Database Patch Application
  • Database upgrade
  • Database Capacity Planning
  • Database Indexing activity
  • Database performance monitoring
  • Managing Cluster databases.
  • Data Upload / Download activities.
  • Trouble shooting connectivity issues.
  • Providing Inputs for Table designing.

Experience 

3 - 5Yrs

Education 

B.E/B.Tech/MCA