Remote SQL Developer

Karmak • Carlinville, IL

1d • Remote

About The Position

The SQL Developer assists in the design, development, documentation, and maintenance of Karmak's database environment. The role also serves as a technical consultant for clients, interacting directly with customers to review their database environments, provide architectural guidance, and troubleshoot complex data issues to ensure performance and reliability.

Requirements

• Proficiency with SQL Server (2012–2019), Azure SQL Database, T-SQL, Visual Studio SSDT, and VSTS (Azure DevOps).
• At least 5 years of experience in data modeling and relational database design, including tables, indexes, keys, and triggers.
• Ability to refactor inefficient T-SQL patterns, including unnecessary cursors and nested subquery bottlenecks, and optimize Common Table Expressions (CTEs).
• Expertise in interpreting graphical execution plans and identifying performance issues such as sorts, hashes, and implicit conversions.
• Ability to write SARGable queries and apply set-based logic rather than procedural approaches.
• Ability to identify wait statistics and blocking issues and determine whether performance lag is code-based, resource-based, or related to deadlocking.
• At least 5 years of professional experience and ability to work with minimal supervision in a team-oriented, cooperative environment.
• Bachelor's degree in a related field or equivalent professional experience.

Responsibilities

• Design and implement database systems based on requirements, with a focus on reliability and stability.
• Develop and troubleshoot advanced stored procedures, scripts, and functions.
• Tune queries, advise on set-based operations, and use diagnostic tools to optimize execution times.
• Work with DevOps to manage deployment and rollback scripts, database source control, and build processes.
• Create technical artifacts such as schemas, design documents, and requirements, and assist Product Owners and QA with testing.
• Develop data movement strategies and resolve bugs or performance issues across development and production environments.
• Conduct technical reviews of customer database environments to identify bottlenecks and recommend optimization strategies.
• Serve as a Tier 3 technical resource, investigating and resolving complex production issues with customer stakeholders.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level