Cheng Shi

437-***-**** ad3lza@r.postjobfree.com Mississauga

TECHNICAL SKILLS

Strong skills in Oracle 10g/11g/19c

Excellent skills in SQL Server 6.5/2000/2008/2012/2016/2019

Strong working knowledge in PL/SQL, T-SOL, PL/pgSQL, Python, Java, c, Linux Script, PowerShell, SSIS

Experience working with Postgresql, Mysql, Clickhouse

Good understanding of k8s, docker, network, machine learning, web server

PROFESSIONAL WORK EXPERIENCE

DBA & DB Developer

Caida Securities, Shijiazhuang Mar 2007 – Oct 2023

www.s10000.com

Administered Oracle 19c/11g/10g and SQL Server 2019/2016/2012/2008 databases

Administered Database include HADR solution, performance tuning, patch, upgrade, backup

Moved data to database objects between environments, such as development, staging and production

Migrated and converted data between platforms include, include Oracle, SQL Server, Postgresql, Mysql, HDFS, Clickhouse and OS file system

Developed report and analysis programs

Provided on call support in troubleshooting database issues on 24/7 basis

Installed and Maintained Oracle and SQL Server databases for test and production environment

Worked on database refresh on a regular basis from production to development/QA environments

Upgraded and patched databases as required

Implemented various solutions for DR including exp/imp, RMAN, sql script, DataSafeGardian Realsync, GoldenGate, DataGuard, Commvault Simpana, data storage consistent group mirroring, SQL Server Replication, Log Shipping, Clustering, Mirroring and AlwaysOn

Deployed databases for production systems like Stock Trading, Risk Control, Anti Money Laundering, Legal Person Liquidation, HR, CRM, Customer Account Management, Margin Trading, Asset Management, Investment Consultant, Open Fund Marketing, Call Center, Futures Trading Management, Sales Pricing Management of Financial Products, Compliance Management, Transaction Settlement Fund Reporting, Stock Pledge, Insurance Fund Data Delivery, Enterprises’ Shares Transfer, Stock Option Business, Private Debt system etc.

Troubleshoot and resolved database integrity, performance, blocking, replication, connectivity and security issues

Created backup/restore strategy for production and development environments

Provided root cause analysis and fixed Windows & SQL Server related issues by writing T-SQL and PowerShell scripts

Used Performance Monitor, SQL Profiler, Extend Events to optimize queries and enhance the performance of database servers

Managed RAC databases using Crsctl, Svrctl and Grid Control

Monitored, traced, troubleshoot and resolved performance issues using AWR/ADDM/ASH/EXPLAIN PLAN reports

Utilized Data Pump Export / Import extensively to migrate objects / schemas between environments

Cloned databases for testing and reporting

Maintained AIX+HACMP platform and storage systems

Wrote shell scripts and scheduled cron jobs for automating regular maintenance and batch jobs

Selected Projects

Loaded data into Clickhouse from Oracle for client analysis

Populated data into HDFS from Oracle for Investor Suitability Assessment

Migrated data from SQL Server to Oracle and Oracle 10g to Oracle 11g

Developed reporting application

Processed interface data files for Liquidation System

Developed procedure to populate snapshot data data based on history journal objects

Application Support

Hebei Securities Co., Ltd, Shijiazhuang Jan 1995 - Feb 2007

Administered SQL Server and Novell Netware

Developed clearing and trading applications

Migrated data between Foxpro and SQL Server

Performed incident management, problem management, change management, application enhancement

Provided 2nd level support for vendor and in-house applications

Selected Projects

Developed Clearing Systems

Developed application to merge orders of branches and split transaction confirmation

Integrated data from branches databases into headquarter database

C++ Developer

Sanquan Electronics Ltd, Shijiazhuang Aug 1993 - Jan 1995

Participated Luoyang Urban Traffic Control project

Play a main role in Hebei Province Highway Toll System project

Worked as team leader in Luoding Highway Toll System project

CANDIAN EXPERIENCE

SQL DBA ( contract )

Hewlett Packard Enterprise, Mississauga Aug 2016 – Sep 2016

Administered SQL Server in AMIA Data Migration project

Data Quality Analyst ( co-op )

Schneider Electric, Mississauga Apr 2015 - May 2015

Cleansed clients data in BFO Account & Contacts Data Cleanse & Enrichment project

Certificate:

Oracle 10g Certified Professional 2008

EDUCATION

Master of Manage Information System, Hebei Institute of Technology, China

Bachelor of Software Design, Nankai University, China

Linkedin: https://www.linkedin.com/in/%E6%89%BF-%E5%B8%88-a7907b295/

Contact this candidate