*Applicants MUST submit a cover letter with resume to be considered. *This position will require in-office presence. Hybrid work schedules may be possible based on specific job duties and consistent with ESD policy.BASIC FUNCTION: Design, develop, maintain and administrate new and existing Microsoft SQL database and applications in support of ESD's business requirements. Applicant must possess a proficient knowledge of current/programming languages and be able to work both independently and in a team environment. Duties will include SQL Server and database administration, application programming, system installation/maintenance, diagnostics/performance monitoring, end user support, system disaster recovery, application testing and documentation as well as to provide technical assistance in any other area of IT as directed by department managers. WORK PERFORMED:
- Administrate database security and access permissions. Manage database user accounts and assist in system integration and data exchange.
- Manage SQL job scheduling
- Generate database technical documentation and standard operating procedures (SOPs)
- Support and develop data structures within ESD's internal data systems and Microsoft Dynamics Platform
- Develop and maintain logical database systems, develop data views and reporting systems, set programming standards and performance measures, document development and design
- Develop and support assigned business applications, taking on an active role in all stages of the application development life cycle
- Provide MS Office / Dynamics support for Access and Excel
- Provide Data Analysis and Ad Hoc reporting as required by application users and ESD Management
- Liaise with project managers, end users and 3rd party vendors in support of application requirements
- Troubleshoot application performance bottlenecks to ensure fast efficient workflow and data processing
- Develop Test and Debug strategies to ensure System reliability and data integrity
- Research new technologies to improve professional knowledge and maintain an industry current skill set
- Assist with IT Disaster Recovery efforts, testing and documentation
- Provide guidance and support to junior level programmers
- Provide technical assistance in any other area of IT as directed by department managers
MINIMUM REQUIREMENTS:Education Level required: BA in an IT related discipline with minimum of 2 years' experience in related field; Or a 2 year degree with a minimum of 3 years' experience; Or, any equivalent combination of experience and/or education from which comparable knowledge, skills and abilities have been achieved. Relevant experience required: BA in an IT related discipline with minimum of 2 years' experience in related field; Or a 2 year degree with a minimum of 3 years' experience; Or, any equivalent combination of experience and/or education from which comparable knowledge, skills and abilities have been achieved. Knowledge required: Strong proficiency with Microsoft Visual Studio 2015+, Microsoft SQL Server 2016+, C#, ASP.Net, JavaScript (JQuery Angular), Microsoft Office applications and Microsoft Operating Systems. Experience with Microsoft Dynamics, Application API (REST, Oauth), Scribe, Crystal Reports 11.x and HTML is helpful; Ability to work with a diverse group of people at both a functional and technical level and communicate at a level appropriate to audience; Ability to work both independently and as part of a team; Strong written and verbal communication skills.