Hire the Best Database Designers
in Australia

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.

Currently working as MS SQL Technical Lead (DBA and Developer Lead) for a top 10 Australian ASX20 company with over 200,000 employees. Over 10 years experience as an SQL DBA / Developer with Azure / AWS experience. Specialising in: • Microsoft Azure / Cloud support. • T-SQL Database development • Database Administration Tasks / Activities • Database Design • Performance tuning • Reporting Services • Integration Services / Azure Data Factory • Automating manual process to simplify day to day tasks. • Database Support • Power shell Scripting Unfortunately, due to the nature of my work, I’m unable to provide examples/samples of my work showing ETL processes developed or the quality/Structure of my code. More than happy to discuss further on the phone/e-mail in more detail. I have previously also worked a Business Analyst for 4 years which will hopefully help with communication and requirements to resolve your issues with ease. Looking to join Upwork for the following reasons: • Help fellow people / businesses resolve issues in a quick and easy manner • Continue to build my own skill set / knowledge with everyday tasks. • Looking to venture out into the freelance space Any questions happy to answer

I am not good at betting and gambling. If you look through my profile and decide that I can help you do not hesitate. I am very flexible and open to negotiations. I am an experienced application and database designer, and developer, as well as a business data and report analyst. I can fix your product, provide analysis, give advice, or complete a full project from start to finish. I have broad experience in the development, integration, and automation of: • Microsoft Office products such as Access (all versions), Excel (versions 3 through 2021), Outlook, PowerPoint, Project, Visio, and Word. • Database management systems: MS SQL Server (versions 6.5 through 2019), Oracle, MySQL, etc. • Reporting services such as SSRS, Crystal Reports, Business Objects, SAP, Access and Excel • Visualization tools: Power BI and Tableau Areas of Expertise • Design, Development, and Administration of Applications, Databases and Reports • Reviving, Rewriting and/or Migrating Legacy Applications • Data Migration and Managment • Designing and Building of Reports • Data Visualization • Web & Desktop Development • Implementation and Deployment of New Products • Project and Product Management • Cleaning, Wrangling and Analysing Data • Business & Functional Analysis • Supporting Marketing Campaign • Creation of Technical & Training Materials Languages For development and application support, I usually use C#, VB.Net, and ASP.Net, along with traditional Visual Basic, ASP, and VBA for legacy applications. Additionally, I often use scripting languages such as VBScript, JavaScript, and Power Shell. And for analysis, I prefer Python, R, and various SQL scripts (ANSI-SQL, T-SQL, PL\SQL, SOQL, SOSL, SAS-SQL, MDX, DAX, and M Language).