5 year history in reverse chronological order

CGI - Senior Database Developer
  • Subject matter expert: Postgres, Aurora, Oracle, AWS
Yugabyte inc – Senior Solutions Engineer in a sales support role

Yugabyte inc is a Silicon Valley Unicorn.  YugabyteDB is a distributed version of Postgres based on customized RocksDB combined with sharding and load balancing algorithms for the data. The Raft consensus algorithm controls the replication of data between the nodes.

  • Subject matter expert on geo-distribution (GDPR, performance)
  • Data Architect, Data Engineer
  • Design and configure Debezium (change data capture) and Kafka for customer project
  • Platforms: AWS EC2/VNC/peering etc,  Kubernetes,  Docker, Docker compose, Centos
  • Yugabyte/Postgres subject matter expert, data architect, platform design, performance, security and integration
BP Germany (via IBM Germany) - Senior Platform Engineer

IBM – Senior Platform Engineer

Seconded to BP Germany working on a global project to deliver new filling station pricing systems

Postgres data engineer and data architect using AWS Aurora (Postgres) in a global filling station pricing project working in an Agile multinational team

  • Design interfaces to meet business needs with appropriate error handling and documentation
  • Tightly integrated with the business, developing solutions which are fit for purpose, futureproof and adding value by thinking outside the box
  • Design and create database objects, write database code (PL/pgSQL functions and procedures) to deliver functionality required by the front end and back end team
  • Design, configure and implement a streaming replication/integration solution from RDS Microsoft SQL (MSSQL) to Aurora/Postgres and vice-versa using AWS Data Migration Services (DMS); logical replication from Aurora to Azure Postgres
  • Postgres subject matter expert, advising on platform design, performance, security and integration
  • AWS Lambda, Simple Notification Service (SNS) Simple Email Service (SES)
  • Platforms: Git, Aurora/Postgres, Linux, Liquibase, Datagrip, AWS, RDS, Azure
Fujitsu - Senior Solutions Architect

Postgres subject matter expert, promoting sales of Fujitsu Enterprise Postgres and advising on data architecture

  • Engage with and advise DBA’s, developers and data architects on integration of Postgres with existing and new data strategies
  • Postgres versions 12 and 13
  • Preparing and delivering customer presentations, promoting open source Postgres and highlighting the added features of Enterprise Postgres for x86, IBM/z and IBM LinuxONE
  • Knowledge transfer – Installation scenarios (on premise, private/public cloud, Redhat Openshift)
  • Marketing strategy.
  • Provide Postgres DBA/Developer/Integration/Solutions Architect support for existing customers
  • Performance testing Enterprise Postgres (on premise) vs Amazon RDS and Aurora
iPlato - Data Architect/DBA

Supporting the myGP healthcare application. Implementing stringent data governance requirements. GP booking, prescription ordering, access to medical records

  • Sole MySQL/MariaDB/Redshift Data Architect/Data Analyst/DBA with responsibility 24/7 for critical healthcare databases supporting customer facing online systems
  • Migration from MySQL 5.5 to MariaDB 10.5.7
  • Complete healthcheck and Centos/MariaDB tuning
  • CentOS 6/7 and Ubuntu 20.4 techops
  • Install, configure system/MySQL monitoring (Percona/Grafana)
  • Design improved client – server architecture to increase throughput by at least 100x
  • Develop/test Java and PHP to benchmark alternative MariaDB drivers
  • Experience up to Mariadb 10.5 (including columnar storage/ColumnStore for OLAP)
  • MariaDB temporal tables
  • MariaDB – Redshift data integration using Talend ETL
  • MariaDB Master – Slave replication and failover (on premise and AWS EC2)
  • MariaDB to Redshift streaming replication using AWS DMS (Data Migration Service)
  • SQL query conversion for different database platforms
  • Data modelling and reverse engineering using Navicat
  • PHP scripts to update Redshift data from MySQL over ODBC and PDO using bulk insert

 

 

 

YOOX Net-A-Porter/YNAP - Data Architect/DBA

Global online retail systems, 100 Postgres servers and integration with Oracle reporting servers.

Global Internet retailer (€2Bn revenue)

  • Primary Postgres DBA/Developer/Architect/Engineer with responsibility for 100+ business critical Postgres database systems and systems integration at datacentres in the UK, US and Japan
  • Postgres 9.2 – 11. Streaming Replication. Logical Replication. Pglogical. Repmgr. Manual and automated failover. PL/pgSQL. PgPool, Puppet. Git
  • Evaluated Amazon Redshift cluster as a demonstration warehouse
  • Developed a Postgres 10 data mart using pglogical to acquire data from source databases running a variety of Postgres versions
  • Postgres upgrades using pglogical for minimum downtime
  • Oracle 12.1 DBA, data architect, pl/sql procedures. Oracle – Postgres integration: . Foreign Data Wrapper. ODBC
  • Developed systems and code for near real-time synchronisation (data integration) of several Postgres databases to Oracle
  • Data Quality and Data Integration Postgres – Oracle using Talend ETL
  • Centos 6,7 and AWS
  • Forward and reverse data engineering, data modelling using Navicat, LucidChart
  • Post-merger strategic architecture review

Previous roles

Ministry of Justice Postgres Architect/DBA (Alfresco, Talend, Redhat/RHEL, Agile, Jira, Ansible)
RBS (Royal Bank of Scotland) Business Change Manager working on the RBS implementation of the Future Clearing Model (FCM) and the Williams & Glynn divestment programme
Radiology Reporting Online
(Now Everlight)
IT Director
UK Payments Administration Data Architect
Wellbeing Software Group Data Engineer (Oracle to Postgres migration of radiology systems for 4 hospital trusts)
CarePathPlus Technical Architect
Urenco (Uranium Enrichment) Oracle data architect/DBA (Security cleared).
Community Union Lead data architect/programmer for a new membership admin system.  Oracle Application Express (Apex)
Pfizer Healthcare Solutions IT Director in the telehealth division (Implementing Oncology Telehealth at Guy’s and St. Thomas’ NHS Trust)
Smithkline Beecham and GlaxoSmithKline/GSK Data architect, Data Engineer, Database and web applications developer. GSK merger support. Oracle, Postgres, Datastage

Other assignments for a variety of clients including University Hospital of North Staffordshire, BP, BT, Hammersmith Hospital, NFU Mutual, Perkin Elmer, Roche, Derbyshire County Council