SUMMARY:

• An experienced Senior DBA and respected Subject Matter Expert with 20 + years of experience providing a highly secure SQL Server Environment ensuring a positive end to end Customer Experience. Experienced in DEV OPS and Agile environments while collaborating with cross - functional teams on new and existing products. Deeply focused on applying best practices in all phases of installation, monitoring, securing, maintaining, BCP and DR, and troubleshooting a diverse SQL Server environment.

SKILL:

• Veritas NetBackup 10.0 Administration - June 2022
• Microsoft SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017,2019, SSRS, SSIS
• AWS Cloud Practitioner Class 4/2022
• CompTIA Security+ Online - ongoing
• Sentry One - Solar Winds
• Microsoft Certified: Azure Fundamentals - 12/2019
• AWS Fundamentals 6/2019
• AWS IaaS SQL Databases
• Service Now
• BCP (Business Continuity Processes) including Backup and recovery technologies
• Replication, Database Mirroring, Log Shipping, High Availability Always On technologies
• Infrastructure Design
• PowerShell for the DBA
• SQL PowerTools
• Azure SQL Database including V12
• Agile tools - Trello, Jira, Confluence
• Windows Server 2000, 2003, 2008, 2012, 2016, 2019
• EMC and IBM Storage SANs
• Integrated Database Security
• Project management
• Idera SQL Compliance Manager

WORK EXPERIENCE:

Senior Database Engineer

Confidential, New York

Responsibilities:

• Support database operations for Constellation Brands resulting in Net Sales +11%, Shipments +8.8%, Depletions +8.9% in FY 2022.
• Provide Support and monitoring of database systems for WMS, ASRS and MES systems packaged over 1.19 Million cases of beer per day. Exceeding previous peak season records by over 200,000 cases/day. These operations have supported the Corona and Modelo brands and the increase in sales and revenue over the past 5+ years while with the company.
• Implemented Sentry One to monitor our Always On implementation at our Mexican Breweries in Piedras Negras and Obregon, Mexico.
• Supported Operations which generated a record 20,720,000 Cases in month of July 2020.
• Working with Microsoft and Third-Party Vendors implemented a Hyper Care platform to identify poor performing operations and implement vendor solutions. Implemented several solutions to reduce weekly downtime from 12 hours per week to less than 1 hour per week in a 7x24x365 operations - 2017.
• Worked on Beer Projects 2.5, 2.75 and 3.0 to allow for full Packaging Capacity in our Brewery. This raised the overall revenue of beer operations to $3.8 Billion dollars from $3.2 Billion dollars in FY 2016.
• Assisted in the migration efforts of the purchase of the Obregon Brewery in 2017. Completed database migrations in less than 3 hours resulting in the brewery back online 8 hours sooner than planned.
• Design a new Database solution for our POS systems at the winery saving the purchase of 8 additional licenses at $2800 per winery.
• Design and Implemented solutions for the Brewery Expansion at Obregon for 8.5 and 13.5 projects.
• Design and Implement Code Deployment standards for the NAVA Brewery Database environment. These standards and process were then migrated to all database systems maintained by the team.
• Design and implement an automated Database Installation process for SQL 2012, 2014, 2016, 2017, and 2019.
• Implemented a Security monitoring solution with vendor EY for Corporate Security.
• Developed new Database Security practices that reduced SYSADMIN level access by over 75%.
• And at the same time reduced individual account management by implementing an Active Directory Security Group policy and standards. Implemented Managed Service Accounts in various Data Centers.
• Implement the SQL 2005/2008 upgrade project moving over 364 databases to SQL 2016 while at the same time retiring over 500 inactive SQL Databases from previous upgrade efforts.
• Developed and tested an AWS Cloud effort for the Archiving of SQL 2008 Databases.
• Design and implement a Mexican Project Software solution in the AWS cloud.
• Design database systems for RPA-Blue Prism, Salto, ZOE, Profisee, and many other third-party SQL Based software applications.
• Developed an automated solution using PowerShell to install SQL Server with Microsoft and CBI database standards for SQL 2012, 2014, 2016, 2019.At the IVC Glass Plant:
• Design and implemented a Vendor Driven BI platform for Operations.
• Design and implemented TecnoFerrari LGV project and completing tasks on-time.
• Design and implemented the CPM Data Warehouse management system tracking end-to-end glass manufacturing.
• Design and implement the System Logistics Modula parts warehouse project on time.

Senior Database Engineer

Confidential

Responsibilities:

• Lead DBA tasked with the Design and implementation of the Azure SQL Database technology for StratusTime product.
• As Scrum Mater developed an Agile methodology for a 3-man DBA team to design, test and build solutions for migrating StratusTime client’s databases to the Azure cloud. Using Kanban and sprint planning for the 3-man team we developed a solution and delivered in 60 days leveraging 3 total sprints.
• Tasked as lead DBA for the NetTime acquisition. Design, Implemented, and supported uplift of StratusTime database servers to SQL 2014 HA with encrypted backups. Install and configure SQL 2012/2014 High Availability Always On features for TLO and StratusTime.
• Assist with product performance to exceed $17 million in revenue in 3rd full year of TLO product.
• Successfully managed the storage migration from EMC to XIV storage with minimal downtime.
• While Lead DBA, worked with team to assist rapid growth of TLO Product by doubling client count in 18-month span to over 18,000 active client databases.
• Implemented DBA standards for server builds based on physical or Virtual hardware requirements.
• Automated the installation of SQL 2005/2012/2014 for faster deployments.
• Uplifted 32 SQL Servers from SQL 2005 to SQL2012 in 14 weeks. Over 20,000 client databases, with no client impact at a cost savings of over $350,000 in license consolidation and leveraged virtual hardware.

Senior Database Engineer

Confidential, New York

Responsibilities:

• Implementation of I-3 Monitoring for real time alerting and performance improvements.
• Managed EMC SAN’s using ECC
• Managed SQL Server Service Packs and upgrades on BAAN ERP system.
• Built and manage Warehouse Management system from Red Prairie
• Upgraded SQL Server databases from HP to UNISYS ES-7000 hardware with EMC DMX1000 SAN and converting to SQL Server 2000 Data Center software.
• Managed databases for new ERP system called BAAN.
• Managed SAN “Mirror” Snaps for reporting and ETL systems.
• Assisted with Custom Warehouse reports helping to push over $1 million in orders out of the warehouse after failed WMS release.
• Systems Analyst for Desktop Support. Trained for SQL Database Position.

Senior Field Service Representative

Confidential

Responsibilities:

• I was the Upstate NY field service rep for supporting a client base of $400,000.
• Grew territory from $250,000 to over $400,000 in annual service revenue.
• Support large format continuous form laser printers for Global Distribution center at Eastman Kodak
• Met monthly preventative maintenance goals and continued a high level of customer support.
• Worked out of my house with a company provided van.

Regional Field Supervision In-house Maintenance

Confidential

Responsibilities:

• Managed a 5-employee regional service department supporting IBM Point of Sale (POS) systems, Time Clocks, and computer-based store systems in 64 Ames Departments stores in update New York and Northern Pennsylvania.
• Create regional department from 4 bare walls.
• Managed to maintain and service 64 stores and maintaining a 97% uptime on all registers during holidays.
• Created a financial tracking system for expense reporting and overall operational expenses.
• Managed a fleet of 3 leased vans, call management and preventative maintenance systems, along with in-house depot repair facility.
• Managed and upgraded IBM PS2 60 and 80 computers for retail POS systems.

Senior Customer Engineer

Confidential

Responsibilities:

• Provide field support for Office, Financial, and Computer based products for Western and Central New York.
• Maintain 100% completion on scheduled preventative maintenance.
• Certified on IBM PC, XT, AT computers. Provide national support on Financial and Labeling systems.
• Provide support to field team to meet or exceed yearly equipment sales.
• Provided support to triple the population of computer-based label systems in upstate NY with over $300,000 sold in 2nd year of release.