Experience

The West Brom

• United Kingdom
• Financial Services
• 200 - 300 Employee

• Sql Server and OracleDatabase Administrator

  • Feb 2021 - Present



Coventry Building Society

• United Kingdom
• Banking
• 700 & Above Employee

• Oracle Sql Server Database Administrator

  • Jan 2020 - Present

  Role------Migration of mission critical SQL Server databases to customer new data centre.Technologies------------------Microsoft SQL Server 2005 - 2016. Microsoft Failover Clustering, Database Mirroring, Availability Groups (AG), Windows Server 2012/16. SSMS. Capacity Planning, baselining, documentation of processes and procedure. Amazon AWS, EC2, RDS technology for Oracle Databases.Description---------------Installation and configuration of Windows Server Failover Clustering to create 4 Node Windows cluster across two new data centres. Installation of SQL Server 2016 across nodes, restoration of application databases, configuring of scheduled Jobs and alerts, Creation and testing of Availability Groups (AG) across of 4 Nodes.Deployment, Testing and scheduling of SSIS jobs for the deletion of legacy data on Oracle and SQL Server.Designed and documented Migration/Upgrade of SQL Server Databases to societies new Data Centre.



Avanade

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• SQL Server DBA / Oracle DBA Datacenter Migration / Devops Engineer

  • Sep 2019 - Dec 2019

  Role-----Migration of mission critical SQL Server databases to customer new data center. Automation of Oracle Database / Patches with installs with Ansible and shell scripts.Technologies------------------Microsoft SQL Server 2014,16,17. Microsoft Fail-over Clustering, Database Mirroring, Availability Groups (AG) , Windows Server 2012/16. SSMS. Capacity Planning, base-lining, documentation of processes and procedure. Oracle 12C, Ansible scripting.Description----------------IInstallation and configuration of Windows Server Failover Clustering to create 4 Node Windows cluster across two new data centres. Installation of SQL Server 2014 across nodes, restoration of application databases, configuring of scheduled Jobs and alerts, Creation and testing of Availability Groups (AG) across of 4 Nodes.Automated the installation, patching and build of database Oracle 12c Database environments Ansible playbooks, YML, and Unix Shell scripts and Jenkins Software.Installation and configuration of SQL 2016/17 databases, Configuration of database mirroring across data centres. Backups, restoration, alerting configuration, full documentation of processes and procedures. Provided assistance to Oracle Database Administrators, Oracle 12c RAC.



Coventry Building Society

• United Kingdom
• Banking
• 700 & Above Employee

• SQL Server / Oracle Migration Database Adminsitrator

  • Jan 2019 - Sep 2019

  Role------Migration of mission critical SQL Server databases to customer new data centre.Technologies------------------Microsoft SQL Server 2005 - 2016. Microsoft Failover Clustering, Database Mirroring, Availability Groups (AG), Windows Server 2012/16. SSMS. Capacity Planning, baselining, documentation of processes and procedure. Amazon AWS, EC2, RDS technology for Oracle Databases. Description ---------------Installation and configuration of Windows Server Failover Clustering to create 4 Node Windows cluster across two new data centres. Installation of SQL Server 2016 across nodes, restoration of application databases, configuring of scheduled Jobs and alerts, Creation and testing of Availability Groups (AG) across of 4 Nodes.Deployment, Testing and scheduling of SSIS jobs for the deletion of legacy data on Oracle and SQL Server. Designed and documented Migration/Upgrade of SQL Server Databases to societies new Data Centre.



Avanade

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• SQL Server DBA Datacenter Migration

  • Sep 2018 - Jan 2019

  Role-----Migration of mission critical SQL Server databases to customer new data center. Automation of Oracle Database / Patches with installs with Ansible and shell scripts.Technologies------------------Microsoft SQL Server 2014,16,17. Microsoft Fail-over Clustering, Database Mirroring, Availability Groups (AG) , Windows Server 2012/16. SSMS. Capacity Planning, base-lining, documentation of processes and procedure. Oracle 12C, Ansible scripting.Description----------------IInstallation and configuration of Windows Server Failover Clustering to create 4 Node Windows cluster across two new data centres. Installation of SQL Server 2014 across nodes, restoration of application databases, configuring of scheduled Jobs and alerts, Creation and testing of Availability Groups (AG) across of 4 Nodes.Automated the installation, patching and build of database Oracle 12c Database environments Ansible playbooks, YML, and Unix Shell scripts and Jenkins Software.Installation and configuration of SQL 2016/17 databases, Configuration of database mirroring across data centres. Backups, restoration, alerting configuration, full documentation of processes and procedures. Provided assistance to Oracle Database Administrators, Oracle 12c RAC.



The West Brom

• United Kingdom
• Financial Services
• 200 - 300 Employee

• Oracle and SQL Server Database Administrator

  • Jan 2018 - Aug 2018

  Oracle and SQL Server Database Administrator Role------Oracle and SQL Server Production Database Administration and System Monitoring.Technologies------------------- Oracle 12C, 12C RAC, Oracle Grid Control, ASM,Red Hat Linux , Performance Tuning Tools. SQL Server 2008/2008R2/2012/2016, Database Monitoring and Support, Development of Capacity Planning Solution, SQL Server Vulnerabilities detection, documentation and resolution. Supported Siebel, Data Warehouse/Management Information Databases.Description----------------Database BAU Activities for SQL and Oracle Databases. Performance Monitoring and configuration with Oracle 12C Grid control. Identification and resolution of performance problems and applying data fixes to application data. Installation , configuration, upgrading and patching of SQL Server 2012/2016 databases.Design, Development and implementation of capacity Planning solution using TSQL, Microsoft Query and Excel 2010. Application of security patches to SQL Server and Oracle Databases. Compliance and Auditing: Identification, documentation and project management of the resolution of SQL Server Vulnerabilities identified by scanning tool NCC SQuirreL across the Societies entire SQL estate of 80+ development / test and production servers.Installation and configuration of Oracle Cloud Control.



DXC Technology

• Devops Senior Oracle/SQL DBA

  • May 2017 - Dec 2017

  Role ------SQL Server / Oracle Production/Development DBA. System Monitoring. Automation of deployment of Oracle/SQL environments with Ansible Playbooks and Shell Scripts.Technologies Utilised----------------------------Oracle Database 11G/12C, Database Migration, ASM, Red Hat Linux, Performance Tuning, Database Monitoring and Support, Ansible Playbooks YML, Unix Shell Scripts, SQL Server 2008 -16, Windows Server 2012/16. Description ----------------Working in Devops Development/Test/Production environments, Migration of multi-terabyte databases from Legacy Oracle Database running on HPUX, to Azure Cloud based Virtual Machines (VM’s) running Red Hat Linux. Install and configuration of Oracle BI Publisher, Oracle Database, Oracle ASM, Apex, Oracle Web HTTP server. Migrated Legacy SQL Server databases (2003 – 2008) to Azure Cloud VM’s running Windows Server 20014/2016 running SQL Server 2016. Installed SQL Server Software and patched with latest security patches. Automated the deployment of Oracle 11G / 12C database software, Bi - Publisher, Oracle Web HTTP server, Oracle patches and application software utilising Ansible, YML and playbooks.



AGCO Corporation

• United States
• Machinery Manufacturing
• 700 & Above Employee

• Senior Oracle DBA

  • Nov 2016 - Apr 2017

  Role------ SQL Server / Oracle Production/Development DBA. System Monitoring.Technologies Utilised -----------------------------Oracle Database 12C, 12c Oracle Grid Control, ASM, Red Hat Linux , Performance Tuning Tools. Database Monitoring and Support, Stored Procedures, Ansible playbooks deveopment,Unix Shell Scripts, SQL Server 2008 -16, Windows Server 2012. Description---------------Database Monitoring and Database support. Supported mission critical databases that controlled manufacturing production lines across Europe. Performance Tuning of Oracle/SQL Server databases advised and documented best practices for SQL performance improvement, Patching, Backups and Security. Developed Ansible/ Unix Shell scripts for automation of data loads and database maintenance. Performed complex releases of software into production and test Databases. Automation of database Installs and software deployment.



IBM

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Oracle Database Administrator (DBA)

  • Jul 2016 - Nov 2016

  Role------SQL Server / Oracle Development DBA . Oracle/SQL Server Database Administration and System Monitoring.Technologies------------------Oracle 11G & 12C, SQL Server 2008- 2012, Oracle Cloud Control, ASM, Red Hat Linux , Performance Tuning Tools. Database Monitoring and Support, Development of PLSQL Stored Procedures, Unix Shell Scripts development. Description ---------------Database Monitoring and Database support. Supported database development teams to ensure smooth transition of mission critical applications from development, testing and into production. Developed and Quality Assured application code. Developed Unix shell scripts for the automatic deployment of code releases, data corrections and data loads. Performed capacity planning for databases to ensure application had adequate resources once delivered into production.



The West Brom

• United Kingdom
• Financial Services
• 200 - 300 Employee

• Oracle and SQL Server Database Administrator

  • Nov 2015 - May 2016

  Role------Oracle and SQL Server Production Database Administration and System Monitoring.Technologies------------------- Oracle 11G,12C, RAC, Oracle Grid Control, ASM,Red Hat Linux , Performance Tuning Tools. SQL Server 2008/2008R2/2012, Database Monitoring and Support, Development of Capacity Planning Solution, SQL Server Vulnerabilities detection, documentation and resolution. Description----------------Database BAU Activities for SQL and Oracle Databases. Performance Monitoring and configuration with Oracle 12C Grid control. Identification and resolution of performance problems and applying data fixes to application data. Installation , configuration, upgrading and patching of SQL Server 2012 databases.Design, Development and implementation of capacity Planning solution using TSQL, Microsoft Query and Excel 2010.Compliance and Auditing: Identification, documentation and project management of the resolution of SQL Server Vulnerabilities identified by scanning tool NCC SQuirreL across the Societies entire SQL estate of 60+ development and production servers.



TNT

• Netherlands
• Freight and Package Transportation
• 700 & Above Employee

• Oracle / SQL Database Administrator/DBA

  • Mar 2010 - Jul 2015

  Database Technologies------------------------------Oracle Performance Tuning (DBA). Oracle Development DBA . Oracle and SQL Server Production Database Administration and System Monitoring. Release Management. Oracle 10g,11G RAC, Oracle Grid Control ASM, Data Guard ,Red Hat Linux , Performance Tuning Tools. Development of PLSQL Stored Procedures and Packages. Development DBA, Release management of application Code, Oracle partition management, Complex environment refreshes. Customer Data Load and Extraction. SQL Server 2005/2008 Database Monitoring and Support. Role------Performed analysis of customer databases, providing consultancy and best practices on database tuning, application tuning and SQL tuning, Developed PLSQL procedures to assist customer to identify performance issues, Oracle statistics monitoring and generating. Development of PLSQL stored procedures and packages to aid statistics generation and performance. Provided monitoring and support for SQL Server databases.TNT is a global logistics organisation; Its core databases have very high number of transactions, with numerous feeds and batch processes, hence imperative to ensure maximum availability. Performed RAC and application failover testing, for numerous third party applications and batch processes. Typical configuration was 3 Node RAC clusters, with database sizes ranging from 2 – 4 Terabytes. Specified, developed and deployed partitioning strategies for applications, as well as resolving performance and operational problems for existing partitioned solutions, additionally advised on data extraction and data load solution deployed (ETL).Development DBA performed complex releases of software into production and test databases. Assisted in application performance testing to identify performance issue in development/test environments. Performed database clones/refreshes to create development and test environments.



Forensic Science Service

• Law Enforcement
• 200 - 300 Employee

• Oracle / SQL Database Adminstrator DBA

  • Nov 2009 - Feb 2010

  Skills Utilised ----------------Oracle and SQL Server Database Administration , Backup and Recovery, Standby Databases, Capacity Planning, Performance Tuning, Database and System Monitoring. Migration of Oracle Databases from Oracle 9i to 10G & 11GTechnologies Utilised --------------------------Oracle Enterprise Server (9i, 10G and 11G). Oracle Enterprise Manager, RAC, ASM, Sql Server 2005/2008, Microsoft Windows ServersRole-----Database Specialist responsible for the configuration, capacity planning and operation of mission critical databases.



Citi

• United States
• Financial Services
• 700 & Above Employee

• Oracle / SQL Database Adminstrator / DBA

  • Jan 2009 - Oct 2009

  Skills Utilised ----------------Oracle Database Administration (DBA), Backup and Recovery, Disaster Recovery, Standby Databases, Capacity Planning, Performance Tuning, Database and System Monitoring. Implementation of Database and Operating system auditing solutions. Provided Support for Microsoft SQL Server databases.Technologies Utilised --------------------------Oracle Enterprise Database Server. Oracle Enterprise Manager Grid control, Powerbroker Auditing Software, Quest FoglightBusiness Area Financial Services (Mortgages, Personal Loans, Credit Cards and Statements, Balance transfers, Business Email Systems, Automatic Reconciliation systems, Management Information and Credit Scoring)Description ---------------Oracle Database Administrator responsible for the specification, configuration, capacity planning and operation of mission critical databases. * Specified and solutioned new banking technical processes. * The monitoring and maintenance of mission critical databases. * Maintained supported and tested standby databases to ensure business continuity. * Specified, installed and configured OS and database auditing software Powerbroker. * Created new databases for production, development, testing and training environments. * Implemented releases of software into test, regression and production environments utilising banks ITIL configuration tools. * Developed and deployed Oracle Partitioning Solutions for a number of applications. * Provide consultancy to development, testing teams and third party suppliers on the optimisation of applications and best practices to ensure optimal integration with production environments.



IBM

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Oracle / SQL Database Consultant DBA

  • Sep 2002 - Oct 2008

  Skills Utilised ----------------Oracle Database Specialist, Oracle Database Administration, Backup and Recovery, Performance Tuning of Database, Oracle Data Guard, Disaster Recovery Testing. Specification and Architectural Design of Oracle Environments, Specification of database clusters and hardware requirements. Oracle RAC 10G and 11G on Redhat Linux. Specification of Backup and Recovery Solutions, Recovery Manager (RMAN)., Data Warehousing, ETL, SQL and PLSQL Optimisation, Data loading with SQL*loader, Oracle Enterprise Manager. SQL Server Databases 2000/2005 databases.Technologies Utilised --------------------------Oracle Enterprise Server ( V9 - 11 ), PL/SQL, SQL, NET*8, Oracle Data guard, RMAN, Oracle RAC and ASM, Sun Sunfire Servers , Microsoft Windows Servers. AIX 5.3, Oracle 9IAS and 10IAS, Red Hat Linux , EMC disk technology. Oracle E-Business Suite, TSM, TDP. Microsoft SQL Server 2000/2005Description --------------Oracle Database Administrator responsible for the installation, configuration and maintenance of many of IBM's outsourced customers, including Pfizer, Royal Sun Alliance, Equifax, Thomson, O2, BP, Virgin, Prudential, Metevante.



Xansa

• IT Services and IT Consulting
• 300 - 400 Employee

• Oracle Database Consultant/DBA

  • May 2001 - Sep 2002

  All aspects of database Specification and Administration. All aspects of database Specification and Administration.



Egg

• Banking
• 100 - 200 Employee

• Oracle Database DBA/Consultant

  • Jun 1996 - Dec 2000

  All aspects of database Specification and Administration. All aspects of database Specification and Administration.



British Rail Business Systems

• Oracle Database Administrator

  • May 1996 - Jun 1996

  All aspects of database Specification and Administration. All aspects of database Specification and Administration.



ICL

• Oracle DBA / Developer

  • Nov 1995 - Apr 1996

  All aspects of database Specification, devleopment of code and Administration of Oracle Databases. All aspects of database Specification, devleopment of code and Administration of Oracle Databases.



Unisys

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Oracle Development Consultant

  • Dec 1993 - Nov 1995

  All aspects of database Specification and Administration. All aspects of database Specification and Administration.