Andrea Hardesty Email & Phone Number

Paducah, Ky, Us

Paducah, Ky, Us

Paducah, Ky, Us

SQL: Led a team of Database Administrators, mentoring and guiding them while enforcing SQL best practices across the enterprise. Provided training in SQL Server maintenance, performance optimization, and troubleshooting. Acted as a subject matter expert, applying best practices to analyze workloads and improve database performance.Proactively identified opportunities for process automation. Utilized Solarwinds DPA to monitor and troubleshoot SQL instances, conducting root cause analysis to enhance system performance. Coordinated SQL upgrades with Software Engineering and Infrastructure teams, and collaborated on PCI audits to ensure accurate SQL audit documentation.Conducted internal SQL security reviews, enforcing the principle of least privilege, and validating elevated access with oversight committees. Supported daily operations, optimizing slow-running queries and providing SQL code recommendations for improved efficiency. Successfully coordinated SQL Server migrations, adhering to industry standards. Automated SQL processes using tools like Visual Basic, C#, and T-SQL.Delivered Tech Talks to Software Engineering teams, focusing on SQL best practices and functions.Unisys DMSII: Provided training and mentoring in DMSII (Unisys Data Management System) maintenance, performance optimization, and troubleshooting. Performed database maintenance, schema changes, and upgrades for DMSII databases on Unisys Clearpath MCP systems.Automated processes on Unisys mainframes using Unisys WFL (Workflow Language) and other tools. Delivered presentations on Unisys mainframe processes to internal teams, fostering better understanding of system functions and best practices.

Paducah, Ky, Us

Collaborated remotely with a team of 5 developers to conduct research, design, code, test, and uphold software solutions for numerous community banks.Played a pivotal role in the continuous development of over 5 loans applications, actively engaging in the coding and maintenance processes using COBOL74 on Unisys ClearPath MCPContributed to the resolution of support calls and crafted tasks to address critical bugs, ensuring the smooth operation of software applications.Innovated by developing an application using COBOL and WFL to automate standard testing processes. This initiative significantly enhanced efficiency, resulting in a reduction of over an hour per person in the overall time spent on each project.