SUMMARY

• Accomplished IT Professional with 20+ years of experience and a background in implementing systems to streamline processes and achieve business objectives in a variety of industries.
• Competent in planning, installing and configuring MS SQL and Oracle server databases as well as troubleshooting UNIX (Solaris, Red hat, Centos, and HP - UX), and documenting processes. Knowledge of UNIX (Sun, Berkeley, HP, Linux) system administration including Unix scripting, implementing OS patches and upgrades, troubleshooting server corruptions, configuring server software and loading new software.
• Keen attention to detail and project management skills with the ability to develop and document standard operating procedures for end-users, production reviews, audits, and training classes.
• Extensive knowledge of hardware and software, networks, servers, and multiple business applications with the ability to complete analysis and infrastructure design. Proven leader with a history of collaborating with high performing teams.

AREAS OF EXPERTISE

• Oracle RDBMS 9i/10g/11g/12C/18C | MS SQL 2005/2008/2012/2014 | Oracle Financials 11.0.3 | Oracle Data Guard| Oracle Application Server 8i/9i/10g/11g
• Oracle Monitor Suite | SQL*Plus| PL/SQL| TSQL | DTS, SSIS| SRSS | Oracle Case tools | Oracle Forms/Reports | DB2, Sun Solaris, HP-UX, AIX, Linux
• Windows workstation | Windows server | Platinum DBA | PeopleSoft | Client Access | Arc-Serve | IBM ADSM | Visio | MS Office: Project-Reflection-Access
• IBM RS 6000 | Sun workstation |Doubletake |Db-sync | Navicat for MySQL, Embarcadero dB Artisan
• Enterprise Manager Cloud Control 13C | Spotlight for Oracle | MySQL | MSSQL | RMAN backup |FileNet
• AWS cloud services| Altova MapForce |Cognos| Iron speed designer

PROFESSIONAL EXPERIENCE

Senior Oracle DBA

Confidential, Los Angeles, CA

Responsibilities:

• Technical Lead for the implementation of all database versions (Oracle 9x/10x/11x/12x/18x) for best practices, policies, and procedures for the entire client base. Migrate development database instances to Oracle cloud services for proof of concept as USC moves into the digital transformation era. Acted as hands-on Project Manager for teams of up to 15 people for project-specific engagements.
• Configure Oracle data guard 9i/10g/11g/12c for data disaster recovery at co-location sites hosting standby databases for all 52 production instances university-wide.
• Setup event alerts for over ten terabits of information transferred to standby databases.
• Serve as technical consultant for all campus initiatives involving the deployment of database technology within and outside of the ITS sphere of responsibility.
• Oversee install and maintenance of RDBMS environments for ORACLE and MS SQL Server.
• Complete data conversion and migration, hardware and database architecture, conversion management, and reporting.
• Ensures data privacy protects against insider/outside threats and enables regulatory compliance on all oracle databases.
• Build and configure highly reliable databases for with 98.9% uptime to be used with the Axium Academic Dental Software system within the Dental school community as well as databases for the Blackboard for Higher Education for the entire campus.

SQL Server DBA/ MySQL DBA Consultant

Confidential, Los Angeles, CA

Responsibilities:

• Lead DBA in maintenance and installation of six production SQL servers with such tasks as data migration from MYSQL to SQL Server, replication, creation and capacity planning, object creation, and modifications.
• Conducted backup/recovery configuration and planning, data load from raw data and database security.
• Completed performance monitoring and tuning, capacity planning for future growth and troubleshooting.

SQL Server DBA/ Oracle DBA Consultant

Confidential

Responsibilities:

• Lead DBA in maintenance and installation of 17 production SQL servers with such tasks as data migration from Oracle to SQL Server, data replication between sites, database creation and capacity planning.
• Conducted backup/recovery configuration and planning, performance monitoring and tuning, capacity planning for future growth and troubleshooting.
• Collaborated with internal technical groups to create test and recovery plans for QA FDA audit.
• Created custom analytic predictive maintenance ad-hoc reports for Faciliworks software users
• Created and maintain SSRS Monthly accounting summary analytic forecast reports

Senior Staff Consultant/Oracle DBA

Confidential, El Segundo, CA

Responsibilities:

• Led deployment of Oracle 8i Application Server in IBM RS 6000 environment.
• Administrated all new modules to interact with the front-end applications and Oracle Financials 11.0.3 applications.
• Led deployment of Oracle 7.x databases on Windows system for the Public Defender (APD) project.
• Assisted in enhancing and creating new modules to interact with the front-end applications.
• Assisted deployment of PeopleSoft HRMS on HP and Oracle DBA for the Los Angeles Payroll System (LAPS).
• Administrated 7.x instances which all interacted with PeopleSoft Personnel Management System.
• Led deployment of scalable Oracle Application Server, Oracle Tools, and UNIX Servers.
• Application was expanded in its second release to send and receive queries to/from the State of California’s Department of Justice (DOJ) System with JDIC serving as a switch/router.

Los Angeles County Probate and Civil Court

• Led deployment of Sun Servers, Oracle Web and Application Servers, and FileNet software to electronically image case documents either received electronically or scanned.
• Managed two others for SUN/OS administration, Oracle development and administration, and FileNet administration for the Ameritech Information Access Interactive Electronic Imaging and Workflow Services System for the Los Angeles County Probate and Civil Court.

Los Angeles Police Department APRIS and ICARS

• Led deployment and administration of HP-UX Servers, Oracle Servers, and FileNet software.
• Developed/implemented a FileNet imaging system to electronically image crime and arrest documents.

EDUCATION & CREDENTIALS

Bachelor of Science, Industrial Science, California State University, Dominguez Hills

Certifications: Oracle Financial Administration; Oracle Application Server Administration; Oracle Financial Audit; Unix Administrator (SUN/OS, LINUX, SCO); FileNet Administration; Oracle DBA