Management of large databases on Oracle - including installation, design, configuration, backup & recovery, performance analysis, tuning, capacity planning/forecast and security.
Collaborate with DBAs, Developers, and Architects in troubleshooting database and application errors. Actively monitor the database environment to ensure optimal performance and to prevent production issues. Backup and recovery and migration using RMAN, datapump and export/import.
Proactively monitor and optimize system performance using tuning, optimization, AWR, ASH, and other methods.
On-Call Support on a rotational basis - including Off-Hours and Weekends.
Collaborate with Data Architects on data modeling using tools such as E/R Studio.
Review Oracle SQL query, DDL, DML including stored procedure, packages before deployment.
Provide support for database/application deployments.
Provide training in areas of specialization to other team members.
Must be a team player with excellent collaboration and people skills to be able to engage in productive group discussions.
Excellent verbal and written communication along with the ability to articulate technical solutions for various levels of management and technical staff.
Ability to interface with users at all levels of the organization and good end-user support skills.
License/Certification/Education: Normally requires a B.S. Degree in Computer Science w/5-7 years of experience.
Required Skills and Experience:
Oracle OBA with 5+ years' experience in a mission critical production database environment, including:
Oracle llg, 12cR1 and 12cR2
Automatic Storage Managment
Real Application Cluster (RAC), Grid Infrastructure, Oracle Clusterware. Recovery Manager (RMAN) database backup, recovery and cloning. Logical and Physical Design
Performance tuning, troubleshooting including SQL Tuning
Installs, upgrades, patching including Bundle Patches