New York, NY
Oracle DBA
Job Description
Job Description:-
- Core technical understanding of Oracle Database Architecture in both RAC and NON-RAC environments
- Mandatory Hands on experience on Oracle Single Instance/ Real Application Clusters/ ASM storage
- Mandatory Hands on experience on Database User creation/ deletion/ password management/ granting access
- Mandatory Hands on experience on Adding/Resizing/ Dropping Tablespace, datafiles in both RAC and NON-RAC environments
- Mandatory Hands on experience on creating /maintaining/ decommissioning of RAC/NON-RAC databases
- Mandatory Hands on experience on RAC Database Patching, Upgradation will be an add-on Advantage for RAC/Non-RAC databases
- Mandatory Hands on experience on OEM , creating jobs, scheduling alerts, scheduling patching for Oracle database
- Mandatory Hands on experience on Backup and Recovery : RMAN (database refresh RAC/NON-RAC)
- Mandatory Hands on experience on Database Schema refresh - Export Import of data( schema level/table level)
- Mandatory Hands on experience on Oracle Physical Standby (Data guard) for both RAC/NON-RAC environments
- Automating DB tasks via shell scripting
- Knowledge of Performance Tuning related issues in real time production environments
- Generating / Diagnosing reports like AWR/ADDM/ASH reports
- Trouble shooting skills for real time issues on RAC/NON-RAC environment
- Working knowledge on Middleware (WebLogic Server - Basic Understanding/ architecture, Troubleshooting)
- Patching for Middleware (WebLogic server 11g/12c)
- Added knowledge on Teradata/ Sybase database would be an advantage
- Awareness of Red hat/CentOS Linux 5/6/7 & any cloud technology
- Hands on experience in Goldengate and OEM
- Ready to work in 24x7 support
- Secondary Role - MySQL DBA \ Postgre SQL DBA or Snowflake
Recommended Skills
- 24/7 Services
- Architecture
- Backup
- Cloud Computing
- Database Schema
- Databases
Browse other jobs