Lori Fry Email & Phone Number

United States

Tulsa, Ok

• Monitored SQL Server Health using Spotlight on over 100 SQL Servers with a mix of SQL versions ranging from 2008 R2 to 2019.• Created Windows scheduled tasks utilizing PowerShell scripts, SSRS reports and SQL stored procedure emails to proactively monitor server performance increasing situational response time.• Safeguarded data by confirming backups, performing regular database integrity checks, and managing user access to SQL Servers and databases resulting in desired system uptime and data integrity.• Automated SQL Server daily health checks with a combination of PowerShell and SSIS packages. • Applied years of hands-on experience and training in performance tuning to make queries run faster with fewer resources.• Used experience in OLTP and SSIS to improve user productivity and efficiency and support creation of OLAP data warehouse.• Supervised code review of scripts and SSIS packages with developers and advised them on code optimization techniques thereby improving performance.• Diagnosed job errors and implemented solutions by working with developers and Server Administration to solve issues in a timely manner resulting in less downtime.• Configured and supported SQL Server replication in SQL version 2008 and 2012 enhancing financial accuracy for international offices.• Automated processes for installations and patching which resulted in reduced server standup time and downtime.• Created and conducted SQL DBA training classes for interns to help them select their area of study.• Currently collaborating with Cloud Operations team to provide user access to Azure SQL Databases using Azure Active Directory.

Helmerich & Payne, Inc

• As Database Administrator for the HR/PR department, maintained the data integrity of two large SQL databases that served as the backend for companywide reporting solutions and MS Access databases as well as creating all the SQL stored procedures and views that were used which increased employee productivity and decreased paper usage and storage by 50%.• As Lead support person for the Benefit Department, monitored the employee benefit database, performed yearly plan table maintenance and modified custom programs provided by the Payroll/Benefits software vendor to ensure maximum uptime and consistent performance. • Supplied daily technical support to the employees in the Benefit Department as they navigated through both purchased and custom software applications increasing productivity. • Designed numerous MS Access procedures to create electronic data feeds to the benefit vendors used by H&P to maintain their employee memberships leading to data accuracy and faster enrollment turnaround.• Conducted training classes for co-workers to familiarize new employees with the structure of the CYBORG Payroll and Benefit modules and how to use the COGNOS reporting tool called Impromptu thus increasing understanding and proficiency. • Conducted yearly training classes for personnel coordinators who travel to the corporate office in Tulsa from offices around the United States decreasing support calls.• Taught several classes on how to use the CYBORG program at a high level and how H&P uses SQL databases and MS Access to provide support to the HR/PR department to showcase the accomplishments of the system.

Ponca City, Oklahoma, United States

• Maintained mainframe COBOL programs used in school accounting process and developed new PC based program in DBASEIII which increased payroll turnaround time. • Designed the SQL Server relational database and created a new user interface using VB6 which facilitated transition from an in-house keypunch system to customer computer data entry further increasing payroll turnaround time.• Developed, tested and implemented the PC programs and created user manuals as well as trained school employees in proper use of software decreasing support calls.• Installed software at client schools that enabled them to enter their payroll data into the system and transmit it electronically to ADPC for processing and creation of payroll checks, W-2’s and state required reports and data files which resulted in timely submission of data to the state and paychecks to the employees.