Primary Responsibilities:

• Provide technical expertise to support and enhance existing ERP systems and in assessing new IT software projects and initiatives.
• Design and update reports, queries and views using various reporting platforms including MS SQL server and SQL reporting services.
• Review and monitor server and database logs, respond to exceptions, and build and maintain proactive management jobs.
• Use scripts to create repeatable jobs and application configuration.
• Assign user and profile security and system data access to ensure integrity of data within technology solutions.
• Project management, including systems upgrades, architecture and database management, software installation and configuration, and patch management services.
• Actively participate in meetings and contribute to developing strategies while providing technical guidance as well as collaborating with users to resolve issues.
• Identify opportunities that can improve efficiency of business processes.
• Assist and advise business users in the effective use of applications and information technology.
• Write technical procedures and documentation for the applications including operations, user guide, etc.; Ensure compliance with IT Policies and Procedures.
• Establish and maintain consistent, reliable, and optimized images for server and client systems.
• Participate in all implementations of software enhancements, upgrades, and patch installations.
• Provide user support including hardware and software installation, maintenance, troubleshooting, and training and orientation.
• Respond to technical requests from end‐users, managers, software developers and business unit team members.
• Test and maintain computer programs and systems processes and conduct periodic system reviews to ensure they are running efficiently.

• Gather end‐user requirements, preparing technical specifications, and ensuring the adoption of IT best practices.

 
Requirements:

• Bachelor’s Degree in Computer Science or related degree program; a minimum of 5 years’ experience in a Systems Analyst or DBA role.
• A minimum of 5 years of MS SQL server experience, including T-SQL scripts for queries, views, triggers, and stored procedures, backup and recovery, and maintenance jobs.
• ERP experience, preferably Visual
• Familiarity with programming languages including T-SQL and at least one of PowerShell, vbScript, or Python.
• Microsoft Active Directory, DNS, DHCP, and general networking
• Windows Server, Windows 10, Linux (CentOS and Ubuntu) system
• Experience with VMware ESX and VCenter
• Ability to influence and deal tactfully and confidently with all levels of the organization as well as internal and external Excellent interpersonal and communication skills (oral/written).
• Demonstrated ability to work with sensitive/confidential

Solid analytical and problem‐solving Expert ability to communicate complex technical solutions to non‐technical audiences.