Craig Newton

Implemented and Maintained SQL Server 2016-2019 High Availability (HADR) servers.

• Constructed Test , Preproduction and Production environments
• Recommended improvements in index and query design using various analytical tools
• Maintaining data integrity and security of data within the database
• Ensuring database backups , recovery , security principals
• Configuration of Availability Groups
• Diagnose, resolve and implement preventative measures using DMV's
• Physical and Logical Backups

Tools Used

First Responder Kit , sp_whoisactive, QueryStore, DMV's , Dbadas, dbatools,SCOM

PostgreSQL 11 -15 Clusters and High Availability Clusters using Patroni, ETCD, HAProxy

• Configure, Test, monitor, upgrade and tune new and existing PostgreSQL cluster
• Backup and recovery
• Physical and Logical backups
• Diagnose, resolve and implement preventative measures
• Upgrade minor , major versions

Tools Used

pg_dump, pgbackrest, pgbadger,pgadmin4,pg_upgrade, pg_repack

Involved in migration projects that converted SQL Server , Oracle databases to PostgreSQL databases.

PostgreSQL development of the NIbble's PostgreSQL Toolkit.

• Within a large Team assembled day-to-day maintenance of varied relational databases SQL Server , Oracle and Ingres.
• Administered, supported and strictly monitored databases to quickly resolve problems.
• Automated database preventative maintenance scripts.
• Monitored , troubleshoot performance related issues.
• Log shipping.
• Plan and execute the installation of new database servers and implementation of new databases in production and other environments.
• Collaborate with Application Operations, Infrastructure Operations , Software Development, Third-Party Vendors to perform application deployments.
• Perform regular database administration, configuration and maintenance activities for database systems including backup and recovery , security patching , incident resolution, change and release management.