Azure SQL Developer

Motion Recruitment - Denver, CO

Full-time - Mid Level

Hybrid - Denver, CO

Administrative and Support Services

About the position

The Azure SQL Developer position at Motion Recruitment involves working as part of a team to design and implement scalable database solutions in both on-premise and Azure cloud environments. The role requires a strong background in SQL Server development, with responsibilities including database design, performance optimization, and troubleshooting. The position is a 12-month contract with the possibility of extension, and it is hybrid, requiring local presence in Denver, CO.

Responsibilities

• Design databases tailored to corporate needs and ensure they operate efficiently and securely.
• Manage all database development phases from procurement to implementation and seek effective solutions for improving speed and performance.
• Implement the overall design, monitoring and optimizing of company databases.
• Plan the logical storage structure of the database and backup processes for servers and associated data.
• Monitor and maintain system health and security and the performance of the database during data access operations.
• Develop, implement, and optimize stored procedures and functions using T-SQL.
• Analyze existing SQL queries for performance improvements using Extended Events, Graphical execution plans, Statistics, partitioning, etc.
• Build appropriate and useful reporting deliverables using SQL Server procedures.
• Develop procedures and scripts for data migration.
• Proactively monitor errors, locks, deadlocks, and other resource utilization, and resolve issues in a timely manner.

Requirements

• 8-10 years of experience in development using MS-SQL Server in both on-premise and Azure cloud environments.
• Strong SQL Server development background with a can-do attitude.
• Good verbal and written communication skills.
• Experience with Python and Synapse skills (data Engineering).
• Skilled at writing T-SQL code and designing new systems.
• Solid understanding of MS SQL Server database troubleshooting and industry standards for database operations.
• Experience with ETL processes to process large amounts of data using Azure Data Factory and SSIS.

Nice-to-haves

• Experience with logical and physical data modeling and design.
• Ability to debug and troubleshoot logical and functional coding errors.

Benefits

• Medical Insurance & Health Savings Account (HSA)
• 401(k)
• Paid Sick Time Leave
• Pre-tax Commuter Benefit