Visual Basic Consultant (Support)

Application Support Engineer - Birmingham, AL Job title: Application Support Engineer Job location: Birmingham, AL SUMMARY: Under limited supervision, the Hydraulics Engineering Software Engineer maintains access to the databases used by engineering and technical support personnel. Supports custom business applications and users by enhancing applications and managing database backend. JOB DUTIES • Maintains access to the databases. • Supports clients with networks and virtual machines. • Supports the technical team with Hydraulic product expertise. • Identifies opportunities for process and procedure enhancements and communicates them to drive efficiency. • Support users by delivering new features to their business applications. • Troubleshoot/correct reported bugs; push-out revisions. • Deploy software for new users. • Access SQL Server ‘back end’ for maintaining tables (data cleansing – removing null entries, corrupted data, spelling errors, etc.). • Update SQL Server transaction codes. • Monitor and optimize the performance of the database using “SQL Server DB Engine Tuning Advisor” and “SQL Server Profiler.” • Backup Server databases to VM as necessary between releases of new versions KNOWLEDGE, SKILLS, ABILITIES • Visual Basic language programming. • Hydraulic product knowledge. • Manages multiple tasks simultaneously while meeting deadlines. • Communicates complex procedures to other colleagues. • Pays close attention to detail and desires to probe further into data. PROGRAMMING TOOLS: (Client-side) • Microsoft® Access® for Microsoft 365 MSO (Version 2308 Build 16.0.16731.20542) 64-bit. • Visual Basic for Applications (VBA) Editor – located under Database Tools menu in Microsoft Access 2016, used to enter VBA code for Forms, Reports, custom functions, etc. • MS Access Debugger • MZ-Tools 8.0 (Add-in) • JSON converter for VBA • Application Programming Interface (API) calls • VBA Automation – calls to external programs like Excel, Word, Outlook. • VBA Editor • JSON based calls. (Server-side) • Microsoft SQL Server Management Studio. • Transact-SQL (T-SQL) - Structured Query Language. • SQL Server Profiler – graphical interface for monitoring Database Engine instances. • Database Engine Tuning Advisor (DTA) – tool to optimize database performance.