Kimberley Moore Email and Phone Number

• Responsible for setup of Windows workstations in all patient waiting rooms and front desk reception, with best security practices including Active Directory, and ensuring HIPAA compliance for all employees• Responsible for installation and setup of cloud software for Webroot and Electronic Medical Records• Responsible for coordinating and consulting with internet providers and third party software providers when troubleshooting performance issues and documenting root… Show more • Responsible for setup of Windows workstations in all patient waiting rooms and front desk reception, with best security practices including Active Directory, and ensuring HIPAA compliance for all employees• Responsible for installation and setup of cloud software for Webroot and Electronic Medical Records• Responsible for coordinating and consulting with internet providers and third party software providers when troubleshooting performance issues and documenting root cause• Responsible for writing technical documentation for software processes • Responsible for ensuring network connectivity to printers, and other devices using WiFi Show less

• Managed SQL Server environment consisting of 4 locations of datacenters and Azure in the United States for the Data Platform Engineering Team. Responsibilities include installing maintaining SQL Server versions 2008 to SQL Server 2022 with associated SQL Services such as SSIS and SSAS. All critical applications utilized Always On with synchronous commit for Nodes 1 and 2 and asynchronous commit for Node 3 for read only use. This includes Development, UAT, Test, Staging and Production… Show more • Managed SQL Server environment consisting of 4 locations of datacenters and Azure in the United States for the Data Platform Engineering Team. Responsibilities include installing maintaining SQL Server versions 2008 to SQL Server 2022 with associated SQL Services such as SSIS and SSAS. All critical applications utilized Always On with synchronous commit for Nodes 1 and 2 and asynchronous commit for Node 3 for read only use. This includes Development, UAT, Test, Staging and Production environments for all critical applications• Managed continuous health of Always On Availability groups for critical applications• Managed SQL Server installations with specific IPs, non-traditional Port Numbers and AD Groups for added security• Managed response to alerting using Foglight, and Service Now with the Data Warehousing team, Network CRM team, SharePoint team and Veeam team to identify poorly performing queries• Managed response to alerting with the Data Warehousing team, Network CRM team, SharePoint team and Veeam team for failed SQL Agent jobs and database restore failures using Commvault and Ola Hallengren SQL Server Backup Scripts• Utilized Agile Methodology for Database Operations, Azure Dev Ops and JIRA to ensure timely delivery of business unit requests and Service Now tickets for incident resolution• Managed Software Releases with the Data Platform Engineering Team with preparation and validation testing and scheduled Change Controls for Production environment.• Determined SQL Server scope requirements and Risk Assessment for new applications based on Business Unit Requirements, including both hardware and software requirements• Exposure to other Database Management Systems including Postgres, Oracle and Snowflake and Cloud-based technologies though on call alerting and company training including Datadog and Terraform Show less

• Responsible for managing and overseeing a SQL Server environment of 700-800 servers globally. Database servers included both datacenter and local plant SQL Servers• Responsible for leading next generation database management with cloud computing using AWS and Azure• Member of Berry’s O365 Team with training business units when needed. Included technical documentation writing for Mobile Apps• Responsible for installing, configuring SQL Server 2019 and upgrading to SQL Server… Show more • Responsible for managing and overseeing a SQL Server environment of 700-800 servers globally. Database servers included both datacenter and local plant SQL Servers• Responsible for leading next generation database management with cloud computing using AWS and Azure• Member of Berry’s O365 Team with training business units when needed. Included technical documentation writing for Mobile Apps• Responsible for installing, configuring SQL Server 2019 and upgrading to SQL Server 2019. Prior versions of SQL Server present in environment included down to SQL Server 2005• SQL Installs included SSRS, SSAS and SSIS where requested and configuring• Responsible for installing and configuring SQL Server 2019 High Availability for Berry mission critical applications used for manufacturing, production tracking and ERP System• Responsible for installation and SQL Server Replication for critical manufacturing applications and ensuring reliable performance• Responsible for working with databases up to 3 TB to maintain best performance and determining best periods for maintenance and upgrades• Responsible for installing latest SQL Server patches and all updates using Baramundi automation software or manually during designated maintenance periods• Responsible for documentation of patching and reporting outcome to CIO and VP of IT Services • Responsible for implementing daily backups and weekly maintenance using Ola Hallengren SQL Server Backup Scripts • Responsible for working with Systems Group to ensure monthly Veeam backups were automated and tested for disaster recovery and restored on test servers for validity• Responsible for analyzing enterprise software, including Idera Inventory Manager and Solarwinds for database and diskspace monitoring• Responsible for managing Ivanti ticketing SQL Server Queue and all tickets associated with SQL Server team, distributing to team and completing tickets assigned in a timely manner before escalation Show less

• Responsible for managing and overseeing SQL Server environment. • Responsible for installing, configuring SQL Server 2017 and upgrading to SQL Server 2017. Prior versions of SQL Server upgraded included down to SQL Server 2008.• Responsible for installing latest SQL Server patches and all updates • Responsible for writing stored procedures for reporting and automation of processes using SQL Server Agent and SQL Server scheduled jobs• Responsible for AS400 connectivity using… Show more • Responsible for managing and overseeing SQL Server environment. • Responsible for installing, configuring SQL Server 2017 and upgrading to SQL Server 2017. Prior versions of SQL Server upgraded included down to SQL Server 2008.• Responsible for installing latest SQL Server patches and all updates • Responsible for writing stored procedures for reporting and automation of processes using SQL Server Agent and SQL Server scheduled jobs• Responsible for AS400 connectivity using IBM I Series Drivers for linked servers • Ensuring using Windows Administration best practices including Active Directory Service Accounts to run all SQL Server Services and auditing of SQL Server user connections Show less

• Maintained environments for the City of Charlotte financial accounting ERP System (Munis by Tyler Technologies) and invoicing system for the Charlotte Douglas Airport• Responsible for installing SQL 2008/2012, SSRS and maintaining service packs on all ERP SQL Servers via VPN and remote desktop, requesting firewall exceptions for database server access as well as establishing security for specific users within the City of Charlotte, CMPD and Airport AD groups by granting access to… Show more • Maintained environments for the City of Charlotte financial accounting ERP System (Munis by Tyler Technologies) and invoicing system for the Charlotte Douglas Airport• Responsible for installing SQL 2008/2012, SSRS and maintaining service packs on all ERP SQL Servers via VPN and remote desktop, requesting firewall exceptions for database server access as well as establishing security for specific users within the City of Charlotte, CMPD and Airport AD groups by granting access to Munis and Propworks. Munis and Propworks are in a separate firewall environment internal to the City of Charlotte• Maintained the production, training, test and development SQL Server environments for both Munis and Propworks• Responsible for ensuring redundancy between Myers Database Servers and Police Fire Training Academy Databases for the Production and Development Munis environments using SQL Server 2012 High Availability• Responsible for maintaining secure Munis EIN and SSN information for vendors information stored in Munis production and development databases using SQL 2012 Database Encryption• Responsible for assisting Finance Department with Vendor Merge of vendors from prior GEAC accounting system into Munis, yearly 1099 Processing and fiscal year closing of the books• Responsible for weekly transfer of Munis production database to Tyler via SFTP with sensitive vendor data wiped prior to delivery, nightly refresh of 4 test environments from production database, weekly and monthly refreshes of 3 development and 2 training environments• Responsible for reimporting Munis security and reimporting Munis workflow when requested after database refresh. Refreshes also include Propworks test, training and development environments from production database • Responsible for maintaining and deploying current reports on Production, Training, Test and Development SQL Server Report Servers developed by Tyler Technologies and internal developers for the City of Charlotte Show less

• Responsible for installing SQL Server 2005/2008, SSRS and maintaining service packs remotely on all servers via VPN and Remote Desktop. Create backups (full and transaction log) using Litespeed compression for Attenex databases and in-house application databases.• Responsible for creating SSIS packages for data export/import from sources such as SQL Server databases Microsoft Access, text files, Excel and Oracle databases from other Bank of America departments. • Responsible for… Show more • Responsible for installing SQL Server 2005/2008, SSRS and maintaining service packs remotely on all servers via VPN and Remote Desktop. Create backups (full and transaction log) using Litespeed compression for Attenex databases and in-house application databases.• Responsible for creating SSIS packages for data export/import from sources such as SQL Server databases Microsoft Access, text files, Excel and Oracle databases from other Bank of America departments. • Responsible for creating SQL scripts for upgrading the Casecura and UnifiedDirectory application test and production database environments which incorporates the Agile method of development. • Responsible for troubleshooting Attenex, Casecura and UnifiedDirectory database errors, connectivity and performance issues through JIRA and Sharepoint notification tickets. • Responsible for providing ad-hoc reporting from Casecura and UnifiedDirectory for Legal Department when requested.• Responsible for maintaining database security for developers, case analysts and management using Windows Authentication on production, test and development servers. Show less

• Developed and implemented a cross server ACH returns process to mark payments in databases that were returned for non-payment.• Created Data Transformation Services Packages and SQL Server Integration Services for data import/export.• Developed alerting within stored procedures to disable customer data loads below a certain threshold to reduce risk of large amounts of missing customer accounts. • Wrote customized stored procedures and triggers for custom back end processes at… Show more • Developed and implemented a cross server ACH returns process to mark payments in databases that were returned for non-payment.• Created Data Transformation Services Packages and SQL Server Integration Services for data import/export.• Developed alerting within stored procedures to disable customer data loads below a certain threshold to reduce risk of large amounts of missing customer accounts. • Wrote customized stored procedures and triggers for custom back end processes at client request.• Responsible for ad-hoc reporting and delivering multiple daily SQL reports for Embarq exclusively. • Troubleshot Speedpay database errors for both hosted and self-hosted clients.• Responsible for retrieving lost or modified production data in database resulting from mass updates or deletes using Log Explorer. • Provided detailed documentation on daily database maintenance practices for self-hosted clients. • Maintained SQL Server 2000/2005 Servers, Service Packs and Security Patches remotely on all servers via PCDuo.• Helped maintain Double Take Replication from database servers in NC to NJ. Maintained SQL Server Log Shipping on Development and QA servers where needed. • Maintained Oracle 8i /9i/NT Speedpay test environments for clients such as Citibank and Chase. Show less

Installed and configured SQL 7.0 servers and established database backup and recovery procedures for Point of Sale (POS) data for all Ralph Lauren stores.• Wrote stored procedures and set up automated SQL jobs to assist with reporting of POS data.• Worked with IT team to continue practices of database maintenance once consultant position was completed, and provided consulting service as needed.

Senior Database Administrator (April 1999 to September 2001)Responsible for installing, configuring and maintaining SQL Server 6.5, 7.0, 2000 on Development Department servers and desktops, QA Department servers and desktops and Sales Engineer laptops• Oversaw Commerce Exchange database installation project for SQL Server 6.5, 7.0, 2000 • Consulted with installation team to create database installation setup for Commerce Exchange • Administered Soffront TRACK database to monitor… Show more Senior Database Administrator (April 1999 to September 2001)Responsible for installing, configuring and maintaining SQL Server 6.5, 7.0, 2000 on Development Department servers and desktops, QA Department servers and desktops and Sales Engineer laptops• Oversaw Commerce Exchange database installation project for SQL Server 6.5, 7.0, 2000 • Consulted with installation team to create database installation setup for Commerce Exchange • Administered Soffront TRACK database to monitor software bugs during software development life • Collaborated with Instructional Communications department to write all documentation to be included with software related to database installation. • Installed, configured and maintained Oracle 8.1.6 /NT on Development Department servers and desktops, and QA Department servers. Database Administrator (February 1996 to April 1999) Responsible for installing, configuring and maintaining SQL Server 6.5, 7.0 on all machines including Development Department servers and desktops, QA Department servers and desktops, Sales and Engineer’s laptops. • Worked with Quality Assurance and Development teams to resolve Rogue Wave errors generated via Commerce Exchange database connectivity and SQL Client Configuration Utility errors. • Transferred all Commerce Exchange 2.5 Data on SQL Server to Oracle servers and Sybase servers when InterWorld began to support non-Microsoft DBMS's and UNIX in 1997. Show less

Responsible for installing and configuring NT Server desktop machines and servers and installing all user software including Microsoft Office Software, Email and Internet Explorer for the Office of Telecommunications.