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 use 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; perform 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; Store Procedures; SSRS; RDL; Power BI; SSAS; Parameterized Reports and Report Designer Database Administrator Microsoft SQL Server; Database Administration; Database Tuning; Database Management; Database Security; and RDBMS Knowledgeofreportingandquerytoolsand practices Application System Architecture BusinessStrategyandhowtobestutilizetechnologytodrivethat strategy API architecture Relational data modeling Application Support Experienceworkinginateam-oriented,collaborative environment with abilitytopresentideasinuser-friendlylanguage ExtensiveknowledgeandexperiencewithSystemsDevelopmentLifeCycle methodologies.

Abilities:

Ability toprioritizeandexecutetasksinahigh-pressure environment Self-motivated and directed, with keen attention to detail with 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 ?eld preferred 2 years SSIS and SSAS experience 2-3years 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 ?owcharting techniques

Preferred Qualifications:

Business Intelligence Analyst/Developer Multi-dimensional and OLAP modeling, star schemas, OLAP cube database design and concepts, and ETL (SSIS).