Adrian Champ Email & Phone Number

Swindon, Gb

Swindon, Gb

Swindon, Wiltshire, Gb

Swindon, Wiltshire, Gb

Swindon, Wiltshire, Gb

DBA Team Lead, Cloud Database architect, AWS database solution architecture & Senior DBA. Overall responsibility for all database related activities and infrastructure.• Manage & mentor the DBA Team• Design upgrade of overall infrastructure with key responsibility for the data tier. Experienced in migrating dedicated on premise solutions to hosted infrastructure. Experience in migrating hosted platforms to AWS.knowledge and experience of AWS database platforms (PostgreSQL, DynamoDB), EC2, VPC, storage including FSx, networking, cloud watch, cost explorer etc• Problem solving complex technical issues.• Designing the data models for all new business streams.• Key member of the technical and solution architecture teams.• Migration of SQL Server environments from SQL Server 2016 to SQL2019 and from 2012 to 2016 and 2008 R2 to SQL2012\SQL 2014. Migration from Oracle to PostgreSQL RDS.• Design and Implement high availability technologies - SQL Server Availability Groups, SQL Server FCI• Final Escalation point for all technical queries relating to the database and SQL Server• Technical lead for integrating brokering of financial transactions from in-house bespoke systems to AX2012.• Performance Tuning• Technical lead on tendering for AWS platforms and hosted infrastructure• Technical lead on Data Centre migrations• Development of in house tools to automate database deployments to support continuous integration for databases• Account management of infrastructure providerArchitecture for SQL server data warehouses, reporting, powerBI

Swindon, Wiltshire, Gb

Database architect & Senior DBA. Overall responsibility for all database related activities and infrastructure.• Design upgrade of overall infrastructure with key responsibility for the data tier. Moving to shared infrastructure, virtualisations and shared SAN’s including DR environment. • Problem solving complex technical issues.• Designing the data models for all new business streams.• Key member of the technical architecture team.• Migration of SQL Server environments from SQL Server 2005 to 2008 R2• Final Escalation point for all technical queries relating to the database and SQL Server• Lead the team that implemented the data warehouse\MRI solution using SSAS. Following the Kimball methodology. • Developing database build processes.

Swindon, Wiltshire, Gb

Senior DBA leading the database team within the IT department. Overall responsibility of all database design, development, support and infrastructure for the business. Technical and System expert for SQL Server and the company databases. Key member of the solution design team.• DB Team Lead• Implemented Database Mirroring and Service Broker technologies• Mentoring DBA’s \ SQL Developers• Solution Architecture• Database Modelling• Infrastructure Design• Lead Technical developer on implementing Dynamics 2009. Integrated brokering of financial transactions between production systems and AX environment.• Migrated finance system to Dynamics 2009.• Designed and implemented DR environment.• Implemented MRI \ SSRS solutions

Swindon, Wiltshire, Gb

Responsible for all of the databases and SQL Infrastructure at what was Search Choice Ltd. • Performance tuning of the main production databases and core database code to allow the business to scale.• Implementing release processes to control database releases. Ensure production and internal environments are at known points and changes are released in the correct manner.• Migration of all SQL environments from SQL 2000 to SQL 2005.

Global, Us

Web & SQL Developer on the Zurich Account.Responsibilities: • Developing new file review for existing claims system in SQL 2000 system driven by web interface. Analysis and Redevelopment of SQL Based reports for performance gains.Achievements: • Significantly reduced run times for generation of key reports from over 7 minutes to approx. 3 seconds.• Developed tool sets to enable quicker development of project and future releases for this system.

Global, Us

Application & SQL Developer \ Environment and Database Administrator in the Group DC team.Responsibilities: • Database Administration, SQL & Web Development, Environment Management and Source Configuration for 24x7 Web Based Pension System. ATLAS Production Oncall Support, System Developments / Enhancements. Achievements: • Database Administration of Group DC development and system test environments across parallel developments and Releases.• SQL and Web Development for phased releases including BACSTEL-IP.• Stabilised Development and System Environments via developing new source and configuration strategy and procedures. This led to very stable environments with significantly increased system uptimes and has virtually eliminated build and environmental problems.• Development and Maintenance of ASP, VB and COM components.

Zurich, Zurich, Ch

Application & SQL Developer \ Environment and Database Administrator in the Group DC Team.

Zurich, Zurich, Ch

Infrastructure Developer \ Database Administrator in – Actuarial Systems team.Responsibilities: • Database Administration, SQL Development, Performance Tuning, Production support, small developments/enhancements, systems analysis, object oriented design, Oncall, testing and consultancyAchievements: • Database Administration of over 100 Actuarial Systems Databases across 10 servers with over 2Tb of data.• System Expert for ATLAS production support and Actuarial Systems Database and Server environments• Support, maintenance and enhancement of a VB and SQL based system that provides valuation data to Actuaries• Planning windows 2000 and SQL 2000 Migration• Developed Database and Infrastructure Strategy• Team Technical Consultant on Wintel Server Consolidation project• Environment and Configuration Management• Development of web based (ASP) production support tools. • Passed the FPC1 – Financial Planning Certificate• Mentored 3 Industrial placement students

Responsibilities: OO Analysis, OO Design, development, documentation, Implementation Coordination, Source and Configuration Management.Achievements: • Completed two and half year graduate training programme in two years• Development of ATLAS Utilities and System Components for Actuarial Valuation System• Coordinated quarterly releases for ATLAS system.• Development of Dynamic team intranet and web based development tools.

Graduate Trainee IT Developer in the Software Development Consultancy team.Responsibilities: •Systems Analysis, design, development, documentation, testingAchievements: • Development of web based DBA utilities for local intranet• Development of corporate standing data utility – mainframe roscoe RPF

Industrial Placement Student in the IT Division. Worked primarily in the Millennium team using PL1, JCL, Roscoe etc to develop \ use tools in preparation for Y2K work.

Bsc Hons, Computer Software Technology

Education record