Resume

Sign in

Manager Sql Server

Location:
Posted:
April 16, 2020

Contact this candidate

Resume:

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



Contact this candidate