QUEYON ZENG

** ******** *****, *******, ******* L3S 2K5 CANADA

TEL: 647-***-**** E-MAIL: acwb5e@r.postjobfree.com

OBJECTIVE:

Senior Oracle DBA/Consultant

SUMMARY:

. Eighteen years of Oracle Consultant experience on Oracle DBA, Oracle Data warehouse, Design and Modeling, Architecture Support, Administration, Software Development and Oracle related products.

. Demonstrated talent and expertise in ORACLE database on UNIX (AIX, Sun Solaris, HP-UX, and Linux) and Windows as well as network connectivity in large multi-platform.

. Good team-work spirit with self-start ability, project leading experience, strong problem solving skills and good background of trouble shooting, performance tuning, data modeling, maintenance, and development roles.

TECHNICAL SKILLS:

. Database System: ORACLE 11g, ORACLE 10g, ORACLE 9i, ORACLE 8/8i, ORACLE 7, SQL Server

. Oracle Products: Enterprise Manager (OEM Cloud 12c), Oracle RAC, Oracle Network, Names Server, Data Guard

. Other Products: TOAD, PL/SQL Developer

. Operating Systems: UNIX (Sun Solaris, HP-UX, AIX, Linux) and Windows

. Program Language: SQL, PL/SQL, Shell Script, Pro*C, C/C++, Perl

SECURITY CLEARANCE:

Level III (Top Secret), File Number: 95386878-0001691997, Granted July 8, 2016, Renewal July 8, 2021

EXPERIENCE SUMMARY:

. DBA Experience covers Oracle standard and enterprise editions of versions from 7.x through 11g, on both UNIX (Sun Solaris, HP-UX, AIX, Linux) and Windows (95/98/NT/2000/XP) platforms, with senior level of PL/SQL experience.

. Senior-level experience in data modeling, designing, implementing and maintaining databases for Government, Health Care, Billing system, E-commerce, Data Warehouse, Java 2 Enterprise Edition (J2EE) applications.

. Production support in RAC environment, and Data Guard implementation and troubleshooting.

. Oracle database Installation, configuration, upgrade and migration. Objects maintenance with proper security policy to reflect the application profile and server capacity. Apply the principles of Optimal Flexible Architecture (OFA).

. High availability (7x24) solutions, performance tuning, resource management and monitor for Oracle and applications.

. Backup/recovery implementations and their validation (RMAN with VERITAS net backup server and Legato backup software, Shell scripting, or NT backup).

. Oracle Names Server, Oracle Net Service, Oracle Connection Manager, and Oracle Advanced Security

. Oracle Timesten 11g In-Memory Cache Database

. Familiar with Oracle Enterprise Manager (OEM Cloud 12c, OEM 11g Grid), Advanced Replication with Streams, Developer Suite, and other related products.

. Data Warehousing Solutions for the environment of very large database, familiar with ETL tool and OLAP. Oracle Warehouse Builder (OWB) to support the definition and maintenance of logical model and the deployment of physical instance of the data warehouse model.

PROFESSIONAL EXPERIENCE:

Aboriginal Affair and Northern Development (AANDC), Gatineau QC

Senior Database Consultant, 01/2014 – 03/2016 (27 months)

Production support for multiple applications of Oracle 11g including maintenance, performance tuning, troubleshooting, and backup/recovery, as well as operational documentation

PL/SQL Programming on the auditing project for database change tracking and data warehousing

Backup/Recovery (Restore) for production environments using SAN as the extended storage, Data refresh between production and Dev/UAT/Test

Responsible for refreshing/cloning Oracle database environments with Datapump database.

Database monitoring, performance tuning on Database/Oracle applications, and troubleshooting using Oracle 11g Enterprise Manager Grid and OEM Cloud Control 12c

Knowledge transfer to other team members, provide training to junior or new DBA

Troubleshooting within the team or independently with excellent analytical, problem-solving, and decision-making skills based on wide-range technology

Tracking the tickets with Remedy ticketing system for Technical support and TimeTrack ticketing system for Production RFC (Request for Change)

Performance tuning on SQL and PL/SQL with Oracle trace and explain plan, regular maintenance on the storage, partitioning, and scheduler jobs

Implement schema changes when needed, including data changes, materialized view changes, as well as stored package changes and table structure changes.

Technology: PL/SQL Development, ETL Tools (Datapump), OEM Cloud 12c, TestTrack

Public Works and Government Services Canada (PWGSC), Ottawa

Senior Oracle Consultant, 01/2013 – 12/2013 (12 months)

Production support for 24X7 application of Real Property Management System (RPMS) of Oracle 11g including maintenance, performance tuning, troubleshooting, and backup/recovery, as well as operational documentation

High Availability solution with standby database implementing replication with Data Guard, Refresh standby database after activation test

Backup/Recovery (Restore) with RMAN (for RPMS), Data Pump (for IMRS) for production environments, Data refresh between production and data warehouse

Responsible for refreshing/cloning Oracle database environments with RMAN duplicate database.

Develop UNIX Shell scripts to automate ETL data loading for Integrated Management Reporting System (IMRS) Production, write PL/SQL for reporting purpose.

Database monitoring, performance tuning on Database/Oracle applications, and troubleshooting using Oracle 11g Enterprise Manager Grid

On-Call cycle within production DBA group for RPMS including evenings and weekends

Performance tuning on SQL and PL/SQL with Oracle trace and explain plan, regular maintenance on the storage, partitioning, and scheduler for IMRS Production

Implement schema changes when needed, including data changes, materialized view changes, as well as stored package changes and table structure changes.

Good use of knowledge of the System Development Life Cycle (SDLC), and good team work spirit with wide range of skills and backgrounds

Production support for other small projects: Occupancy Instrument System (OIS), Windows Facilities Inventory System (WinFIS), tracking asset and occupancy data managed by Real Property Services

Technology: Data Guard, Standby Database, PL/SQL Development, ETL Tools (Datapump)

Correctional Services Canada (CSC), Ottawa

Senior Oracle Consultant, 02/2010 – 11/2012 (2 years 9 months)

Support production databases under IT Infrastructure Library (ITIL), certified with ITIL V2

Production support for InfoPol, OMS (RAC environment), CJIL, HRMS (Data Guard) and other CSC applications

Install Cluster Group patches when the patches are available upon the system requirement

Backup/Recovery (Restore) with RMAN connecting to SAN storage and Tape system, Data Pump for development, QA and production environments

Responsible for refreshing/cloning Oracle application and database environments with RMAN duplicate database.

Database migration across different platforms (From Windows to UNIX, Windows to Windows, UNIX to UNIX)

Develop UNIX/LINUX shell scripts to automate various daily DBA operations as-needed for business requirements.

Regular morning check and performance tuning for all databases and operating systems (VMS, HP-UX), monitor and support for ETL processes/jobs

Database administration of Oracle RDBMS 10g and/or 11g including maintenance, configuration, tuning and troubleshooting of databases

Database monitoring, performance tuning on Database/Oracle Applications, and troubleshooting using Oracle 11g Enterprise Manager Grid and TOAD for Large Databases

Provide professional troubleshooting service to end user issues by providing technical documentation with recommendations

Track the tickets with Web-based ticketing system

PL/SQL development (using SQL Developer and TOAD) and UNIX shell (ksh) scripting for product functionality and maintenance job

Write and tuning SQL and PL/SQL for production databases (SQL Developer and TOAD)

Provide recommendations to clients in the proper usage of Oracle RDBMS 11g on Unix platform

Knowledge transfer to other team members with new Oracle products, and provide training to junior or new DBA

Database installation, configuration, tuning and troubleshooting, recreating and upgrading relational database management systems and production databases

On-Call cycle with production DBA group for evenings and weekends

Technology: Oracle 11g RAC, Data Guard, PL/SQL Development, ETL Tools (Datapump), ON-Call, HP-UX

Telepin Software Inc, Ottawa

Senior Oracle DBA/Developer, 09/2008 – 12/2009 (15 months)

Level III support for Tele-communication productions based on Oracle 10g and/or 11g (4 Terabytes) on Solaris

Database installation, configuration, tuning and troubleshooting, recreating and upgrading relational database management systems and production databases

Logical design, data modeling and physical implementation for 3-Tiered web application on Oracle RAC environment

Provide recommendations to clients in the proper usage of Oracle RDBMS 10g on Unix Platform on the purpose of production maintenance

Backup/Recovery with Data Pump for research and development environments

PL/SQL development and shell scripting for product functionality and maintenance job

Write technical documents making use of Oracle RDBMS 10g on Unix platform and provide to the clients

Write and tuning SQL and PL/SQL for Tele-communication production databases

Performance tuning on SQL, PL/SQL, storage, partitioning, and scheduler

Good use of knowledge of the System Development Life Cycle (SDLC)

Timesten 11g In-Memory Cache Database between Web server and 24X7 backend database

Technology: Oracle Timesten 11g, RAC Implementation, PL/SQL Development, ETL Tools (Datapump)

CIBC - Data Management & Decision Support, Toronto

Senior Oracle Consultant for Bank, 05/2007 – 02/2008 (9 months)

Provide production d atabase support for High Availability Banking System on database backup/restore, table partitioning, analyzing and data loading with ETL tools.

PL/SQL development for application promotion and data transfer across different modules of application with the full knowledge of the System Development Life Cycle (SDLC).

Write and tuning SQL and PL/SQL for production databases in banking system especially for performance tuning and troubleshooting purpose

Database installation, configuration, tuning and troubleshooting, recreating and upgrading relational database management systems and production databases

Track the tickets with ticket tracking system for Production Change Requests

Implementation plan with design document and technical specifications for promotion package and QA support, provide technical documentation for the banking system taking use of Oracle RDBMS 10g on Unix Platform

Provide recommendations to clients in the proper usage of the Oracle RDBMS 10g in Banking system on Unix Platform

Data conversion and data mapping between different projects using PL/SQL blocks and packages/procedures

Technology: Oracle 9i/10g, RAC Implementation, PL/SQL Development, ETL Tools (Export/Import, SQL*Loader), Data Warehouse, Tuning, Backup/Restore

Ministry of Environment – Land and Resources Cluster, Toronto

Senior Oracle Consultant for Government, 03/2007 – 05/2007 (3 months)

. Repair Oracle Replication after migration

After migrated Oracle 9i with Replication (Updatable Snapshots) from AIX 4.3 to Sun Solaris 10.0 using export/import utilities, the Oracle Replication could not working properly. I repaired the Oracle Replication by going through and fixing the replication components.

Technology: Oracle 10g, Oracle Replication, Migration from AIX to Sun Solaris

CIBC – Administrative Group Service, Toronto

Senior Oracle Consultant for Bank, 06/2006 – 03/2007 (9 months)

Auditing Data Replication with Streams, Oracle Jobs, Database Audit and Database Trigger

Referential Integrity Check for VLDB with dynamic SQL and Multi-Processing in PL/SQL package

Data Statistics for Data Warehouse with Parallel Query and Multi-Processing

Write and tuning SQL and PL/SQL for production databases in banking system especially for performance tuning and troubleshooting purpose

Provide technical documentation for the banking system taking use of Oracle RDBMS 10g on Unix Platform

Database installation, configuration, tuning and troubleshooting, recreating and upgrading relational database management systems and production databases

Provide recommendations to clients in the proper usage of the Oracle RDBMS 10g in Data Warehouse environment on Unix Platform

Provide training to clients and operation DBA, knowledge transfer to production operation team

Performance Tuning for High Volume Banking System

Technology: Oracle Audit, Replication (Streams), Referential Integrity, Data Warehouse, Performance Tuning

Rogers (Sprint) Canada Inc, North York

Senior Oracle Consultant for Internet Service, 09/2005 – 06/2006 (9 months)

PL/SQL development for Rogers ADSL system on order processing cycle.

Good knowledge of the System Development Life Cycle (SDLC)

Write and tuning SQL and PL/SQL for databases in billing system

Be responsible for troubleshooting and performance tuning for existing applications in Data Warehouse production environment with ETL process.

Technology: PL/SQL development in Data Warehouse with ETL process in 3-tier Web environment

Ministry of Transportation (MTO), Downsview, TORONTO

Senior Oracle Consultant for Government Applications, 11/2003 – 07/2005 (21 months)

Implement physical database based on data model to meet the business requirements, install and configure Oracle Connection Manager to control client connections to database through firewalls.

Migrate Oracle databases from Windows NT to Sun Solaris platform, and enhance the interface between the databases and web servers (Web Logic).

Develop PL/SQL packages and triggers to implement the logical data integrity, cleanup the duplicate data, and provide technical support and training to the development groups.

Write and tuning SQL and PL/SQL for production databases

Database installation, configuration, tuning and troubleshooting, recreating and upgrading relational database management systems and production databases

Technology: Data Model, Connection Manager, Oracle Designer, ERWIN, Oracle 8i/9i/10g, Migrate from Windows to Sun Solaris, RAC Implementation, PL/SQL, RMAN, Veritas

CCH Canadian Limited, TORONTO

TECHNICAL TEAM LEADER for Business Information System, 06/2003 – 10/2003 (4 months)

. As a technical team leader, I migrate the client-server application on Oracle 7.3/UNIX to 3-tier application with Oracle 9i Application Server. Also upgrade Oracle Forms, Reports and Designer Repository from version 6i to 9i.

. Responsible for database logical and physical design, data model conversion between database and data model using Oracle Designer 9i within Oracle 9i Developer Suite.

. Deploy the upgraded application onto the Oracle 9i Application Server Portals with Single-Sign-On on Windows 2000 Server and perform the loading test on the application.

Technology: Oracle Fusion Middleware, Oracle Application Server, Oracle Forms, Reports, Designer, Database Logical and Physical Design, RMAN, Data Model, Oracle Designer

Systems Xcellence Inc., MILTON

SENIOR ORACLE CONSULTANT for HealthCare System, 04/2002 – 05/2003 (14 months)

As a technical leader of DBA group, I organized the frequently changing databases to adapt to the development and production environments. I also did the performance tuning for UAT and production databases, provided the best solutions to the clients, technical support and internal training and presentation for the development team.

Database Design for HealthCare System; use ERWIN to convert between physical model and real database environment. Data Conversion from SQL Server on Windows to Oracle on UNIX, and from Informix to Oracle

Provide technical support to the clients following the provincial standard, Ontario Healthcare Reporting Standard (OHRS) for Ontario clients

Database installation, configuration, tuning and troubleshooting, recreating and upgrading relational database management systems and production databases

Implement Oracle Names Server to fit in with the frequently changed network configuration of DEV environment and realize Oracle Advanced Replication (Multi-Master Replication) for the high availability of Oracle Names Server.

Write and tuning SQL and PL/SQL for production databases

Technology: Development DBA, Oracle 9i, Informix, SQL Server, Database Model, ERWIN, Explain Plan, Oracle Names Server, Connection Manager, RMAN, Oracle Advanced Replication

Ministry of the Solicitor General, TORONTO

SENIOR ORACLE CONSULTANT for Government, 10/2001 - 01/2002 (4 months)

. Be responsible for database logical design, physical design, and database maintenance and enhancement.

. Health check, enhancement, monitor, performance tuning on all the database environments with text content for both Coroner Information System and Sex Offender Registry system.

Technology: Database Logical and Physical Design, Oracle Designer, PL/SQL

BCE Emergis Inc, MISSISSAUGA

SENIOR ORACLE CONSULTANT for B2B e-commerce, 03/2001 – 08/2001 (6 months)

Perform the health check and performance tuning on the production databases; organize the database monitoring system, and all other database related tasks.

Provided the best solution for the performance problem in the on-going production database.

Write and tuning SQL and PL/SQL for production databases

Fixed the listener compatibility problem of the previous upgrade.

Track the tickets with OWO ticketing system for both Production and Non-Production Change Requests

Transfer data between the online transactional database and data warehouse with transportable Tablespaces. Maintain the data warehouse on Sun Solaris with ETL feature and summary advisor (OLAP).

Technology: Oracle Network, RMAN, Veritas, Data Warehouse, Transportable Tablespace, ETL

Sigma Systems (Canada) Inc, TORONTO

SENIOR ORACLE CONSULTANT for BILLING SYSTEM, 09/2000 – 02/2001 (6 months)

Design the database model (Using ERWIN) for the billing system and implement on production.

Database installation, configuration, tuning and troubleshooting, recreating and upgrading relational database management systems and production databases

Perform the Data Repository Management including the metadata, data model and data dictionary for production.

Convert initial data from SQL Server 7 into Oracle 8i to replace the old billing system.

Migrate the database and upgrade the software, design and setup the billing operation.

Write and tuning SQL and PL/SQL for production databases

Technology: Data Model, ERWIN, RMAN, SQL Server, Oracle 8i, Data Warehouse

Destech Consulting & Education, TORONTO

SENIOR ORACLE CONSULTANT, 08/1999 – 08/2000 (12 months)

Project 1: Canada Celestica Inc.: Modeling for data warehouse, logical and physical design

Project 2: Canada Extend Media Inc.: Oracle replication, Backup/Recovery with RMAN on Sun Solaris with Legato

Project 3: Canada Grocery Gateway Inc.: Logical and physical design

Project 4: IBM Canada Ltd.: Provide on-site training on Oracle Enterprise Manager, backup/recovery

Project 5: Canada I-Com Inc.: Modeling on e-commerce application and implementation

Project 6: Canada ILAP Internet Service Inc.: Trouble shooting on PL/SQL procedure

Project 7: the Law Society of Upper Canada: Logical and physical design, database migration

Project 8: Canada Ministry of Housing: Performance tuning on OpenVMS environment

Project 9: MRO Software Inc. (PSDI): Oracle replication

Project 10: Ontario Pharmacy Corp.: Oracle Application Server

Project 11: Speech Link Communications Corp.: Logical and physical design

Project 12: Turbo Promote Inc.: Performance tuning, capacity planning and trouble-shooting

Technology: Oracle 8/8i, PL/SQL, RMAN, Oracle Enterprise Manager, Oracle Designer, Oracle Parallel Server, Oracle Fusion Middleware, Oracle Application Server, Oracle Replication

Guang Dong Ricsson Computing Company, CHINA

PROJECT LEADER for Billing System, 07/1993 - 12/1998 (78 months)

. Guang Dong Long Distance and Mobile Core Billing System

Technology: Oracle 7.3, PL/SQL, Pro*C, RAID 5, Sun Solaris, HP-UX, Backup/Recovery

Zhong Shan University, CHINA

DEVELOPER, 07/1992 - 06/1993 (12 months)

. Develop the real time processing system for Horse Racing Center.

Technology: Foxpro, Windows, C/C++

EDUCATION:

Bachelor Degree of Computer Science, Zhong Shan University, Guangzhou, CHINA, 1988-1992

(Credential Evaluation Report from World Education Services (WES) is available)

PROFESSIONAL TRAINING AND CERTIFICATE:

IT Infrastructure Library (ITIL), Ottawa, 2010 Certified

Oracle9i PL/SQL Developer Certified Associate (OCA), Toronto, 2003 Certified

HIPAA (Healthcare Insurance Portability & Accountability ACT), Systems Xcellence Inc, 2003 Certified

ORACLE Certified Professional (OCP) for Oracle 9i, 8i DBA, Toronto, 2002 Certified

ORACLE Certified Professional (OCP) for Oracle 8 DBA, Toronto, 1999 Certified

ORACLE Advanced Administration, Oracle Corporation, 1997 Certified

HP-UX 10.0 Network & System Administration, Hewlett Packard, 1996 Certified

Contact this candidate