Connecticut StateDepartment of Administrative Services

Information Technology Analyst 3 (40 Hour)

Performance Office

Recruitment #200108-7605FD-002

Introduction

 

 

The Connecticut State Department of Education, Performance Office, is recruiting for an Information Technology 3 position. The Performance Office collects data about students, staff, schools and districts to satisfy reporting and policy priorities. We are seeking an experienced Database/Server Administrator to work as a full-time Information Technology Analyst 3 in our IT Development unit. Many mission-critical functions depend on this unit including all data collections applications, the teacher certification system, RSCO Lottery system and the data warehouse and reporting portal – EdSight.

The individual in this position will work collaboratively to:

  • Set up/maintain the Microsoft SQL Server infrastructure which includes virtualized environments.
  • Implement security practices to protect confidential information.
  • Manage SQL Server data storage and disaster recovery.
  • Develop and maintain data collection applications.
  • Troubleshoot application and database issues.
  • Provide support to end-users.

This position is located at the State of Connecticut office building at 450 Columbus Boulevard, Hartford. This is a full-time 40-hour position that operates Monday - Friday, 8:00 a.m. - 5:00 Columbus Blvd., Hartford, CT.

Selection Plan

  • New hires to state service start at the minimum of the pay plan.
  • There are no supplemental attachments required at this time. Candidates selected for interview will be asked to provide a resume detailing experience in addition to three (3) pertinent professional references. State employees selected for interview will be asked to provide a copy of their last two service ratings.
  • Due to the anticipated volume of applications, the Bureau of Human Resources is unable to provide confirmation of receipt and/or the status of applications during the recruitment process. Updates will be provided through your JobAps portal account. Interviews will be limited to candidates whose experience and training most closely meet the requirements of the position. For all other inquiries, please contact Kim Barberi at kim.barberi@ct.gov; 860-713-6691.

PURPOSE OF JOB CLASS (NATURE OF WORK)

In a state agency Information Technology (IT) environment, this class is accountable for performing the most complex and technical support work and/or acting as a working supervisor of Information Technology Analysts engaged in information systems development or technical support.

EXAMPLES OF DUTIES

All Functional Areas: Diagnoses host system problems and develops and coordinates resolutions; manages planning, analysis, design, selection, installation and implementation of new technologies; evaluates new technologies; tests and evaluates new hardware and/or software; makes recommendations for hardware and/or software purchases; determines interface and utility requirements and creates design specifications; acts as liaison to hardware and/or software vendors, system developers, programmers and management; develops and implements network and system security guidelines; makes recommendations for migration and upgrade directions; trains operators, systems developers and users on new procedures; conducts system performance analysis, tuning or storage management; conducts technical training programs for IT staff; acts as project coordinator overseeing other technical staff and support personnel; plans, coordinates and directs multiple projects of assigned staff; reviews work of assigned personnel; calculates project time and cost estimates; prepares necessary procedural specifications to meet design requirements; arranges necessary hardware and software availability; oversees hardware and software vendors; manages project budgets and schedules; reviews work of assigned Information Technology Analysts and serves as consultant and/or troubleshooter; reviews documentation work of assigned staff; communicates with business owners and management; facilitates meetings; assists in development of information technology policies, procedures and standards; participates in Request for Proposal (RFP) process; implements disaster recovery plans, assists in determining critical applications and personnel, or ensures offsite backups; defines data flow; performs related duties as required.

Working Supervisor Use: Plans unit workflow and determines priorities; schedules, assigns, oversees, and reviews work; establishes and maintains unit procedures; provides staff training and assistance; conducts or assists in conducting performance evaluations; acts as liaison with operating units, agencies, and outside officials regarding unit policies and procedures; make recommendations on policies or standards; prepare reports and correspondence; performs related duties as required.

Systems Programming: Performs the most complex duties related to application development; develops and implements system programming standards; configures and installs host-based application packages; maintains host operating systems; installs and upgrades host and/or Front End Processor (FEP) operating system software; performs other related duties as required.

Software Development: Configures and installs host-based application packages; analyzes upgrades for complex applications to determine functionality and necessary software customization; writes program specifications and systems specifications; designs forms, screens and reports; performs related duties as required.

Database Administration: Provides advanced level database support and troubleshooting; designs, installs, tunes and maintains integrity of major host-based database; leads integration efforts, transitioning applications to new technology; performs related duties as required.

Network Support: Designs and implements complex communications networks; diagnoses and resolves problems using network management systems and utilities; performs related duties as required.

IT Security: Develops, tests and maintains agency disaster recovery plans designed to restore IT system operability; develops process and procedures in support of IT Business Continuity Planning; conducts platform recoverability assessments and Business Impact Analysis (BIA) to determine and assess the impacts associated with disruptions to business functions; conduct risk analysis of IT environments by assessing administrative, technical and physical safeguards; performs IT investigations to include maintaining chain of custody procedures; performs forensics and documents detailed reports of findings; performs related duties as required.

KNOWLEDGE, SKILL AND ABILITY

Considerable knowledge of principles and techniques of systems analysis, design, development, and computer 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 project management principles and techniques; considerable knowledge of principles, problems and techniques of data processing and data communication operations; considerable knowledge of data processing and data communications equipment and diagnostic tools; considerable knowledge of methods and procedures used to conduct detailed analysis and design of computer systems; considerable knowledge of principles of complex computer operating systems; knowledge of principles and techniques of business information systems re-engineering; knowledge of network protocols and architecture; knowledge of practices and issues of systems security and disaster recovery; knowledge of applications systems development principles and techniques; knowledge of principles and practices of data base management; considerable interpersonal skills; considerable oral and written communication skills; considerable problem solving skills; considerable technical problem solving skills; considerable analytical skills; considerable ability to prepare correspondence, manuals, reports and documentation; considerable ability to analyze and resolve operational and communications problems; considerable ability to analyze and debug complex software programs; considerable ability to identify, analyze and resolve complex business and technical problems; some supervisory ability.

MINIMUM QUALIFICATIONS - GENERAL EXPERIENCE

Seven (7) years of experience in information technology (IT) operations, programming, systems/software development or another IT related field.

MINIMUM QUALIFICATIONS - SPECIAL EXPERIENCE

One (1) year of the General Experience must have been at the full professional working level with responsibility for performing a full range of complex technical support functions in one of the following areas:
1. Assisting in the design, implementation and management of a major communications network.
2. Providing technical and administrative support for a wide area network (WAN) or mini-computer system.
3. Assisting in the installation and maintenance of major sub-systems or installing and maintaining other host and/or network software.
4. Participating in the design and development of system applications.
5. Serving as a project coordinator responsible for coordinating the design, development, programming and implementation of moderately complex information systems projects.
NOTE: For state employees this is interpreted at the level of Information Technology Analyst 2.

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 equaling 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 ideal candidate must be technically-skilled (see preferred qualifications below), organized, systematic, hard-working, and solutions-oriented. The preferred candidate will possess deep knowledge and experience in the following areas:

  • Administer, install and support Microsoft SQL Server on Windows-based platforms, including Hyper-V. 
  • Monitor and troubleshoot database and application performance issues. 
  • Logical and physical database design, including typical normalization practices (e.g., 3NF). 
  • Creating and maintaining SQL Server Integration Service (SSIS) packages 
  • Implementing software upgrades, patches and hot fixes. 
  • .Net programming, including VB.Net, C#, ASP.Net, MVC, Razor, JQuery 
  • Development of web-based and Service-Oriented Architecture applications. 
  • Implementing industry-standard systems security and disaster recovery practices. 
  • Strong experience with Windows Server management. 
  • Troubleshooting skill in a range of hardware, networking and software areas. 
  • Ability to identify, research, analyze and resolve complex business and technical problems. 
  • Writing and maintaining technical documentation, manuals and standard operating procedures. 
  • Make recommendations for migration and system upgrade directions 
  • Strong Communication and Interpersonal skills. 
  • Strong Organizational skills. 
  • Collaborate with the Bureau of Enterprise Systems and Technologies (BEST) teams for data center support. 
  • Work closely with vendors and other state agencies. 
  • Provide customer service in a friendly, efficient and professional manner.

Additionally, preference will be given to candidates with experience in the following areas:

  • Using Team Foundation Server and BMC Footprints for work item tracking. 
  • SharePoint development and administration. 
  • Team Foundation Server administration. 
  • Legacy SQL Server Data Transformation Services (DTS). 
  • SQL Server Analytics Service (SSAS). 
  • VB6 and Classic ASP programming and conversion to .Net.

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.







The State of Connecticut is an Affirmative Action/Equal Opportunity Employer and strongly encourages the application of women, minorities and persons with disabilities.