Post Job Free

Resume

Sign in

Technical Support Sql Server

Location:
Carmel, IN, 46032
Posted:
September 16, 2015

Contact this candidate

Resume:

YING ZHANG

**** ***** **. ****** **, *****

Phone: 317-***-****, 765-***-****(c), E-mail: acrpt3@r.postjobfree.com

HIGHLIGHTS OF QUALIFICATIONS

19+ years working experience and knowledge in application lifecycle management and various IT platforms: Enterprise Servers (HP, SUN, DELL), OS (UNIX, Linux, MS Windows), DBMS (MSSQL, Oracle, MySQL) and CISCO Network.

Proficient in system administration and technology support.

Skilled in SQL, T-SQL, PL/SQL, C/C++, UNIX Shell Scripting and Centrify and Puppet tools.

Creative thinking and troubleshooting, strong organization and management skills, and demonstrated ability to work on multiple projects simultaneously.

A great team player, quick learner, highly self-motivated, efficient and responsible.

Excellent communication, interpersonal and documentation skills.

WORK EXPERIENCE

System Administrator (RH Linux, CentOS, ORACLE) 2015 /01 - /03

Indiana Health Information Exchange (IHIE), Indianapolis, IN, USA

Maintained and troubleshot 200 RHEL Servers.

Installed and configured CentOS and Oracle Server.

Migrated VMware vSphere EXSi4.0 virtual machines.

Monitored Linux Servers with Opsview.

Set up and troubleshot LOG Server, Log4j.

Maintained and configured LOG Server and Opsview Server.

Maintained and troubleshot Tomcat applications.

System Administrator (RH Linux, MS Windows, ORACLE, MSSQL, MySQL) 2014 /04 - /10

BCforward, contracted to Indiana Department of Education, Indianapolis, IN, USA

Designed and Implemented solution for Oracle Red Hat Enterprise Linux System Migration.

Installed and configured VMware vSphere EXSi5.5 host and visual machines.

Installed a Hadoop Server and Postfix MTA server on CentOS.

Maintained and troubleshot RHEL Servers for DNS, FTP, SFTP, Send mail, Mailman and so on.

Installed MS SQL Server 2012 Failover Cluster with two MS Windows 2012 nodes, Domain Controller, DNS, IIS and Network Load Balancing Cluster.

Set up Moodle Learning Management System on MS Windows 2008 R2 Server, MS SQL Server 2008, Apache and PHP.

Installed and configured Track-IT and ePO on Windows Server 2008 R2 Enterprise and MS SQL 2008.

Maintained and troubleshot for DELL Appassure5 and Symantec Backup Exec backup servers.

Provided technical support for Dell KACE K1000 and K2000, and trained other IT support staffs.

Systems Analyst III (RH Linux, MS Windows, MSSQL, MySQL) 2002-2013

Department of Population Health Research (PHR), Alberta Health Services, Calgary, Alberta, Canada

Solution Architecture

-Provided technical leadership and solution architecture, improved IT infrastructure value to achieve health research business objectives and successful project delivery.

-Collaborated with research scientists, vendors and IT strategy team to ensure technology solutions were consistent with business requirements and to maximize cross-functional alignment.

-Evaluated exiting assets and estimated business value to support the development of a business case for technology investment.

-Designed and constructed high performance and low cost integrated platforms to meet business requirements and saved hundred thousand dollars in IT infrastructure investment, including MSSQL central database server, project based file server, archive server, VM servers, research project Data Dictionary and key application servers.

-Developed and executed standardized procedures for effective project implementation.

-Led security strategy development and performance optimization.

Server Administration

-Performed all administrator functions to manage and maintain the all department servers.

-Maintained 14 servers (MS Windows, Red Hat Linux and Solaris) for a variety of applications (MSSQL, FS, VM, SAS, STATA, R, Subversion, LAMP/IIS, TeleFrom, Freezerworks and CPAC&OPAL).

-Installed and configured new hardware and software.

-Applied Operating System updates, patches and configuration changes.

-Monitored, tuned and optimized server performance.

-Analyzed system logs and identified potential issues.

-Managed user accounts.

Database Administration

-Maintained 9 database systems (MSSQL, MySQL, and Oracle) in the depertment.

-Executed database system installation, configuration, and update.

-Maintained database and ensured availability to users.

-Managed database users and secured database.

-Monitored and optimized database performance.

-Backup and recovered database and transferred data.

Client Service and Leadership

-Managed software development life cycle, including business requirement analysis, evaluation, design, construct, support, optimization and retirement.

-Implemented and optimized practical guidelines regarding data security and related software and hardware, and generated system documents.

-Mentored and trained junior IT team members; provided high level technical support and training to users in responding to help desk requests.

Senior System Analyst, Architect (UNIX, Win2000/NT, ORACLE and Network) 1998-2001

Computer Center of CHINA TELECOM, Dongguan, Guandong, China

-Provided technical leadership and project management for infrastructure architecture to achieve successful business development and strategy execution.

-Contributed to solution analysis and system architecture, including analysis, design, planning, data integration, interfaces and implementation.

-Worked with business partners, vendors and IT strategy team to align technology solutions with business requirements.

-Worked as a project leader to develop Telecom Service Integrated Management System (TSIMS) to improve telecom service operation and management. Achieved data sharing and highly automatic telecom service on a unified computer network platform. Saved company millions dollars in business processes and data management per year.

-Participated in the development of Telecom Network Management System (TNMS) to achieve remote centre management and real-time monitoring of Telecom Switching Exchanger Systems. Saved company millions dollars in data collection and troubleshooting.

-Constructed an Enterprise Integrated Network (EIN) platform to improve enterprise network performance.

-Generated project documentation; trained team members and operators.

System Administrator (UNIX, ORACLE and Win2000/NT) / Programmer 1993-1997

Computer Center of CHINA TELECOM, Dongguan, Guandong, China

-Provided technical support and system administration.

-Installed, configured, tested and administrated system hardware and software.

-Developed and implemented backup and recovery strategies.

-Designed programs using C, Pro*C, PL/SQL and Oracle Developer 2000.

PROFESSIONAL CERTIFICATES

"Oracle Performance Tuning", "Oracle DBA Fundamentals II", "Oracle 11g SQL and PL/SQL", "Oracle DBA Fundamentals I" (2011, 2012)

"Maintaining a Microsoft SQL Server 2005 Database", "Implementing a Microsoft SQL Server 2005 Database", "Microsoft SQL Server Administration" (2006, 2007)

"Oracle Database and Applications Design Technology" (1996)

"UNIX Administrator", "DEC Alpha Servers", "HP 9000 series Servers", "Disk Array", "Digital Unix Tru-Cluster", "Memory Channel Technology" (1994, 1997)

"CISCO Switch/Router", "Computer Network and Communication", "CA Unicenter TNG Network Management" (1995,1998, 2000)

EDUCATION

B.Sc. Electronics and Information Systems, Ocean University of China 1993



Contact this candidate