SQL Developer

22nd Century Technologies Inc.; Glastonbury (CT); On-site; USD 110,000 - 160,000; Full time

Job summary

The State of Connecticut Judicial Branch seeks a Software Engineer – Database with extensive SQL Server experience to design, develop, and migrate large data sets. The role emphasizes advanced SQL, T-SQL development, ETL processes, and data modeling across multi-environment deployments.

Candidates should demonstrate strong problem-solving, documentation, and collaboration skills, with the ability to work independently and with a team of developers and business analysts.

Qualifications

• Minimum ten (10) years of development experience coding applications using SQL Server 2014 through 2022.
• Knowledge and experience in the design and creation of tables, indexes, foreign keys, including the use of appropriate data types, default constraints, etc.
• Knowledge and experience of advanced SQL and T-SQL development, including designing and writing complex queries, stored procedures, triggers, and userdefined functions.
• Perform field mapping (mapping between the source and target structure with data cleansing, if necessary).
• Define the migration process (automated and manual).
• Develop data extractors and loaders.
• Responsible for data management and conversion activities such as Data Assessment, cleansing, extracting, migrating and reconciliation of data.
• Knowledge and experience in the design and creation of XML schema, XML data storage and transformation.
• XML knowledge is required for legacy data conversion into XML-based structures.
• Knowledge and experience in performance tuning techniques.
• Manage the data conversion process and data push process to the various environments.
• Create and maintain technical documentation.
• Provide management level statistics and reports to monitor data migration progress.
• Investigate, analyze and document reported defects.
• Investigate and rectify technical issues within the ETL process.
• Proven ability to work independently with minimal supervision.
• Ability to work well with a team of developers and business analysts.

Responsibilities

• Develop data extractors and loaders.
• Design and create XML schemas and data structures for migration.
• Perform data cleansing and validation during migration.
• Optimize SQL Server performance and troubleshoot issues.
• Collaborate with analysts and developers to ensure accurate data transfer.
• Document technical specifications and progress reports.

Skills

SQL Server

T-SQL

Data modeling

ETL concepts

Data migration

XML

Performance tuning

SSIS

Data modeling tools

XML schema design

RedGate tools

Tools

Microsoft Visio

RedGate tools

Microsoft Visual Studio

Job description

15+ years of experience as SQL Developer Experience is Required

Scope of Services

The State of Connecticut Judicial Branch is looking to engage the services of a Software Engineer – Database. The scope of services required for the role includes:

Core Technical Skills

• 10+ years of experience with SQL Server, must include version 2014 through 2022.
• Knowledge and experience of database design & data modeling.
• Familiarity with tools such as Microsoft Visio or similar data modeling tools.
• Knowledge and experience in the design and creation of tables, indexes, foreign keys, including the use of appropriate data types, default constraints, etc.
• Significant experience of advanced SQL and T-SQL development, including designing and writing complex queries, stored procedures, triggers, and userdefined functions.
• Must demonstrate knowledge of ETL (Extract-Transform-Load) concepts. Experience designing and building ETL Processes. Experience working with SSIS is a plus.
• Has good knowledge / technical expertise in data migration, including data extraction, data validation and cleansing processes / methodology.
• Knowledge and experience in the design and creation of XML schema, XML data storage and transformation.
• XML knowledge is required for legacy data conversion into XML-based structures.
• Knowledge and experience in performance tuning techniques: Query optimization, Index tuning, Execution plan analysis, and Database performance troubleshooting.
• Researching and troubleshooting data inconsistencies, scripting solutions to fix production data issues.
• Experience with RedGate tools to manage database objects and deployment to the various environments, preferred.
• Special consideration will be given to candidates with working knowledge of and experience using Microsoft Visual Studio.

Soft Skills

• Strong analytical and problem-solving skills.
• Ability to effectively manage time, prioritize tasks, and have a basic understanding of project management.
• Excellent verbal communication skills to explain and transfer knowledge both informally and at design and code review meetings.
• Excellent written communication skills to prepare regular periodic status reports and documentation.
• Knowledge and experience of Microsoft Office Tools.

Minimum Qualifications

The minimum skills and experience levels required for a candidate to be considered for this position include:

• Minimum ten (10) years of development experience coding applications using SQL Server 2014 through 2022.
• Knowledge and experience in the design and creation of tables, indexes, foreign keys, including the use of appropriate data types, default constraints, etc.
• Knowledge and experience of advanced SQL and T-SQL development, including designing and writing complex queries, stored procedures, triggers, and userdefined functions.
• Perform field mapping (mapping between the source and target structure with data cleansing, if necessary).
• Define the migration process (automated and manual).
• Develop data extractors and loaders.
• Responsible for data management and conversion activities such as Data Assessment, cleansing, extracting, migrating and reconciliation of data.
• Knowledge and experience in the design and creation of XML schema, XML data storage and transformation.
• XML knowledge is required for legacy data conversion into XML-based structures.
• Knowledge and experience in performance tuning techniques.
• Manage the data conversion process and data push process to the various environments.
• Create and maintain technical documentation.
• Provide management level statistics and reports to monitor data migration progress.
• Investigate, analyze and document reported defects.
• Investigate and rectify technical issues within the ETL process.
• Proven ability to work independently with minimal supervision.
• Ability to work well with a team of developers and business analysts.