Ms Sql Management

GUANGFU(GEOFFREY) LIU

MS SQL DBA with MySQL,Oracle DBA and Adobe AEM Administrator experiences

Address: **-**** *** ** ******, BC, Canada V3W 0Y5 Home: 1-778-***-****

Email: ********.*****@*****.*** Linkedin: https://www.linkedin.com/in/geoffreyliu

Residency: Canadian Citizen / TN Visa Availability: Immediately

OBJECTIVE

Experienced MS SQL DBA

SUMMARY OF QUALIFICATIONS

Strong educational background with Master's degree of Computer Science (Database systems).

More than 15 years’ work experience in database development, database analysis, modeling and design, and production database administration.

Extensive experience in designing and implementing complex enterprise database and data warehouse systems, esp. with web-applications and e-commerce.

Rich experience in MS SQL,Oracle EBS, Oracle Fusion Middleware and Applications.

Extensive experience in Adobe AEM (CQ5) Architect and System administration

Extensive experience in various web-platforms, Oracle APEX, LAMP, .NET and J2EE.

Extensive experience in Software Development and Quality Assurance.

Extensive experience to deploy/configure/install internally developed code as well as 3rd party applications, OS and RDBMS.

Strong process and methodology to work through SDLC for application and database development and deployment.

Strong writing ability for technical documentation.

Strong supervisory, organizational, problem-solving and troubleshooting skills.

Effective presentation and interpersonal skills with clear, excellent written and verbal communication skills.

Responsible, positive, self-motivated, detail-oriented, sound work habit.

Enjoy challenges, perform well under pressure to complete project on time.

Able to handle multiple tasks at the same time, can prioritize tasks well.

Strive for excellence, execute flawlessly, and work both efficiently and effectively.

Strong customer service skills and expertise.

Rapid learner who enjoys keeping up-to-date technology.

Ability to adapt to dynamic environments quickly, and work both independently and in a cooperative team environment.

Great project management skills with diversified experience in project planning and management.

EDUCATION:

Southeast University, Nanjing, China

Master's Degree, Computer Application

Hunan University, Changsha, China

Diploma, Software engineering

TRAINING:

Adobe Training, Edmonton, Canada

Certification, Adobe AEM (CQ5) System Administration and Development

Langara College, Vancouver, Canada

Certification, English for Academic Purpose

Petrocom Computer School, Vancouver, Canada

Vocational, Computer Software Testing

Tsinghua University, Beijing, China

Certification, Oracle DBA and Development

PUBLICATIONS:

Paper:

“An Expert System Building Tool Supporting Knowledge Compilation and Management”.

ICTAI 1993: 470-471

Books:

“Programming in ADA”, Sichuan Technology Press, China

“Programming in dBASE IV”, Sichuan Technology Press, China

“Stock and Future's Technical Analysis”, Guangdong Tech. Press

EXPERIENCE:

07/2015 – 06/2016 MS SQL DBA/Technical Lead

Duijiu Dangge e-Commerce Inc., Shenzhen/Vancouver

Duijiu Dangge is an e-Commerce company providing O2O (online to offline) service for communities. Customers could order any goods with LBS(Location-Based Service), getting them in one hour.

Responsibilities:

Responsible for R&D plan and Duijiu dangge O2O e-Commerce platform's development and operation:

Maintained, administered and supported multiple 7x24 productions and development MD SQL/MySQL databases hosting web/MOBILE applications, e.g. Installed, patched, maintained, and upgraded database software system and applications, automating systems management of new and existing database, administrated InnoDB, MyISAM, NDB.

Troubleshooting SQL Server related CPU, memory, I/O, disk space and other resource contention.

Established database design and coding standards, database management policies and procedures, and ensured developers accountable for adhering them.

Developing and optimizing logical and physical database(Schema) model and design for the applications, e.g. designed Duijiu databases, wrote & troubleshot SQL scripts, code and design, including stored procedures, functions, triggers, tables, views, indexes and constraints, etc.

Migrating Databases between different systems and Clean up databases.

Planning and implementing backup and recovery strategy, e.g., Setup and monitored backups; implemented and tested recovery techniques, e.g., cold backup, hot backup, full backup, incremental and cumulative backup, offline and online backup, user-managed backup, operating system backup, etc.

Configuring and managing replication/standby/cluster instances of MS SQL/MySQL to implement high availability, e.g. AlwaysOn, Clustering, Mirroring, Log shipping, Replication for SQL, master-slave, master-master-slave replication for MySQL.

Monitoring, diagnosing, correcting database performance problems, Performance Tuning, Query Optimization using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools, optimized database and capacity planning. Including: Data Model Tuning, SQL Code Tuning, Physical and Configuration Tuning, Instance Tuning and Network Tuning, etc.

Designing and implementing DB security, user management, and Controlled database access permissions and privileges.

Providing Database administration and design expertise for projects, and provided solutions for complex database problems.

Participating in software test with defect-tracking systems.

10/2012 – 06/2015 MS SQL DBA, STANTEC Consulting Inc., Edmonton, AB, Canada

STANTEC, is one of top 10 design companies in the world and a public company trading on the NYSE under the symbol STN. It provides professional consulting services in planning, engineering, architecture, interior design, landscape architecture, surveying, environmental sciences, project management, and project economics for infrastructure and facilities projects.

Stantec’s services are provided on projects around the world through approximately 13,000 employees operating out of more than 200 locations in North America and 4 locations internationally.

Responsibilities:

Working as MS SQL DBA:

Participating in administering 60 SQL 2000/2005/2008R2/2012/2014 Servers with Windows 2003, 2008 and 2012 Server OS environment using SSMS/SSRS/SSIS, TOAD, SpotLight, LiteSpeed and Quest Capacity Manager. e.g. Installed, patched, maintained, and upgraded database software system and applications;

Troubleshooting SQL Server related CPU, memory, I/O, disk space and other resource contention.

Planning and implementing backup and recovery strategy, e.g., Setup and monitored backups; implemented and tested recovery techniques, e.g., cold backup, hot backup, full backup, incremental and cumulative backup, offline and online backup, user-managed backup, operating system backup, etc.

Configuring and managing replication/standby/cluster instances of SQL to implement high availability, e.g. AlwaysOn, Clustering, Mirroring, Log shipping, Replication for SQL;

Planning and implementing backup and recovery strategy, e.g., Setup and monitored backups; implemented and tested recovery techniques, e.g., cold backup, hot backup, full backup, incremental and cumulative backup, offline and online backup, user-managed backup, operating system backup, etc. performing restore and recovery as required;

Monitoring, diagnosing, correcting database performance problems, Performance Tuning, Query Optimization using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools, optimizing database and capacity planning. Including: Data Model Tuning, SQL Code Tuning, Physical and Configuration Tuning, Instance Tuning and Network Tuning, etc.

Designed and implemented DB security, user management, and Controlled database access permissions and privileges.

Providing day to day/on call support to MS SQL/Applications production and other instances

Monitoring DB growth and provided DB capacity planning and data retention policy for applications’ expansion;

Investigating and troubleshooting for production database issues, and providing solutions for complex database problems;

Providing Database administration and design expertise for projects and development team;

Meanwhile, as AEM (CQ5) System Administrator, responsible for the Adobe AEM (CQ5) System Administration. and as an Oracle DBA, participating in administering over 50 Oracle 10G/11G DB Servers, Fusion Middleware Servers and Application Servers for E-Business Suite 12.1.3/12.2.2 with HP-UX(Unix)/Red Hat (Linux) environment.

07/2009 – 09/2012 MS SQL DBA /Technical Lead, GPVAQ.COM Inc., Shenzhen, China

GPVAQ.COM Inc. is a network company that operates Global Points and Vouchers Automated Quotation System and provides points exchange service.

Responsibilities:

As Technical Lead and DBA, responsible for R&D plan and all projects’ development and operation: Developed the portal website www.gpvaq.com for global points and vouchers exchange, and “Global Points and Vouchers Automated Quotation System (GPVAQ)” with B/S and C/S versions. My main tasks include: planning, requirement capture, system analysis and design, development, database modeling and design, SQL development, deployment and project management, architecture plan, etc. The website and systems have been developed successfully. The GPVAQ System includes: Quote Server, Quote Client, Order Server, Order Client, Matching System and Clearing System, etc. It is a stock exchange total solution. The development environments are Windows 2003/2008, .NET, MS SQL 2005/2008/2012, Linux, Weblogic, Oracle 10G/11G, MySQL 5.1/5.5, VS 2005/2008, C#, VC++, etc.

Maintained and administered multiple 7x24 productions and development Oracle 10G/11G, MS SQL 2005/2008/2012, MySQL 5.1/5.5 databases hosting web applications www.gpvaq.com and the GPVAQ Systems, e.g. Installed, patched, maintained, and upgraded database software system and applications.

Established database design and coding standards and ensured developers accountable for adhering those standards

Developed and optimized database model and design for the applications, e.g. designed GPVAQ databases, wrote & troubleshot SQL code and design, including stored procedures, functions, triggers, tables, views, indexes and constraints, etc.

Planned and implemented backup and recovery strategy, e.g., Setup and monitored backups; implemented and tested recovery techniques, e.g., cold backup (offline), hot backup (online), full backup, incremental backup, etc.

Implemented high availability with Replication, Cluster (SQL 2012 Always On, RAC) and Database Mirroring, etc.

Monitored, diagnosed, corrected database performance problems, optimized database and capacity planning. Including: Data Model Tuning, SQL Code Tuning, Physical and Configuration Tuning, Instance Tuning and Network Tuning, etc.

Designed and implemented DB security, user management, and Controlled database access permissions and privileges.

Provided Database administration and design expertise for projects, and provided solutions for complex database problems.

02/2009 - 06/2009 Database Developer (Volunteer), Columbia College Vancouver, BC, Canada

Columbia College is a private college in Downtown, Vancouver.

Responsibilities:

Developed a Book Ordering System for the library independently, including Requirement capturing, System analysis and design, Database analysis and design, and wrote program with VB and Access 2003.

Transferred data from the old system to the new system.

The software system has been running well since deployment.

05/2008 - 01/2009 MS SQL DBA/ Technical Lead, Chinae.com Inc., Shenzhen, China

Responsibilities:

(The same as before, please refer to 1/2006 - 12/2007)

01/2008 - 04/2008 Database Developer (Contractor), Rocket Gaming Systems Inc., Vancouver, Canada

Rocket Gaming Systems designs, develops, and delivers real-time interactive electronic gaming systems for casino slot machines. RGS's product enables players in multiple gaming facilities to simultaneously compete against one another for multi-level wide-area progressive jackpots.

Responsibilities:

Participated in developing Data Service System for Gaming, including data gathering with replication, generate report, mainly with MySQL &SQL

Transformed business requirements into conceptual, logical data models and created physical database schemas.

Set up and implemented replication, diagnosed replication issues and solved them, e.g., Data Out of Synch Issues and Resolution.

Developed stored procedures, functions and triggers, etc.

Developed Database Installer for Gaming systems to set up and update database for the applications.

Migrated Databases and Clean up databases.

Used various skills: Java, VC++, XML, Ant, Eclipse, Crystal Report, Wise, Tomcat, ODBC, JDBC, JUNIT TEST, MySQL, and MS SQL.

Designed and implemented DB security, user management, and Controlled database access permissions and privileges.

Created script to fill DB with high volume of data for load testing purpose.

Participated in overall system stress testing and found performance bottlenecks in the database.

Created and defined scripts and tools for troubleshooting Production database issues.

Reviewed SQL queries and data access code submitted by developers for functional and performance correctness.

Provided technical help to development team.

01/2006 - 12/2007 MS SQL DBA/Technical Lead, Chinae.com Inc., Shenzhen, China

Chinae.com Inc. is a network company listed in NASDAQ, which operates Equity Exchange Platform & provides software products for equity exchanges.

Responsibilities:

Led a team to develop the portal website www.chinae.com for equity market, and two software products: “Chinae Equity Registration and Depositary System” (C/S) and “Chinae Equity Exchange System” (B/S). Including: System planning, requirement capture, system analysis and design, database plan and design, architecture plan, etc. The website and systems have been developed successfully. The environments are Windows 2003, .NET, MS SQL 2000/2005, Linux, J2EE, Weblogic and Oracle 9i/10g.

Responsible for operation and support of www.chinae.com, a large-scale exchange platform for equity exchange, and two software products.

Maintained and administered multiple 7x24 productions and development Oracle 9i/10g, MS SQL 2000/2005 databases hosting website chinae.com.

Planned, coordinated and implemented database management software, and established related standards and documentation, e.g. Installed, patched, maintained, and upgraded Oracle, MS SQL and MySQL, etc.

Designed optimized data model for the systems and website according to the requirements, e.g. designed normalized tables, indexes, partitions, etc.

Controlled database access permissions and privileges.

Developed, monitored and maintained database back-up and recoverability procedures, and performed recovery as required.

Implemented High Availability and Disaster Recovery with Oracle RAC and DataGuard, Replication, and Database Mirroring etc.

Implemented Performance Tuning: Data Model Tuning, SQL Code Tuning, Physical and Configuration Tuning, Instance Tuning, Network Tuning, etc.

Developed SQL queries, stored procedures, and triggers for the applications with SQL, PL/SQL and optimized them.

Designed SSIS, development and maintained ETL and data replication processes with SSIS, SSAS and SSRS, etc.

Allocated database files to different storage for quick access and prevention of data loss.

Monitored DB growth and provided DB capacity planning and data retention policy for applications’ expansion.

Created script to fill the database with high volume of data for load testing.

Participated in overall system stress testing and found performance bottlenecks in the database.

Created and defined scripts and tools for troubleshooting Production database issues.

Responded and assisted developers in troubleshooting application problems related to database.

10/2003 - 12/2005 Manager, IT Department/ DBA, Luenthai Garment Inc., Dongguan, China

Luenthai Garment Inc. is a company listed on the HK Stock Exchange. It is one of the biggest manufacturers of famous brand garments and apparel in Hong Kong. There are 11,000 employees in the company.

Responsibilities:

Responsible for the IT Department management, and IT Operation of the company. Planning the IT Department, Team building and projects management, improving the processes of IT and other departments.

Provided Support of all Application Systems running in the company, such as SAP ERP (Finance, Purchasing, Fixed Assets Management, etc.), HRMS, SCM, Production Tracking System (ProTrack) and ProTrack Report Generation System, etc.; The production environment is WINDOWS 2000/2003, .NET, MS SQL 2000/2005, Linux, AIX (UNIX), J2EE, Weblogic and ORACLE9i/10g.

Maintained and administered production database systems for ERP and other applications: MS SQL 2000/2005, Oracle 9i/10g, e.g. Installed, configured and upgraded software, server, tools and applications.

Responsible for planning, analyzing, modeling and designing the databases to support a variety of software applications.

Controlled database access permissions and privileges.

Developed, managed and tested backup and recovery plans, e.g. cold backup (offline), hot backup (online), full back up, incremental backup, etc.

Designed and implemented redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.

Implemented High Availability with Replication, Standby database, Cluster (RAC), DataGuard and RMAN. Implemented replication setup and replication Issue diagnostics, e.g. Data Out of Synch Issues.

Implemented Performance Tuning: Data Model Tuning, SQL Code Tuning, Physical and Configuration Tuning, Instance Tuning, Network Tuning, etc., e.g. Database Partitioning, index, etc.

Monitored DB growth and provide DB capacity planning for applications’ expansion. Monitored, tuned, sized, analyzed and defragged databases.

Migrated DB between software versions, platforms and DB products.

Developed scripts, triggers, procedures, packages with SQL, PL/SQL, etc.

Investigated and was the troubleshooter for production database issues, and provided solutions for complex database problems.

Data mining, analysis, aggregation, merging with some Data warehouse and ETL tool.

Set up and planned servers, SAN and network.

Supported developers in tuning DB and applications for optimal performance.

Provided Database administration and design expertise for projects and development team.

09/2002 - 09/2003 Looking for new project

05/2002 - 08/2002 Oracle Instructor, Data College Richmond, BC, Canada

Responsibilities:

Instructed all four courses for Oracle 9i OCP DBA program:

Introduction to Oracle9i: SQL;

Oracle9i Database: Fundamentals I;

Oracle9i Database: Fundamentals II;

Oracle9i Database: Performance Tuning;

Guided students through operation of Oracle 9i on both Windows 2000 and Linux OS.

01/2000 - 04/2002 Database Administrator/PM, Chinaeagle Securities Inc., Shenzhen, China

08/1992 - 12/1999 Development Manager, Zhifu (SmartRich) Stock Analysis Inc., Shenzhen, China

03/1987 - 07/1992 Instructor of computer science, Shenzhen University, Shenzhen, China

TECHNICAL SKILLS

SKILL NAME

LEVEL

LAST USED/EXPERIENCE

PROJECT MANAGEMENT/PMBOK

Expert

Currently Used / 15 years

System Analysis and Design

Expert

Currently Used / 15 years

Windows 2003/2008/2012 Server

Expert

Currently Used / 8 years

MS SQL 2000/2005/2008/2012/2014

Expert

Currently Used / 10 years

ETL/SSMS/SSIS/ SSAS/ SSRS FARM

Intermediate

Currently Used / 5 years

AlwaysOn/Clustering/Mirroring/Log Shipping

Expert

Currently Used / 5 years

MS SharePoint 2007/2010/2013

Intermediate

Currently Used / 3 years

SQL,T-SQL, PL/SQL, SQL Developer

Expert

Currently Used / 10 years

OLAP/Crystal Reports

Intermediate

Currently Used / 5 years

ODBC/JDBC

Intermediate

Currently Used / 5 years

LYNC, Exchange, HP-PPM

Intermediate

Currently Used / 5 years

Linux(Red Hat)/Unix(HP-UC, Solaris, Aix)

Intermediate

Currently Used / 5 years

Oracle 8i/9i/10g/11g/12c

Expert

Currently Used / 10 years

Oracle E-Business Suite (EBS) 12.X

Intermediate

Currently Used / 3 years

Oracle Fusion Middleware/Applications

Intermediate

Currently Used / 3 years

Adobe AEM (CQ5) Architect and Admin

Expert

Currently Used / 3 year

ORACLE FORMS/REPORTS

Expert

Currently Used / 10 years

Oracle Apex/ BI Publisher Report

Intermediate

Currently Used / 2 years

TOAD/VMware/Oracle VM

Expert

Currently Used / 5 years

Enterprise Manager (OMS), OEM, RMAN

Expert

Currently Used / 10 years

Cluster, RAC and ASM

Expert

Currently Used / 8 years

ECLIPSE,ANT,J2EE,JAVA,JSP, JUNIT,DBUNIT

Intermediate

Currently Used / 5 years

GIT/SVN/Teamforge/Jenkins/Maven/Nexus

Intermediate

Currently Used / 3 years

IIS/ Apache /Tomcat/Weblogic/Websphere

Intermediate

Currently Used / 5 years

Python/Perl/PHP/Power Shell Scripting

Intermediate

Currently Used / 5 years

Kash/Bash

Intermediate

Currently Used / 5 years

PHP/Zend/Drupal

Intermediate

Currently Used / 2 years

Data warehouse

Intermediate

Currently Used / 3 years

.NET/C#/VB/VC++

Intermediate

Currently Used / 5 years

JAVA SCRIPT/VB SCRIPT/Dreamweaver

Intermediate

Currently Used / 5 years

ASP/ASP.NET/HTML/XML/CSS

Intermediate

Currently Used / 5 years

MobaXTerm/RDP/Nagios, Cacti

Expert

Currently Used / 5 years

Software Test/Unit Test

Expert

Currently Used / 10 years

Network and Server Trouble Shooting

Expert

Currently Used / 10 years

Computer Instructor

Expert

Currently Used / 10 years

15-6478 121 ST Surrey BC V3W 0Y5

Email: ********.*****@*****.*** Tel: 1-778-***-****

Linkedin: https://www.linkedin.com/in/geoffreyliu

Dear Sir or Madam:

Please consider my application for the position of “MS SQL DBA” with your company.

Undoubtedly, my skills and experiences match all your needs and I am the perfect fit for the role. I often work as bilingual and trilingual DBA (MS SQL, Oracle and MySQL). And I always make a difference and have played a key role in the companies where I have worked before.

With Master’s degree of Computer Science (Database systems). I have over 15 years’ experience in Database administration, database/application development using MS SQL 2005/2008/2012/2014, Oracle 8i/9i/10G/11G/12C and MySQL.

I am very quick study. I can master a new product or language or database in half a month by self-study. You know, there are always new products and technology in the market. This ability is very important.

I am very good at building the standard, improving processes and making strategy plan and project management as well as instructing, guiding and mentoring others.

I can work as MS SQL, Oracle and MySQL DBA as well as Adobe AEM (CQ5) Administrator to contribute my experience, skills gathering from different companies in my life.

My main experiences and qualifications include:

1. More than 15 years’ experience in database administration, database/application development with MS SQL 2000/2005/2008R2/2012/2014, Oracle 8i/9i/10g/11g/12c, EBS, SAP, and MySQL, Unix/Linux and Windows 2003/2008/2012 servers.

2. Extensive experience in IT management and Project management.

3. More than 10 years’ experience in SQL, PL/SQL & T-SQL.

4. More than 10 years’ experience in Software Development Life Cycle (SDLC) and QA.

5. More than 10 years’ experience in technical support and mentoring DBA and development team.

6. More than 10 years’ experience in developing/improving database administration process and standards.

7. More than 5 years’ experience in performing database and application tuning and capacity planning.

8. More than 10 years’ experience in relevant and emerging database technologies and tools.

I once worked as MS SQL DBA/Oracle DBA/AEM(CQ5) Administrator with STANTEC headquartered in Edmonton, Alberta. There are 12 DBAs here, but only me working as multiple tasks.

I look forward to discussing the position with you in more detail. If you feel my qualifications match those, which you are seeking, please contact me at your convenience. I may be reached at 778-***-**** (home) or I can be emailed at ********.*****@*****.***

Thank you for your consideration of my resume.

Best regards

Guangfu (Geoffrey) Liu

Enclosure: Resume

Contact this candidate