Gary Ashpole Email & Phone Number

Dunstable, England, United Kingdom

Dunstable

Working as part of the managed services team, providing support to their managed services customers.Providing end to end customer environment support on Solaris 10/11 and oracle 9i, 10g, 11g and 12cPatching and installing Oracle up to and including 12.1.0.2 and associated PSU'sManaging all aspects of Dataguard, OFM and OAS environmentsCapacity planning in a UNIX/Solaris EnvironmentDatabase performance tuningManaging, testing and implementing RMAN backup solutionsConfiguration managementDaily interaction with Customers and both in house and external development teams to deliver fast, accurate and correct resolutions to customer issues

Senior Oracle consultant providing ongoing support to existing DSP customers.Designing and building new Oracle environments for both new and existing DSP clients.Supporting multiple Oracle databases from v.8.1.7 to 11.2.0 (Enterprise and Standard Editions).Supporting the databases on various platforms mainly Solaris 8 to 10, Windows 2000/2003, Windows NT, Oracle Enterprise Linux and Red Hat Enterprise Linux.Planning, developing, building and administering new Oracle RAC and Dataguard environments.Conducting upgrades for all database versions to newest supported versions and testing and implementation of Oracle patch sets and security patches.Working on complete problem investigation and resolution, to ensure minimum impact to clients for all database issues.Conducting regular performance tests, and implementation of recommended database changes to improve performance.Providing a full 24X7 out of hours support function for all DSP customers.Developing new solutions and improving existing Oracle functionality between myself and customers internal and external development teams.Working directly with Oracle, Cisco and IBM to understand and evaluate new products and benefits to DSP customers and to partner with them to implement new client solutions.Developing and implementing shell scripts and Windows batch jobs to automate daily tasks and improve error reporting to be proactive rather than reactive to customer issues.Working with both Sales and Solutions Architect teams to develop solutions tailored to individual customer requirements to encompass High Availability, Performance and Disaster Recovery.

Sole Oracle DBA maintaining high availability solutions for various clients.Supporting Multiple Oracle databases from v.8.1.7 to 10.2.3 (Enterprise and Standard edition).Supporting the databases on various platforms mainly Solaris 8 to 10, Windows 2000/2003 and Windows NT.Configuring and Managing Oracle Data guard and RMAN, across remote sites to ensure high availability and disaster recovery.Conducting disaster recovery planning, implementation and testing for all clients.Working with Tivoli Televault and Net backup teams to ensure complete backup and recovery availability for all clients.Performance tuning and liaising with client’s application providers to ensure optimum database performance and enhancements.24 X 7 out of hours support for all Oracle clients.Working closely with clients and third party software providers administering large Oracle environments consisting of large database configurations (30x10Tb databases) using EMC disk arrays Liaising with clients to suggest improvements to their Oracle configuration for enhanced security, resilience and performance.Upgrading existing customers from Oracle 9.2.0.5 to Oracle 10.2.3Working with Pre sales teams to recommend Oracle 10g environments for new clients, to include hardware configuration, Oracle versions and DR configurations such as Standby database and Oracle Data guard.Installing and configuring Oracle environments for new clients, and troubleshooting set up issues in tandem with various different Sungard teams (networking, O/S, Vaulting)

Milton Keynes, United Kingdom

Responding to management requests for database reports, Creating bespoke reports on a daily basis.Working as part of a 4 man team, managing 15 large databases (between 800Gb and 2Tb).Running Oracle version 8.0.6 to 9.0.2 on Solaris 7 and 9Doing out of hours on call and 24/7 support to ensure maximum database availability.Rolling out Oracle onto new Sun Cluster technology and utilising Sun Snapshot capabilities. Managing RMAN backups and Data guard on Oracle databases.Generating Business reports for different business sectors.Creating test platforms for Oracle to test new software updates developed by fourth line. Installing 10g Oracle enterprise edition database to test application upgrades.

Milton Keynes, United Kingdom