Quantam Solutions
Quantam Solutions

Senior Database Developer

Glastonbury, CT, US • Posted 3 days ago • Updated 6 hours ago
Full Time
On-site
Fitment

Dice Job Match Score™

🛠️ Calibrating flux capacitors...

Job Details

Skills

  • Training
  • Microsoft Visio
  • Microsoft SSIS
  • Data Extraction
  • Data Validation
  • Query Optimization
  • Research
  • Scripting
  • Red Gate
  • Database
  • Microsoft Visual Studio
  • SQL
  • Writing
  • Mapping
  • Data Cleansing
  • Data Management
  • Migration
  • XSD
  • Data Storage
  • XML
  • Performance Tuning
  • Data Conversion
  • Technical Writing
  • Management
  • Statistics
  • Extract
  • Transform
  • Load
  • Supervision
  • Microsoft SQL Server
  • Transact-SQL
  • Database Design
  • Data Modeling
  • Stored Procedures
  • Data Migration

Summary

Overview:

Quantam Solutions provides IT solutions and consulting for various clients. We offer competitive hourly wages, health benefits, paid time off, and a 401(k) plan. We are currently seeking a Senior Database Developer. This position requires two days of onsite training (in Glastonbury, CT) and then allows for a fully remote work schedule.

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 user-defined 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.

Minimum 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 user-defined 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.

Additional Information:

  • Contract length is 6 months with possible renewals.
  • Candidates are required to attend their first two days in person in Glastonbury, CT. Then are able to work either a hybrid or remote schedule.

Skills:

SQL Server,Advanced T-SQL,Database Design,Data Modeling,Stored Procedures,Triggers,Data Migration
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10280509
  • Position Id: 2855d961666c88a67624aaada2dc592c
  • Posted 3 days ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Senior SQL Server Database Developer Data Migration & ETL

Remote or Glastonbury, Connecticut

•

4d ago

Easy Apply

Contract, Third Party

$Depends on Experience

SQL Database Developer

Remote

•

4d ago

Easy Apply

Third Party, Contract

Depends on Experience

SQL Developer - Top Secret Clearance

Remote

•

Today

Full-time, Contract

Senior SQL Engineer

Remote

•

Today

Full-time

USD 90,000.00 - 120,000.00 per year

Search all similar jobs
More jobs at Quantam Solutions in Glastonbury, CT