[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