Senior Engineer
Current- Automate various database administration tasks for a Centos 7 environment running PostgreSQL 13, including major version upgrades, data integrity checks, auditing, and performance tuning.- Create and maintain services to assist with the security and performance of an EHR system.- Create and maintain various utilities used by customer support teams to identify and fix problems for the HIS server concerning performance, uptime, and disaster recovery.- Created a proof of concept of a web service to remotely start cloud-hosted database migrations on-demand as its locally-hosted application started up post-update.- Assist with investigation of security breaches by hostile actors of HIS systems.- Automate deployment of database roles and default permissions via git workflows to an Azure Flexible Server for PostgreSQL instance.- Create a proof of concept for migrating a multi-tenant database in GCP to a PostgreSQL flexible server hosted in Azure- Create various tools to verify and monitor HIPAA compliance of our databases and HIS systems.