STATE OF CONNECTICUT EXECUTIVE BRANCH JOBS

SQL DBA Technical Analyst 3

IT Analyst 3 (35 Hour)

Recruitment #190613-7605EU-002

Introduction

The State of Connecticut is looking for self-starters willing to make a difference. We are working to improve the experience of all those who interact with the State and are making progress, but we’ve still got work to do. That’s where you come in.

Join an organization that provides superior benefits, competitive salaries and a place where people truly believe in what they are doing. We’re committed in bringing passion and customer focus to all those with whom we interact.

The Department of Administrative Services ' (
DAS) Platform Services Division is seeking a strong collaborative SQL DBA Technical Analyst 3 (ITA 3) to join the Bureau of Enterprise Systems and Technology (BEST) team, with an ability to learn and grow. You will be working for the Manager of Data Services.

This full-time 35 hours per week position is conveniently located at Farmington Ave in Hartford, CT, working Monday through Friday from 8:00 a.m. to 3:30 p.m.

In this role you will perform database management duties including:

  • problem resolution,
  • performance tuning,
  • back-ups,
  • recoveries,
  • disaster contingency testing,
  • database product installation and patching,
  • database configuration and product life cycle management.

All applicants must include a resume within the "Resume Tab" of their application.

Note: At any point during the recruitment process, applicants may be required to submit additional documentation which support their qualification(s) for this position. These documents may include: a cover letter, performance reviews, attendance records, supervisory references, college transcripts, licensure, etc., at the discretion of the hiring agency.

Applicants must meet the minimum qualifications as indicated to apply for this position. State employees currently holding the above title or those who have previously attained permanent status in this class may apply for a lateral transfer.

Should you have questions pertaining to this recruitment, please contact Elena Vazquez at Elena.Vazquez@ct.gov, (860) 713-5166.

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

The primary responsibilities of this position are to:

  • Lead maintenance of databases including back-ups, statistics, patching and upgrades;
  • Investigate, analyze and resolve database incidents including performance bottlenecks and connectivity issues;
  • Contribute to continuous improvements within the organization;
  • Develop reports/tools to help manage the environments;
  • Perform product life cycle management for database and associated software and 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 successful candidate will possess:

  • Minimum 3 year Structured Query Language Server Database Administrative Experience;
  • Experience with Structured Query Language Server Always On clusters;
  • Experience with Structured Query Language Server Reporting Services (SSRS);
  • Experience with Powershell;
  • Experience with DB2 Relational Database Technology.

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.