Jake Morgan

Database Administrator

Areas of Expertise
Oracle RDBMS
SQL Server
Shell Scripting
RMAN
Disaster Recovery
ETL
Middleware
HTML/CSS/JS/PHP

Key Attributes
  • Self-motivated professional with extensive project management and IT skills, capable of adapting to various work environments
  • Critical thinker with exceptional analytical and problem-solving skills, proficient in managing complex challenges
  • Adept at managing multiple deadlines and demonstrating strong organisational skills in high-pressure situations
  • Strong presentation skills, blending sound analytical research and clear verbal explanation to convey complex ideas
  • Committed to taking on new responsibilities and challenges, driven by personal growth and continuous improvement
  • Passionate about delivering high-quality results and consistently striving for excellence in all endeavours
Education

Ysgol Friars, Bangor:
12 GCSE Grades A to C and 2 AS Level

Personal Summary

As an exceptionally skilled IT professional with over 15 years of in-depth experience, I excel in enterprise database and Linux administration, specialising in both Oracle and MS SQL systems. My expertise spans across both local and sophisticated cloud-based environments, including Azure, where I have demonstrated exceptional prowess. I bring to the table a unique blend of technical acumen and leadership, driving technical projects with unparalleled efficiency and implementing solutions across a diverse range of product lines. In high-pressure, dynamic environments, I am the go-to expert for managing large volumes of critical data, ensuring peak performance and steadfast support.

  • Proven track record as a seasoned Database Administrator, mastering complex on-premise and cloud database configurations.
  • Renowned for performance tuning and optimisation, utilising advanced monitoring and troubleshooting tools to deliver excellence.
  • Deep-rooted expertise in SQL Server Management Studio and Azure Data Studio, offering sophisticated solutions.
  • Extensive experience in Azure cloud deployments, including VM, IaaS, PaaS, and Managed Instances, showcasing versatility and innovation.
  • Proficient in leveraging Microsoft Azure services like Data Factory and Synapse Studio to drive data transformation.
  • Expert in implementing robust Database Maintenance, Backups, Restores, and Recovery Models, ensuring data integrity and resilience.
  • Adept in deploying High Availability and Disaster Recovery strategies for SQL Server, guaranteeing uninterrupted service.
  • Skilled in navigating Windows Server environments, Active Directory (AD), and Azure Active Directory (AAD), enhancing system security and efficiency.
  • Accomplished in conducting comprehensive Upgrades and Installations of SQL Server and Windows Platforms.
  • Efficient in migrating and cloning SQL databases across various environments, reflecting adaptability and technical sophistication.
  • Familiar with ITIL and ISO 27001 processes, aligning with industry best practices and standards.
  • Demonstrated ability to thrive in large organisations, adhering to stringent change processes and delivering to the highest quality standards.

Work Experience

SENIOR DATA PLATFORM ENGINEER

2023 - Present | Coeo | Reading

As a Senior Data Platform Engineer within the Managed Services team at Coeo, I work in and contribute to a team of around 45 database experts in delivering comprehensive database services. My role primarily focuses on SQL Server and Azure, with additional exposure to AWS, encompassing performance tuning, optimisation, and replication to ensure optimal database performance and reliability for a diverse client base.

  • Expert in performance tuning and optimisation, implementing strategies to enhance database speed and reliability.
  • Specialising in SQL Server and Azure, while also proficient in AWS, to provide versatile database solutions.
  • Ensuring database replication and consistency across multiple platforms, contributing to data integrity and system reliability.
  • Addressing unique client requirements through customised database strategies, balancing traditional and cloud-based solutions.
  • Collaborating within a large team of database professionals, fostering a culture of knowledge-sharing and continuous improvement in database management.
SENIOR DATABASE ADMINISTRATOR

2020 - 2023 | Proact International Ltd | St. Asaph

Diligently managing, configuring, maintaining, and optimising critical databases to ensure dependable performance and availability of Oracle, SQL Server, and other RDBMS systems. Committed to delivering high-quality results, driving continuous improvement, and upholding best practices in a Senior Database Administrator role.

  • Developing and maintaining comprehensive documentation and scripts for data management and system administration tasks, focussing heavily on automation.
  • Ensuring regular and meticulously tested backups for all databases, effectively safeguarding data integrity, preserving critical information, and maintaining consistent availability to achieve optimal system performance and reliability
  • Continuously monitoring and fine-tuning database performance, conducting in-depth root cause analyses for databases and interfaces.
  • Skillful configuration and management of cloud database platforms.
  • Seamlessly migrating and documenting Oracle to MS SQL and Postgres transitions, facilitating multi-platform deployment of mission-critical applications
DATABASE AND APPLICATIONS ADMINISTRATOR

2013 - 2020 | Bangor University | Bangor

Responsible for the technical and administration aspects of the University’s Oracle and MS SQL Database infrastructure.

  • Installing and maintaining databases (Oracle 12c, 19c & SQL Server)
  • Conducting patch management to address bugs and enhance security measures
  • Creation and execution of comprehensive technical tests for system validation
  • Developing and implementing resilient backup strategies ensuring data integrity.
  • Systematically conducting backup tests validating data recoverability and reliability
  • Installation, configuration and development of APEX environment & applications
  • Safeguarding database security through diligent management and best practices
  • Involved in the physical design process and architecture of database systems
  • Patching, administration and management of the University's ERP system
ORACLE DATABASE ADMINISTRATOR

2008 - 2013 | Natural Resources Wales | Bangor

Oracle Database Administration, APEX development and Azure Migration

  • Designed an advanced, automated web-based monitoring system for enterprise-wide usage, utilizing key technologies such as shell scripts, PowerShell, VBS, SQL, and APEX. This innovative solution enabled the operational DBA team to effectively collect database metadata, identify exceptions, and analyse performance statistics for endpoints across an extensive Oracle infrastructure with over 150 multi-platform servers.
  • Devised an efficient alerts system to proactively notify DBAs and the infrastructure team of potential failures, enhancing system reliability and facilitating rapid response to emerging issues.
  • Enhancing the organisation's EDRMS system through data integrity analysis and tuning metric optimisation.
  • Delivered programming and DBA expertise for seamless migration of corporate applications from Solaris to Linux platform server environments.
  • Optimised the production copy test environment refresh process for spatial projects, significantly reducing duration while enhancing reliability and efficiency.
  • Mentored DBAs and developers on Oracle architecture, 11g/12c features, replication, RMAN backups, Oracle RAC, Data Guard, and WebLogic Middleware Platform, fostering knowledge sharing and team growth.