I am responsible for all database related work within the organisation from configuration, database design & modelling, database programming, implementation, testing and production support. I designed and manage the infrastructure architecture of the organisation based on the AWS platform.My key duties include: • Designed enterprise-wide database to incorporate order management system, provisioning system and data asset management• Designed exclusivity engine, to manage media assets (media, music, photos) worldwide and block assets within company defined license regions. • Database designed to be multi-lingual and operates in following languages – English, Dutch, Polish, Swedish, Danish, German, Finnish, Spanish, French• Define generic XML & JSON based systems to be used by all our partners for order submission. SQL server accepts orders 24/7 via web service and validates order in the order management system• 24x7 administration of all SQL Server 2005/2008/2012/2017 database instances in production, staging and development environment in multiple regions around the world (EU, US, UK and AU)• Database provides content for over 30+ websites (Can provide examples)• Synchronisation of data between SQL Server and Salesforce.com using XML• Set up complex replication from central SQL Server DB to remote  AWS Aurora in various regions of the world using native SQL Server CDC and AWS DMS. • Maintain and perform upgrades to all our SQL Server and Aurora DB instances to the latest software versions• Design, setup and manage the whole of the organization's infrastructure on the AWS platform using VPC, EC2, RDS and other core AWS services• Worked in Hangzhou, China for 6 month secondment to manage a team of 20+ developers on enterprise wide project• Worked in Kiev, Ukraine for 4 month secondment to manage a team of 8 developers on project to create a new app to interface with Google AdsTechnologies Used:MS SQL ServerAWS AuroraMariaDBAWS platform

I worked as DBA on the development and production databases for the whole of Barclays Africa division, duties include: • Structured database design of a middleware database using SQL Server.• Day-to-day administration of all SQL Server 2005 database instances in production environment• Create data dictionary using extended properties• Create and implement backup and recovery plan• Design and code using stored procedures a generic database archiving process• Monitoring and fault fixing of production databases issues across Africa• Create, test and implement database upgrades.

I worked on an interface project for the Ministry of Defence. For this role I had to undergo security clearance due to the sensitive nature of the data involved: • Design and code interface database to import on a daily basis 16 XML files from various external military systems into a centralised SQL Server 2000 database containing military personnel information.• Performance tuning of stored procedures and database to ensure daily load is completed within a limited time window.• Full unit testing and integration testing of SQL code to comply with MOD standards.

I completed a dual role as DBA and developer based within the Finance dept for the design, creation and maintenance of OLAP systems using SQL Server 2000 and MS Analysis Services: • Design and code Partition Management system to automate the partitioning of relational data on SQL Server using partitioned views and creation, cloning, merging and dropping of OLAP partitions within Analysis Services.• Write complex batch schedules using DTS• Design star schema DB for the data warehouse• Create and Introduce SQL programming coding standards

I designed and coded SQL processes and provide first level support for the production and development SQL Server environments. Some of the key duties of my role include: • Day-to-day administration of over 150 SQL Server 2000 database instances in production environment• Planning and implementing a backup and restore strategy in both production and development environments• Analyse, design and code data conversion programs to migrate over 150 localised databases from Interbase 6.0 to SQL Servers 2000 using DTS• Develop and edit scripts through Transact-SQL for DTS packages including troubleshooting and VB scripting• General House keeping duties: space management, performance turning, optimisation procedures, analytical troubleshooting and bottlenecks fixes• Developed back office financial processes using stored procedures and triggers for an automated BACS and Credit Card payment and rejection system• Configuring the SQL agent and setting up SQL Mail, Defining jobs, alerts and associating alerts with jobs in MS-SQL Server 2000• Design and implementation of database schema changes

I designed, coded and implemented IT solutions to meet corporate requirements; defined database and programming standards; and provided first level support for the production and development SQL Server and Oracle database environments. Some of the key duties of my role included: • 24 hour on-call support of all SQL Server production databases• Management of development team: delegation and supervision of work, organisation of resources, regular progress reporting to business users and senior management, analysis of user requirements and writing business and technical specifications• Designed, coded and tested database software• Extensive writing of SQL stored procedures, packages, functions and triggers• Responsible for peer code reviews • IT staff recruitment and interviews• Mentor to junior and trainee programmers within Systems Development• Major projects I have worked on included:o 2 year project to replace ICL and SQL Server core banking system with AS400 and Oracle systemo Building Society Merger projecto Customer Analysis OLAP systemo Mortgage Fixed Rate maturity systemo Migration of SQL Server systems

Based in IT Systems Integration division, I carried out various Mainframe and PC developments. My primary role involved analysis, coding and implementation of IT developments from concept through to completion. As a trainer, I designed, documented and delivered various in-house IT training courses.• Detailed analysis of user requirements• Produced business and program specifications• Software coding• Tested and implemented software• Designed and delivered various workshop/training seminars to business users• Production of IT training material for business users• Major projects included:o Design and coding of Helpdesk system using MS Accesso Central enhancements to payroll system on ICL mainframeo Significant improvement to personnel system

I developed software for the administration of life and pension products on the Unisys 2200 mainframe. My role included:• Writing of program specifications• Structured design of programs• Coding of software in specified language either COBOL or DELTA• Unit and System testing• Major projects included:o Coding of Pensions Maturity systemo Coding of conversion programs for company merger