Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Seán Breslin

London

Summary

Seán has nearly a decade of experience working as a Database Administrator, working primarily across multiple versions of Oracle Database, SQL Server and Azure SQL Database. He has vast knowledge of vital database processes across these technologies, such as installation, patching, backup and restore, security administration, migrations and HADR. He has been the database technical lead on several mission-critical database migration/upgrade projects for Oracle and SQL Server databases, including a large scale migration project to Oracle Exadata for one of Ireland's principle energy providers, and performing migrations from on-premise databases to and from cloud platforms.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Senior Database Administrator

Version 1 UK
03.2019 - Current

Working on Onsite DBA Team with Electricity Supply Board, Ireland's foremost electricity provider. Leading the team in Oracle Database administration and Oracle Exadata support and management.

  • Managing full Exadata stack including hardware and software components. Patching and management of Exadata Components such as Compute Servers, Storage Servers, ROCE Network Switches and Power Distribution Units.
  • Implementation of table partitioning and Hybrid Columnar Compression for storage-saving in Oracle 19c database, providing customer with optimal usage of existing storage.
  • Installation, configuration, support and patching of Multi-Tenant Oracle Instances, Oracle Data Guard and Oracle RAC.
  • Database technical lead for large scale migration projects across Oracle and SQL Server databases, coordinating with large project teams to ensure efficient migrations to newer database versions on Windows, Red Hat Linux and Azure Virtual Machines.
  • Management of security for Oracle Databases. Implementing Transparent Data Encryption, Fine Grained Auditing and defining standards for non-DBA database user access to ensure tightened security in Oracle. Created Powershell script to audit entire Environment against CIS Security Benchmarks for Oracle Databases.
  • Management of security for SQL Server database, implementing server and database level auditing policies and Role Based Access Control to ensure hardened security for vital systems.
  • Installation, configuration, support and patching of SQL Server single instances, SQL Server Always On High Availability Groups and SQL Replication, maintaining one of Ireland's largest SQL Server environments.
  • Oracle and SQL Server backup policies. Using Oracle RMAN for backup and recovery processes to ensure Point in Time Recovery available. Implementation of Forever Incremental Backup strategy across Oracle estate.
  • Performance tuning with Oracle AWR and ADDM reports and using Query Store for SQL Server, working with application developers to both create and tune indexes to maximise application performance.
  • Management of Azure SQL and Azure Managed Instances databases, working with application teams to efficiently scale and utilitise cloud benefits to maximise application performance.
  • Installation, patching and configuration of Oracle Enterprise Manager 13.4 on Red Hat Linux.
  • Managing Junior DBA within the team, performing knowledge transfer sessions, managing career growth and performing performance reviews.
  • Involved in the hiring of 3 Junior DBA's into the team, performing technical interviews encompassing several tiers of the hiring process.
  • Member of 24/7 oncall rota.

Managed Services Database Administrator

Version 1
09.2016 - 03.2019

Member of Version 1 Managed Services DBA team, providing support for over 20 customers for Oracle, SQL Server and MySQL databases.

  • Responsible for management of problems, task and incidents for Team Queue, supporting over 20 customers.
  • Database support for Oracle, SQL Server and MySQL databases.
  • Performed installation and patching of Oracle and SQL Server databases.
  • Administration of SQL Servers High Availability Group and Oracle Data Guard HADR environments.
  • Deployed releases to Oracle and SQL Server environments in conjunction with application developers.
  • Member of 24/7 oncall DBA rota.

Education

Bachelor of Science - Computer Science

University College Dublin
Dublin
09-2016

Skills

  • Oracle Database 11g, 12c, 19c
  • Oracle Exadata
  • Oracle RAC
  • Oracle Data Guard
  • Azure SQL
  • SQL Server 2012-2022
  • Oracle Linux 7
  • Windows Server 2012-2022
  • Powershell
  • Basic PostgreSQL
  • Oracle Enterprise Manager
  • Azure SQL Managed Instances

Certification

  • ITIL Foundations Certification
  • AZ-900: Microsoft Azure Fundamentals
  • DP-300: Administering Microsoft Azure SQL Solutions
  • Oracle Database 12c Administrator Certified Associate
  • Oracle Database 19c Administrator Certified Professional

Timeline

Senior Database Administrator

Version 1 UK
03.2019 - Current

Managed Services Database Administrator

Version 1
09.2016 - 03.2019

Bachelor of Science - Computer Science

University College Dublin
Seán Breslin