Resume

Sign in

Support Manager

Location:
Montreal, Quebec, Canada
Posted:
August 22, 2018

Contact this candidate

Resume:

Vlad Kirov

514-***-**** ac6r0c@r.postjobfree.com

Profile:

• Microsoft Certified Technology Specialist in SQL Server 2005 & 2008.

• Provided 24/7 production support, administration, migration, performance tuning, troubleshooting.and plan/support all kind of HA/DR solutions

•Innovative and creative problem solver, who is results oriented, has an aptitude for learning and can maximize resources while possessing a sense of urgency.

Computer knowledge:

Operating Systems:

Windows, AS-400, Linux (Debian 7)

MS Office/Open Office applications:

Word, Excel, Access, Power Point, MS Project

DB / SQL:

MS SQL, DB2, postgresql, MySQL

ETL:

SSIS/ various composed scripts

Reporting

SSRS (basic knowledge)

EMPLOYMENT HISTORY

03/2017-present “FX innovation”

Senior DBA MSSQL – at this position I deal with planning and development of DB standards, provide optimization suggestions, solve performance issues, design migration plans, plan and implement HA/DR solutions, prepare data capacity plans.

Planning, configuring and support of SQL HA solutions as Clusters & AG

Develop monitoring tools and work with third party monitoring tools

Design backup retention according companies’ policies

Planning and implementation of migrations to higher versions

Configure, maintain and troubleshooting of replication, log shipping, mirroring, Clusters and AG

Performing health check of hundreds of instances on a daily basis

Provide support during off hours (ONCALL)

Provide 7 x 24 Production and development support for databases

Design maintenance plans according companies’ policy

Writing and publish DB’s documentation

Review databases security, backup, recovery and integrity

12/2015-03/2017 “Société Générale”

DBA MSSQL - development and production support within the SQL Server Specialists team. The main objectives of my position are to provide HA/DR solutions, to solve performance issues, to design migration plans, standalone/cluster instances planning and its configuration etc.

Provide 7 x 24 Production and development support for the various databases

Reviewing & Deployment various scripts on development and production environment

New instance installations using power shell scripts

Deployment of various SSRS and SSIS packages

Configuration, maintenance and troubleshooting of replications and log shipping

Performing health check of hundreds of instances on a daily basis

Planning and implementation of migrations to higher versions

Provide support during off hours (ONCALL)

Design maintenance plans according companies’ policy

Writing and sharing documentation

05/2014-12/2015 “Datavalet” Ltd Montreal

DBA MSSQL & PostgreSQL

In first two months at the company, I reduced by 70% IO & CPU and improved significantly DBs performance.

Provide 7 x 24 Production support and maintenance of DBs

Established development, QA & staging DB environments

Redesign and design company’s databases

Plan Installations and updates/upgrades of database servers

Prepare documentation for all DB processes

Support and advise development team in the field of database

Write DB administration stored procedures

Configure cluster, mirroring and log shipping topologies

Basic Linux (Debian 7) administration

Postgresql & Mysql administration

11/2013-3/2014 "DBsoft" Ltd Montreal

DBA MSSQL - production support within the SQL Server Specialists team

Provide 7 x 24 Production support for the various databases

Develop SSIS Packages for monitoring of clients SQL Servers

Installing and configuring company’s application on clients Servers

Troubleshooting SQL issues by using SQL and various tools

Monitor client's SQL servers to improve & optimize the performance

Participate in any database related projects of companies clients

08/2013-11/2013 "Upclick" Ltd Montreal

Internship, assistant to the SQL DBA of the company

12/2012- 07/2013 "iMD-soft" Ltd

DBA MSSQL - production support

Production support DBA in company which is developing and supporting most critical system for operation and intensive care rooms in hospitals.

Configuration, maintenance and troubleshooting of Replication topology

Provide 7 x 24 Production support for the database

Work with developers to tune the SQL queries in test environment, and tuning and improving performance using SQL Profiler on production DBs

Analyze performance by execution plan and DMVs to improve performance

Review and tuning of SQL queries, stored procedures, views

Suggest Disk Capacity, Processors and Memory based on the Capacity planning

Creating and planning automated processes as backups, update statistics and check integrity of DBs

Planning indexing and re-indexing for objects in DB to improve performance

Document all the details into CRM system-salesforce.com

2/2008 – 12/2012 "Michshuv ERP group" Ltd

Production support and DBA

Provided 7 x 24 Production support for the database and application issues which were based on MSSQL, Sybase and DB2 DB Servers.

MSSQL 2005 & 2008- setup, maintenance, tuning and improving performance.

Worked with developers to tune the SQL queries using SQL Profiler.

Developed Database Backup Scripts and automated those processes.

Support billing, reservation & hospitality systems, installation and implementation.

Technical support of PMS (Hotels), Attraction & POS systems.

Support AS400-DB2, manage users, solving of system and DB issues.

2003 – 2008 "HOD" Hotel Ltd

Control department manager

I was responsible of information system (ERP) and hotel computerization.

Projects management in the hotel

I've composed reports for the general manager

I've coordinated the work with the hotel purchasing officer, and managed the hotel inventory. Also, negotiated with communication suppliers

Management of department which included 12 labors and drugstore of the hotel

Education:

2018: CEGEP - John Abbott College - VMware ESXi 5.5-6.5

2015: Montreal college of IT - Linux administration

2009: Ness College - DBA (SQL server 2008 - MCTS) course.

1999-2002: Ben-Gurion University – B.A. of tourism and hospitality management.

Languages:

English

French

Russian



Contact this candidate