ITS Senior Analyst

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.

The Office of Information Technology Services (ITS) at the Connecticut General Assembly (CGA) is seeking a Senior Analyst/Database Administrator (DBA) with experience in translating business requirements into technical specifications developing testing implementing and maintaining SQL databases/servers in a highly interactive production environment.

Participates in or coordinates project planning sessions with analysts team members and supervisors defines and designs scope and provides design recommendations for moderately complex systems. Troubleshoots and resolves database and IIS related production problems. Assists with VMWare administration Amazon Web Services (AWS) administration and server systems. Performs other duties as assigned.

Bachelors degree in computer science or related field plus a minimum of 3 years experience in information technology operations programming or systems/software development or an equivalent combination of education and experience.

Job Duties:

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: 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 FTP administration

• Install maintain monitor and troubleshoot performance and high availability
• Maintain High availability via Kemp Load balancer hardware - Kemp Administration
  
  Familiarity/Working knowledge
  
  
• AWS (Amazon Web Services) Administration
• Backup Administration
• Server Systems
• VMWare Administration

Developer Collaboration & Optimization

• Work closely with developers to review database design schema changes and indexing strategies.
• Identify and help retire unused obsolete or redundant database objects such as tables stored procedures views and indexes.
• Evaluate and optimize keys constraints and relational structures for performance and scalability.
• Analyze SQL queries and execution plans; provide detailed recommendations for query and application-layer tuning.
• Participate in code and schema review processes focused on stored procedures functions and data access patterns.
• Promote best practices for SQL development data modeling and naming conventions.
• Provide guidance during application troubleshooting related to database performance.
• Edit maintain and troubleshoot Microsoft DTS packages (and SSIS packages where applicable).
• Create configure schedule and monitor SQL Server Agent jobs including alerts and notifications.

Database Tooling & Governance

• Utilize RedGate Source Control SQL Compare and related RedGate tools for versioning change tracking and environment synchronization.
• Develop and improve processes for managing the lifecycle of database objects.
• Document standards procedures and best practices for both DBA and developer activities.
• Monitor database growth and support long-term capacity planning.

Additional Responsibilities

• When time permits assist in IIS Server administration tasks such as:
• Reviewing application pool health and configuration
• Basic troubleshooting
• Coordinating deployment-related settings with the development team
• Experience with RedGate Source Control SQL Compare and related tools is strongly preferred.
• Exposure to IIS administration or willingness to learn and support IIS-related tasks.

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