Information Technology Specialist

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.

• 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.

• Provides application support. Responds to support tickets for Production Applications as well as ad hoc report requests.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

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