SQL Database Administrator

Job Application

JOINT COMMITTEE ON LEGISLATIVE MANAGEMENT

ROOM 5100, LEGISLATIVE OFFICE BUILDING

Hartford, CT 06106-1591

The policy of the Joint Committee on Legislative Management is to provide equal opportunity to all prospective employees without regard to race, religious creed, color, sex, age, national origin, ancestry, veteran status, sexual orientation, marital status, present or past history of mental disorder, learning disability, mental retardation, physical disability except in cases of bona fide occupational qualification or other protected class status under applicable law. Moreover, the Joint Committee on Legislative Management does not discriminate against any “qualified applicant with a disability” and will make reasonable accommodations that do not impose an undue hardship for individuals who are physically challenged or otherwise disabled as defined by the Americans with Disabilities Act. If you require reasonable accommodation to complete this application or any other aspect of the selection process, please contact the Human Resources Administrator in the Office of Legislative Management at or email .

General Application Instructions

Please complete all information requested on this application. Do not include extraneous or non-responsive information. If a question does not apply to you, please write “N/A” in the space provided. The Joint Committee on Legislative Management may reject any application that is incomplete.

If you fail to provide complete information on this application form, or if you provide any false or misleading information here or in any part of the application process, your application will not be considered further. If you are employed by the Joint Committee on Legislative Management, the discovery of omissions, misrepresentations or misleading information in the application process will be grounds for termination of employment.

Providing References

Please provide three (3) professional references on your application. A professional reference is an individual who has been paid to supervise your work and can attest to your work performance, technical skills, and job competencies. If you do not have any or sufficient professional references, please include non-related professionals, such as educators or other professional associates.

Description

The Office of Information Technology Services (ITS) at the Connecticut General Assembly (CGA) is seeking a SQL Database Administrator with experience in researching, analyzing, designing, proposing, and delivering technology solutions and system specification designs that effectively support CGA business strategies for the existing and future CGA technology infrastructure.

Examples of Duties

Major Function and Responsibilities:

Database Administration for MSSQL Server in multi-instance environment.

New SQL installations and upgrades

Troubleshooting and Resolving Database Problems

Performance Tuning and Optimization using Native Monitoring and Troubleshooting Tools

Backups: AWS/ Restores / Recovery Models / Replication/ Distribution

Maintain High Availability / Disaster Recovery Options for MSSQL Server

ETL Tools (Extract Transform Load) – SSIS

Creating Scripts and Stored procedures

Database maintenance – maintain Indexes / Index Management / Statistics

Creating SQL agent jobs for performance and alert monitoring

Maintain and manage Inventory and helpdesk databases

Web Server – IIS and SSL Certificate Experience

Install, maintain, monitor, and troubleshoot performance and high availability

Maintain High availability via Kemp Load balancer hardware - Kemp Administration and VMWare Site Recovery Manager.

Conducts systems performance monitoring to preserve the integrity and availability of all system resources and key processes

Review’s performance metrics and recommends tuning strategies to achieve higher performance and availability

Supports the CGA with troubleshooting and change requests for various CGA infrastructure systems, related services, and applications

Resolves enterprise infrastructure issues regarding operations, including installations, setup, security, systems transactions, system status, and downtime procedures

Identifies and resolves any degradation, unusual activities, or system downtime

Communicates with vendors to obtain pricing and technical specifications for hardware, software, or services

Performs other duties as assigned

Typical Qualifications

Education and Experience

5+ years of relevant work experience in SQL Database Administration, Information Technology (IT) Operations, multi-systems integration, infrastructure design, and planning.

Bachelor's degree in Data Management or Information Technology related field.

Knowledge, Skills, and Abilities

Broad level knowledge and working experience in a variety of Information Technology disciplines/technologies

Strong experience in performance tuning and troubleshooting of highly available infrastructure systems

Demonstrate experience in the creation and management of technical documentation

Possesses excellent interpersonal and communication skills, including effective written and oral presentation skills

Possesses exceptional logical and analytical skills, demonstrating talent for identifying, scrutinizing, improving, and streamlining complex work processes

Flexible team player who has exceptional ability to effectively prioritize and juggle multiple concurrent assignments

Innovative problem solver who can troubleshoot complex CGA systems-related issues and generate workable solutions

Ability to perform advanced administration of multiple CGA systems and ensure systems availability

Demonstrates sound analytical and diagnostic skills dealing with issues that are not readily defined and/or conflict with available information

Familiarity/Working Knowledge:

AWS (Amazon Web Services) Backup Administration

FTP / SFTP

DNS /DHCP

SCCM – MECM Administration

Server Systems

Team Foundation Server Administration

VMWare Administration

VPN / RDP (Remote desktop)

File/data movement processes i.e., DFSR (Distributed File System Replication)

Supplemental Information

Qualified candidates who meet the above requirements should submit a resume and cover letter. Starting Salary: $88,542.