It looks like you are in United States. Would you like to go to https://onsiter.com/us/ instead?
Kan vara tillgänglig
(Uppdaterat 1+ år sedan)SQL Server DBA
Dublin, Ireland
Modersmål English, Russian
- 25+ years of experience in databases
- 25+ years of experience in T-SQL
- 25+ years of experience in SQL Server DBA
Kompetenser (41)
DATABASE
RAID
SQL SERVER 2000
DATABASE MODELING
MS SQL Server
Database Development
Database Design
OLTP
Database Administration
SQL SERVER 2008 R2
SQL Server
SQL
TEAM PLAYER
STORED PROCEDURES
REPLICATION
Microsoft SQL Server
DATA INTEGRITY
PERFORMANCE TUNING
HARDWARE DESIGN
SQL SERVER 2005
SQL SERVER 2008
SQL SERVER 2012
DATA MODEL
REAL TIME
REAL-TIME
MENTOR
MICROSOFT OFFICE
Excel
WEB DATABASE
INTEGRATION
INTEGRATOR
OIL PIPELINE
RETAIL
COOKING
PIPELINE
SHIPPING
STATISTICS
FINISHING
AUDIT
RETAIL MARKETING
AUDITING
Sammanfattning
Accomplished professional with 25+ years hands-on experience and a background in complex and very large database driven projects design, development, and database administration, performance tuning and troubleshooting seeking a challenging position where my experience and skills would be needed.
Professionell bakgrund
Senior SQL Server DBA
Lloyds Banking Group
2015-01 - Pågående
I am working as a contractor for Lloyds Banking Group via Dublin-based consulting company Version 1. As part of a team of highly skilled DBAs I am responsible for "Changing the Bank" SQL Server programme, which includes performance analyses, recommendations, troubleshooting, database design and migration from SQL Server 2000 and SQL Server 2005 to SQL Server 2008 R2/2014. During a year our team improved and migrated more than 500 SQL Server instances from various locations into virtual environment in consolidatated Bank datacenter.
As part of the migration I was working closely with other Bank teams to provide best possible service and support by running performance analyzing, check and record user activities, searching for hardware and software bottlenecks, provisioning new server configurations and hardware, to test, migrate and support critical Bank applications with SQL Server databases in background, from very small to very big, critical and intensively used ones.
Tools and technologies used for this project:
- SQL Server 2000, 2005, 2008R2, 2014,
- SQL Server clustering and mirroring,
- SQL Server High Availability groups,
- SQL Server Integration Services (SSIS),
- T-SQL coding and troubleshooting
- SSRS reporting
As part of the migration I was working closely with other Bank teams to provide best possible service and support by running performance analyzing, check and record user activities, searching for hardware and software bottlenecks, provisioning new server configurations and hardware, to test, migrate and support critical Bank applications with SQL Server databases in background, from very small to very big, critical and intensively used ones.
Tools and technologies used for this project:
- SQL Server 2000, 2005, 2008R2, 2014,
- SQL Server clustering and mirroring,
- SQL Server High Availability groups,
- SQL Server Integration Services (SSIS),
- T-SQL coding and troubleshooting
- SSRS reporting
Senior SQL Server DBA
Lloyds Banking Group
2018-08 - Pågående
via Version 1 Consulting
www.lloydsbank.com
http://www.version1.com/
Lloyds Banking Group - Senior SQL Server DBA (contract position)
After finishing my contract with Microsoft I come back to Lloyds Banking Group via Dublin-based consulting company Version 1 to work on the extension of the same project that I used to wok on 2015.
As part of a team of highly skilled DBAs I am responsible for "Changing the Bank" SQL Server programme, which includes performance analyses, recommendations, troubleshooting, database design and migration from SQL Server 2000, 2005 and SQL Server 2008 to SQL Server 2014.
As part of the migration I was working closely with other Bank teams to provide best possible service and support by running performance analyzing, check and record user activities, searching for hardware and software bottlenecks, provisioning new server configurations and hardware, to test, migrate and support critical Bank applications with SQL Server databases in background, from very small to very big, critical and intensively used ones.
Tools and technologies used for this project:
- SQL Server 2000, 2005, 2008R2, 2014,
- SQL Server clustering and mirroring,
- SQL Server High Availability groups,
- SQL Server Integration Services (SSIS),
- T-SQL coding and troubleshooting
- SSRS reporting
www.lloydsbank.com
http://www.version1.com/
Lloyds Banking Group - Senior SQL Server DBA (contract position)
After finishing my contract with Microsoft I come back to Lloyds Banking Group via Dublin-based consulting company Version 1 to work on the extension of the same project that I used to wok on 2015.
As part of a team of highly skilled DBAs I am responsible for "Changing the Bank" SQL Server programme, which includes performance analyses, recommendations, troubleshooting, database design and migration from SQL Server 2000, 2005 and SQL Server 2008 to SQL Server 2014.
As part of the migration I was working closely with other Bank teams to provide best possible service and support by running performance analyzing, check and record user activities, searching for hardware and software bottlenecks, provisioning new server configurations and hardware, to test, migrate and support critical Bank applications with SQL Server databases in background, from very small to very big, critical and intensively used ones.
Tools and technologies used for this project:
- SQL Server 2000, 2005, 2008R2, 2014,
- SQL Server clustering and mirroring,
- SQL Server High Availability groups,
- SQL Server Integration Services (SSIS),
- T-SQL coding and troubleshooting
- SSRS reporting
Senior SQL Server developer
Microsoft Ireland
2017-08 - 2018-08
(contract position)
I am currently working as Senior SQL Server developer in Microsoft Ireland, supporting development and migration of Microsoft Retail Incentives Programme - a system that creates, controls and auditing all Microsoft Retail Offers around the globe for all Microsoft products such as Microsoft Office, XOBOX, Games, PC peripherals, Microsoft Wearables, Phones, Surface laptops and desktops.
I am working in close contact with Microsoft development team in Redmond, USA and responsible for database design, performance and data integrity.
Tools and technologies used for this project:
- SQL Server 2016,
- SQL Server High Availability groups,
- SQL Server Integration Services (SSIS),
- T-SQL coding and troubleshooting,
- Excel macros
- PowerBI visualization tool
I am currently working as Senior SQL Server developer in Microsoft Ireland, supporting development and migration of Microsoft Retail Incentives Programme - a system that creates, controls and auditing all Microsoft Retail Offers around the globe for all Microsoft products such as Microsoft Office, XOBOX, Games, PC peripherals, Microsoft Wearables, Phones, Surface laptops and desktops.
I am working in close contact with Microsoft development team in Redmond, USA and responsible for database design, performance and data integrity.
Tools and technologies used for this project:
- SQL Server 2016,
- SQL Server High Availability groups,
- SQL Server Integration Services (SSIS),
- T-SQL coding and troubleshooting,
- Excel macros
- PowerBI visualization tool
Senior SQL Server DBA/Developer
Bank of America/Merrill Lynch
2016-11 - 2017-07
(contract position)
I started at Bank of America/ Merrill Lynch at November 2016 after our project with Lloyds Banking Group was successfully finished. I joined a team that developes and supports one of the biggest Bank applications responsible for Bank global audit by US government.
As part of this team I am responsible for various DBA and Database developer's duties including database and Integration Services coding, design, hardware design and planning, creating and supporting database replications, support for database instances on production, testing and development environments.
Tools and technologies used for this project:
- SQL Server 2014,
- SQL Server clustering,
- SQL Server High Availability groups,
- SQL Server Integration Services (SSIS),
- T-SQL coding and troubleshooting,
- Memory-optimised tables and procedures,
- SQL Server transactional replication,
- SSIS
I started at Bank of America/ Merrill Lynch at November 2016 after our project with Lloyds Banking Group was successfully finished. I joined a team that developes and supports one of the biggest Bank applications responsible for Bank global audit by US government.
As part of this team I am responsible for various DBA and Database developer's duties including database and Integration Services coding, design, hardware design and planning, creating and supporting database replications, support for database instances on production, testing and development environments.
Tools and technologies used for this project:
- SQL Server 2014,
- SQL Server clustering,
- SQL Server High Availability groups,
- SQL Server Integration Services (SSIS),
- T-SQL coding and troubleshooting,
- Memory-optimised tables and procedures,
- SQL Server transactional replication,
- SSIS
Lloyds Banking Group
2015-01 - 2016-09
via Version 1 Consulting
www.lloydsbank.com
http://www.version1.com/
www.lloydsbank.com
http://www.version1.com/
Senior Database Developer/DBA
Fleetmatics Ltd
2001-05 - 2014-12
Database team lead/Data architect
In 2001 I joined Fleetmatics in Dublin as a senior database developer/DBA/Database architect. At that time there were only 7 people in the company and only one client. Today Fleetmatics has about 700 employers, 60'000 clients and one of the few Irish companies that listed in NY stock exchange for the last 10 years.
In 2001 I joined Fleetmatics in Dublin as a senior database developer/DBA/Database architect. At that time there were only 7 people in the company and only one client. Today Fleetmatics has about 700 employers, 60'000 clients and one of the few Irish companies that listed in NY stock exchange for the last 10 years.
Akademisk bakgrund
M.S.
Bryansk Technical University
2019-10 - 1994-01
Certifikat
Microsoft Certified Professional
Microsoft Certified
MCP
MCSA
Certified Solutions Expert
Personal/hobby
Enjoy mountain hiking, clay shooting, fishing, cooking, travelling and exploring
Love technology and IT