Mike Dann MBCS

Experience

• 

  Systems Services Ltd

  Nov 1996 - Nov 1998

  Oracle DBA and UNIX System Administrator

  Oracle database administration UNIX system administrationTechnical lead on server consolidation/migration project

• 

  Walkers Snack Foods Ltd

  Mar 1999 - Feb 2003

  Oracle database administration Oracle database administration

  • Senior Consultant DBA

    Feb 2001 - Feb 2003

  • Oracle DBA

    Mar 1999 - Feb 2001
• 

  PepsiCo

  Feb 2003 - May 2014

  Oracle DBA and Application Administrator

  Oracle Database (8i/9i/10g/11g/12c) administration (including Oracle DataGuard, Oracle RMAN, Oracle Streams)Oracle Applications 11i/R12 administrationMicrosoft SQL Server (2000/2005/2008) administrationMiddleware (Oracle Application Server, Oracle WebLogic) administrationDatabase Capacity planningPerformance diagnosis and tuningTroubleshooting and issue resolutionProactive automated monitoring including daily, weekly, monthly database health checksBackup and recovery strategy design, implementation and testingHigh availability (HA) cluster strategy design, implementation and testing (HP-UX ServiceGuard and Oracle Data Guard)Disaster recovery (DR) stategy design, implementation and testingCutover planning and executionOracle/UNIX/Linux SMELiaising and working with managed service providersAutomated development/test environment build and refresh from productionAutomated application code release to system test, UAT and production environmentsSecurity and SOX/audit complianceITIL (incident, problem, change and configuration management)DocumentationUNIX scripting and SQL and PL/SQL development Show less

• 

  Dannix Solutions Ltd

  May 2014 - Nov 2017

  Oracle DBA

  PepsiCo International: • UK Technical Lead for UK aspect of global data centre migration and consolidation project • Managed technical cutover planning (including walk-throughs) and resource planning for multiple cutovers to meet key objectives of minimal downtime; phased application cutover; ensure data integrity; zero data loss; flawless execution• Engaging and liaising with multiple managed service providers to ensure input, commitment, understanding and adherence to technical plans • Co-ordinated technical migration and cutover activities prior to, during and post cutover as per the cutover plan • Technical troubleshooting and resolution throughout testing, cutover and post-cutover handover to supportHCL Technologies & PepsiCo International:• Oracle Database (10g/11g/12c) administration• Middleware (Oracle Application Server, Oracle WebLogic, IBM WebSphere) administration• Training and handover (remote and face-to-face) to the incoming managed service provider’s database and application administratorsCritigen:• Oracle Database 12c administration – patching, performance tuning, troubleshooting• Oracle WebLogic 11g/12c administration – patching, performance tuning, troubleshooting• Oracle Primavera P6 technical administration• Conducted environment review and subsequent implementation of recommended changes to significantly improve backup & recovery, security, availability and performance of Oracle Database and Oracle WebLogic installations• Implemented and tested robust backup and recovery strategy (Oracle RMAN)• Created detailed systems configuration documentation to improve ongoing supportability• Developed self-service Oracle APEX support application and dashboard to allow functional support team to perform routine application tasks and health check monitoring • Implemented daily and intra-daily capture of server and database performance and usage metrics to facilitate capacity management and planning. Show less

• 

  DSP

  Nov 2017 - now

  • Full technical and “hands on” lifecycle involvement in client engagements from pre-sales, design, planning, build, test, and migration through to transition into managed service.• Best-practice and security-focused solution design, planning and install, configure, health check, problem resolution, migration, patching, upgrade, and documentation across multiple technologies and platforms, spanning countless clients and projects.Subject-matter-expert (SME) proficiency in the following technologies:• Oracle Cloud Infrastructure (IaaS, PaaS/DBaaS, ADB, Networking, Storage)• Oracle Database (8i, 9i, 10g, 11g, 12c and 19c)• Oracle Linux Virtualization Manager (OLVM) / Kernel-based Virtual Machine (KVM)• Oracle VM Server (OVM)• Oracle Linux / Red Hat Enterprise Linux (v6, v7 and v8)• Oracle WebLogic (11g and 12c)• Oracle Forms and Reports (11g and 12c)• Oracle E-Business (12.1.3 and 12.2.10)• Terraform Show less

  • Professional Services Oracle Team Lead

    Oct 2023 - now

  • Database Consultant

    Nov 2017 - Oct 2023