Must Skills - Oracle DBA with 11g, 12c & 19c experience on UNIX (Solaris/Aix /RHEL/Linux) and Windows Operating system. Hands-on experience in Oracle AVDF is must
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
- Hands-on experience in Oracle AVDF installation, configuration & maintenance
- Should have good troubleshooting Skills
- Usage of data dictionary views
- Space management, Undo Management, User management
- Partitioning of tables
- Experience in database patching.
- Experience in Database migration & upgradation
- 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 kshell, Born & c shell.
- Should be good in Performance tuning experience using AWR, Explain Plan and TKprof.
- Should have experience in RAC configuration & administration
- Data Guard( physical standby) administration & implementation,
Soft skills - Must have good team working skills balanced with ability to work alone and a positive attitude. Customer focus and good communication skills