Database Administrator

Are you a hardworking, motivated IT professional looking to make a difference while working with a dynamic and reciprocal IT team in the public sector? If so, we want you to consider applying to this exciting opportunity today! We are recruiting for a highly motivated Database Administrator (Information Technology Analyst 2) to work at the State of Connecticut, Workers' Compensation Commission.

Position Details:

• Full-time, 40 hours per week with a work schedule of Monday through Friday, 7:45 am-4:30 pm
• A competitive benefits package is offered which includes healthcare coverage, wellness programs, paid time off, and various leave programs.
• Centrally located in Hartford, CT which is easily accessible to all major highways.

Agency Facts:

The Workers' Compensation Commission is a quasi-judicial agency whose core function is to support the adjudication process for contested workers' compensation cases. Other areas include education, health and safety, and administration. There are eight District Offices located throughout the State in addition to the Office of the Chairman in Hartford.

Responsibilities include:

• Administering the Data Warehouse (holds copies of all region data, admin data, and proof of workers' compensation insurance coverage data);
• Maintaining and updating the Proof of Coverage tables and Database, First Report of Injury (FRI) Database, and agency rate tables;
• Providing reporting and interfaces for the above databases.

This is an open position that we will be filling immediately; you surely do not want to miss out!

In a state agency Information Technology (IT) environment, this class is accountable for independently performing a full range of information technology tasks and project coordination work involving infrastructure systems support, security and application development in an IT environment.

For All Functional Areas: Acts as liaison to hardware and/or software vendors, system developers, programmers and user community; evaluates and recommends products; participates in Request for Proposal (RFP) process; assists in estimating cost for annual budget; identifies and implements opportunities for cost savings; conducts system performance analysis, tuning and storage management; assists staff and customers in use of computer systems and software packages; trains operators, IT staff and end users on new procedures; participates in recovery activities; participates in the evaluation of new, related technologies; analyzes requirements and designs systems; participates in or coordinates project planning sessions with customers, analysts and team members to analyze requirements and provide design recommendations for moderately complex systems; provides technical consultation on moderately complex issues regarding the usage of the infrastructure, integration of applications systems into the infrastructure, etc.; participates in system integration testing of operating system, system utilities, hardware upgrades as well as new software and hardware technologies; works with project team to define and design scope for each project; plans, coordinates and schedules assigned projects; coordinates resources for project; ensures timely completion of all phases of project; evaluates and recommends vendors; performs related duties as required.

Database Administration: Recommends and creates action plans for system development and/or integration; provides and maintains documentation and manuals necessary at operational level; provides basic database support and troubleshooting; responsible for standards and design of physical data storage, maintenance, access and security administration; writes utilities for system management, reporting, file clean up and auditing; analyzes requirements and designs systems; recommends and creates action plans for system development and/or integration; provides and maintains documentation and manuals necessary at operational level; proactively tunes operating systems and system components to avoid performance problems; coordinates backups and file management with operations staff; writes utilities for system management, reporting, file clean up and auditing; responsible for standards and design of physical data storage, maintenance, access and security administration; constructs operational DBMS and data stores that enable informational, analytical management inquiry; performs backup and recovery on database management systems, configures database parameters, and prototypes designs; performs related duties as required.

Considerable knowledge of IT equipment and diagnostic tools; considerable knowledge of principles and techniques of systems analysis, design, development and 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 capabilities of computer technology; knowledge of methods and procedures used to conduct detailed analysis and design of computer systems; knowledge of principles and techniques of software generation and programming; knowledge of practices and issues of systems’ security and disaster recovery; knowledge of computer operating systems; knowledge of project management principles and techniques; knowledge of principles and techniques of business information systems re-engineering; considerable technical problem solving skills; considerable logic and analytical skills; considerable oral and written communication skills; considerable problem solving skills; interpersonal skills; project coordination skills; considerable ability to analyze, troubleshoot and resolve data communications problems; considerable ability to write, test and debug computer programs; considerable ability to use programming development tools; considerable ability to prepare manuals, reports, documentation and other written materials; considerable ability to identify, analyze and resolve complex business and technical problems; ability to analyze and debug complex software programs.

Six (6) years of experience in information technology (IT) operations, programming, systems/software development or another IT related support area.

One (1) year of the General Experience must have been performing professional information technology work in one of the following areas:
1. Installation and support of microcomputer hardware, software and operating systems.
2. Analysis, design and development of information systems.
3. Network hardware and software installation and support.
4. Network hardware and/or software problem diagnosis and resolution.
NOTE: For state employees this is interpreted at the level of Information Technology Analyst 1.

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 equalling 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.

We are looking for candidates that possess:

• Possess experience working with MS-SQL Server database including crafting and managing database objects including tables, indices and views; utilization of SQL Server Enterprise Manager (including MS-SSRS, MS-SSIS, and SSMA);
• Performance monitoring utilities, SQL Server development and deployment tools;
• Experience working with Sybase databases running on Unix and/or Windows platforms;
• Experience in data mapping, data transformation and related data migration activities;
• Interface development using industry standard messaging in formats including XML or data exchange formatted like HL7.

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.