Senior DBA and SQL Developer for the Athoris project, responsible for all aspects of database, ETL, report design, development and deployment; highly focused on maintaining performance, integrity and security within all of the database environments. Ensuring database scripts, data definition documentation, including data standards and security access are created, stored and kept up to date. Responsible for monitoring database activity and ensuring that index statistics, database growth/storage, archiving, back-up and recovery procedures are in place and functioning correctly. Responsibilities also include managing junior team members, mentoring to ensure standardised processes are followed and new code is consistently created to the highest standards. Scheduling workloads to meet expectations within tight time scales.

Played pivotal role in this automotive industry global provider of outsourced business solutions by demonstrating flexibility, consistency and professionalism in requirement capture, design, implementation, testing and support. Working predominately on ASP.NET / C# / SQL Server systems but also progressed in to the maintenance of the core MSXi Java / Oracle systems.• Scripted SQL to support, modify and expand data schemas of existing databases • Designed, created, tested and implemented complex/dynamic queries, procedures, functions/table functions, triggers and views• Used SQL Server Profiler / Execution Plans / Refactoring to streamline existing stored procedures, functions and views to increase efficiency, reliability and performance of data loading, reporting and application response times• Developed flexible, reusable data loader routines to support multiple file formats using T-SQL/SSIS/Talend which included schema compliance, data quality, synchronisation, error handling and reporting• Successfully carried out the migration of live data from legacy SQL Server 2000 database into new version of the contact management system running a SQL Server 2005 backend• Integrated data processing (ETL) routines with dealers/third parties to export/import data for analysis/cleansing/enhancement activities• Built and maintained SQL scripts, indexes, and complex queries for data analysis• Carried out requirement capture and specification definition directly with technical/non-technical clients, account managers and end users• Provided 2nd/3rd line support for operational and technical field teams handling issues with application, data and remote client auditing tool

Contracted by SPX Valley ForgeWorked alongside the Ford IT group on large scale Oracle implementations, providing administration/support/analysis/testing for the Ford EtisIDS feedback system (warranty reduction program).Administered database control access rights to the feedback servers and report functionalityDesigned and project planned in new/ad hoc feedback reports using PL/SQL, working with Ford-IT groups to understand the business requirements, development resources and timing implementationsDeveloped and ran regular/ad hoc SQL queries to aid analysis on dealer feedback within a number of key UK and European business areasMaintained integrity of XML session file data to enable feedback report accuracyPerformed complex deep dive analysis on dealer feedback and used results to construct management metrics / warranty cost saving analysis / content issues / early warningResolved reporting issues by understanding complex relational database processes

Contracted by SPX Valley ForgeWorked with information from warranty analysis and parts engineers to create diagnostic routines uploaded to the Ford EtisIDS diagnostic tool used by workshop technicians.Liaised with Advanced Diagnostics and Product Development engineering areas to capture requirements and concerns for the development of diagnostics and service routines for current and new model programsDeveloped and tested diagnostic routines for implementation on the Authorised Repairer (AR) diagnostic tool (IDS/EtisIDS)Validated and signed-off diagnostic service routines using simulation, rigs and vehiclesAssisted in the coordination of the diagnostic software validation with the software sub-contractor validation engineers

Contracted by SPX Valley ForgeAuthored workshop procedures to assist Ford service technicians to remove and install mechanical and electrical components in existing/new Ford vehicles.Liaised with Advanced Diagnostics and Product Development engineering areas to capture requirements and concerns for the development of diagnostics and service routines for current and new model programsDeveloped and tested diagnostic routines for implementation on the Authorised Repairer (AR) diagnostic tool (IDS/EtisIDS)Validated and signed-off diagnostic service routines using simulation, rigs and vehicles Assisted in the coordination of the diagnostic software validation with the software sub-contractor validation engineers