Mark Howard Email & Phone Number

Bristol, United Kingdom

• Providing Database Administration resource for both BAU and Projectsover a number of environments, sites and countries on prem and in cloud.• SME database architecture, design, development and management.• Management of team of 3 DBA’s Duties involved: Database Administration of over 400 instances of SQL Server 2005 – 2019 with 5000+ databases. Responsible for architecture design and best practice of the SQL Server Estate. Migration of existing estate to both a virtualised and high availability infrastructure. Cloud implementations with Azure SQL Database/Managed Service, AWS RDS and IaaS. Third party tools including Red Gate Suite, Quest Spotlight, Sentry One. BI Stack management of SSAS, SSRS and ETL development using SSIS/BIDS. Working within operations team for BAU tasks and development teams for project work. Providing application support for several database related services including ERP systems (SAP, MS Dynamics, Exact, Agresso, Infor Sungard) and specialist software Viewpoint, FIS VPM, Screening Deployed, SS&C EZE.

Bristol, United Kingdom

Trowbridge

Database Administration of 400+ SQL Server 2000, 2005, 2008, 2012 databases. Responsible for Maintenance , Support, Design and Build of multiple SQL Server instances using the native RDBMS toolsets SSIS, SSAS and SSRS. Managing advanced/enterprise SQL Server features including TDE encryption, sharepoint integration and snapshot replication. Use of third party tools including Red Gate Suite and Quest Spotlight.

Taunton, United Kingdom

Administration of 1000+ SQL Server 2012,2008,2005,2000, Oracle 12C, 11G, 10G and Ingress II servers/instances over multiple networks. Providing 2nd/3rd level technical support, investigation, diagnosis of incidents and resolution within agreed SLAs. Perform installation and (re)configuration of hardware/software of database servers. Report writing using SSRS and ETL development using SSIS/BIDS. Working within a team of four DBA’s.

Working as part of a Boeing development team in conjunction with HP Software Solutions implementing the HP IT Performance Suite (formerly HP BTO) into the Boeing Defense UK organization consolidating service desk, service management and change management functions. Technical duties involve administration of 30+ SQL Server 2008 R2 instances with clustering on both physical and virtual servers. Management of over 100+ servers that host the HP IT Performance Suite and it products using VMware, Microsoft Server 2002/2008 64-bit, IIS and Apache Tomcat. Systems administration of the HP IT Performance Suite products including Service Manager, Asset Manager, uCMDB, Release Control, DDMI, BSM and Operations Manager. Using HP Connect-It ETL tool to manage integrations between products in the suite and load data. Using HP Quality Centre for test plan creation and SAT/UAT testing. Working closely with HP on the project management of release enhancements and patches. Training of system administrators for each individual suite product.

Database Administration of 30+ SQL Server 2000, 2005, 2008 and Oracle 8i,9i,10G instances with some clustering over multiple wide area networks. Supporting Legacy RDBMS, planning migration of database systems to DII(Europe’s largest IT Project). Implementing Backup/Recovery plans, constructing maintenance regimes with T-SQL, Setting up Replication and Log Shipping, applying patches and service packs. Responsibility for SMS/WSUS servers and specifically their SQL Server back ends. Administration and management of Axios Assyst ITIL/CRM/SLA package. Production and monitoring of SLA statistics on a monthly basis. Management of Centennial Discovery for change and configuration management teams. Report writing using Crystal Reports 8,9, 10 and SSRS for management teams. Implementing security protocols. Undertaking small development projects involving DTS/SSIS, IIS/ASP, HTML and SQL/T-SQL scripting.

Administration of 100+ SQL Server 7, 2000 real-time OLTP and OLAP instances over multiple networks. Troubleshooting database performance and security issues. Setting up Transactional and Snapshot Replication within SQL Server to multiple instances. Applying patches, service packs, producing/running upgrade scripts and moving databases between servers/networks. Working with Development, Testing, Projects and Operations Departments on a daily basis. Development of maintenance routines with T-SQL. Suggestion and implementing solutions to improve system performance by over 50%. Producing client specific installation scripts. Database and network design with Visio. Management of legacy FoxPro GIS systems.

Taunton

Administration of 150+ Oracle 8i, SQL Server 2000, Sybase and Ingress II servers/instances over multiple networks. Responsible for creation, backup, set-up of user accounts, maintenance of instances, disk/tablespace allocation and recovery using RMAN within Oracle. Applying patches, service packs, producing upgrade scripts and moving databases between servers/networks. Working within a team of three DBA’s. SAP R/3 administration using HR, Payroll, Finance and Time-Recording modules. Research into implementing of Backup Exec with SAP R/3. Development of maintenance routines with T-SQL and PL/SQL. Implementing security protocols on Oracle and SQL Server.

Cheltenham

Database administration of 20 (12 Production and 8 Development) SQL Server 2000 and Oracle 8i, 9i servers/instances all on Windows NT & 2000 spread over a number of countries including UK, Japan, Germany, Holland, France. Responsible for creation, backup, maintenance of instances, disk/tablespace allocation and recovery using RMAN. Also responsible for creating scripts, schema comparisons using Toad and setting up of 9iAS portals plus other DBA tasks. Applications development of various client based systems using Visual Basic with T-SQL and PL/SQL. Database and Network design with Visio. Creation of software builds using Wise to create installation programs, Network administration of Trigger network, installation and maintenance of Windows NT and 2000 servers, installing hubs, configuring routers and firewalls.

Bath

Bristol