Support Sales
Resume:
CHUAN ZHOU
LOS ALTOS, CA *****
******@*****.***
(US Citizen)
Goal
I am looking for a permanent full-time position as SQL Database Administrator or SQL Developer in San Francisco Bay Area.
SUMMARY OF QUALIFICATIONS
More than 20 years of working experience as MS SQL Database Administrator and System Administrator across multiple industries. Hands-on experience in the following areas: Microsoft SQL 2008, SQL 2012, SQL 2014, SQL 2016, SQL 2017 and SQL 2019; Microsoft Always on Failover cluster FCI; SQL Always On Availability Group; SQL Reporting Service (SSRS); SQL Integration Service(SSIS); 24x7 production support, performance monitoring and optimization using MOM/SCOM, SQL Profiler, T-SQL and PowerShell scripts; SQL Database High Availability (HA) and Disaster Recovery (DR) design and implementation; Log shipping, database mirroring setup and configuration; Replication setup and maintenance; Data integration between different platforms using Oracle Golden Gate; DTS and SSIS package and ETL design; Database design and implementation; SQL security hardening implementation. TDE and TLS 1.2 implementation. SQL server planning and implementation on physical machines, in VMWare environment, and in Microsoft Azure Cloud; SQL server upgrade and Migration; Developing SQL queries, triggers, and stored procedures using T-SQL. Solid understanding and experience on Windows Operating Systems and LAN/WAN which help in designing and implementation of enterprise data structure. Well experienced with storage planning and implementation in SQL deployment. Good understanding of network principals and it impacts on SQL architect design. Pay attention to details and true believer of technical documentation. Self-motivated and problem solving oriented. Ability to work under pressure and multi-tasking. Good communicator and a team player. A solid academic background with multiple advanced degrees in engineering and science.
WORKING EXPERIENCE
MSSQL DBA (MTS1) 11/2016 – 11/2020
PayPal Inc. (San Jose, CA)
●Worked as a senior member of MS SQL DBA team that manages over 500 MS SQL instances supporting over 80 applications.
●Performed architecture design of database structure to meet application HA/DA requirements using latest Microsoft SQL technologies and features.
●Provided SQL support throughout the full life cycle of applications, from onboarding, installation, go live to upgrade, and decommission.
●Participated in making Corp IT SQL database security standards and led the SQL server hardening project to implement security measures on all PayPal SQL servers.
●Led projects in SQL server security hardening implementation and monitoring. Brought all SQL servers in compliance with company security requirements.
●Improved SQL security patching process and kept all SQL servers in compliance with company’s vulnerability remediation requirements.
●Automated SQL monitoring and auditing processes.
●Worked with Microsoft resources to adopt new SQL technologies and implement best practices, as well as on resolving critical production issues.
●Participated 24X7 on call rotation to support production systems.
●Provided SQL performance tuning and SQL coding for application team.
●Mentored junior DBA and documented SQL team operation processes and knowledge base.
Senior Database Administrator 03/2014 – 11/2016
Netapp Inc. (Santa Clara, CA)
●Operational support for production databases in Corporation Datacenter.
●Responsible for the overall planning of database infrastructure. Including database backup strategy. Data transfer and synchronization among multiple production sites and corporation data centers.
●As the most senior Database Administrator in the Corp operation group, heavily involved in database design in our in-house developed production testing and reporting applications.
●Played a lead role in data center migration project and other database/application upgrade and migration projects.
●Optimize and tune corporate application databases. Troubleshooting database performance problems.
●Participated in a 24x7 on-call duty rotation.
●Managed Service-Desk tickets and Database Administration Service-Desk ticket queue.
●Provided documentation and record keeping as directed by management.
Lead Analyst 11/2011 – 03/2014
New York Stock Exchange (NYSE) (San Francisco, CA)
●Provided support of NYSE Post Trade Systems which include Billing, Clearing, Accounting, and Regulatory reporting.
●Played a hands-on support role that performs all aspects of data and database administration, release management, process automation and application support.
●Participated in designing and reviewing existing Disaster Recovery, High-Availability, data archiving, capacity planning, performance and tuning.
●Performed daily support activities which include: development, Quality Assurance & production releases, production support, data requests, problem analysis and application support.
●Provided 24 x 7 on call duty for production systems alone with other team members.
●Provided training for offshore consultants and documentation of supported production processes and troubleshooting knowledge base.
Senior SQL Database Administrator 08/2010 – 11/2011
IBM (San Jose, CA)
●Provided support for over 400 SQL servers in production, testing, and development environments.
●Worked in a team environment and provided level 3 support on various SQL issues for clients.
●Played key roles in various projects as leading SQL DBA resource. Provided SQL resource in database architect, high availability, disaster recovery design, capacity planning, and implementation using Veritas cluster and NetApp SAN storage devices.
●Enriched hands-on experience in setting up SQL cluster, log shipping, database mirroring, and replication.
●Participated in performance tuning on key production systems. Identified the system bottlenecks and provided solutions.
●Involved in SQL server monitoring and management development.
●Worked with other team members to build up a SQL knowledge base that greatly improved the team trouble shooting efficiency.
Senior SQL Database Administrator 03/2008 – 07/2010
eBay Inc. (San Jose, CA)
●Provided 24 x 7 support for over 60 eBay/PayPal production SQL servers.
●Participated and played an important role in various application setup and upgrade projects as leading DBA resource.
●Responsible for initial setup and configuration production SQL server clusters using SAN storage devices.
●Worked with application engineers on database architecture design, capacity planning, backup schema design and implementation, and planning and implementing disaster recovery scheme by log shipping.
●Carried out performance tuning, monitoring and troubleshooting for key production SQL servers. Identified system bottlenecks and provided solutions.
●Provided technical support for application engineers and application end users on database issues.
●Trained junior DBAs and transferred knowledge related to our SQL environment.
●Documented and maintained working knowledge base and SQL inventories.
SQL Database Administrator 12/2006 – 03/2008
PLAYPHONE INC. (San Jose, CA)
●As the DBA lead, planned and implemented Payphone’s Production, QA, and development SQL server environments.
●Responsible for 24x7 production SQL server support. Performance monitoring and improvement.
●Designed and implemented database backup and disaster recovery plan.
●Successfully planned and implemented the migration of production SQL server to a new data center with minimum downtime.
●Played a major role in implementing replication and reporting systems for executives and marketing.
●Worked closely with developers in database design and other application development tasks.
●Tutored junior DBA and developers on how to write efficient SQL queries. Provided technical support for all database users in different departments across the whole company.
Database Administrator 09/2005 – 12/2006
R2 TECHNOLOGY INC. (Sunnyvale, CA)
●As a key technical lead, successfully migrated R2’s CRM system from an old platform into SalesForce.com. Saved company tens of thousands of dollars in consulting fees in the project using my SQL Server and IT knowledge.
●Worked with Oracle SalesForce.com to develop an application that integrated SalesForce.com with our internal sales system.
●Responsible for upgrading, maintaining, backing up databases, and supporting end users of 12 applications for Sales, Manufacturing, Service, Engineering, Accounting and Finance departments. Worked with each department to design and implement data integration among applications.
●Developed and implemented backup and disaster recovery strategy for 8 application databases.
●Provided business intelligent reports and ad-hoc queries for QA, Sales, Accounting and Executives.
Senior Network and System Administrator / SQL DBA 11/2001 – 09/2005
APPLIED UNDERWRITERS INC. (San Francisco, CA)
●Setup, configured, and maintained 7 Microsoft SQL 2000 Servers located in 6 different corporate offices.
●Design and implement database backup and disaster recovery strategy for Applied Underwriters.
●Worked with application developers in design database, security policy, and optimize SQL servers’ performance.
●Developed Business Intelligent reports and queries for the Sales department and Executives.
●As the leader of the IT group, successfully migrated corporate network, which include over 30 Windows 2000/2003 servers and 300 + workstations in 6 different geographic locations, from NT 4.0 to Windows 2000 active directory.
●Redesigned corporate WAN/LAN structures. Established VPN tunnels among headquarters and 4 branch offices. Setup firewall and DMZ to improve network security.
●Other responsibilities include: Provide technical advice to executives on IT budget planning; Hardware and software purchasing; Working with vendors and consultants on various IT projects.
Database Administrator (MSSQL and Oracle) 08/1999 – 11/2001
HOMESTEAD TECHNOLOGIES (Menlo Park, CA)
●Worked as DBA in a mixed MS SQL and Oracle server environment, supporting the company's 24x7 production database. Performed routine tasks of database configuration, monitoring, tuning, daily backup and restore.
●Worked with software developers in database design. Developed and implemented a QA process to test and optimize new SQL scripts and application embedded queries before applied to live site databases.
●Planned and implemented MS SQL server migration from Version 6.5 to 7.0.
●Worked with consultants in a MS SQL Server to Oracle migration project.
SQL Server DBA and System Administrator 05/1998 – 08/1999
ACME SOFTWARE INC. (Santa Clara, CA)
●Worked as SQL server DBA. Responsibilities include: SQL Server setup; Design and implement backup strategy; Replication setup and configuration; Data transfer and synchronization among databases; SQL server monitoring and troubleshooting; SQL server performance optimization.
●Designed and implemented database data and security schemas. Developed SQL server stored procedures and triggers.
●Upgraded SQL servers from Version 6.5 to 7.0.
Information Specialist 08/1996 – 04/1998
PARSYSTEMS INC. (Albany, NY)
●Worked as a Windows NT system administrator. Setup and maintained 10 Windows NT servers, over 100 Windows NT/95 workstations, and about 20 HP network printers. Provided technical support for over 100 internal users.
●Maintained a Data General AV8500 system (UNIX) and about 80 terminals.
●Worked on Oracle database development projects. Used Oracle Developer/2000 to develop financial and management databases.
●Performed help desk function for clients who purchased our product.
EDUCATION
STATE UNIVERSITY OF NEW YORK AT ALBANY, Albany, New York
Master of Science in Computer Science
STATE UNIVERSITY OF NEW YORK AT ALBANY, Albany, New York
Master of Science in Atmospheric Science
CHINA ACADEMY OF TELECOMMUNICATIONS, Beijing, China
Master of Science in Electrical Engineering
TSINGHUA UNIVERSITY, Beijing China
Bachelor of Science in Electrical Engineering
Additional Information: Citizen of the United States.
Contact this candidate