Job Description :
SQL Server Database Administrator for the State of Connecticut
Location: Wethersfield CT
Duration: 12+ Months
Client: CT DOL
Req Id: 8016

6-8 yrs exp Provides technical support for the development, implementation and maintenance of an internal database. Maintains policies and procedures for ensuring database’s security and integrity. Implements data models, database designs, data access and table maintenance codes. Resolves database performance and capacity issues, and replication and other distributed data issues. Relies on knowledge and professional discretion to plan and achieve goals. Works under general supervision and usually reports to a supervisor, though some ingenuity and flexibility is required. May require a bachelor’s degree in a related area and 2–4 years of relevant experience.
Preferred Criteria:
Minimum 3 year SQL Server Database Administrative Experience
Experience with SQL Server Always On clusters
Experience with SQL Server Reporting Services (SSRS)
Experience with Powershell
Experience with DB2 Mainframe is a plus
TFS
.NET
AD / Windows Security
Demonstrated Experience IN MS SQL Server:
o o 2000, 2008, 2008r2, 2014, 2016
Demonstrated Experience with MS SQL Server ETL tools:
o o BIDS, DTS, SSIS
Ability to create/ edit DDL, DML, CRUD, TSQL
Ability to produce written documentation , data dictionaries & ER diagrams
Skiils:
Ability to create/ edit DDL, DML, CRUD, TSQL
.NET
DB2
TFS
Experience with MS SQL Server ETL tools
Microsoft SQL Server
Powershell
SQL Server Database Administrative Experience
SQL Server Reporting Services (SSRS)

Client : State of Connecticut