Sql Server Database Administrator
Resume:
Gary Kovalski
Cell: 416-***-****
e-mail: ****.********@******.***
HIGHLIGHTS OF SKILLS AND QUALIFICATIONS:
Extensive experience supporting SQL production environments at Royal Bank, Sun Life Financial, IBM and Exxon Mobil
15 + years of experience with 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: 700+ instances
Experience implementing Always On high availability solutions
Experience with Azure Cloud platform
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 2008/2012/2014/2016/2019
Operating System: MS Windows Server 2008/2012/2016, Linux
Storage Systems: EMC SAN
Backup Software: Red Gate, Veritas NetBackup for MSSQL, EMC Networker, TDP (Tivoli Data Protection) for MSSQL
Encryption Technology: Thales (IBM) Guardium GDE
Creating technical documentation
Programming Languages: Transact-SQL, Powershell
Modeling applications: ERWIN data modeler
Reporting Applications: Microsoft reporting services 2008/2012/2014/2016/2019
Azure Data Studio
EXPERIENCE AND ACHIEVEMENTS:
Royal Bank of Canada (RBC), Toronto, Canada
Senior SQL Server Database Administrator, DNA group May, 2024 – August, 2024
Supported wide portfolio of bank applications, on prem as well as in Azure cloud, acting as focal point for SQL related matters, while providing services to application teams and project managers
Provided operational production support to variety of SQL server versions –2012, 2014,2016 and 2019, on consolidated and standalone environments
Performed database refreshes, promotions to production and migrations, including migrations to Azure MI
Conducted application database regression tests, leveraging server side trace and analyzing collected performance data with RML utilities
Analyzed query performance, detected top resource consumers, recommended on database physical structures
Supported and maintained backup and recovery processes leveraging EMC Networker software
Designed and implemented table Partitioning for number of applications
Promoted logical database models to physical structure, leveraging ERWIN data modeler
Developed and implemented T-SQL and PowerShell scripts supporting operational processes and automation
Collaborated with other team members and technical support groups
Royal Bank of Canada (RBC), Toronto, Canada
Senior SQL Server Database Administrator, DB Systems group May, 2023 – April, 2024
Implemented various infrastructure projects, leveraging PowerShell automation including:
-Installation and configuration of Windows clustering components
-Deployment of SAN storage for FCI
-Configuration of networking
-Installation and configuration of SQL Server as multi-node and multi instance cluster
Deployed, configured and supported Always ON for SQL server
Supported and maintained backup and recovery processes leveraging EMC Networker software
Supported user requests on SQL platforms from SQL 2014 to SQL 2019
Developed and implemented transition from standard Active Directory SQL service accounts to gMSA accounts
Resolved various performance problems related to infrastructure
Royal Bank of Canada (RBC), Toronto, Canada
Senior SQL Server Database Administrator, DNA group December, 2020 – April, 2023
Supported wide portfolio of bank applications, on prem as well as in Azure cloud acting as focal point for SQL related matters, while providing services to application teams and project managers
Provided operational production support to variety of SQL server versions –2012, 2014,2016 and 2019, on consolidated and standalone environments
Performed database refreshes, promotions to production and migrations, including migrations to Azure MI
Conducted application database regression tests, leveraging server side trace and analyzing collected performance data with RML utilities
Analyzed query performance, detected top resource consumers, recommended on database physical structures
Supported and maintained backup and recovery processes leveraging EMC Networker software
Designed and implemented table Partitioning for number of applications
Promoted logical database models to physical structure, leveraging ERWIN data modeler
Developed and implemented T-SQL and PowerShell scripts supporting operational processes and automation
Collaborated with other team members and technical support groups
Sun Life Financial, Toronto, Canada
Senior SQL Server Database Administrator January, 2019 – December, 2020
Delivered SQL Server infrastructure projects including new server deployments, database and server migrations in standalone and clustered environments
Established and maintained written best practices, supporting SQL server operation by creating technical documentation
Implemented various SQL performance tuning techniques to stream line data processing
Supported and maintained backup and recovery processes leveraging Red Gate and Networker software
Provided operational production support to variety of SQL server versions – 2008, 2012, 2014 2016 and 2019, including additional platform components such as Integration, Reporting and Analysis services
Deployed and supported Always ON an Database Mirroring high availability solutions
Implemented SQL server on IaaS VMs in AWS cloud
Designed, implemented and supported SSRS infrastructure, including scale out deployments, migration and security
Developed and implemented T-SQL and PowerShell scripts supporting operational processes and automation
Implemented and deployed database encryption leveraging IBM Guardium Data Encryption technology
Planned and implemented patching for SQL server instances including Service Packs and CUs
Collaborated with other team members and technical support groups
Supported SOX audits from SQL infrastructure perspective
Leveraged Change Management Process for deployment cycles, adhering to company standards
Royal Bank of Canada (RBC), Toronto, Canada
Senior SQL Server Database Administrator, DNA group May, 2018 – December, 2018
Supported wide portfolio of bank applications, acting as focal point for SQL related matters, while providing services to application teams and project managers
Provided operational production support to variety of SQL server versions –2012, 2014,2016 and 2019, on consolidated and standalone environments
Performed database refreshes, promotions to production and migrations
Conducted application database regression tests, leveraging server side trace and analyzing collected performance data with RML utilities
Analyzed query performance, detected top resource consumers, recommended on database physical structures
Supported and maintained backup and recovery processes leveraging EMC Networker software
Designed and implemented table Partitioning for number of applications
Promoted logical database models to physical structure, leveraging ERWIN data modeler
Developed and implemented T-SQL and PowerShell scripts supporting operational processes and automation
Collaborated with other team members and technical support groups
Sun Life Financial, Toronto, Canada
Senior SQL Server Database Administrator May, 2016 – April, 2018
Delivered SQL Server infrastructure projects including new server deployments, database and server migrations in standalone and clustered environments
Established and maintained written best practices, supporting SQL server operation by creating technical documentation
Supported and maintained backup and recovery processes leveraging Red Gate software
Provided operational production support to variety of SQL server versions – 2008, 2012, 2014 and 2016, including additional platform components such as Integration, Reporting and Analysis services
Deployed and supported Always ON high availability solutions
Installed and configured IaaS solutions leveraging Windows Server VMs Azure Cloud
Implemented and supported Azure Cloud components –Availability Sets, NSG, Virtual Networks, Storage Accounts and Azure Active Directory
Deployed and configured PaaS solutions based on SQL Database as a service in Azure Cloud
Designed, implemented and supported SSRS infrastructure, including scale out deployments, migration and security
Developed and implemented T-SQL and PowerShell scripts supporting operational processes and automation
Implemented and deployed database encryption leveraging IBM Guardium Data Encryption technology
Planned and implemented patching for SQL server instances including Service Packs and CUs
Collaborated with other team members and technical support groups
Supported SOX audits from SQL infrastructure perspective
Leveraged Change Management Process for deployment cycles, adhering to company standards
IBM, Toronto, Canada
Senior Production Database Administrator September, 2010 – April, 2016
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 application Database migrations including metadata and security principles from various versions of SQL Server : 2005--2008; 2008-2012 on multi-node, multi instance fail over cluster platforms
Led number of projects which required designing, installing and configuring SQL Server 2012 subsystems including clustering and Always On solutions
Designed, implemented and supported FCI+AG solution on SQL Server 2014
Tuned database performance leveraging Profiler, DTA, DMVs and DMFs
Standardize large SQL environments while leveraging SQL Server Policy Based management
Implemented and maintained SQL server monitoring leveraging Extended events and Alerts
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 and implemented SQL Server Audit solutions
Planned and implemented patching for SQL server instances including Service Packs and CUs
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
Exxon Mobil (ESSO), Business Support Center, Toronto, Canada
Database Administrator, EMIT group July, 2007 – August, 2010
Led project of migrating SQL 2005 instance to SQL 2008 in cluster environment
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
EDUCATION:
Bachelor's Degree in Computer Science
Haifa University, Israel
Advanced Programming course
Technion Institute of Technology, Israel
MCSE 2000 certification
MCSA certification MS SQL Server 2008
REFERENCES:
Available Upon Request
Contact this candidate