To use my skills in administration / development / Data Modeling and ETL with SQL Server and the operation of network systems.
I have written operations manuals and am an accomplished public speaker.
- Took over administration of 82 databases that had no backup or disaster recovery plan and created a backup and DR system.
- Applied third party monitoring to reduce query run times.
- Replaced numerous stored procedures that were slowing the system.
- Utilized SSIS to move and transform data and to replace more than 200 SQL jobs creating better efficiency and a troubleshooting path.
- Revamped SmartConnect middleware to achieve better synchronization times between CRM and Dynamics GP databases.
- Achieved better customer experience by implementing additional RDS servers and load balancing the remote location logins.
- Repositioned servers from physical boxes to VMWare saving the cost of purchasing additional hardware.
- Implemented a planned software/infrastructure lifecycle program to ensure that all software was up to date and functional.
- Utilized SQL 2008, 2012 and 2014.
DBA | Analysts International
- Utilized data modeling and SSIS to assist in merging adult and juvenile offender data into a single data source.
DBA / BI DEVELOPER
- Created data warehouse for renewals and commission payment.
- Administered SQL Servers for businesses.
- Utilized SSIS to move data from legacy system to new customer management system.
- Created disaster recovery and backup plans.
- Created almost real - time video reports for sales force by using replication and SSRS.
- Utilized SQL 2012 and 2014.
- Administered 8 SQL Servers for loan and collection processes and 13 MySQL Servers that were utilized for recording phone calls and miscellaneous data.
- Assisted in creating a PCI compliant infrastructure.
DBA / DATA MODELER
- Administered 2 SQL Servers.
- Utilized SSIS and the QuickBooks API to move data from 63 Family and business partnerships into a consolidated format in SQL Server.
- Assisted with completion of federally funded project for school districts that was running behind and was going to lose funding.
- Programmed UI utilizing vb.Net and Visual Studio.
- Responsible for all professor and staff computers and software.
- Responsible for two computer labs.
- Reworked and remodeled 30 years of dos based data into SQL Server utilizing DTS.
- Built the front-end application for enrollment and grading using VB.NET and Visual Studio.