ZHENG ZHOU
adct7h@r.postjobfree.com
cell: 201-***-****
OBJECTIVE
Seeking a challenging Database Administrator position where I can utilize my excellent technical, written and verbal communication skills
PROFESSIONAL SUMMARY
Around 10+ years of IT experience in SQL Server Database Administration, System Analysis, Testing and Support of SQL Server 2017/2016/2014/2012/2008 in Production, QA and Development Environments
Experience in database migration from on premise to AWS and Microsoft Azure Cloud
Expertise in database administration activities such as Installation, Configuration, Upgrades, Backup/Recovery and Performance Tuning
Extensive knowledge of Relational Database Management Systems (RDBMS)
Expert in implementing High Availability and Disaster Recovery Solution such as SQL Server Failover Clustering and Replication
Expert skills in Performance Turning SQL Servers for Index Fragmentation, Query Optimization and Deadlocks
Expertise in database Backup/Recovery and Disaster Recovery procedures
Developed and documented Disaster Recovery plans and Backup/Recovery strategies for Production Environment
Experience in providing 24/7 Production Support
Excellent communication skills, organizing skills, highly punctual and an excellent listener
TECHNICAL SKILLS
SQL Software and Tools: SQL Server Profile and Query Analyzer, Database Turning Advisor, SQL Server Upgrade Advisor, SQL Server Reporting Services (SSRS) Configuration Manager
IDERA SQL Diagnostic Manager, Redgate SQL Monitor and Index Manager
Database Management Systems: Microsoft SQL Server 2017/2016/2014/2012/2008, Sybase, DB2
Operating Systems: Windows Server 2016/2014/2012/2008, Red Hat Linux and Unix (SunOS, Solaris)
CERTIFICATION
Sun Certified System Administrator for Solaris
PROFESSIONAL EXPERIENCE
Aero OpCo LLC. Lyndhurst, NJ 2015 – Present
Database Administrator
Managed All Production, QA and Development Environments running SQL Server 2017/2016/2014/2012/2008 on Standalone, Cluster and VM Ware Servers
Successfully worked with vendor, server and application teams to move vendor database to cloud environment
Reviewed daily operation of SQL Server database, database backups, transaction log backups, dbcc checks and SQL Server Agent jobs for errors
Installed and configured SQL Server 2017/2016/2014/2012 for company-wide Production, QA and Development Environments
Working experience of architecting and implementing High Availability and Disaster Recovery Solution such as setting up and configuring Failover Clustering and Replication for SQL Server Production Environment
Working experience with Amazon and Microsoft account manager and Solution Architect in migration from on premise SQL Server to AWS and Microsoft Azure Cloud
Experience using IDERA Diagnostic Manager and Redgate SQL Monitor/Index Manager to address database Performance Turning issues such as Blocking, Deadlock, Query Optimization and Index fragmentation
Created Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Rebuilding of Indexes
Implemented Data and Transaction log backups and restoration strategies for company-wide Production, QA and Development SQL Servers
Participated in the refreshing process for SQL Server 2017/2016 from Production Environment to QA/Development Environment as requested by application team
Installed and Configured SQL Server Reporting Services (SSRS) in Production environment for SQL Server 2016/2012 Failover Cluster
Performed User Account administration
WITZ CREDIT ADVISORY GROUP, LLC. Newtown, PA 2007 – 2015
Database Administrator
Documented processes involved in upgrading SQL Server 2008 to SQL Server 2012
Involved in Performance Tuning on Production, QA and Development SQL Servers
Improved performance of databases by analyzing indexes and fragmentation issues
Planned location of Data and Transaction log files on the disk
Implemented Data and Transaction log Backup/Recovery strategies
WASHINGTON MUTUAL INC. New York, NY 2003 – 2007
Database Administrator
Maintained various databases for Production, QA and Development Environments using SQL Server 2005/2000
Created Backup/Recovery strategies for Production, QA and Development SQL Servers
Involved in Monitoring Performance of different Production SQL Servers
Monitored SQL Server logs to ensure whether the backup operations, batch commands, scripts have completed successfully
PRUDENTIAL FINANCIAL, INC. Livingston, NJ 2000 – 2002
Database Administrator
Provided 24/7 SQL Server and Sybase database Production Support for Prudential Retirement Services Technology group
Created and maintained various databases and database objects using SQL Server Management Studios for Production, QA and Development Environments
Installed DB2 Universal Database client software for Prudential Mutual Fund Services Technology group
GOLDMAN SACHS GROUP, INC. New York, NY 1997 – 2000
Database Administrator
Performed 24/7 Sybase database Production Support for Goldman Sachs Equity and Prime Brokerage Technology group
Installed Sybase Database Servers on Unix platform
Developed Web-based front end applications to retrieve database backup information for Goldman Sachs DBA groups
EDUCATION
B.S.Computer Science City College of New York – School of Engineering