Sql Server Database Administrator
Resume:
Hai Yan (Henry) Liang
**********@*****.***
Sachse, TX, 75048
EDUCATIONS
June, 1993 - Jan, 1996: Master Degree. Major in Computer Science
Beijing University of Science and Technology
Sep, 1986 - July, 1990: Bachelor Degree. Major in Computer Science
Beijing University of Science and Technology
PROFESSIONAL CERTICIFATIONS AND TRAININGS
Microsoft Certified: Azure Database Administrator Associate – Dec 2021
10986 UPGRADING YOUR SKILLS TO SQL SERVER 2016 – Nov 2016
MCTP (SQL 2008 Database Administration) - Dec, 2012
Implementing and Maintaining Microsoft® SQL Server® 2008 Reporting Services (6236A) – May 2011
Implementing and Maintaining Microsoft® SQL Server® 2008 Analysis Services (6234A) – Sep, 2011
Designing, Optimizing, and Maintaining a Database Administrative Solution for Microsoft® SQL Server® 2008(50400A) – Dec 2010
Maintaining a Microsoft® SQL Server® 2008 Database (6231A) - Mar, 2010
Oracle 10g administration workshop II - Jun, 2006
Oracle 10g RAC course - Mar, 2005
Oracle 10g new feature course - Oct, 2004
Oracle 10g administration workshop I - Sep, 2004
Cisco Certified Network Associate (CCNA) - Sep, 2003
Oracle Certified Professional (OCP) DBA - DEC, 2000
Microsoft Certified Professional (MCP) - Jan, 1995
Veritas Cluster/Volume Manage/Netbackup Training - Nov, 2002
Solaris 9 system administration training - Jul, 2001
Microsoft Certification Course - Jan, 1995
Solaris 2.x system administration, network administration training - Oct, 1992
PROFESSIONAL EXPERIENCES
Oct 2008 - Current : Senior Database Administrator, Hudson Advisors, Dallas, TX, USA
* Lead/manage offshore DBA team
Achievements:
# Weekly meeting with offshore team and go through tasklist
# Provide guideline for all database admin areas
# Set example and mentor junior DBAs
# Manage oncall schedule as well as weekend maintenance
# Provide performance evaluation on quarterly basis
* Provide Senior DBA Service for SQL server systems
Achievements:
# Implemented Always-On for Corporate data warehouse
# Setup standard procedure for SQL server installation – naming convention, standard DBA jobs, email alert groups, etc
# Database troubleshooting and performance monitoring setup – DMV, Idera Diagnostic Manager, Central DB
# Annual SQL server true up and MAP tools scan – provide license report to management
# Provide database documentation – Redgate Doc
# Manage backup with native backup as well Idera SQL safe
# Implemented SQL server auditing using Idera CM
# SQL server patching and upgrade
* Provide Senior DBA service for Oracle databases
Achievements:
# On-call support for All Oracle databases – 9i, 10g, 11i, 12c, 19c
# Setup RMAN backup and align with company retention policy
# Setup OEM/GridControl for monitoring and alerting
# Handle Oracle audit and had working experience with Oracle Global Licensing & Advisory Services
Sep, 2005 – Oct 2008 : Senior Database Administrator, Overstock.com, Salt Lake City, UT, USA
* Primary DBA for Auction database (4 nodes RAC)
Achievements:
# Implemented RAC database backup/recovery procedure and strategy
# Setup and supported logical standby between ReadWrite and ReadOnly database
# Created monitoring framework and standardize it across the board
# participated in Oracle beta program and following the latest Oracle technology, such as Oracle 11g
# Setup database replication using EMC BCV technology
# Production/Standby Database performance tuning/monitoring/capacity planning
# Oracle OEM implementation
# Database application troubleshooting and TAR management
# Data Warehouse maintenance: Index rebuilding, Partition table/MV management
# Maintain DEV, REPORT, TEST, STANDBY, 3rd Party TEST Databases,
# Provide data replication between different environment
# PL/SQL, stored procedure, triggers, UNIX shell programming for database monitoring and development support
# Implement database cloning using BCV technology from EMC
# Database design/modeling with ERWIN
# Provide Internal Oracle training seminar, skill sharing and support documentation,
* Provide Senior DBA Service for shopping database (10 nodes RAC)
Achievements:
# Implemented RAC database backup/recovery procedure and strategy
# Setup and support DataGuard as a physical standby for production
# Database troubleshooting and TAR management, patch consulting
# Setup standard procedure for production ticket testing
# Provide database feature consulting for development team, such as bitmap indexing, partition/MV usage, converting LONG type to LOB
# Created customized GridControl Pages for quick access to database metrics
* Provide DBA service for other database
Achievements:
# On-call support for All Overstock databases
# Provide guidance for migration from 9i to 10g
Mar, 2003- Sep, 2005: Senior Database Administrator, Canada Post., Ottawa, Canada
* Database application development for Canada Post; Entity relationship analysis and database design; Database capacity planning and growth projection
Achievements:
# Trigger, stored procedure development using PL/SQL; Creating views for reporting;
# Logical, physical database model design and maintenance; Reverse engineering from existing database;
# Cooperate naming standard maintenance;
# Schema change management between development/QC/Production environments; Established change management procedures;
# Have extensive knowledge on database development tools, such as TOAD, ERWIN, Oracle Designer, Oracle Developer;
# Database space usage calculation and growth projection;
# Assisted development team on all database issues; Troubleshooting database problem, regarding connectivity, access privileges;
# Database support documentation development;
* Provide advise to management; Provide enterprise database administration service to Canada Post; Implemented Oracle Real Application Cluster firstly in Canada Post IT infrastructure and provide senior DBA support for RAC; SAP database back-end database administration;
Achievements:
# Provide senior DBA suggestions to management level; Participated in setup co-operation policy regarding enterprise security, enterprise DB monitoring, enterprise and backup implementation;
# Investigate open source database solutions, such as MySQL, MaxDB, PostgreSQL. And provide analysis report for management consideration;
# Carry out daily administration task using oracle database tools, such as OEM, RMAN, import/export, SQL LOADER;
# Canada Post database application support (24x7); Trouble/Change ticket tracking and monitoring;
# Database administration documentation creation and review (RunBook);
# Implemented the first Oracle 10g RAC production database for Canada Post in 2004; Key participant during architecture design, staging and production implementation of the 2-node RAC system, that consists components like ASM, CRS, RMAN, Grid Control, and Raw EMC devices ;
# Implemented RAC failover technology on both server and client side; designed and carried out failover test plan, which include all hardware failure and software failure scenarios.
# Oracle Grid Control installation and configuration; Database performance metric gathering and reporting ; Database alert configuration;
# SAP back-end database administration; Perform data warehouse administration and ETL tasks;
* Project highlights:
(1) Vote By Mail project - The Vote By Mail product is being developed specifically to address the Ontario Municipal Election
Software: Windows .NET framework; Oracle 9i, VERITAS VCS/VXFS file system, Sun Solaris; ERwin; TOAD;
Hardware: Sun E3500, EMC Symmetrix
# Concept integration phase and database development cost estimation;
# Reserve engineering from previous version of application;
# Database performance test and result analysis; Identify and fix performance bottle-neck on database side and assist development team on SQL tuning;
# Oracle database, Intelligent Agent implementation/configuration in a high availability environment;
# Database backup/recovery strategy design, testing and implementation;
(2) FETCH project - Fetch is an innovative new service that works with existing advertising channels to make advertising more interactive and effective.
Software: Sun One application server, Oracle 10g Real Application Cluster; Oracle CRS 10g, ASM, Oracle Grid Control 10g, Solaris 9;
Hardware: 2 x Sun E3000 Server, EMC symmetrix
# Sun Storage device installation and configuration;
# Oracle Cluster Ready Service installation and configuration;
# Oracle 10g RAC installation; ASM (Automatic Storage Management) configuration administration;
# Multiple database environment - DEV/QC/PRD - maintenance and synchronization;
# Backup/recovery strategy design, testing and implementation;
Feb, 2001-Mar, 2003: Senior System administrator/DBA, Bell Canada, Ottawa, Canada
* Oracle Database, Application Server administration of IP application - Billing, Email, DNS, Bell Intranet, etc
Achievements:
# Oracle Application/Database installation, implementation and procedure documentation
# Oracle Database backup implementation using VERITAS NETBACKUP and RMAN
# Production/Standby Database performance tuning/monitoring/capacity planning
# Oracle OEM implementation
# Oracle HA implementation and administration (EMC, Veritas, Solaris)
# Database application troubleshooting and TAR management
# Data reporting/analyzing with Oracle Discoverer
# Data Warehouse maintenance: Index rebuilding, Partition table/MV management
# Database design/modeling with Oracle designer/UML
# PL/SQL, stored procedure, triggers programming for database monitoring and development support
# Provide Internal Oracle training seminar and support documentation
* Provide 4th line technical support for SYMPATICO IP applications (Billing, DNS, AAA, User provisioning, mail, etc)
Achievements:
# 24x7 technical support on bi-weekly bases
# Unix Server installation and administration
# Unix script programming using Shell, awk, sed, perl for system administration, monitoring
# Unix Server installation and administration
# Troubleshooting/installing/configuring Cisco router/firewall/VPN products
# DNS, Radius, LDAP, MYSQL, SYMPATICO Mail system support and administration
# Develop technical documentation on daily operation and troubleshooting
* Project highlights
(1) SYMPATICO usage billing system implementation
Software: Oracle 8i, XACCT Usage, VERITAS VCS/VXFS file system/NETBACKUP, Sun Solaris
Hardware: 5 x Sun E250, 7 x Sun E3500, EMC Symmetrix
# Overall user accounting solution evaluation, design and testing
# working closely with different vendors to ensure the full success of the project
# Developed clear and deliverable plans for implementation
# Oracle database, Intelligent Agent implementation/configuration in a high availability environment
# Database backup/recovery strategy design, testing and implementation
# Database performance analysis and monitoring tool implementation
# XACCT Usage system monitoring scripts development
# Programming using Shell, C, Java, SQL to provide interact with other billing system
(2) Bell employee service intranet implementation
Software: Oracle DB, SAP BASIS, SAP HR, Sun Solaris
Hardware: 4 x Sun E3000 Server, EMC symmetrix
# BASIS administration and daily operation
# Database server installation and configuration
# Backup/recovery strategy design, testing and implementation
(3) Bell operation intranet (Oracle 11i Financial+ Oracle DB + Sun + VERITAS + EMC)
Software: Oracle 11i Financial (11.5.7), Oracle Web and J2EE, Oracle DB, Solaris, VERITAS VXFS/ VCS
Hardware: 4 x Sun E250, EMC symmetrix,
# System architect, evaluation, vendor selection
# Oracle 11i financial (GL/AR/AP) implementation, administration and monitoring
# Oracle Single Sign-On and Portal implementation/configuration, portal development
# EDI implementation (e-commerce gateway ) and system patching (maint. pack, mini-pack )
# J2EE applications development and deploy: Servlets, JSPs, J2EE applications, and Web services
# System/Database backup/recovery testing and implementation
# Standby database configuration to provide high availability as well as extra DSS capacity
# Technical documentation for Bell operation intranet
(4) Bell Canada DNS and IP management project
Software: Oracle8i, Lucent QIP, Solaris, VERITAS HA and VXFS file system
Hardware: 3 x Sun E3000, 10 x Sun E250, EMC Symmetrix
# Oracle database implementation, configuration in a high availability environment
# QIP system multi-node installation and testing (Remote servers, Enterprise servers, Audit manager)
# develop implementation/migration plan to insure smooth production transfer
# Window client installation and firewall rule setup
# Created demos for different DNS management team as a starting point
# System architecture and operation documentation
(5) Bell Customer service system implementation
Software: Oracle8i, Motive, Solaris, VERITAS HA and file system
Hardware: 4 x Sun E3000, EMC Symmetrix
# Database implementation, configuration and administration
# Backup/recovery strategy design, testing and implementation
# Motive application and client installation
(6) SYMPATICO user authentication (AAA) system
Software: Cisco Access Registrar (AAA), IPLANET LDAP, VERITAS HA and VXFS file system, Sun Solaris
Hardware: 4 x Sun E3000, 16 x Sun E250, EMC symmetrix,
# System architecture design, solution evaluation
# Migration plan development and testing for smooth production transfer
# System release during maintenance window
# Technical documentation writing
Jan, 2000-Feb, 2001: System administrator, Opensoft Consulting, Toronto, Canada
* Solaris system administration
Achievements:
# IBM Rational ClearCase installation and configuration
# Sun E3000, E250 Server installation and configuration
# NIS, NIS+, NFS administration
# Boot server configuration
# SAMBA server configuration and administration
* Linux system administration (SUSE, REDHAT), FreeBSD administration
Achievements:
# SAMBA server configuration
# Apache web server administration
* Oracle database administration
Achievements:
# Oracle database installation and configuration
# Oracle database backup and recovery implementation
* Network administration
Achievements:
# Cisco router and switch configuration
# Cisco PIX firewall configuration
# Remote access using VPN
May, 1998-Nov, 1999: IT department manager, ChinaBIG.com, Beijing, China
* Provided technical support for top level management and decision makers
* Managing technical team of 8 person
* Project highlights
(1) ChinaBig.com online yellow page project
Software: Oracle8i, Oracle Application Server, Solaris, VERITAS Cluster/Volume manager/NETBACKUP
Hardware: 4 x Sun E3000, Sun Storage array
# Business requirement analysis
# Vendor selection and solution evaluation
# Project management: implementation planning, consulting service management, etc
# Oracle Application Server, Oracle database Installation and configuration
# Backup/recovery strategy design, testing and implementation using RMAN and VERITAS NETBACKUP
# Sun cluster administration
# Database replication between stage system and production systems in Hong Kong and Beijing
# System and performance monitoring with Oracle OEM, OPENVIEW
# Web server configuration and content management
(2) CHINABIG CRM project
Software: Siebel CRM, windows NT, SQL server, IIS, Exchange Server
Hardware: HP PROLIANT server
# Business requirement analysis
# Project management: deliverable planning and tracking
# manage Siebel professional consulting team
# System and SQL server installation and administration
# Communication with Siebel professional support team
* Firewall and Web-trend administration
Achievements:
# Check point firewall administration
# Web statistic system installation, administration and report configuration
* Internet application administration
Jan, 1996-May, 1998: Professional Service Consultant, Oracle, Beijing, China
* Technical support via phone/email at call center
* Oracle product implementation service
Achievements:
# Database application business requirement analysis
# Database programming using SQL/PLSQL/Pro*C
# On-site database administration service
# Database migration from Sybase, SQL server, Informix, DB2
# Backup/Recovery implementation
# OEM installation/configuration
# Standby database configuration for high availability
# Database operation and management (security, storage, index, backup, etc)
# Database/WEBDB installation/configuration
# Provide technical support for system integration partners
# Project documentation
* People's Daily Online Publishing System" project
Achievements:
# Customer, vender relation management
# Web application programming using PL/SQL, Perl
# Oracle Database installation and configuration
# Oracle Enterprise Management server installation and configuration
Jun, 1990-Dec, 1993: System administrator, Beijing Telecom, Beijing, China
* UNIX system administration
Achievements:
# Solaris upgrading and patching support
# NFS/NIS/NIS+ implementation and troubleshooting support
# OPENBOOT troubleshooting and configuration support
# System performance tuning support
# Hardware diagnostic
* Network design and configuration
Achievements:
# LAN design and wiring
# Network troubleshooting
# Router and switch configuration
* Daily telephone support for customers
Contact this candidate