Keith James Baugh, Developer in Cwmbran, United Kingdom
Keith is available for hire
Hire Keith

Keith James Baugh

Verified Expert  in Engineering

Database Performance Consultant and Developer

Location
Cwmbran, United Kingdom
Toptal Member Since
November 2, 2020

Keith developed his software skills from the military digital circuit design in the nineties and went freelance as a DBA and developer in 1994. Since then, he freelanced in the UK for many leading companies, including British Gas, ICL Medical, British Telecommunications, HMCE, Sapient, Bank of England, Credit Suisse, Royal Bank of Scotland, and Hays. Keith also developed a database management product and his iOS ski app with piste maps and group sharing and tracking capabilities, SkiMax.

Portfolio

Just-the-Biz Limited (Self-employed)
MySQL, Swift, Objective-C, Xcode, Linux, Microsoft Excel, Programming...
Hays, PLC
PL/SQL Tuning, Unix Shell Scripting, Perl, PL/SQL, Oracle DBA...
Sapient
Solaris, HP-UX, Oracle8i, Oracle PL/SQL, PL/SQL Tuning, Oracle Database Tuning...

Experience

Availability

Part-time

Preferred Environment

Oracle, Perl, SQL, Xcode

The most amazing...

...thing I've resolved is a bug in my code to a design fault in a hardware piece, directing the supplier to the design issue and what they could do to fix it.

Work Experience

iOS Developer

2014 - PRESENT
Just-the-Biz Limited (Self-employed)
  • Developed a full iOS application from scratch. The app is called SkiMax, and I designed it in my spare time for skiers as a solo effort in Objective-C.
  • Integrated a back-end functionality, Apple Push Notification service, into SkiMax's back-end cloud servers.
  • Developed back-end databases in MySQL on DigitalOcean cloud servers for data sharing and group tracking functions of the app.
  • Developed a geographical, tiled piste map data processor on cloud servers to support SkiMax.
  • Worked with Xcode translation services to get SkiMax translated into other languages as an ongoing project.
Technologies: MySQL, Swift, Objective-C, Xcode, Linux, Microsoft Excel, Programming, Unix Shell Scripting, iOS, Swift 4, Performance Tuning, Database Performance Tuning

Freelance Database Development Consultant

2008 - PRESENT
Hays, PLC
  • Provided expert performance and tuning advice for Oracle RAC database clusters.
  • Created innovative database code generators in Perl to write code for several large requirements, such as feeds for search mechanisms and Elasticsearch.
  • Administered problem analysis and solutions for multiple real-time application database issues.
  • Provided global production Oracle RAC DBA support, including managing backups and storage issues.
  • Tuned database performance systematically to meet the CPU usage goals for the production equipment.
  • Implemented numerous production-quality database jobs for unmanned execution against production databases.
  • Mentored developers in writing code to run against live databases and provided detailed assistance with tuning SQL and PL/SQL statements.
  • Developed code generators in Perl to create a bespoke internal sub-string indexing system with predicted hit counters, giving character by character hit count refinement.
Technologies: PL/SQL Tuning, Unix Shell Scripting, Perl, PL/SQL, Oracle DBA, Oracle Database Tuning, SQL, Oracle PL/SQL, Amazon Web Services (AWS), Oracle Database, Amazon EC2, Linux, OLAP, Stored Procedure, Data Engineering, Microsoft Excel, NoSQL, Programming, SQL Loader, SQL Plus, ETL, OLTP, Performance Tuning, Database Performance Tuning

Freelance Oracle Database Administrator

2001 - 2020
Sapient
  • Provided Oracle DBA support for 80+ developers on the UK government's (Cabinet Office) web development program.
  • Created code that enabled 80+ developers to work in their own sandpit database environments while maintaining data models for the project and performing weekly database rollouts.
  • Helped the development team with solutions to development database issues, dev performance issues, debugging issues, and production performance issues.
  • Provided DBA support for the development team of the Opodo website, including production setup and tuning.
Technologies: Solaris, HP-UX, Oracle8i, Oracle PL/SQL, PL/SQL Tuning, Oracle Database Tuning, Oracle Database, Linux, Stored Procedure, Microsoft Excel, Programming, PL/SQL, Unix Shell Scripting, Oracle DBA, SQL Loader, SQL Plus, Data Modeling, Performance Tuning, ETL, SQL, OLTP, Data Engineering, Database Performance Tuning

Database Development Consultant

2006 - 2008
Royal Bank of Scotland
  • Performed database data modeling, schema change support, and maintenance operations.
  • Consulted the database developers on design for project work.
  • Provided expertise in developing database management and design of replication and advanced queueing mechanisms.
Technologies: SQL, Azure Queue Storage, Oracle, Oracle DBA, Oracle PL/SQL, PL/SQL Tuning, Oracle Database Tuning, Oracle Database, Linux, Stored Procedure, Microsoft Excel, Programming, PL/SQL, Unix Shell Scripting, SQL Loader, SQL Plus, ETL, OLTP, Data Engineering, Performance Tuning, Database Performance Tuning

DBA Consultant

2005 - 2006
Credit Suisse
  • Managed a large-scale evaluation and assessment of Oracle data center monitoring and management tools.
  • Completed formal interviews and fact gathering for vendor-related product assessment for Oracle database monitoring tools.
  • Provided expert advice and opinion in a formal report to the management of the bank's data center stakeholders.
Technologies: Data Centers, Oracle, Oracle PL/SQL, PL/SQL Tuning, Oracle Database Tuning, Oracle Database, Linux, Stored Procedure, Microsoft Excel, Programming, PL/SQL, Unix Shell Scripting, Oracle DBA, SQL Loader, SQL Plus, Performance Tuning, ETL, SQL, OLTP, Data Engineering, Database Performance Tuning

Database Consultant

2004 - 2005
British Telecommunications
  • Implemented complex data extract, transformation, and load code pipelining through bespoke filters for the United Kingdom's NHS program.
  • Designed and coded metadata-driven automated load processes for a two billion row data transfer, including pseudonymization and encryption of key fields.
  • Consulted on numerous data warehouse performance issues to provide system and query turning advice.
  • Authored the design documentation for the main daily warehouse pseudonymization process and implemented a working version of the same in PL/SQL, Perl, C, and KornShell.
Technologies: C, Erwin, Oracle PL/SQL, PL/SQL Tuning, Oracle Database Tuning, Stored Procedure, Microsoft Excel, Programming, PL/SQL, Unix Shell Scripting, Oracle DBA, SQL Plus, Data Modeling, Performance Tuning, SQL, OLTP, Data Engineering, Database Performance Tuning

Contract Oracle DBA

2000 - 2001
Bank of England
  • Provided Oracle DBA development and production support to the monetary financial and statistics group of the Bank of England.
  • Supported a small group of internal bank employees in the development of the bank's internal systems.
  • Provided production support for the bank's financial statistics group on a system that provides input to the bank's Monetary Policy Committee (MPC), which sets the bank's base interest rate.
Technologies: SQL, Oracle, Oracle PL/SQL, PL/SQL Tuning, Oracle Database Tuning, Stored Procedure, Microsoft Excel, Programming, PL/SQL, Unix Shell Scripting, Oracle DBA, SQL Loader, SQL Plus, Data Modeling, Performance Tuning, ETL, OLTP, Data Engineering, Database Performance Tuning

Data Warehouse Consultant

1999 - 2000
Her Majesty's Customs and Excise, National Intelligence Division
  • Analyzed fuzzy search requirements for the organization's data warehouse systems to allow disparate datasets to be linked.
  • Designed a modular approach to implementing fuzzy search connections between disparate datasets within an Oracle data warehouse environment.
  • Worked within the legal constraints of the UK data protection laws relating to the use of data for specific purposes.
Technologies: Pro*C, Oracle8i, Data Warehouse Design, Data Warehousing, Oracle PL/SQL, PL/SQL Tuning, Oracle Database Tuning, Stored Procedure, Microsoft Excel, Programming, PL/SQL, Unix Shell Scripting, Oracle DBA, SQL Loader, SQL Plus, Data Modeling, Performance Tuning, ETL, SQL, OLTP, Data Engineering, Database Performance Tuning

SkiMax iOS Application and Full Back-end Cloud Support

This was my first full iOS project, completed as an exercise to learn Xcode and Objective C. An interest in skiing prompted me to develop my own skiing app, emphasizing family group data sharing and group tracking facilities.

I also integrated my version of the Open Snow Map project data rendering showing chairlifts and other lift types actively moving on the MapKit views. I am currently working on extending the language support for other translations.
1989 - 1994

Bachelor of Science Degree in Mathematics

The Open University - United Kingdom

1984 - 1985

Higher National Diploma in Electronics

Gwent College of Further Education - Wales, UK

1981 - 1983

Higher National Certificate in Electronics

Gwent College of Higher Education - Wales, UK

Libraries/APIs

MapKit API

Tools

Microsoft Excel, Xcode, Erwin

Languages

SQL, Stored Procedure, Perl, C, Pro*C, Objective-C, Swift 4, Swift

Storage

SQL Loader, PL/SQL, Oracle DBA, Oracle PL/SQL, OLTP, MySQL, Oracle Database Tuning, Azure Queue Storage, Data Centers, NoSQL

Platforms

Oracle, Oracle Database, Linux, HP-UX, Solaris, Amazon Web Services (AWS), iOS, Amazon EC2

Paradigms

ETL, OLAP

Frameworks

CODE

Other

SQL Plus, Programming, Unix Shell Scripting, Data Modeling, Oracle8i, Performance Tuning, Data Engineering, Database Performance Tuning, Data Warehousing, Data Warehouse Design, Digital Circuit Design, Analog Circuit Design, Microprocessors, PL/SQL Tuning, Machine Learning, Analysis

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring