Lead Oracle Database Administrator

Jd

Lead Oracle Database Administrator [JD as below]

Experience : 7+

Role Lead Oracle Database Administrator

Designation Senior Manager up to 15-17LPa / Immediate joiner / Jaipur location.

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