Resume of

Alex C. K. Wong

***** ********* ***

Fremont, CA 94536

Cell phone: 510-***-****

email: acurrh@r.postjobfree.com

Citizenship: USA

Position Desired

Sr. Oracle DBA

Summary

Oracle certified professional (15+ yrs.).

Supported Oracle database as DBA working in a 24x7 environment. (15+ yrs.)

Application development using PL/SQL stored procedure, packages, triggers and functions. (15+ yrs.)

Developed Unix scripts. (15+ yrs.)

Support Databases (SQL Server, Vertica) in Cloud environment. (1yr)

Installed and supported of RAC and ASM software and database. (2 yrs.)

Configured and supported Oracle Streams (Advanced Replications). (2 yrs.)

Performed database performance tuning, utilizing explain plan, TKPROF, AWR and ASH reports. (10+ yrs.)

Supported Sahraplex database replication environment. (4 yrs.)

Installed Oracle software to new versions (8i, 9i, 10g, 11g, 12c), upgraded database and applied database patches (one off, CPU, PSU). (15+ yrs.)

Performed the migration of database from one operating system to another operating system. (4+ yrs.)

Performed Data Center migration. (4+ yrs.)

Worked with application team to create, modify and re-design of database objects like tables, partitioned tables, indexes, views, materialized views, sequences, functions, triggers, stored procedures and packages. (15+ yrs.)

Designed and developed backup and recovery strategies. (15+ yrs.)

Developed scripts to automate the cloning of the databases for development/testing environments. (15+ yrs.)

Supported Data Warehouse of 15 TB. (10+ yrs.)

Developed and maintained database with Object Oriented design. (2+ yrs.)

Supported Database environments included SAN and Veritas’s HA/Cluster Servers technology and Quest’s SharePlex and DataGuard standby and Golden Gate replication technology (4+ yrs.)

Successfully implemented Oracle Multi-Master Replication. (1 yr.)

Supported other Replication environment include Streams, AQ and SharePlex. (4+ yrs.)

Architected the backup and recovery environment using RMAN and customized scripts. (15+ yrs.)

Utilized ERwin for data modeling. (1 yr.).

Created reports with Seagate Crystal Report. (2 yrs.)

Adminstrate user access privileges using roles and direct grants. (10+ yrs)

Utilized SQL Navigator and TOAD by Quest Software. (6+ yrs.)

Utilized scheduling software such as crontab. (15+ yrs.)

Worked with Help Desk Software, Remedy and ClearQuest. (8+ yrs.)

Conducted training classes and delivered presentations to users, developers and management. (2 yrs.)

Education

Major: Information and Computer Science

Degree: Bachelor of Science, University of Hawaii, Hawaii

Certification

OCP 8i, 9i

Hardware

Sun/Solaris 2.6, 7, 8, 9, 10. Unix, Linux RedHat, HP/UX,

Squent/dynix, Hitachi/SAN, NetApplicance/NAS,

Veritas file manger, Netbackup, Quick I/O, IBM 3090 MVS/ESA,

PC Window/NT, BURROUGHS B3700, B4700.

Database

Oracle (7.3, 8.0, 8i, 9i, 10g, 11g, 12c), DB2, IMS, Vertica, Mongo, SQL Server

Software

Oracle PL/SQL, sqlplus, PL/SQL, packages, stored procedures, triggers, import/export, datapump, SQL Loader, OEM, GRID Control, DB Control, Multi-master replication,

RMAN, SharePlex, Golden Gate, DataGuard/standby, Streams, AQ, RAC, ASM,

Unix scripts (Korn shell, C shell, Bash shell), Veritas/Cluster Servers, Quick I/O, Crystal Reports,

SQL Navigator, PeopleSoft, Platinum/EPM, StorageTek/Reelback, Logic Work/ERwin, neon/ODBC, crontab, autosys, Control-M, COBOL VS, COBOL II, CICS Command/ Marco Level,

IMS/DB DL/I, DB2/SQL, SO/ISPF, JCL, CA7/11.

CASE Tools

ADW, FOUNDATION (Design/1 and Install/1).

Employment History

Jan. 20014 – July 2015 (contractor) Wells Fargo Bank, San Francisco, CA

Business: Banking and Financial Industry

Position: Sr. Infrasturcture DBA

Supported the delpoyment of application scripts and DDL changes to DEV and SIT environments.

Cloned databases from seed DB to DEV and SIT environment upon user requests.

Resolved DB related issues for developers.

Supported quarterly OS patch DB outages.

Supported PSU patches to DEV and SIT DB.

Created documents for Oracle DB new releases (11.2.0.4 and 12.1.0.2) software installation and DB upgrade process.

Performed Oracle DB new releases software installation and DB upgrade.

Developed PL/SQL packages for the DB data purge project.

Enhanced and simplified existing DB outage and deployment processes to be more efficient.

Nov. 20012 – Jan. 2014 (FTE) RMS, Newark, CA

Business: Insurance Industory

Position: Sr. Cloud DBA

Supported databases (SQL Server, Vertica, Mongo DB) in Cloud environment.

Provide 24x7 production support.

Developed a Vertica readonly access environment with sensitive data masking for developers to trouble shoot on production database.

Presented development project design to developers and managements.

Held training classes on new system and 3rd praty tools.

Conducted training classes on newly delevloped systems and 3rd party tools.

Explored and documented SQL Server Log Shipping and HA solutions for future production deployment.

Evaluated Ignite database monitoring tool, created and customized alert scripts.

Configured CommVault backup and restore solution for SQL Server.

Developed Unix scripts to extract from daily reports to create history respository for retrival by date range.

Supported environment cloning between production and non-production environments.

Supported applicaton release on production and non-production environments.

Oct. 20011 – Nov. 2012 (contractor) Wells Fargo Bank, San Francisco, CA

Business: Banking and Financial Industry

Position: Sr. DBA

Supported databases in System Intergation Test (SIT) environment for online applications.

Installed Oracle 11g RAC and ASM software.

Upgraded databases to 10g and 11g.

Converted non-RAC database to RAC database using ASM.

Applied CPU and PSU patches.

Deploy database changes to support multiple application releases in SIT env.

Enhanced database changes handoff procedures between DEV, SIT, QA, PTE and PROD env.

Mantor junior DBA.

Interact with DEV, QA, PTE and PROD DBA team to provide support and assist software installation and project implementation.

Provided technical support to application developers.

Monitor daily, weekly cron jobs for database backup and partition maintenance.

Created documents for routine DBA tasks for consistent support and cross training.

Mar. 2011 – Oct. 2011 (contractor) PayPal, San Jose, CA

Business: Online Payment Service

Position: Sr. DBA

Supported databases in development and QA environment for online applications.

Upgraded databases to 10g and 11g.

Installed and configured Standby database.

Supported Gloden Gate replication.

Performed SQL tuning utilizing explain plan.

Developed stored procedures and packages to automate the database cloning and script deployment.

Provided technical support to application developers.

Menor junior DBAs on-site and offshare.

.

July 2009 – Jan. 2011 (contractor) Wells Fargo Bank, San Francisco, CA

Business: Banking and Financial Industry

Position: Sr. DBA

Supported databases in development environment for online and batch applications.

Installed Oracle 10g and 11g software.

Upgraded databases to 10g and 11g.

Applied CPU and PSU patches.

Installed and configured Streams replication.

Performed SQL tuning utilizing explain plan.

Redesign application DSS data statistics gathering and aggregrating process using partitioning tables and materialized views to reduce the processing cycle from 8 hours to 30 minutes.

Developed stored procedures and packages to facilitate the management of application DSS data statistics gathering and aggregrating process.

Developed stored procedures and packages to automate the creation and dropping of daily and monthly partition maintenance.

Created documents for installation and support of software releases.

Provided technical support to application developers.

Provided support to production DBA in tuning and trouble shooting in performance issues.

Mentor junior DBA.

May 2008 – May 2009 (FTE) Walmart.com, Brisbane, CA

Business: E-Commerce, Retail

Position: Sr. DBA

Supported production Databases for online portal in DataGuard standby and Veritas cluster environment.

Supported data warehouse with Netezza and Informatica.

Supported and automated the monthly release process to production.

Performed changes to QA and other non-production environment.

Performed SQL and dtabase tuning utilizing explain plan, TKPROF, AWR and ASH reports.

Managed database space usage and capacity planning.

Installed and upgraded Oracle 10.2.0.3.

Installed and Configured Oracle Message Gateway.

Developed scripts to compare and reconcile the access privileges between databases.

Classroom trained on MySql.

Mar. 2007 – Mar. 2008 (contractor) Wells Fargo Bank, San Francisco, CA

Business: Banking and Financial Industry

Position: Sr. DBA

Installed Oracle 9i, 10g software.

Created and cloned databases.

Refreshed schemas between databases.

Supported Database with Streams and AQ replication.

Performed code migration and SQL tuning.

Developed scripts to automate database backup jobs and monitoring process.

Performed database recovery.

Mentored junior DBA.

May 2005 – Feb. 2007 (FTE) Symantec Corp., Cupertino, CA

Business: Software Development

Aug. 2003 – May. 2005 (contractor)

Position: Principal DBA

Installed Oracle 9.2.0.4, 9.2.0.6, 10.2

Supported SharePlex replication environment.

Upgraded Data Warehouse databases from 8i to 9i.

Created RMAN repository Database.

Backup database using RMAN with Veritas Netbackup media layer.

Performed database recovery.

Maintained databases in 8i and 9i for Data Warehousing using Veritas Quick I/O for Siebel Analytics 7.3 implementation.

Developed sql and scripts to monitor 8i and 9i space usage.

Developed scripts and SQL to administrate and manage user access privileges.

Conducted training classes on newly delevloped systems ans 3rd party tools.

Created and maintained partitioned materialized views (snapshots) for fast and full refresh.

Automated sql and scripts to create quarterly partition tables.

Utilized explain plan, TKPROF and STATSPACK to performed tuning on 8i and 9i databases and SQL to support Siebel Analytic 7.3, PeopleSoft HR 8.2 and Informatica for data extraction form ODS and load into DWH.

Responsible for all database 24x7 uptime, performance and storage requirement in development, QA and Production environments.

Cloned database from production to development and QA environments.

Extracted and populated partial/full schema data from production to development and QA environments.

Migrated application and database changes from development to QA and production environments.

Validated sql performance before implemented to production.

Project lead of scalability and performance project.

Sep. 2001 – July 2003 (FTE) Ecast/RioPort.com San Francisco/San Jose, CA

Business: E-Commerce, Music

Position: Sr. DBA

Installed Oracle 9.2, 8.1.7 and created databases to support Multi Languages application with OFA on SUN Solaris 7 E450 and E1405, NetAppliance/NAS, Hitachi/SAN.

Migrated Oracle 8.1.6 databases to Oracle 8.1.7 databases.

Configured a multi-master replication environment.

Using RMAN and created scripts to perform backup and recovery strategy.

Performed database and SQL performance tuning.

Participated in database design of Data Warehouse and Web application database.

Evaluated 3rd party software for database monitoring, performance and replication (e.g. SharePlex).

Implemented Oracle Multi-Master Replication.

Wrote stored procedures and triggers for data extraction from ODS and load into data warehousing for loading and reporting.

Designed and maintained reports with Crystal Reports.

Monitored database performance, disk space usages and RMAN backups using Veritas Netbackup media layer.

Assisted developers to resolve 3rd party software technical problems.

Developed a process to automate the data extraction processes (ETL) for the Data Warehouse.

Developed scripts and SQL to administrate and manage user access privileges.

Created Crystal Reports.

Responsible for all database 24x7 uptime, performance and storage requirement in development, QA and Production environments.

Nov. 1999 - June 2001 (FTE) Spherion (Interim Technology, Inc) San Francisco, CA

Business: Consulting Agency

Position: DBA Consultant

(Being assigned to different client sites to fulfill the client’s DBA functions)

Client: Matson Navigation Co. San Francisco, CA (July 2000 – April 2001)

Installed Oracle 8.1.6 and created databases with OFA on SUN Solaris 2.6 E220R.

Installed Oracle 8.0.5 and crested databases on Windows/NT 4.0.

Created scripts for database backup and recovery strategy.

Performed cold backup, hot backup restore and recovery scenarios.

Created PL/SQL Packages to facilitate data loading.

Installed OEM for database monitoring and administration tasks.

Performed database, shared pool and SQL performance tuning.

Upgrade Oracle 7.3.3 to Oracle 8.0.5 on Windows/NT 4.0.

Create Oracle database on Veritas/Cluster Servers for High Availability.

Evaluate 3rd party software for database monitoring.

Participated in PeopleSoft upgrade and SQR performance tuning.

Responsible for all database 24x7 uptime, performance and storage requirement in development, QA and Production environments.

Client: Sayit.com Foster City, CA (Dec. 1999 – July 2000)

Installed Oracle 8.1.5 on SUN Solaris 2.6 E450 and Ultra 5.

Created database and tables using Object Oriented design.

Installed Oracle 8.1.5 client on NT Red Hat Linux 2.6 for Web-Servers.

Developed and created scripts in Korn shell for backup and recovery strategy.

Performed cold backup and hot backup restore and recovery scenarios.

Created SQL scripts to product daily reports

Created SQL scripts to monitor and fix operational data problems.

Installed OEM for database monitoring and administration tasks.

Analyzed SQL for performance. Redesigned database objects for quick throughput.

Performed database, shared pool and SQL performance tuning.

Developed stored procedures, Korn shell scripts and SQL scripts to automate the process for data populating, loading and reporting.

Partnered with web and application developers to enhance the usability and performance of the web site and database.

Responsible for all database 24x7 uptime, performance and storage requirement in development, QA and Production environments.

Client: QRS Richmond, CA (Nov. 1999 - Dec. 1999)

Created a Datamart on an Oracle NT 8.1.5 database using partitioning tables.

Created sql scripts to load data into the partition tables, to administer users and

all Datamart partitioning tables, to backup and restore the Datamart partitioning

tables.

Aug. 1999 - Oct. 1999 Chen & McGinley San Francisco, CA

Business: Consulting Agency

Position: Consulting DBA (Contractor)

Client: ReleaseNow.com San Carlos, CA (Aug. 1999 - Oct. 1999)

Functioned as a technical consultant to the in-house DBA.

Provided technical recommendations and reviewed the Oracle initial parameters for existing databases.

Defined standards for naming file systems and scripts.

Setup infrastructure for Oracle environment on Unix servers using OFA.

Created cron jobs in C shell for hot backup, cold backup and export of databases in addition to RMAN.

Performed SQL analysis and tuning to enhance performance.

Installed Oracle 8.0.5 on Unix server.

Created Oracle Database on Unix servers.

Recovered database from database failure.

Jun. 1996 - Aug. 1999 (FTE) DHC/Mervyn’s/Target Hayward, CA

Business: Retail

Position: Sr. DBA

Trained on Unix and Oracle DBA courses.

Supported Oracle V7 & V8 databases for Data Warehouse of 40 to 200 GB.

Created new monthly tables of partition views used by the Data Warehouse databases loading data from ODS.

Worked with application developers and Information Analysts to develop new Oracle V8 database.

Used ERwin as data modeling tool to design and extract DDL scripts.

Created Oracle V8 database for Web Applications with multiple schemas and cross schema dependency.

Developed hot backup and cold backup strategy using Reelback and import/export.

Performed database monitoring, tuning, SQL tuning and database recovery.

Installed Oracle software and applied patches.

Worked with Unix SA to install and configure Platinum’s Enterprise Performance Monitoring software.

Responsible for all database 24x7 uptime, performance and storage requirement in development, QA and Production environments.

Contact this candidate