Core Oracle DBA [Cor-Inf-Gan-2019-11-11-58]

Number of Vacancy : 2

Applicant must have: 8 – 12 Years Experience

Mandatory Technical Skill:

• Oracle Database 19c/12c/11g/10g Administration.
• Oracle Database Architecture including of all components.
• Backup, Restore and Recovery Scenarios.
• Expert in Performance Tuning ( SQL, PL/SQL and Instance Tuning).
• Well experience High Availability Solutions like RAC, Active Dataguard, FSFO and ASM.
• Experience with enterprise monitoring tool and backup solution is must.
• Troubleshooting and issue resolving skill with documentation is must.
• Additional Experience in PostgreSQL, MySQL and Oracle GoldenGate is an added advantage.
• Exposure to managing multi-terabyte databases and large environment is must.

Preferred Skills:

• Oracle Database 19c/18c/12c/11g
• Database Architecture
• Backup, Restore and Recovery
• Performance Tuning
• High Availability Solutions like RAC, Active Dataguard, FSFO
• ASM ,PostgreSQL, MySQL and Oracle GoldenGate

Non-Technical Skill:

• Producing quality documents including root cause analysis and managing same.
• Good written skill and spoken/communication skill.
• Working experience with large environment.
• Team Management (Optional)
• Good Communication and Interpretation skill
• Good analytical and problem-solving skills
• Producing quality documents including root cause analysis and managing same.
• Working experience with large environment.
• Must worked on large environment and having exposure to managing multi-terabyte databases.
• Well experienced Oracle DBA having complete knowledge on all area of Installation, administration, configuration, monitoring, migration, advance performance tuning, backup/restore and recovery option, user and security administration of Oracle Database Instance and worked on different Oracle database versions like 19c/18c/12c/11g
• Experience in planning, administering and supporting production and non-production databases and capacity planning, technical infrastructure design.
• Hands on experience on working and administering of managing RAC, ASM, Standby Database/DataGuard environment and RMAN, Oracle Grid Control and other oracle options and utilities.
• Highly expected troubleshooting skill on issue with RAC, ASM, Database, Performance Tuning and Backup Recovery etc.
• Thorough understanding of Oracle Database’s logical and physical structure.
• Must aware about new features supported with Oracle Release and Options and Features supported by Oracle and implementation strategy with best practices.
• Well experienced on database upgrade, database patching, database security implementation, database hardening and able to troubleshoot adhoc problems on live system having large user base.
• Well experience in Oracle Database Advance options of tuning and administering like In-Memory,Recovery Advisor, ADDM, AWR, Tuning and Diagnostic Pack etc.
• Experience on working with enterprise monitoring tool like Oracle EM 13c/12c and administration of 13c /12c EM.
• Experienced on heterogeneous operating system environment on Linux and UNIX and Windows server system having high end configuration and mission critical application deployed.o Good quality knowledge on SQL, PL/SQL, Linux Shell Scripting/Perl Scripting and other development options available with Oracle.
• Working on Cloud Environment will be an added advantage.

ADDITIONAL EXPECTATION WITH JOB RESPONSIBILITY

• Good and quality interpretation, written, communication and documentation skill.
• Able to support 24/7 in critical situation where availability is matter.
• Ready to work during planed weekend support.

Ready to work out-of-hours maintenance and on call support