Responsible for designing and developing a companywide ERP solution, consisting of Microsoft Business Central as the backend with a custom Microsoft Power Apps order entry system that passed data to the ERP via Microsoft Power Automate. Utilized Microsoft Power BI for reporting and analytics which pulled data from both Business Central and Dataverse through APIs on regular schedules. Used Agile methodologies both internally and coordinated with the outside consulting group. Setup Jira to… Show more Responsible for designing and developing a companywide ERP solution, consisting of Microsoft Business Central as the backend with a custom Microsoft Power Apps order entry system that passed data to the ERP via Microsoft Power Automate. Utilized Microsoft Power BI for reporting and analytics which pulled data from both Business Central and Dataverse through APIs on regular schedules. Used Agile methodologies both internally and coordinated with the outside consulting group. Setup Jira to track requirements during development and issues after initial deployment. Setup Github integration with Power Apps for version control which included configuring application account permissions in Azure. Managed the project for the ERP with outside consulting firm. Once implemented, supported the 80 plus users of the system. Managed small team through the initial development and implementation phase. Reported to CFO and was involved in most C level management meetings and activities. Show less

Responsible for implementing the company's first data governance program. Worked with outside industry expert to develop a customized solution that included an operating model, road map and communications plan.

Responsible for design of database environments, understanding requirements from stakeholders and encouraging solid architectural principles throughout the software development lifecycle. Led effort to migrate to MS Azure including moving to SQL Azure.

Senior DBA responsible for production support of MS SQL Server environments, focused on performance. Worked with development teams to support their SQL Server environments.

Contract position leading the database team responsible for migration of customer data into System Works Secretary of State software. Team also responsible for maintaining development, quality and production environments, developing database tools for internal and production use, maintaining data models, and identifying and solving performance issues. Worked with MS SQL Server 2012 including Data Tools, Toad data modeler, and TFS.

Team lead for the database group. Responsibilities include lead architect, performance and tuning, innovation, migration, data collection, and setting general direction for the team. Worked with all levels within the organization from CEO to mentoring junior team members.• Key member of an innovation team that sought new ways to migrate customer data more quickly and affordably.• Managed process of loading vehicle data from all 100 NC counties.• Developed complex migration process… Show more Team lead for the database group. Responsibilities include lead architect, performance and tuning, innovation, migration, data collection, and setting general direction for the team. Worked with all levels within the organization from CEO to mentoring junior team members.• Key member of an innovation team that sought new ways to migrate customer data more quickly and affordably.• Managed process of loading vehicle data from all 100 NC counties.• Developed complex migration process using MS SQL Server 2012 SSIS. Show less

Development and production database administrator and data architect. Responsible for all aspects of database support on MS SQL Server 2008 R2. Responsible for design decisions and database modeling. Responsible for all aspects of production support for SQL Server databases running on virtual environments. Responsible for setup and support of SSRS environment and reports. Main contributor for recommending processes and tools for supporting all aspects of company’s database needs.

Primary development database administrator and designer. Responsible for creating and maintaining all data models for company’s talent acquisition suite of products using Sybase Power Designer. Responsible for creating and maintaining all MS SQL Server 2008 development database scripts used for product upgrades. Responsible for diagnosing and resolving database and query performance issues. Responsible for maintaining development database servers. Assist operational DBAs with tough issues… Show more Primary development database administrator and designer. Responsible for creating and maintaining all data models for company’s talent acquisition suite of products using Sybase Power Designer. Responsible for creating and maintaining all MS SQL Server 2008 development database scripts used for product upgrades. Responsible for diagnosing and resolving database and query performance issues. Responsible for maintaining development database servers. Assist operational DBAs with tough issues whenever needed. Leverage my 20+ years of experience to provide database expertise throughout all levels of the organization. Show less

Designed, implemented and maintained database to support new web based license and vessel registration system. Worked with developers as a subject matter expert for SQL.

Managed data model and provided database support for all aspects of development for investment tracking system.

Database developer and administrator for a newly created development team. Took over responsibility of existing database environments from previous consulting group. Responsible for daily administration, changes and new development in the database environments and migrating existing databases from Microsoft SQL Server 6.5 to 2000. Used ER/Studio for data modeling.

Responsible for all database development and support for a small startup company. Created logical and physical data models for multiple databases using ER/Studio from Embarcadero Technologies. Implemented databases on MS SQL Server 2000 including development of stored procedures and functions. Integral part of the team that designed the overall system and validated Microsoft's new Simple Object Application Protocol. Assisted with debugging of Visual Basic data access code using MS SQL… Show more Responsible for all database development and support for a small startup company. Created logical and physical data models for multiple databases using ER/Studio from Embarcadero Technologies. Implemented databases on MS SQL Server 2000 including development of stored procedures and functions. Integral part of the team that designed the overall system and validated Microsoft's new Simple Object Application Protocol. Assisted with debugging of Visual Basic data access code using MS SQL Server 2000 tools. • Worked with business analysts to create data model for equity tracking system.• Designed system for re-applying business rules to modified transactions. Show less

Responsible for installation and support of development and production MS SQL Servers. Designed and implemented logical and physical database models using Erwin. Responsible for performance tuning and monitoring of production databases. Assisted development efforts by creating stored procedures and by passing knowledge on to developers. Worked with customers, developers and system administrators to diagnose, troubleshoot and fix problems. • Researched and engineered implementation of MS… Show more Responsible for installation and support of development and production MS SQL Servers. Designed and implemented logical and physical database models using Erwin. Responsible for performance tuning and monitoring of production databases. Assisted development efforts by creating stored procedures and by passing knowledge on to developers. Worked with customers, developers and system administrators to diagnose, troubleshoot and fix problems. • Researched and engineered implementation of MS SQL Server 2000.• Led design of data replication system between AS/400 and SQL Server. Show less

Responsible for design and development of Internet tee time reservation system. Produced database designs using ER/Studio. Used MS SQL Server 6.5 and 7 for backend database. Golf course front-end written in MS Access 97. Web front-end written in Visual Interdev. Also produced a utility to add new customers using Visual Basic 6.0.

Setup and maintained Sybase, Oracle and MS SQL Server databases for both development and production environments. Primary provider of support for database issues in both development and production. Developed and maintained logical and physical data models using Erwin. Developed, coordinated, and implemented database migrations between product versions. Provided performance analysis and tuning of both development and production database systems. Trained all levels of personnel.

Provided database expertise for the Release Engineering and Test Systems groups. Setup and maintained Sybase and Oracle databases for the purposes of software verification and performance testing. Handled all database issues related to the building and releasing of project systems. Provided database design and performance analysis through all phases of software development.

Supported eight customer databases, two of which were in the gigabyte range, on multiple Sybase SQL servers. Daily responsibilities included keeping reference data synchronized, maintaining nightly dumps and weekly consistency checks, and helping developers with SQL. Managed source code and development environments for systems, applications, and database groups. Created and maintained routines for tracking code changes.

Managed a team of six programmers responsible for designing, implementing, and maintaining over 100 large database products on a VAX/VMS cluster. Team produced file maintenance and data integrity systems in C, FORTRAN and RMS, as well as resolving problems in the applications.