SQL Server Developer

Robotic Process Automation LLC; 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

• Design and develophigh-quality database solutionsfollowing data management best practices
• Develop, implement, and optimizestored procedures and functions using T- SQL
• Write, troubleshoot, and enhanceStored Procedures, Views, Functions, and Triggers
• Understand and work withdimensional data models
• Review and interpret business reporting requirements
• Research required data and builduseful, accurate reporting deliverables
• Analyze existing SQL queries forperformance improvementand recommend optimizations
• Develop procedures and scripts fordata migration
• Investigate and resolve data exceptions related toasset movements

Development & QA Support

• Develop and analyze SQL Server code objects and identify defects
• Performperformance tuningand optimization of database objects
• Work withTransactional SQL andSSIS packages
• Develop, maintain, and troubleshootSSIS workflows
• Supportcode version managementand deployments across environments

Required Skills (Top 3)

• Hands-on experience integratingon-prem SQL Server / SSIS with cloud services

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.