Expert database designer and developer (SQL/functions/ETL)
Expert in relational database systems, especially PostgreSQL (Supabase, Amazon Aurora/RDS, Azure Hyperscale/CosmosDB/Citus, postgREST, RPC, RLS, timescaledb, PostGIS) and MS SQL Server, with more than 25 years of experience on both. I’m also a software developer with 35 years of experience in many platforms, programming languages, and database systems. I'm from in Sydney, Australia, but currently travelling in the USA and Argentina. I’ll be happy to assist with your needs wherever you are in the world.
Expert in all of the following:
* database installation, configuration, optimisation, securitisation, backups, performance improvement, encryption.
* database design, SQL code optimisation, indices optimisation, coding stored procedures, increasing performance and security, partitioning.
* database conversion or migration (e.g. to/from noSQL or JSON stores), interfacing with other databases, importing and exporting data, interfacing with online services (pl/perl, C, C#)
* hot/cold backup and restore, recovery, replication (master/slave or master/master), mission critical
* encryption in transit and/or at rest; encryption of data for authorised access only
* text-file data extraction, formatting, conversion, clean-up.
Databases: PostgreSQL, SQL Server, MySQL, D3/Pick, Oracle, NexusDB, DB2, SQLite, COBOL, MongoDB, BerkeleyDB, Informix, Access, InterBase, Paradox, DBase/Clipper/Fox (DBF), CSV and plain text.
Expertise with Regular Expressions (regex), batch and shell scripting, sed and other text processing tools, Excel, REST, SOAP and web services, networking tools, and many programming languages (including Delphi, C/C++/C#, Perl, PHP, Smalltalk, Java, JavaScript, Python, and more). I can provide training and consultancy.
Work Terms
I take hourly and milestone-based contracts, with a current hourly rate of US$60.