Support Manager
Resume:
Vlad Kirov
514-***-**** *********@*******.***
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