Role:- Oracle Database Administrator
Experience : 5+
Location –Jaipur
Skill Required :
- Ability to Work in a 24x7 production environment and provided day-to-day support on-call basis and as per raised ticket and mails.
- Proficient in Oracle single instance/ Real Application Cluster (RAC) Database administration involving capacity planning, Implementation of medium and very large sized mission critical production databases Designing & creating physical database.
- Providing solutions to the Clients in term of quick response time, throughput/load and database availability and technical support to application development teams.
- Experience with Oracle 11g/12c Real Application Clusters(RAC) Installation, Database creations, Administration, Monitoring, Database Backup and Recovery.
- Good exposure to database Cloning (i.e. Cold/Hot Backup and RMAN)
- Strong experience in logical backup using Data pump and Traditional Exp/Imp.
- Good understanding of Real Application Cluster (RAC) Databases, OCR, Voting Disk and good exposure in CRSCTL & SRVCTL commands.
- Experience in User Management, Space Management, tnsnames & Listener Configuration.
- Creating and Managing Tablespace, datafiles, schema objects and users.
- Good exposure to RMAN Backup , RMAN restoration and Recovery techniques on single instance as well as RAC environment.
- Experience in oracle database Upgradation with 10g/11g/12c/19c.
- Experience of Implementation and Administration of Oracle Data guard and Data guard broker
- Experience of Switchover and Switchback of production Database.
- Oracle 12c, 19c Database administration
- Oracle RAC installation
- Database Creation, Upgrade and Patching
- Database Patching and Upgradation
- Oracle Database Performance Tuning
- Oracle Database access management
- Oracle RMAN backup and recovery
- Oracle Data pump export and import
- Data Guard configuration, implementing and maintaining standby databases
Disaster Recovery Implementation and Drill Activity
- Having DR implementation experience
- DR Drill automation performed by using third party tool
- Implementation experience on Oracle Active Data Guard
- Performed the DR Drill Activities
Database and System hardening and auditing
- Experienced with Database Security Administration, system monitoring including adding and removing users, configuring quotas, auditing, and analyzing security problems.
Experienced with Database hardening for Banking Domain