SUMMARY:

• Master in both SQL Server and Oracle with experiences on other DBMS systems including MySQL, AS400, DB2 UDB, Sybase, PostgreSQL and Netezza
• Specialist in database and application performance tuning with extensive skills in various SQL and procedural languages including SQLPlus, PL/SQL, TSQL, PSQL, PL/pgSQL, NZSQL, Perl, VB, Shell and DOS PowerShell scripts
• Over 18 years hand on DBA experience in Application Development Life Cycle including enterprise data architectures capacity/storage planning, logical and physical database design, installation, configuration, upgrading, migration, patching, cloning, backup, disaster recovery, change management, security, monitoring, reporting, QA, supporting, training, troubleshooting, performance tuning and documentation on ERP, CRM, BIS, OLTP, OLAP, DSS, Data Warehouse databases for HR, Sales, Call Center, Health Care, e - Commence and Financial applications
• Skilled in SQL Server 7/2000/2005/2008/ 2012/2014/2016, Oracle 8/8i/9i/10g/11g/12c, Oracle Application 10/11/11i/12, Sybase ASE 15.0, DB2 10.1, PostgreSQL 8.2, Netezza NPS 6.0, Informatica 7/8, Cognos 7/8, BusinessObjects XI R2, Delphix 4.0.0.1, SharePlex 8.6.5, LiteSpeed 4.8, Oracle Design/Developer, Crystal Report, E-R Modeling, ERWin, Data Warehouse, Data Mart, BI, Star Schema, Dimensions, Materialized View, Strategic Data Analysis, ETL, RAC, ASM, DataGuard, DataPump, RMAN, Grid Control, DataLoader, SQLLoader, TOAD, OEM, Replication, Partitioning, Streams, Encryption, DTS, SSIS, SSRS, SSAS, Mirroring, Log Shipping, SQL AlwaysOn, VPD, JAVA, JDBC, NLS, HTTP, ADI, HTML, XML, ASP, .NET, SOA, SAP, Veritas Clustering, EMC, SAN, NAS, RAID, TCP/IP, Herbinate, Wiki, SVN, VPN, Bugzilla, FTP, SSH, Unix (Solaris, HP-UX, AIX), Linux (RedHat 5/6), Windows 2000/2003/2008/2010/2012
• A self-motivated and detail oriented individual with a strong problem solving and communication skills

PROFESSIONAL EXPERIENCE:

Confidential, Torrance, CA

Sr. DBA (Consultant)

Responsibilities:

• Upgraded over 300 SQL 2000/2005 databases to SQL 2008/2012 and over 50 Oracle 9i/10g databases to 11g database. Migrated over 100 databases with data center move from Phoenix, Arizona to Dallas, Texas.
• Performed installation and configuration for SQL Mirroring, log shipping and AlwaysOn with availability group for SQL 2012/2014/2016 on Windows 8/10/12. Implemented and supported SQL SSIS, SSAS and SSRS for various application projects.
• Performed installation, configuration and testing on data replication from Oracle 11g database to SQL 2008 database using SharePlex third party tool as well as data replication between SQL 2012 databases.
• Performed installation, configuration and testing on data virtualization and integrated data masking solution using Delphix to branch virtual Oracle 11g databases for application development and testing.
• Supported SEC1 user security management tool OIM (Oracle Identity Management) and upgraded it from Oracle 10g to current Oracle 11g R2 version.
• Performed installation, configuration and testing on Oracle 12c with multiple node RAC and data guard.
• Prepared the enterprise wide database standard documentations including installation, infrastructure ready check list, standardized procedure and security standards for all SQL Server 2008/ 2012/2014/2016 databases as well as Oracle 10g/11g/12c databases for Toyota financial services.

Confidential, CA

Sr. DBA (Consultant)

Responsibilities:

• Performed SQL tuning on Zynx Authorspace health care applications and rewrite over 30 top stored procedures in three months and reduced the CPU load from 90% to 5% and reduced memory usage by 80%.
• Installed and configured SQL Server mirroring and log shipping for high availability and disaster recovery.
• Completed database migration project from Dubai to US main server including data analysis, DTS to SSIS migration, data mapping, transformations and data load in just three months.

Confidential, Burbank, CA

Sr. DBA

Responsibilities:

• In charge of the logical and physical database design for a mission critical multi million project (SPECTRUM) from scratch and implemented the new data architecture on multiple database environments.
• Installed and configured Oracle 10g and 11g databases on Linux RHAS5 64bit Linux operation system and performed data migration from 10g to 11g.
• Performed daily maintenance on SQL Servers 2005/2008 with database mirroring and replications.

Confidential, Los Angeles, CA

Principle DBA (Consultant)

Responsibilities:

• Performed enterprise level data architecture analysis including business requirements, system resources and data analysis. Reverse engineered the data E-R model using Erwin.
• Installed and configured Oracle 10g (RAC) on Linux RHAS5 64bit Linux with 8 nodes clustering application servers for load balancing. Implemented and configured three way data guard / Grid control on the databases for hot standby and disaster recovery.
• Performed SQL tuning on SaaS applications build on Herbinate using AWR, OEM Grid control SQL advisor.
• Created and modified shell scripts for database monitoring, backup and disaster recovery using RMAM, data pump, DBMS Scheduler and automatic email notifications.

Confidential, Westlake Village, CA

Sr. DBA (Consultant)

Responsibilities:

• Installed and configured BusinessObjects XI R2 for BI solution. Designed and implemented ETL procedure using PL/SQL, TSQL, PSQL, NZSQL, shell scripts and DOS scripts to transfer data from Oracle, MS SQL, DB2 UDB databases into Netezza NPS 4.0 data warehouse appliance.
• Installed and configured Oracle 9i/10g on Windows 2000/2003 and RHAS4 64bit Linux for financial applications. Implemented and configured data guard/Grid control.
• Implemented SpeedLite from Quest Software for MS SQL 2005 Server backup/recovery and saved time/space for over 90%.

Confidential, Chino, CA

Sr. DBA (Consultant)

Responsibilities:

• Designed HP forecast E-R model for enterprise CRM data warehouse applications.
• Installed and configured Oracle 10g on Window 2000, and migrated three live Oracle 8i/9i databases to Oracle 10g. Finished all database upgrade and migration related tasks in less than two weeks.
• Performed administration and troubleshooting for Oracle 11i E-Business Suite / ERP systems including GL, AP, AR, INV, PO, OE, Call Center, MRC using RapidInstall, ADAdmin, AutoUpgrade, AutoPatch, RapidClone, other AD utilities and OEM application Manager.

Confidential, Los Angeles, CA

Sr. DBA (Consultant)

Responsibilities:

• Upgraded Oracle Application 11 on Sun Solaris 2.8 to 11i on HP-UX 9000/800 using 4 nodes 9i RAC and Veritas clustering.
• Performed code migrations using Perl, shell and PL/SQL scripts. Migrated forms, reports and concurrent programs into the new Oracle Application 11i system.
• Created and modified custom Perl and Shell scripts using FTP and McAfee E-Business Server with PGP encryption to secure data transition.

Confidential, Culver City, CA

Sr. Data Architect / Sr. DBA

Responsibilities:

• Performed enterprise database system analysis and capacity planning using EMC, SAN, RAID, Veritas clustering/cloning technologies for enterprise applications.
• Designed and implemented centralized enterprise data warehouse systems using BI star schema with partitioning and materialized view. Designed ETL processes using Informatica tool, PL/SQL, SQL Load, DTS, T-SQL, Shell scripts and migrated legacy data from various data sources (Oracle, SQL server, DB2, Sybase, MySQL, Access and Excel) into the data warehouse in Oracle.
• Managed security, user responsibility and implemented encryption for sensitive data.

Confidential, Santa Monica, CA

Sr. DBA

Responsibilities:

• Analyzed and redesigned existing database using E-R model and migrated the Oracle 8i database from Unix (Sun Solaris7) platform into Linux (Red Hat3) platform.
• Successfully re-launched the Confidential web site using Cold Fusion/Vignette Story Server web application teamed with consultants from CGI in less than three months.

Confidential, Panorama City, CA

DBA

Responsibilities:

• Analyzed, planned and designed DSS/data warehouse by Rational Rose 2000 CASE tool.
• Managed Oracle 8i database in windows for 401K Network web application. Migrated data from Betrieve databases using Oracle transparent gateway.