SQL tuning, Oracle database performance tuning

Database Performance Tuning• Reactive outage / incident resolution coordinator• SQL/CBO optimizations (SQL monitor interpretation, set based processing, explain plan/stats/data analysis, adaptive features, cursor management, extended optimizer stats, use of GTTs, hints/baselines, SPM, SQL tuning sets)• Proactive database tuning via AWR/ASH• Identification of isolated / generalized database problems• Remediation and RCA with Oracle Support (MOS)Database design and development• Identify code fixes with internal application and development teams• Proactive 100x/scalability issue resolution• Application tuning and debugging • Research, test & implement new technologies (DBRM, TDE, optimizer features, OKV, SQL encryption, partitioning)• Create / publish Oracle database best practices and SOPs• Capacity planning for storage, memory and CPU to reduce TCO• Validation and research for 11.2 to 12.2 migration and implementation• Train/support DBA team on best practices & Oracle software developments• Review of enterprise-wide parametersOEM• Database performance monitoring• Metric extension creation / deployment• PL/SQL Job schedulingExadata - X7• Maintain database performance• Cell offloading/smartscan performance monitoring• Configuration of Exadata per Oracle best practices

Client-aligned Database Administrator• Oracle 10.2g, 11.1-11.2g, 12.1c• SQL tuning (baseline and index creation)• OEM monitoring • Design and maintenance• PL/SQL scripting• Database/memory tuning• Patching, upgrading database/grid clusterware• RMAN backup & recovery using Vertias Netbackup solution