Azure SQL Developer

Motion Recruitment - Atlanta, GA

Full-time - Mid Level

Hybrid - Atlanta, GA

Administrative and Support Services

About the position

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

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.
• 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 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 logical and physical data modeling and design.
• Ability to perform work with minimal to moderate supervision and apply business rules in daily work.
• Experience with ETL processes using Azure Data Factory and SSIS.

Nice-to-haves

• Good team player with a can-do attitude.
• Ability to multitask when needed.

Benefits

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