STATE OF CONNECTICUT EXECUTIVE BRANCH JOBS

Information Technology Analyst 2 (Confidential)

Office of Policy and Management

Recruitment #171121-7615CN-001

Introduction

The State of Connecticut's Office of Policy and Management (OPM) is presently accepting applications for an Information Technology Analyst 2 (confidential) position in the Budget and Financial Management Division, first shift, forty (40) hours per week, Monday through Friday.  This confidential position is exempt from collective bargaining.

This is an exciting opportunity to work with the latest in .Net and SQL Server in a fast-paced environment.  Showcase your software development skills by thinking outside the box to solve complex programming problems.  This position manages the system utilized for formulating and implementing the state budget, and also maintains selected agency web pages devoted to budget information.  This position requires knowledge of C# (or similar languages) and SQL.

Applicants for this position are required to submit a cover letter that describes your interest and suitability for the position and your resume.  Current state employees must provide the last three (current and consecutive) performance evaluations.  These documents must be uploaded with your application.

Selection Plan

This is a competitive position, open to the public.

PURPOSE OF JOB CLASS (NATURE OF WORK)

In the Office of Policy and Management and is accountable for development, deployment, operation and support of the statewide automated budget system, which includes access to matters involving collective bargaining. In a Information Technology (IT) environment, this class is accountable for independently performing a full range of information technology tasks and project coordination work involving infrastructure systems support, security and application development.

EXAMPLES OF DUTIES

For All Functional Areas: Acts as liaison to hardware and/or software vendors, system developers, programmers and user community; evaluates and recommends products; participates in Request for Proposal (RFP) process; assists in estimating cost for annual budget; identifies and implements opportunities for cost savings; conducts system performance analysis, tuning and storage management; assists staff and customers in use of computer systems and software packages; trains operators, IT staff and end users on new procedures; participates in recovery activities; participates in the evaluation of new, related technologies; analyzes requirements and designs systems; participates in or coordinates project planning sessions with customers, analysts and team members to analyze requirements and provide design recommendations for moderately complex systems; provides technical consultation on moderately complex issues regarding the usage of the infrastructure, integration of applications systems into the infrastructure, etc.; participates in system integration testing of operating system, system utilities, hardware upgrades as well as new software and hardware technologies; works with project team to define and design scope for each project; plans, coordinates and schedules assigned projects; coordinates resources for project; ensures timely completion of all phases of project; evaluates and recommends vendors; performs related duties as required.

Systems Programming: Provides second or third level support for network connectivity, or related network issues for the user community; diagnoses and resolves moderate network problems utilizing traces, hardware diagnostic tools, software aids, network management systems and utilities; coordinates the installation and maintenance of network components; analyzes network activity; analyzes capacity planning and facilities bandwidth requirements and system interdependencies; manage, maintains and contributes to network system documentation; develops back-up procedures for LAN servers; analyzes the recovery and reliability capability of systems and network services and makes recommendations for improvement; recommends hardware and software purchases in support of remote access; configures and certifies wiring; participates in projects which calls for troubleshooting, installing, implementing, administering, and maintaining network systems; assigns file access controls, encryption keys and other security attributes; maintains host and/or front end processor communications software; provides support to customers experiencing problems with hardware, operating systems and related utilities in servers; assists in installation and maintenance of performance monitors, schedulers, program management systems and utilities, report generators and compilers; configures and installs application packages; coordinates and/or performs installation and configures operating systems, new software releases, system upgrades and patches in support of hardware products; coordinates backups and file management with operations staff; proactively tunes operating systems and system components to avoid performance problems; writes utilities for system management, reporting, file clean up and auditing; provides and maintains documentation and manuals necessary at operational level; responsible for standards and design of physical data storage, maintenance, access and security administration; performs functions associated with vulnerability and security risk assessments; perform functions in support of investigative and forensics activity; performs related duties as required.

Software Development: Recommends and creates action plans for system development and/or integration; responsible for standards and design of physical data storage, maintenance, access and security administration; writes utilities for system management, reporting, file clean up and auditing; configures and installs application packages; develops and maintains documentation and manuals necessary at customer level; prepares time and cost estimates and initiates purchase requests for multiple projects; creates test files and performs system testing across multiple packages and systems; writes and programs system specifications; defines work and/or data flow; designs screens, forms and reports; defines data elements; prepares source code; designs and develops tables and relationships; arranges necessary hardware and software availability for assigned projects; may be responsible for design, development and implementation of new system interfaces for applications on multiple platforms from mid-range computers to client server and Internet based environments; analyzes assigned specifications, codes, tests and implements software solution, utilizing appropriate software engineering processes; debugs and/or corrects errors; maintains integrity of software; maintains and enhances existing programs; writes utilities for system management, reporting, file clean up and auditing; designs and develops routine to moderately complex applications; responsible for all phases of systems development life cycle; develops strategies for data acquisitions, archive recovery, security and implementation of routine to moderately complex applications; defines and develops the project scope of multiple projects; constructs operational Database Management System (DBMS) and data stores that enable informational, analytical management inquiry; performs backup and recovery on database management systems; configures database parameters, and prototypes designs; provides basic database support and troubleshooting; responsible for standards and design of physical data storage, maintenance, access and security administration; performs related duties as required.

Database Administration: Recommends and creates action plans for system development and/or integration; provides and maintains documentation and manuals necessary at operational level; provides basic database support and troubleshooting; responsible for standards and design of physical data storage, maintenance, access and security administration; writes utilities for system management, reporting, file clean up and auditing; analyzes requirements and designs systems; recommends and creates action plans for system development and/or integration; provides and maintains documentation and manuals necessary at operational level; proactively tunes operating systems and system components to avoid performance problems; coordinates backups and file management with operations staff; writes utilities for system management, reporting, file clean up and auditing; responsible for standards and design of physical data storage, maintenance, access and security administration; constructs operational DBMS and data stores that enable informational, analytical management inquiry; performs backup and recovery on database management systems, configures database parameters, and prototypes designs; performs related duties as required.

Network Support: Recommends and creates action plans for system development and/or integration; performs functions associated with vulnerability and security risk assessments; performs functions in support of investigative and forensics activity; maintains host and/or front end processor communications software; provides second or third level support for network connectivity, or related network issues for the user community; diagnoses and resolves moderate network problems utilizing traces, hardware diagnostic tools, software aids, network management systems and utilities; coordinates the installation and maintenance of network components; analyzes network activity; analyzes capacity planning and facilities bandwidth requirements and system interdependencies; manages, maintains and contributes to network system documentation; develops back-up procedures for LAN servers; analyzes the recovery and reliability capability of systems and network services and makes recommendations for improvement; recommends hardware and software purchases in support of remote access; configures and certifies wiring; participates in projects which calls for troubleshooting, installing, implementing, administering, and maintaining network systems; assigns file access controls, encryption keys and other security attributes; provides and maintains documentation and manuals necessary at operational level; develops and implements network security procedures; installs, configures and programs hubs, routers, bridges, gateways, servers, multiplexors, modems and other communications equipment; installs, monitors, maintains and upgrades network access to servers and mainframe services; maintains host and/or front end processor communications software; monitor network traffic for malicious activity; performs related duties as required.

IT Security: Assists in developing, testing and maintaining agency disaster recovery plans (DRP) designed to restore IT system operability; assists with development of processes and procedures in support of IT Business Continuity Planning; performs functions in support of platform recoverability assessments and Business Impact Analysis (BIA) to determine and assess the impacts associated with disruptions to business functions; performs functions in support of risk analysis of IT environments by assessing administrative, technical and physical safeguards; assists with IT investigations to include maintaining chain of custody procedures; performs forensics and documenting detailed reports of findings; monitors network activity for malicious activity; performs related duties as required.

KNOWLEDGE, SKILL AND ABILITY

Considerable knowledge of IT equipment and diagnostic tools; considerable knowledge of principles and techniques of systems analysis, design, development and programming; considerable knowledge of principles of information systems; considerable knowledge of principles and theories of business and planning functions; considerable knowledge of programming languages; considerable knowledge of capabilities of computer technology; knowledge of methods and procedures used to conduct detailed analysis and design of computer systems; knowledge of principles and techniques of software generation and programming; knowledge of practices and issues of systems’ security and disaster recovery; knowledge of computer operating systems; knowledge of project management principles and techniques; knowledge of principles and techniques of business information systems re-engineering; considerable technical problem solving skills; considerable logic and analytical skills; considerable oral and written communication skills; considerable problem solving skills; interpersonal skills; project coordination skills; considerable ability to analyze, troubleshoot and resolve data communications problems; considerable ability to write, test and debug computer programs; considerable ability to use programming development tools; considerable ability to prepare manuals, reports, documentation and other written materials; considerable ability to identify, analyze and resolve complex business and technical problems; ability to analyze and debug complex software programs.

MINIMUM QUALIFICATIONS - GENERAL EXPERIENCE

Six (6) years of experience in information technology (IT) operations, programming, systems/software development or another IT related support area.

MINIMUM QUALIFICATIONS - SPECIAL EXPERIENCE

One (1) year of the General Experience must have been performing professional information technology work in one of the following areas:
1. Installation and support of microcomputer hardware, software and operating systems.
2. Analysis, design and development of information systems.
3. Network hardware and software installation and support.
4. Network hardware and/or software problem diagnosis and resolution.
NOTE: For state employees this is interpreted at the level of Information Technology Analyst 1.

MINIMUM QUALIFICATIONS - SUBSTITUTIONS ALLOWED

1. College training in management information systems, computer science or information technology related area may be substituted for the General Experience on the basis of fifteen (15) semester hours equalling six (6) months of experience to a maximum of four (4) years for a Bachelor's degree.

2. A Master's degree in management information systems, computer science or electrical engineering may be substituted for one (1) additional year of the General Experience.

PREFERRED QUALIFICATIONS

The preferred candidate will have knowledge of C# and SQL.

Conclusion

AN AFFIRMATIVE ACTION/EQUAL OPPORTUNITY EMPLOYER

The State of Connecticut is an equal opportunity/affirmative action employer and strongly encourages the applications of women, minorities, and persons with disabilities.