Candidate MUST be local to CT or Springfield MA. No relocations
Job Title: SQL Server DBA
Client: State of Connecticut Department of Mental Health & Addiction Services (DMHAS)
Duration: Longterm contract Multiyear
Location: Middletown CT Hybrid
Rate: $55 depending on experience.
USC/GC/GCEAD/H4EAD
SQL Database Administrator
- Hands on experience of the role as DBA. Experience in creating Jobs Alerts SQL Server Mail Agent Log setting and Active directory user access.
- Strong experience with data warehousing.
- Experience in the design and development of TransactSQL
- Database Backup and Recovery
- Performance management troubleshooting and tuning
- The ability to do adhoc SQL to research data questions identify root causes and interact closely with peers and business users is essential.
- Understand entire data life cycle migration development transformation maintain virtualization and visualization
- Experience installing configuring managing monitoring and troubleshooting SQL Server.
- Comprehensive knowledge and experience of using Business Intelligence (SSIS SSRS SSAS) and SQL Server together to realize the business requirements.
- Highly experienced in Data Transformation Services creating complex ETL packages and ETL configuration by using SQL Server Integration Services (SSIS).
- Highly experienced in data lineages and troubleshooting with the knowledge of software coding database data virtualization and data visualization.
- Expertise in using SQL Server to create Tables Views Stored Procedures Functions Indexes Cursors and Triggers.
- Experienced with ETL package configuration and error handling.
- Experience in Designing Creating and deploying and Processing of Cubes using SSAS.
- Experience in writing Multidimensional Expressions (MDX) and using MDX queries in report generation. Experience developing complex MDX queries.
- Highly experienced in data visualization. Hands on experience on developing Custom Reports and different types of Tabular Reports Matrix Reports parameterized drill through and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
- Good knowledge on Data Security by using combination of user id and stored procedure/function/view in the reports.
- Proficient in creating Standard Subscriptions and Data Driven Subscriptions for delivering reports by email or stored on drives.
- Experience in build and maintain web app with Angular ASP.NET Core MVC and Entity Framework.
- Experience in IIS configuration publishing web services and power shell command line script.
- Experience on server maintenance. Hands on experience of managing SQL server configuration. Fully conduct any SQL server upgrades.
- Experience in DeveOps as sprint tool for version control creating pipelines and user stories.
- Excellent Agile team player and familiar with sprint and scrum team practice.