Post Job Free

Resume

Sign in

Sql Server Project

Location:
Vaughan, ON, Canada
Posted:
May 12, 2015

Contact this candidate

Resume:

[pic]

Gary Kovalski

Cell: 416-***-****

* ***** **., ******* *-mail: acpm3b@r.postjobfree.com

HIGHLIGHTS OF SKILLS AND QUALIFICATIONS:

. Extensive experience supporting major banks, government and

telecommunication companies

. Ten years of MS SQL database implementation, performance tuning and

design

. Extensive experience in SQL Server HADR solutions: Clustering,

Database Mirroring, Replication and Log Shipping

. Experience supporting very large SQL server environments around 700

instances

. Experience implementing Always On high availability platform

. Security clearance Level 2 (Secret)

. In depth knowledge of SQL Server disaster recovery techniques

. Solid background in computer system administration - Windows

Server, Active Directory, Networking systems, monitoring and backup

applications

. Exceptional analytical, problem-solving, organizational, time

management skills

. Well rounded energetic, conscientious team player

SPECIALIZED KNOWLEDGE:

. Database: MS SQL 2000/2005/2008/2012, Oracle 8i, 10g, MySQL 5.0

. Operating System: MS Windows Server 2003/2008/2012, Linux

. Storage Systems: EMC SAN

. Backup software: Veritas NetBackup for MSSQL, TDP (Tivoli Data

Protection) for MSSQL

. Creating technical documentation

. Programming Languages: Transact-SQL

. Reporting Applications: Microsoft reporting services

2005/2008/2012

EXPERIENCE AND ACHIEVEMENTS:

IBM, Toronto, Canada

Senior Production Database Administrator

2010 - Present day

. Performed role of Account Focal for two large company's clients. The

role required interacting with business, project managers and

application support units. Planning and scheduling routine tasks,

maintaining projects portfolio as well as providing guidance for team

members. Assisted in standardizing processes across the team and

audit preparations

. Implemented database migrations including metadata and security

principles from various versions of SQL Server : 2005--2008; 2008-

2012

. Led number of projects which required designing, installing and

configuring SQL Server 2012 subsystems including clustering and Always

On solutions

. Provided 24x7 operational support on SQL Server systems for number of

company's clients

. Designed and implemented SQL 2008 Transparent Data Encryption for

number of projects.

. Implemented, tested and provided high availability using SQL 2008

Replication and Database Mirroring

. Designed, tested and implemented application database migration to

multi-node multi-instance SQL 2008 Cluster. Project included migration

of DTS packages, Reports and Analysis services cubes

. Provided support for SQL 2008 and 2012 database servers, including

capacity planning, performance tuning, backup and recovery as well as

security management

. Led numerous Disaster Recovery exercises for number of clients

. Analyzed and resolved complex technical problems, worked with

Microsoft support team

Exxon Mobil (ESSO), Business Support Center, Toronto, Canada

Database Administrator, EMIT group

2007 - 2010

. Led project of migrating SQL 2005 instance to SQL 2008

. Designed and implemented SQL 2008 Policy based management

. Implemented, tested and documented SQL 2008 Mirroring technology

. Performed MS SQL database server administration and maintenance

running in multi server environment including multiple SQL instances

of 24x7 used as backend for variety of applications

. Designed and implemented Sharepoint backend infrastructure

. Designed, tested and implemented large scale DTS to SSIS migration

Provided training to developers

. Designed and implemented scripted automatic configuration of newly

built servers leveraging SSMS solutions capability

. Implemented improvements to QA system used by DBAM team members

reducing time required to perform quality assurance of SQL system

. Designed and developed maintenance plans SSIS packages to be

distributed automatically to any new SQL 2005 server. Project

resulted in reducing at least of half an hour of manual work per

server

. Tested and implemented LiteSpeed backup application on the development

and production environments

. Implemented and operated SOX compliant databases

Intel Semiconductor, Intel Development Center, Haifa, Israel

Database Administrator, Engineering computing division

2004 - 2007

. Performed MS SQL database server administration and maintenance

running in multi server multi instance environment including 15

clustered instances of 24x7 served as backend for Chip Design and

validation applications.

. Designed and implemented SQL server consolidation project

consolidating stand alone servers into unified powerful multi node

cluster.

. Project resulted in significant improvement of databases

availability, performance, eliminating physical servers and

substantially reducing TCO

. Designed and implemented reduced downtime inter-server database

migration technique. This method minimized database down time to

several minutes compared with several hours when using traditional

approach to database migration. The technique combined usage of

Veritas Net Backup and SQL server native backup capabilities. The

technique was globally inherited among Intel sites.

. Explored and implemented I/O distributed database concept. Project

resulted in substantial decrease in server I/O contention over disk

resources while minimizing amount of drive letters used in multi

instance environment.

. Performed testing and production implementation of SSIS clustering.

Consolidated diverse SSIS environments increasing availability,

performance and manageability of the service. Performed DTS

migrations.

. Handled various types of database backups and restores. Provided

customers with point in time restore allowing recovery from user

errors. Assisted in development of backup and recovery standards for

Engineering Computing database operations team.

. Assisted application developers in optimizing and tuning database

performance following best practices of capturing SQL activities,

identifying long running queries, analyzing execution plans and

building indexes

. Performed high availability solutions based on database mirroring and

snapshots

EDUCATION:

Bachelor's Degree in Computer Science

1993 - 1998

Haifa University, Israel

. OCA certification in Oracle Database Server 10g R2

. MCTS certification in MS SQL 2005 Server

. MCTS certification in MS SQL 2008 Server

. MCSE 2000 certification

. MCSE 4 certification

REFERENCES:

. Available Upon Request



Contact this candidate