SQL Server DBA Dublin, Ireland

Might be available

(Updated 1+ year ago)

SQL Server DBA

Dublin, Ireland

Native English, Russian

  • 25+ years of experience in databases
  • 25+ years of experience in T-SQL
  • 25+ years of experience in SQL Server DBA

Skills (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

Summary

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.

Professional Experience

Senior SQL Server DBA
Lloyds Banking Group

2015-01 - Present

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
Senior SQL Server DBA
Lloyds Banking Group

2018-08 - Present

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
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
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
Lloyds Banking Group

2015-01 - 2016-09

via Version 1 Consulting
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.

Academic Background

M.S.
Bryansk Technical University

2019-10 - 1994-01

Certifications

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

Contact contractor

/