Network Engineer Sql Server

YING GAO

312-***-****

*** ***** ***** ****** ******* IL 60605

*********@*****.***

US citizen

OBJECTIVE: Senior System Network Engineer

Skill Highlight:

Strong System Network Administration with Heavy Scripting Skills and SQL/SSIS development

Strong Troubleshooting skills

Smart individual with excellent communication and a great team worker

Over 10 years in-depth hands-on experience in Cisco Networking including installing and configuring the Cisco ASA 5510/5512, ISR4 4431 Router, 3750/3560 Switches. Plan, design and implement multiple sites nationwide, configure site to site VPN, Microsoft aZure Cloud, remote access, routing and manage security. Configure and manage multiple VLANs. Troubleshoot all network related issues.

Over 15 years of in-depth hands-on experience in Windows Server administration including design, deploying, administering, tuning, troubleshooting Domains, DC, Exchange (2013 and 2003)), Office 365, ADFS 2.0 SAML 2.0, SQL (2016, 2014, 2012, 2008), Terminal, IIS, BES, DPM, Symantec Messaging Gateway, TrendMicro Enterprise Security, EMC Enterprise Avamar Backup and DR solution. Hands-on experience with Office 365, Druva Cloud Backup, zScaler Cloud Web filter system.

Over 8 years of heavy Scripting experience with Perl and VBscript, PowerShell for various system admin task and SSIS for Data Integration between different platforms and SSRS Reporting.

3 years in-depth hands-on administration of VMWare vSphere 5.5 (multiple clusters), IBM Blade Center, Blade Server, Fujisu SAN.

Expertise working on SQL Server installation and configuration, backup and recovery and performance tuning. Extensive hands-on experience in SQL Server T-SQL and Stored Procedure.

In-depth working knowledge on various industrial proprietary applications, i.e. Dynamics GP, Vital

Proficiency working on EDI package support including Gentran, Trading Partner and Lexicom AS2

Excellent verbal and written communication skills and great team worker.

EXPERIENCE:

Sr. System Network Engineer/Automation 2015 – Present

Family Health Network (Chicago, IL)

Lead network engineer and system administrator to support an infrastructure of over 500 hundred users and over 50 servers at multiple sites. Configure and manage the VMWare infrastructure on vSphere 5.5 with IBM Blade Center, Fiber channel switches and Fujitsu SAN. vCloud migration and management. EMC Avamar enterprise backup and Cloud based Druva backup system. zScaler cloud web filter application. Install and configure Cisco ASA 5512 failover, site to site VPN and remote access. ISR 4431 VPN to Microsoft aZure Cloud Service. Avaya Switches ERS4000 series. Migration from Exchange 2013 to Office 365. Trouble shoot mail flow issues. Manage Symantec Messaging gateway. Server management and complex Group policy management. ADFS 2.0 SAML 2.0 Configure Aruba Wireless. Support Avaya Aura IP Phone system. Deploy Windows, Mail and Database Servers. Data Integration between various platform including FTP, sFTP, SQL and flat files, using different tools, including SSIS, different scripting language i.e. VBscript, Perl, PowerShell, and GoAnywhere. Support JIRA application. Support Business Tier 1 applications. Troubleshooting system performance issues. Work with different teams within IT. Work with Vendors on the evaluation and deployment of the new technology. Provide recommendations to the management and guidance to the junior level peers.

Lead System / Network Engineer 2005 – 2015

Turano Baking Company (Berwyn, IL)

Serve as the main senior technical person in the department to support a network of 5 nationwide sites and 300+ users. Plan, implement and maintain the infrastructure, network, servers, databases and all applications. Responsible for all technical operations including VM and Hyper V infrastructure, wired and wireless Cisco networks, all Windows servers, Exchange, SQL databases, SQL and Crystal reporting, scripting, integration and automation among different systems, .Net development, Backup solutions, Web filter and EDI, etc. Provide high availability on systems by providing seamless data access and maximum up time.

Implement and maintain the connectivity among 5-sites nationwide WAN including MPLS, L2L VPN and remote access. Implement and manage LAN including multiple VLAN and routing/switching infrastructure with all Cisco devices (ASA5510 firewall, 3750/3560 switches) and wireless networks. Implement Sophos web filter appliance. Troubleshoot network and system performances issues.

Implement and manage all Windows servers and server applications running on Hyper V infrastructure, Exchange 2010, SQL 2008/2005, Terminal server 2008/2003, IIS, BES, FS and Print, etc. Develop Perl and VB script to automate administration tasks. Manage server backup with DPM and Symantec backup exec.

Configure, backup, troubleshoot MS SQL databases and develop complex T-SQL and Stored Procedures. Develop complex SQL Server Reports and Crystal Reports. Develop integration among different systems to automate the business processes with scripts. Develop web applications with .Net and SQL. Develop touchscreen applications for production with VB and SQL. Support EDI systems with Gentran, Trading Partner and Lexicom AS2 applications etc. Provide in depth support and customization to MS Dynamics GP application.

Network Administrator 2001 –2005

Chicago Gasket Company (Chicago, IL)

Manage Windows servers and Novell Netware server network. Install, configure and troubleshoot all servers, desktops, laptops, printers, firewall, router, switches and hubs, mobile devices, etc. Manage Active Directory and network security (Firewall, Anti-virus and Remote Access). Manage file system backup/restore with Symantec Backup Exec. Setup and configure GPO, DNS, DHCP, user/group permissions, file and print sharing and email services. Provide second level help desk support. Install and upgrade computer hardware and Operating System. Develop network documentation. Purchase computer equipment and related software. Maintain software and hardware licensing and support contract. Provide recommendations to the company. Serve as main technical contact to the outside vendors.

Support HP-UX UNIX system 10.0 (Schedule cron job, manage user/group account, configure jobs in SAM, etc.). Install applications/patches. Configure Backup and Recovery.

Transition Novell Netware file server to Microsoft Windows Server platform. Develop Application with MS Access, Visual Basic and Crystal Report.

CERTIFICATE:

- CCNA (Cisco ID: CSCO10993933)

-MCSE (Microsoft ID: 3259660)

- MCTS (SQL Server 2005)

TRAINING:

-Microsoft: SQL Server, SharePoint 2013, SSIS development

-Cisco: ASA firewall

-VMWare 6.0 Administration

-Programming: VBA, Crystal Report, Dexterity for Dynamics

EDUCATION:

-Master of Science in Computer Science, DePaul University, Chicago, IL, 2003

-Bachelor of Science in Information Systems, Science & Technology University, Beijing, China, 1995

Contact this candidate