QUEYON ZENG

*** ******** *****, *******, ******* L3R6J1 CANADA

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

OBJECTIVE:

Senior Database DBA / Senior ETL Developer / Architecture / Consultant

SUMMARY:

.Twenty-Eight years of Database Consultant experience on DBA and Development, Data warehouse, Design and Modeling, Normalization, Architecture Support, Administration, Software Development and related products.

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

. IT Professionals throughout the Software Development Life Cycle Experience in Structured and Agile and Waterfall SDLC Methodologies for Development, Design, Implementation and Maintenance.

. 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.

. Work hard and work smart with good team lead skills

TECHNICAL SKILLS:

. Database System: ORACLE, MySQL, SQL Server, Postgress

. Database Products: Enterprise Manager, Oracle RAC, Oracle Network, Names Server, Data Guard, Exadata

. Other Products: TOAD, PL/SQL Developer, Elasticsearch in Cloud with Kibana and Logstash, DevOps

. Cloud technologies: Elasticsearch, Azure Data Factory, Azure Blob Storage, ADF Pipeline (ETL), Azure SQL

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

. Program Language: SQL, PL/SQL, TSQL, Java, Unix Shell Script, Pro*C, C/C++, Python

SECURITY CLEARANCE:

Level III (Top Secret), File Number: 95386878-0002806436, Granted May24, 2022 Renewal May 24, 2027

EXPERIENCE SUMMARY:

. DBA Experience covers Oracle standard and enterprise editions of versions from 7 to the latest, on both UNIX (Sun Solaris, HP-UX, AIX, Linux) and Windows platforms, with senior level of PL/SQL experience.

. Senior-level experience in data modeling, designing, implementing and maintaining databases for Government, Major banks, Health Care, Billing system, E-commerce, Data Warehouse, J2EE applications.

. Hands on Development experience in Azure Cloud and related technologies (Elasticsearch, Apache, Azure Data Factory, Azure Blob Storage, etc)

. Design and build Data Warehouse Solutions on Azure platforms including logical model and physical model of the data warehouse.

. Elasticsearch in Cloud with Kibana and Logstash for Index Management, Index Patterns, Snapshot and Restore.

. ETL loading process with Pipeline in Azure Data Factory working with Oracle, SQL Server, and Azure Blob.

. Good experience in Rapid Application Development (RAD) and Agile and Waterfall SDLC Methodologies, and good Documentation still for knowledge transition and post-implementation support.

PROFESSIONAL EXPERIENCE:

Scotiabank, Toronto ON

Risk Warehouse, Toronto ON

Senior Database Consultant/Developer for Bank, 4/2023 – 1/2024

Logical and Physical data model for Banking System in Oracle 12c and Oracle 19

Automate storage / partition / subpartition maintenance for current online data, and compression for history archived data.

PL/SQL development for application promotion and data transfer across different modules of application with required data conversion, replication, data extract, data loading and business report.

Write and tuning SQL and PL/SQL for production databases in banking system for functional implementation, data analysis, decision making, and implementation of data flows between internal system as well as external systems.

Production support for High Availability Banking System on database backup/restore, table partitioning, analyzing and data loading with ETL tools, using the Right Tool to do the Right Thing.

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

Technology: Oracle 12c, Oracle 19, PL/SQL Development, Python, Java, ETL Tools (Export/Import, SQL*Loader), Data Migration, Tuning, Backup/Restore

Ministry of Environment, Toronto ON

SQL, DBA, Data Architecture, ETL Developer for Government, 7/2020 – 3/2023

Project 1: MPI ETL from Multiple Source Databases to Azure Elasticsearch

Design and implement ETL loading process integrating multiple source application data into Azure Data Factory with Extraction, Transformation, and Loading Activities to provide searching services to end users.

Logical and physical data/information model design, data Architecture for the target solution (Azure Elasticsearch in Cloud), and design the Data Initial and Incremental Loading approach and strategy.

Design and develop ETL processes with Exception handling and automatic e-mail notification for Report and Monitoring, keep track of the processes with execution log.

Translate technical systems specifications and requirements into working applications, develop detailed programming specifications and design documents, writing codes with unit tests.

PL/SQL developments for complex SQL functions/procedures/views/scripts to normalize and de-normalize data with required data conversion, data extract, transfer/cleanse, and load into the target format/structure for Azure search in Cloud.

Data verification across Source, Staging, and Target databases over the ETL process with Azure Data Factory Pipeline, send verification report by e-mail to specified recipients configurable in database tables.

Perform database analysis, SQL and Database/Solution performance tuning, perform all required changes to the database, data model, database scripts, queries, stored procedures/functions/packages/views.

Perform migration testing, load testing, performance monitoring, and provide recommendations for improvements in database and application tuning.

Provide Application deployment assistance as required for implementation of planned implementation life-cycle services and deliverable.

Troubleshoot technical problems/issues with applicable solutions to resolve the technical problems. Provide technical assistance in implementation, conversion and migrations when necessary.

Provide Problem/Issue log investigation and troubleshooting, root cause analysis, impact assessment and options analysis. Provide recommendations to fix the problems, code and test the solutions, and Release.

Knowledge transition for post-implementation support and design/operation walk-through with project team.

Technology: Azure Data Factory, Elasticsearch in Cloud, Azure Blob Storage, Pipeline, Link Services, Python, Logic Apps, Normalization, Repository Pipeline / Release

Project 2: ERS-ERO Migration and Enhanced Reports

Data Migration from the existing Legacy ERS application to historic data in ERO on Elasticsearch in Cloud with Kibana and Logstash before Decommissioning of the old ERS application.

Data Analysis and Understand the existing Legacy ERS data and structure, identify the data issues/anomalies and provide data extract as required.

Design logical and physical data/information models, data Architecture for the target solution (Elasticsearch in Cloud with Kibana and Logstash), and design the Data Migration approach and strategy.

PL/SQL developments for complex SQL functions/procedures/views/scripts to de-normalize data with required data conversion, data extract, transfer/cleanse Legacy ERS data, and load into the target format/structure for Elasticsearch in Cloud.

Setup, Configure, Provision the target database solution. Configure/Customize Elasticsearch function (Indexes Management, Index Patterns, Snapshot and Restore, etc), and perform the data Migration.

Perform database analysis, SQL and Database/Solution performance tuning, perform all required changes to the database, data model, database scripts, queries, stored procedures/functions/packages/views.

Perform migration testing, load testing, performance monitoring, and provide recommendations for improvements in database and application tuning.

Provide Application deployment assistance as required for implementation of planned implementation life-cycle services and deliverable.

Provide Problem/Issue log investigation and troubleshooting, root cause analysis, impact assessment and options analysis. Provide recommendations to fix the problems, code and test the solutions, and Release.

Technology: Oracle 12c, PL/SQL Development, XML,ETL Tools (Export/Import), Data Migration, Tuning, Backup/Restore, Elasticsearch in Cloud with Kibana and Logstash

CIBC, Toronto ON

Project 1: Capital Market, Toronto ON

Senior Database Consultant/Developer for Bank, 12/2018 – 6/2020

Logical and Physical data model for Banking System in Oracle 12c and SQL Server.

PL/SQL development for application promotion and data transfer across different modules of application with required data conversion, replication, data extract, data loading and business report.

Write and tuning SQL and PL/SQL for production databases in banking system for functional implementation, data analysis, decision making, and implementation of data flows between internal system as well as external systems.

Production support for High Availability Banking System on database backup/restore, table partitioning, analyzing and data loading with ETL tools, using the Right Tool to do the Right Thing.

Data migration and data mapping between different projects and different databases (SQL Server and Oracle) using PL/SQL blocks and packages/procedures, writing ETL scripts to migrate from Microsoft SQL Server to Oracle, transfer (send and receive) data from other systems with internal banking system.

Track the tickets with JIRA, Git hub for source code version control and data model changes

Technology: Oracle 12c, PL/SQL Development, Python, Java, ETL Tools (Export/Import, SQL*Loader), Data Migration, Tuning, Backup/Restore

Project 2: Data Management & Decision Support, Toronto ON

Senior Oracle Consultant for Bank, 05/2007 – 02/2008

Provide production database 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

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

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

Project 3: Administrative Group Service, Toronto

Senior Oracle Consultant for Bank, 06/2006 – 03/2007

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, Referential Integrity, Data Warehouse, Performance Tuning

Parsons Canada Inc, Markham ON

Senior Database Consultant/Developer, 09/2016 – 12/2018

Database Administration and Development for Emission-Test Management System with Oracle 12c

Implement Replication System from Operating Database to Data Warehouse with Advance Queue Technology with more efficiency better performance than standard Oracle Replication

Performance tuning and trouble shooting for Very Large Database Production with customized advance technology in addition to the standard performance tuning tools

Develop database monitoring and reporting tools on the critical production to meet the Service Level, ensure the best quality of system

Planning on the Data Migration from Oracle database and Microsoft SQL Server to AWS Cloud

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

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

Production Version/Release control of schema changes, data updatesand stored package changes and table structure changes, as well as any production related deployment

Technology: PL/SQL Development, Oracle 11g/12c, AWS Platform, ETL Tools, OEM Cloud 12c

Federal Government of Canada, Ottawa ON

Senior Database Consultant, 02/2010 – 03/2016

Project 1: Aboriginal Affair and Northern Development (AANDC), Gatineau QC

Production support for multiple applications of Oracle 11gincluding 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 Data Migration between different databases and platforms

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

Project 2: Public Works and Government Services Canada (PWGSC), Ottawa

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

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 Data Migration from Linux to Windows of Oracle database 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)

Project 3: Correctional Services Canada (CSC), Ottawa

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 apps

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 DB.

Data 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.

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 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), HP-UX

Ministry of Transportation (MTO), Downsview, TORONTO

Senior Oracle Consultant for Government Applications, 11/2003 – 07/2005

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.

Data Migration of 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

BCE Emergis Inc, MISSISSAUGA

SENIOR ORACLE CONSULTANT for B2B e-commerce, 03/2001 – 08/2001

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

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.

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

. Provided consulting services to multiple clients

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

. 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

Oracle 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,1997Certified

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

Contact this candidate