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