Sam Stepter

Experience

1. Sr Database Administrator

   NextGear Capital by Cox Automotive

   Oct 2016 — Present

   Migrated several Production Databases into AWS EC2 and AWS Aurora. • Built a reporting framework leveraging Powershell, AWS Lambda and S3. • Responsible for the setup of new Microsoft SQL and PostgreSQL servers. • Leveraged PowerShell and a vendor API to extract security scan data into SSRS and created reporting dashboards interpreting the data. • Manage 20+ PostgreSQL 9.6 clusters on CentOS and 50+ SQL Servers ranging in size from 1GB to 3TB. • Created High Availability and disaster recovery plans for PostgreSQL and MSSQL that meets the RTO and RPO objectives. • Maintain code repository for all SQL code in GITHUB Enterprise and Atlassian Stash. • Setup Automated auditing of all database and application permissions for several production application. • Leveraged PowerShell/bash to automate point in time database restore process from Production to UAT and development environments for PostgreSQL and MSSQL. • Automate DBA tasks leveraging PowerShell, BASH and SQL. • Monitor the health and replication status for all MSSQL and PostgreSQL servers. • Assist developers with optimizing poorly performing queries and stored procedures. • Advise developers on best practices for new micro service applications. • Leveraged PowerShell/bash to automate a point in time database restore process from Production to UAT and Development environments for PostgreSQL and MSSQL. • Assisted a development team with creating an automated frameworks for developers to leverage allowing them to create server logins and database users for new Microservice applications.