Maintenance Manager -Project Manager
- Maintenance Manager and Project Manager for several projects with 24/7 support. Lead the teams to maintain all system and make sure all system meet customer’s SLA - Manage over a dozen oracle databases from 50GB to Terabytes, running oracle 8i,9i,10g,11g,12c. Support critical manufacturing database application running 24*7. - Implement and maintain Oracle Real Application Cluster with Database 10g,11g,12c in all OS platform - Implement and maintain Oracle Dataguard with Oracle RAC 10g,11g,12c in all OS platform - Implement and maintain Oracle Audit Vault and Database Vault - Design and implement data extraction and transformation from OLTP database to backend data warehouse, transfer data using Datastage and in-house ETL solution. - Application database schema design using stored procedures and packages using PLSQL, Shell script - Implement Oracle Enterprise Manager Grid Control as centralized database monitoring and operation solution. - Implement Oracle Clusterware and IBM Power HA to manage application failover (HA) - Implement and maintain SUN, IBM, Oracle Storage. - Implement Veritas Netbackup - Implement ORACLE database security feature and audit policy setup to meet SOX compliance requirement. - Implement different OS platform security feature and audit policy setup to meet SOX compliance requirement - Manage Oracle database platform and standards, maintain database patching level and perform 9i and 10g,11g,12c upgrades. - Manage AIX, Solaris, Linux, Windows platform and standards, maintain OS patching level and perform upgrades. - IBM AIX, Solaris and Linux server administration - Leading several application deployment project running on different databases and OS platform, complete phases from requirement study, development checkout to final deployment. - Write a monitoring tool by using PLSQL,shell script to detect system issue and send SMS alert. - Mentoring and training of new engineers on Unix and database.