Yong Zhang

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

516-***-****

Great Neck, NY 11020

acwnwf@r.postjobfree.com

SUMMARY

DBA with 10 plus years of solid experience in database administration including but not limited to installing, applying patches to and migrating software, designing both logical and physical, creating, modifying and managing databases on Sun Solaris, AIX, Windows, Linux. Performed performance tuning, back up & recovery of databases using RMAN, O/S commands, EXP / IMP and expdp/impdp utilities. Set up and configured replication, Oracle RAC, SQL Clustering and VCS/Legato. PL/SQL programming.Microsoft SSIS. Data Warehouse ETL. Server consolidation. Possess complete life cycle experience of designing and implementing databases. Working knowledge of DB2 on z/OS, AIX, Sybase, MySQL, Websphere and iPlanet. Set up Sun StorEdge replication Software. Replatforming Oracle database from Solaris to Linux platform. Virtualizing windows servers using VMWare and set up SQL Server Cluster resources on those VM images.

WORK EXPERIENCE

HighBridge Capital Management, New York, NY

Senior Oracle/SQL Server DBA Consultant 03/2016 – PRESENT

Supported core trading application as well as Data Warehouse databases with heavy concurrent user volumes.

Planned, tested and migrated Oracle database from 10g/11g to 12c.

Managing oracle databases with RAC, ASM, Data Guard, Grid Control, SQL Developer.

Troubleshooting database performance issues by rewriting sql, rebuilding indexes, recreating sql profiles for both OLTP and OLAP databases.

Refreshed QA/DEV from Production databases by using Rman, impdp/expdp utilities.

Performed database monitoring, growth forecast and reporting.

Providing 24/7 support of the critical applications on rotation basis.

Upgraded SQL Server databases from 2005/2008 to 2012 to consolidate servers to save costs for the company.

Evaluating and testing new technologies for the company to adopt.

Managing database users, objects and changes in accordance with SOX Audit.

Howard Systems International, Rye, NY

Senior Oracle/SQL Server DBA (Avon on site as consultant) 06/2015 – 02/2016

Supported core web application ECOM (WEBE) with heavy concurrent user volumes on a 24x7 basis to ensure stability of production system.

Planned, tested and migrated Oracle database from 10g/11g to 12c.

Managing oracle databases with RAC, ASM, Data Guard, Grid Control, SQL Developer.

Performed follow-the-sun 24/7 global support on a rotation basis to keep global operation going.

Troubleshooting database performance issues by rewriting sql, rebuilding indexes, rebuilding tables for both OLTP and OLAP databases

Refreshed QA/DEV from Production databases by using Rman, impdp/expdp utilities

Performed storage monitoring and database growth forecast.

Performed disaster recovery exercise for the company

Upgraded SQL Server databases from 2005/2008 to 2012 to consolidate servers to save costs for the company.

Astoria Bank, Lake Success, NY

Senior Database Administrator 08/2014 – 04/2015

Performing on-call DBA rotations in a 24x7 environments with Oracle/SQLServer/MySQL.

Reviewing and evaluating DML/DDL changes to production databases/Data Warehouse databases before implementations.

Performing storage forecasts and capacity monitoring to reduce maintenance overhead costs.

Performing backup and disaster recovery exercise for Oracle/SQL Server/MySQL databases and applications.

Designing and building Data Warehouse database (Dev/Prod) from scratch.

Interacting with business units to identify system requirements and working with development teams to materialize the requirements.

Designing data processing architecture and optimizing data loading process.

Designing ETL procedures to load data into staging/target tables via SSIS,Sqlloader etc.

Messaging data from different sources into SQL Server/Oracle databases.

Establishing procedures to QA data and ensure data accuracy.

Involving replatforming databases from Solaris to Solaris Intel/Linux platform to reduce costs.

Planning, designing, coordinating and migrating Oracle databases from 10g to 11gR2/12c.

Supporting application development teams (Oracle Financial/Hyperion/In house apps etc)with version upgrades, application releases, and cloning /creating copies of existing databases for testing and development purpose.

Scheduling and monitoring database jobs, progress and completion of all jobs and take corrective actions as necessary.

Performing SOX compliance tasks and developing best practices.

Communicating effectively within I.T team and with other business units.

MajescoMastek, New York, NY

Senior DBA Specialist 07/2012 – 08/2014

Performing all Oracle DBA related activities for major projects.

Planning, designing, coordinating and migrating Oracle databases from 9i,10g to 11gR2/12c.

Performing database tuning by rewriting sqls, rebuilding indexes, restructuring schemas via Tools like AWR and StatsPack reports

Support application development teams with version upgrades, application releases, and cloning /creating copies of existing databases for testing and development purpose.

Scheduling and monitoring database jobs, progress and completion of all jobs and take corrective actions as necessary.

Performing on-call DBA rotations in a 24x7 environment.

Virtualizing Oracle Databases from physical to virtual servers, saving cost for the clients

Reviewing and evaluating DML/DDL changes to production databases/Data Warehouse databases before implementations.

Performing storage forecasts and capacity monitoring to reduce maintenance overhead costs.

Performing backup and disaster recovery exercise for the clients.

Performing SOX compliance tasks and developing best practices for the clients.

Coordinating support amongst on shore and off shore support for the customers.

Converting/consolidating physical servers to virtual servers to reduce foot prints of the servers to reduce cost for the clients.

Upgraded SQL Server databases from 2000/2005 to 2008/2008R2 to consolidate servers.

AVON PRODUCTS INC., Rye, NY 10/2011 – 06/2012

Senior Oracle/SQL Server DBA

Planned, tested and migrated Oracle database from 9i,10g to 11g.

Replatformed Oracle databases from AIX to Linux operating system

Managing oracle databases with RAC, ASM, Data Guard, Grid Control.

Performed follow-the-sun 24/7 global support on a rotation basis to keep global operation going.

Troubleshooting database performance issues by rewriting sql, rebuilding indexes,rebuilding tables for both OLTP and OLAP databases

Refreshed QA/DEV from Production databases by using Rman, impdp/expdp utilities

Performed storage monitoring and database growth forecast.

Performed disaster recovery exercise for the company

Involved in setting up SAP by using DB2 (LUW).

Supported core web application ECOM (WEBE) with heavy concurrent user volumes on a 24x7 basis to ensure stability of production system.

Upgraded SQL Server databases from 2000/2005 to 2008/2008R2 to consolidate servers to save costs for the company

Installed SQL Server 2008 R2 Clusters on Windows 2008 R2 server

ONEBEACON INSURANCE, Melville, NY

05/2006 - 10/2011

Senior Oracle /SQL Server DBA

Defined and installed Oracle 11g R2, migrated test environment from Oracle 10gR2 to 11g R2.

Upgraded SQL Server infrastructure from 2000 / 2005 to 2008 / 2008 R2

Involved in planning and designing hardware infrastructure for the company’s I.T. infrastructure.

Managed and prioritized database changes task queue distributing workload of 50 to 250 changes per week to DBA staff.

Performed Oracle and SQL Server Database recoveries for annual Disaster Recovery Exercise.

Performing 24/7 support for all Production Databases (OLTP/OLAP), support for Sand, DEV, QA and Staging databases.

Replatformed Oracle databases from Sun Solaris to Linux resulting in a cost saving for the company.

Participate in release planning of DB changes, patches, upgrades and scheduled maintenance.

Installed and managed Oracle RAC (10gR2) for web database on Point of Sale Project.

Setup and manage Data Guard for the Oracle Databases in DR site.

Migrated Data Warehouse & POS production database from 8.1.7 to 10.2.0.3 successfully.

Performed performance tuning for the database (10gR2) and rewrote procedures and triggers.

Partitioned tables and indexes to improve performance for both Oracle and SQL Server.

Reengineered existing schemas for Renaissance (OLTP) and Data Warehouse production database for performance optimization.

Reengineered Data Warehouse load packages/procedures based on the new requirements.

Automated database tasks by scripting and through use of tools such as Grid Control.

Updating, migrating and refreshing database environments (for both OLTP and OLAP databases) from production to QA and DEV environments.

Performed SOX compliance tasks for the company and developed best practices for whole team

Converting/consolidating physical Windows server to VM Ware to reduce foot print of the servers to reduce cost for the company.

Consolidating sql server databases to reduce foot print of window servers.

Documented DBA working standards, procedures, as well as technical documentations.

DELTA FUNDING CORP, Woodbury, NY

02/2003 - 04/2006

Supervisor/Oracle/Peoplesoft DBA

Created standby database (logical and physical) for the company’s Click and Close Project.

Performed performance tuning for the database (9i R2) by using DBExpert and SQLExpert and rewrote procedures and triggers.

Partitioned tables and indexes to improve performance.

Reengineered existing schemas for Click and Close Project (OLTP) for performance optimization.

Installed and configured databases on Sun Solaris, NT and Linux platforms.

Tested and installed Sun StorEdge Software to setup disaster recovery for the company.

Installed and configured Peoplesoft applications and oracle database as backend on Sun Solaris/NT

Participated in planning and designing hardware infrastructure for the company.

Planned and implemented DR infrastructure for the company by utilizing Data Guard for Oracle databases.

Set up Data guard (logical standby) for company’s reporting/data warehouse for management and STREAMS for high availability for the business.

DEUTSCHE BANK, New York, NY

12/2001 – 12/2002

Oracle DBA, DB2.0 Project, Global Market

Reengineered existing schemas (ERWIN) for Global Market trading system for performance optimization using Oracle as back-end and WebLogic as front-end.

Analyzed data elements, grouped data requirements, and eliminated data redundancy. Enhanced system performance.

Rewrote packages, procedures, functions, triggers to improve performance.

Designed, created and managed Data Warehouse to generate reports for senior management.

Performed and managed database migration through all phases including development, component testing, integration testing and production on Sun Solaris/AIX Platform.

Reduced project’s downtime by Performing trouble shooting, performance tuning proactively.

Automated database backup process and reduced human error using Korn Shell Scripting together with RMAN and EXP.

Provided 24/7 supports for consultants, programmers, business analysts and end users throughout New York, London and Sydney.

Created and managed users, roles, synonyms and maintained system security.

Refreshed databases from production to development with large size on monthly basis.

Increased work efficiency using PHP to improve intranet website for database change request.

AIRMEDIA.COM,INC,New York, NY 07/1999 – 10/2001

Oracle DBA

Designed logical using Erwin; implemented physical databases for wireless communication systems on Sun Solaris from scratch.

Predicted growth of database accurately by Monitoring growths and changes using SHELL Scripting, PL/SQL and Perl.

Installed and configured different versions of Oracle Clients to accommodate requirements of different vendors on different platforms including Sun Solaris, Win NT/2000.

Performed hot and cold backup of databases, restored/recovered databases using RMAN, O/S commands, EXP, IMP, SQL Loader.

Implemented Advance Replication for the Hub Applications to ensure business continuity.

Participated in setting up and configuring Veritas Clustering Server/Legato for the company.

Created database reorganization procedures, database alert scripts, monitoring scripts and backup procedures; controlled and monitored user access to databases.

Wrote PL/SQL packages and assisted C++, Java, Perl programmers with developing programs to call PL/SQL packages.

Installed and configured Oracle Portal to help end users access database for report purpose.

Helped as system administrator when SA is not available.

Provided 24x7 technical supports to developers, business users, end users both in New York and London.

EDUCATION

ORACLE CERTIFIED PROFESSIONAL (Oracle 8i, 9i,10G,11G)

MCTS (SQL SERVER 2008)

Received training in Oracle RAC, Data Guard, Advanced Replication from Oracle University. Received training in SQL Server 2005, SQL Server 2008 Clustering, SSIS, Oracle 12c from Learning Tree.

MBA, Lubin School of Business, Pace University, New York, NY

BA, International Exchange, Beijing University, China

Contact this candidate