Oracle Database Administration
JOB DESCRIPTION
· RAC 11G R2
· Oracle 12 G
· Oracle Upgrade to 12 C project
· Active Data Guard
· EMC Avamar tool knowledge good to have
· Database Creation and administration
· Database Space/Storage Management
· System and Database Performance Monitoring
· Backup – Execution and Monitoring
· Database Refresh
· Startup/Shutdown
· User Management
· Managing Database Security
· Administer Database Object Privileges
· Administer Production Data Access
· Administer Schema Access
· Problem Resolution (DBMS)
· Database Object Performance/ Monitor/Tuning
· Create/Maintain/Execute DDL
· Create/Maintain/Execute Public DBMS Objects
· System Performance Tuning
· Administer DBMS Environment
· System Recovery – Execution
· Software Upgrade
· DBMS Features e.g. Data Replication, Parallel Server
· DBMS Environment Design/Maintenance/DBA
· Providing recommendations for capacity planning
· Planning Migration/Upgrades
· Database Consolidation
· Performing Disaster Recovery
· Good communication skill
· Ability to work with global resources to implement servers, and resolve issues.
· Participates in on-call rotation
· . Customer interaction and communication skills.
· Adheres to documented, approved standards
· Plans and coordinates infrastructure requests to accommodate server requests
· Coordinates and plans with other support groups and vendors to provide emergency and scheduled maintenance in an effective timeframe
Responsible for coordinating requested changes and minimizing the business impact of those changes. Understand and follow operational processes and policies.