Database Administrator

• Feb 2018 - Present

Database Administrator

• Feb 2018 - Jun 2022

• Installation and administration of on-prem and virtualized SQL Server 2012-2019 instances. • Migrating databases and instances between on-premises and Azure. • Capacity and workload planning, baseline collection, and continuous performance monitoring. • Supported 20+ full stack developers in an agile development environment. • Extensive TSQL scripting of stored procedures and user-defined functions for Jira trouble tickets. • Management of SQL git repository and preparation\implementation of release migration scripts. • Daily performance tuning utilizing execution plans, extended events (XE), and Querystore. • Extensive backup & restore including development of custom backup management system utilizing full, differential, and log backup strategies with point-in-time restore capability. • Fully documented enterprise database environment and procedures in Notion. Show less

Director of Database Development

• Apr 2005 - Sep 2017

• Development and administration of 50+ SQL databases across multiple instances, servers, and domains. • Data modeling with MS Visio to build entity relationship diagrams (ERDs) for new system design and reverse engineering preexisting systems to ERDs for documentation. • Extensive performance tuning utilizing dynamic management views (DMVs), SQL Server Profiler, execution plans, and index-tuning. • Requirement gathering, design, development, testing, implementation, and maintenance of SQL Server databases • Backup & restore including development of custom backup management system utilizing full, differential, and log backup strategies with point-in-time restore. • Installation of Microsoft SQL Server in physical and virtualized environments. • Extensive TSQL scripting of database objects like tables, indexes, stored procedures, views, and user-defined functions. • Daily construction of SQL Server Integration Services (SSIS) and SQL Server 2000 Data Transformation Services (DTS) packages for ETL. • Administration of FTP and SFTP servers and accounts. • Daily management and administration of SQL Server 2000/2008R2 Agent service and jobs. Show less

Financial Analyst

• Feb 2003 - Apr 2005

• Design and administration of Microsoft SQL Server 2000 Desktop Edition (MSDE) database to facilitate ETL between finance and human resources departmental applications. • Development and administration of variable-incentive compensation database in MSAccess pulling data from enterprise CRM (SalesLogix) and accounting (Axapta) systems with SQL Server 2000 backends. • Design and tuning of VBA modules to automate production and distribution of financial reports in Adobe Acrobat and Powerpoint formats. • Form design and implementation to standardize and expedite data extraction, transform, and load (ETL) via MSDE. • Designed and implemented VBA modules to compile and distribute incentive compensation reports for each salesperson in Adobe Acrobat and distributed via email. • Designed and implemented MSAccess frontend to enterprise payroll software (ADP PCPW) to generate journal entries, process PTO, and generate data imports from HR enterprise database (ABRA). Show less