Ezequiel T.

Expert in relational database systems, especially PostgreSQL (Supabase, Amazon Aurora/RDS, Azure Hyperscale/CosmosDB/Citus, postgREST, RPC, RLS, timescaledb, PostGIS), MS SQL Server, and MySQL, with more than 27 years of experience as a database architect, designer, developer, and administrator. I’m also a software developer with 37 years of experience in many platforms, programming languages, and database systems. 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. * data quality, de-duplication, normalisation, AI-assisted enrichment. * single and multi-tenant systems, JWT authentication, RLS authorisation. * REST and RPC functions, Edge/Lambda functions, Webhooks, AI APIs, Realtime, migrations. * 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, archival, 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 UAT/development/test environments, Regular Expressions (regex), batch and shell scripting, sed and other text processing tools, Excel, 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.