STATE OF CONNECTICUT EXECUTIVE BRANCH JOBS

Information Technology Subject Matter Expert (35 Hour)

Department of Developmental Services

Recruitment #171106-7607EU-001

Introduction

The Department of Developmental Services (DDS) has a job opportunity for an Information Technology (IT) Subject Matter Expert in the Central Office in Hartford.  The position is a full-time, thirty-five (35) hours per week. The work schedule is Monday through Friday, first shift.  

Qualified current State employees being considered for further steps in the hiring process may be required to submit their last two performance appraisals while qualified non-state employees being considered for further steps in the hiring process may be required to submit two professional letters of reference.

Selection Plan

This is a competitive position. Open to the public.

PURPOSE OF JOB CLASS (NATURE OF WORK)

In a state agency supporting a highly complex Information Technology (IT) environment this class is accountable for functioning as a Subject Matter Expert in one of the following functional IT areas: networking, security, systems development, systems programming or database administration. This class also provides technical leadership and consultation in the areas of architecture, application design, systems programming, system integration, and/or database management OR the analysis, development and operational support of highly complex technologies affecting multiple infrastructure areas.

EXAMPLES OF DUTIES

Acts as a full project manager; participates in the development of architectural designs; recommends policies, procedures, and associated technical implementation standards; researches, designs, analyzes, develops and enhances new and highly complex infrastructure projects in support of agency information systems; participates in the design and configures infrastructure systems that optimize information access capabilities and ensure the security and integrity of these systems; provides consulting in a technology area, such as IT Security, Network Architecture (including LAN/WAN design), Platform Architecture (including mainframe and desktop hardware and software selection), Middleware Architecture (including messaging and Physical Data Architecture); acts as a consultant to management and individual employees regarding area of expertise including technical leadership and consultation in the areas of architecture and application design, systems programming, system integration, and/or database management or the analysis and development of highly complex technologies affecting multiple infrastructure areas; serves as Subject Matter Expert on various IT project teams; researches and analyzes technology trends and assists in the development of infrastructure technology strategy and standards; troubleshoots existing infrastructure systems to identify errors or deficiencies; recommends and implements software, hardware and configuration changes to improve system performance; participates in defining architecture and technology standards to optimize system performance and integrity; participates in long-term infrastructure technology strategy development and planning; recommends new tools, technologies, and platforms to be implemented; assists in the development of a comprehensive disaster recovery plan; provides technical leadership; provides assistance with escalated Tier III support issues; works on multiple projects including complex integration efforts and transitioning applications to new technologies; defines and develops the project scope of multiple complex projects; makes recommendations towards buy versus build decisions surrounding applications; designs component architectures, making use of multiple tiers to provide insulation to changes from application interfaces and databases; participates in the evaluation and selection process for application packages to meet solutions; recommends testing tools, middleware, and database management systems; document changes to architecture and conversion plans; develops and maintains system and application architecture diagrams; assists in organization wide data modeling and database design; participates in the definition of data architecture standards, policies and procedures for the organization structure, attributes and nomenclature of data elements; assists in the design and construction of data architectures, operational data stores, and data marts; performs related duties as required.

KNOWLEDGE, SKILL AND ABILITY

Considerable knowledge of current methods of information systems analysis, design and development; considerable knowledge of principles, practices and techniques of information technology; considerable knowledge of applications systems development principles, techniques and development; considerable knowledge of principles and techniques of computer programming and languages; considerable knowledge of principles and theories of business planning functions; considerable knowledge of project management principles and techniques; considerable knowledge of principles and techniques of systems analysis and design; considerable knowledge of computer operating systems and databases; considerable knowledge of business re-engineering process; considerable knowledge of principles of data modeling and related tools; considerable knowledge of distributed systems architecture, network, middleware and object oriented analysis; considerable interpersonal skills; considerable oral and written communication skills; considerable analytical and problem solving skills; considerable ability to develop and implement system security and disaster recovery plans; considerable ability to identify, analyze and resolve highly complex business and technical problems; considerable ability to conduct highly complex detailed analysis and design of major computer systems and networks; considerable ability to develop reports, manuals and documentation.

MINIMUM QUALIFICATIONS - GENERAL EXPERIENCE

Nine (9) years of experience in infrastructure systems support, programming, database administration, systems/software development, networking or technical support.

MINIMUM QUALIFICATIONS - SPECIAL EXPERIENCE

Two (2) years of the General Experience must have been performing advanced technical level duties or as a working supervisor in one of the following areas:
1. Designing, configuring and implementing complex networks.
2. Configuring, installing and upgrading host based applications packages and host and/or operating system software.
3. System software/application development.
NOTE: For state employees this is interpreted at the level of Information Technology Analyst 3.

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

Extensive experience designing and implementing SQL Server databases.

In-depth knowledge and expertise in all SQL Server object types (tables, views, stored procedures, user-defined functions … etc.)

Proficiency with SSIS development and deployment and SSRS site administration.

Comprehensive understanding of SQL Server database administration, including security administration, routine maintenance, backup administration, performance tuning, and miscellaneous troubleshooting.

Mastery of SQL DML, including expertise in translating business questions into simple or complex queries, and compositional SQL (breaking down queries into component views that collectively answer the business question.)

Expertise with ASP.NET MVC and Entity Framework, Microsoft Access, including VBA, project management, especially business requirements, understanding of HIPPA security requirements, Red Gate Software, understanding of Active Directory security, and Data Warehouses and star schemas.

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.