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