Oracle Database Administrator
Gci Communications Corp. | Anchorage, Ak
• Constructed and deployed database structure, procedures, shell scripts and scheduled jobs to accomplish the goal of migrating historical partitions from SSD storage to less expensive spinning disk storage saving extensive space and associated costs• Implemented, documented, evangelized new database team GitHub/BitBucket repository home to track database changes• Successfully performed Oracle database refreshes using Recovery Manager (RMAN) duplicate, Data Pump Export/Import, followed by reactivation of Data Guard or Golden Gate replication where appropriate• Consulted, recommended and implemented user logon trigger enabling read-only user reporting on alternate schema• Researched and produced Executive Summary regarding proposed option for Oracle EBS replication to Azure• Designed and implemented underlying database structure, queries, and views to support Tableau dashboards for Netcracker replication state as well as new RMAN backup catalog status for both technical and executive use• Performed troubleshooting and resolution of Golden Gate "replicat" issues during database maintenance as well as implemented looping logic and advanced job alerting from both Linux shell and Oracle procedures• Successfully completed recommended Azure Fundamentals training and certification