Information Technology Specialist 5

ATTACH COVER LETTER AND RESUME

Under the general direction of the Information Systems Director, the Information Technology Specialist V provides service in application system architecture, application support, computer programming, report writing and database management. Application System Architecture Ensures that applications are scalable, reliable, available and manageable. Crafts the correct architecture to solve the problems at hand. Provides continuous research and review of current and projected solutions to address the ongoing need for the agency. Works with internal and external IT staff to ensure that best practices as identified for the agency are being followed. Participates in the hiring of additional contract application developers as needed. Provides work direction to external contractor application developers. Creates and maintains the technical application architecture used by the BOPD. Works with external business partners to establish and/or maintain a standardized integration solution/process. Application Support Provides application support. Responds to support tickets for Production Applications as well as ad hoc report requests. Computer Programmer Design, code and implement computer programs for a variety of data processing needs. Creates and deploys new custom applications, databases, computer programs and reports; performs analysis and modification of existing programs and operations to meet changing needs and to provide for system enhancements. Write maintenance and user documentation to support programs. Test and debug programs for accuracy and reliability; instruct program users in proper operation. Provides estimates for additions/changes to Production Application. Works on production issues as needed. Report Writer Analyze data and produce reports for a wide variety of applications. Develop customized reports from databases to extract and collect data according to end user and/or management needs. Database Administrator Monitors application performance and provides solution and/or recommendations on optimization as needed. Responsible for the performance, integrity and security of all agency databases. Creates and maintains database documentation, including data standards, procedures and definitions. Responsible for managing and testing back‑up and recovery plans for agency databases. Oversee the development and organization of the databases, assessment and implementation of new technologies, and providing Information Technology with a long‑term perspective on the relationship of database technology to the business opportunities facing the agency. Works on assigned projects designing and/or deploying databases/tables, adding data fields and/or tables to accommodate changes in agency needs. Knowledge and Skills Computer Programmer: Web API, JSON, Entity Framework Reporting Writing: Microsoft SQL Server, TSQL, Stored Procedures, SSRS, RDL, Power BI, SSAS, Parameterized Reports and Report Designer Database Administrator: Microsoft SQL Server, Database Administration, Database Tuning, Database Management, Database Security, RDBMS; knowledge of reporting and query tools and practices; application system architecture; business strategy and how to best utilize technology to drive that strategy; API architecture; relational data modeling; application support; experience working in a team‑oriented, collaborative environment with ability to present ideas in user‑friendly language; extensive knowledge and experience with Systems Development Life Cycle methodologies. Abilities Ability to prioritize and execute tasks in a high‑pressure environment. Self‑motivated and directed, with keen attention to detail; ability to plan, organize and work on multiple tasks simultaneously. Minimum Qualifications BE or BS Degree in one of the following subject areas: Computer Science, Information Technology or related field preferred. 2 years SSIS and SSAS experience. 2–3 years IT operation with strong understanding of database structures, theories, principles, and practices. 3–5 years Microsoft SQL Server experience. Minimum of 4 years working with systems design and support. 3 years' experience in complex relational data modeling. 3 years of experience developing, testing and implementing new technical computer program solutions. Experience developing new and modifying SSRS reports. Experience in development and maintenance of T‑SQL stored procedures, functions, and views to facilitate reporting. Experience with data management and data processing flowcharting techniques. Preferred Qualifications Business Intelligence Analyst/Developer. Multi‑dimensional and OLAP modeling, star schemas, OLAP cube database design and concepts, and ETL (SSIS). #J-18808-Ljbffr State of Minnesota Board of Public Defense