Assistant Vice President - Oracle DBA

Role Oracle Database Administrator- JD Below

Experience : 10+

Location –Jaipur (No WFH)

 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.

• Experience in handling critical situations and can manage pressure situations.
• 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 19c 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.
• Planning and execution of Purging and partitioning of large tables
• 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 12c/19c.
• Experience of Implementation and Administration of Oracle Data guard and Data guard broker .
• Experience of Switchover and Switchback of production Database.
• Oracle19c Database administration
• Oracle RAC installation and upgradation
• Implementation of Oracle Enterprise Manager 13c
• 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
• ExaData/ExaCC Administration will be an added advantage
• Handling database security

 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
• Experienced with VAPT closure
• Able to implement Secured Configurations across all Oracle databases.

Database Security

·       Should have in depth knowledge on database security and have exposure in handling Database security tools. DAM tool like Imperva will be an added advantage.