SQL Database Administrator

Salary: See Position Description Location : Hartford, CT Job Type: Full-Time Job Number: 202300093 Department: Information Technology Services Opening Date: 02/25/2026 Closing Date: 3/18/2026 5:00 PM Eastern 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 (860) 240-0100 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. BENEFITS FOR REGULAR, FULL-TIME LEGISLATIVE EMPLOYEES HEALTH AND DENTAL INSURANCE Regular full-time legislative employees are eligible for health and dental insurance effective the first of the month following employment. There are several medical and dental plans from which employees and their eligible dependents may choose. GROUP LIFE INSURANCE Regular full-time legislative employees are eligible for basic group life insurance by payroll deduction for up to $85,000 of coverage, depending on the employee's salary and position. The employee contribution is $.20 bi-weekly for each $1,000 of insurance. In addition, the state makes a small contribution. (Employees earning more than $45,500 annually may elect to have supplemental insurance of up to $50,000. This supplemental insurance is paid for entirely by the employee). Employees who elect to take the coverage must do so within their first six months of employment or be required to provide evidence of insurability thereafter. Upon normal retirement one would receive a reduced paid-up life insurance policy based upon years of service. (The supplemental insurance is not used when calculating retirement benefits). RETIREMENT Legislative employees hired on or after July 31, 2017 are members of Tier IV of the State Employees' Retirement System. (In some instances, employees with prior state service might be eligible for membership in another plan.) Members are required to contribute a percentage of their earnings on a pretax basis to a defined benefit plan and a small percentage to a defined contribution plan. Tier IV allows ten-year vesting, however, the benefits are enhanced after 15 years of service. Employees with ten or more years of service can begin collecting a pension at age 58. An employee's average salary for the five highest earning years is used to determine the pension amount. DEFERRED COMPENSATION Deferred Compensation allows legislative employees to set aside money (through payroll deduction) during peak earning years and receive its value later, when one would presumably be in a lower tax bracket. The state's Defined Contribution retirement savings plans can help you save for a more financially secure retirement. Defined Contribution Plans are voluntary retirement savings plans that permit you to defer income into the retirement plan either on a pretax basis or after-tax (Roth) basis. The plans offer a wide variety of investment options and accept pretax funds (rollovers) from other 401,403(b) and 457(b) governmental plans and traditional IRAs. HOLIDAYS There are a total of 13 state holidays, as follows: New Year's Day, Martin Luther King Day, Lincoln's Birthday, Washington's Birthday, Good Friday, Memorial Day, Juneteenth, Independence Day, Labor Day, Columbus Day, Veteran's Day, Thanksgiving Day, Christmas Day VACATION LEAVE Regular full-time legislative employees earn fifteen (15) days of vacation leave each year. Employees with more than 10 years of service receive from 1-5 extra days each year. Total accrual cannot exceed 120 days. All employees are paid for their unused vacation days when they leave state service. SICK LEAVE Regular full-time legislative employees earn fifteen (15) days of sick leave each year. Accrual is unlimited. However, no payment for unused days is made unless the employee goes directly into retirement from active service. Payment is then based on 25% of accrued sick leave days with a total payment not to exceed 60 days. PERSONAL LEAVE Regular full-time legislative employees receive three (3) days of personal leave of absence with pay in each calendar year. Personal leave of absence shall be for the purpose of conducting private affairs, including observance of religious holidays, and shall not be deducted from vacation or sick leave credits. Personal leave of absence days not taken in a calendar year shall not be accumulated. No payment is made for unused personal leave days upon termination. TUITION REIMBURSEMENT Regular full-time legislative employees are eligible for tuition reimbursement. Employees receive up to $115.00 for each undergraduate credit and up to $145.00 for each graduate credit. There is a limit of 18 credits per fiscal year. DEPENDENT CARE ASSISTANCE PROGRAM Regular full-time legislative employees are eligible to participate in the state's Dependent Care Assistance Program (DCAP) that allows one to pay for dependent care expenses with wages that will not be subject to federal or state income taxes or social security taxes. Reimbursed expenses must be for dependent children under age 13 or a spouse or dependent older than 13 who is incapable of self-care and who resides with the employee at least eight hours each day. The dependent care must enable the employee or the employee and his or her spouse to be employed. MEDICAL FLEXIBLE SPENDING ACCOUNT (MEDFLEX) MEDFLEX contributions can be used to cover medical expenses for yourself, your spouse and your eligible dependent(s). Medically necessary out-of-pocket medical expenses are eligible for reimbursement if they are consistent with IRS guidelines. QUALIFIED TRANSPORTATION ACCOUNT (QTA) The QTA allows you to use pre-tax dollars to pay eligible transit and parking expenses for your regular daily direct commute from home to work. Eligible expenses include public transit, van pools and/or the cost of parking at or near your work location. Employees working at least half time (0.5 FTE - Full Time Equivalent) are eligible to enroll on their first day of employment. Maximum benefits for both transit and parking are $300 per month. SHORT TERM DISABILITY INSURANCE Regular full-time legislative employees may purchase short-term disability insurance that protects against the short-term loss of income due to a covered accident or illness. The policyholder is paid regardless of any other insurance he/she may have. LONG TERM DISABILITY INSURANCE Regular full-time legislative employees may purchase long-term disability insurance that protects against the long-term loss of income due to accident or illness. AUTO AND HOMEOWNERS INSURANCE Regular full-time legislative employees may purchase auto and homeowners insurance that protects against liability and damage to, or loss of, auto, home and other personal property. UNIVERSAL LIFE INSURANCE Regular full-time legislative employees may purchase universal life insurance based on age, sex and smoking status. VOLUNTARY TERM LIFE INSURANCE Regular full-time legislative employees who participate in the basic group life insurance program are eligible to purchase up to $500,000 of term life insurance. 01 Which statement below best describes the highest level of education you have completed? High school graduate, diploma or the equivalent (GED) Associate degree Bachelor's degree Master's degree Professional degree Doctorate degree 02 How much professional experience do you have in Database Administration or Development ? 03 Are you able to work a flexible work schedule that includes nights, weekends, holidays, and includes varying shifts? Yes No 04 The information provided in your application must support your selected answers in the supplemental questions. The information you provide will be verified and documentation may be required. Please be as honest and accurate as possible. You may be asked to demonstrate your knowledge and skills in a work sample or during an interview. By completing this supplemental questionnaire, you are attesting that the information you have provided is accurate. Any misstatements, omissions, or falsification of information may eliminate you from consideration or result in dismissal. Yes, I understand and agree No, I do not agree Required Question

Created: 2026-03-10