SQL Server Developer - ETL, SSIS & Cloud-Ready Data Expert

Robotic Technologies Automation; Minnesota; On-site; USD 90,000 - 130,000; Full time

Job summary

Robotic Technologies Automation in Minnesota seeks a SQL Server Database Developer/DBA to design, implement, and optimize database solutions. You will work with T-SQL, stored procedures, dimensional models, and reporting requirements to deliver reliable data services.

Responsibilities include performance tuning, data migration scripting, and maintaining SSIS workflows. On-prem SQL Server experience with cloud integration is essential for this role.

Qualifications

• Experience with on-premises SQL Server and SSIS integration with cloud services.

Responsibilities

• Design and develop high-quality database solutions following data management best practices.
• Develop and optimize stored procedures and functions using T-SQL.
• Write, troubleshoot, and enhance stored procedures, views, functions, and triggers.
• Understand and work with dimensional data models.
• Review business reporting requirements and deliver reporting outputs.
• Analyze SQL queries for performance improvements and implement optimizations.
• Develop scripts for data migration.
• Investigate and resolve data exceptions related to asset movements.
• Develop and analyze SQL Server code objects and fix defects.
• Performance tune database objects and optimize queries.
• Work with Transact-SQL and SSIS packages.
• Develop, maintain, and troubleshoot SSIS workflows.
• Support code versioning and deployments across environments.

Skills

Database design

T-SQL

Stored procedures

Dimensional modeling

Performance tuning

Data migration

SSIS

Version control

Reporting requirements

Data quality

Tools

SSIS

SQL Server

Job description

Robotic Technologies Automation in Minnesota seeks a SQL Server Database Developer/DBA to design, implement, and optimize database solutions. You will work with T-SQL, stored procedures, dimensional models, and reporting requirements to deliver reliable data services.

Responsibilities include performance tuning, data migration scripting, and maintaining SSIS workflows. On-prem SQL Server experience with cloud integration is essential for this role.