Remote SQL Developer

Karmak, Inc. • Carlinville, IL

1d • Remote

About The Position

The SQL Developer assists in designing, developing, documenting, and maintaining Karmak's database environment. The role also serves as a technical consultant for clients, reviewing their database environments, providing architectural guidance, and troubleshooting complex data issues to support performance and reliability.

The position works with DevOps, Product Owners, and QA on database deployment, source control, build processes, technical documentation, and testing. It also investigates complex production issues with customer stakeholders and develops strategies to maintain data integrity across development and production environments.

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 eliminating unnecessary cursors, resolving nested subquery bottlenecks, and optimizing Common Table Expressions (CTEs).
• Deep expertise in interpreting graphical execution plans and identifying performance issues such as sorts, hashes, and implicit conversions.
• Proven ability to write SARGable queries and apply set-based rather than procedural logic.
• Ability to identify wait statistics and blocking issues and determine whether lag is code-based, resource-based, or related to deadlocking when reviewing customer environments.
• At least 5 years of professional experience.
• 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, emphasizing 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 and oversee database source control and build processes.
• Create technical artifacts, including schemas, design documents, and requirements, and assist Product Owners and QA with testing efforts.
• Develop data movement strategies and resolve bugs or performance issues across development and production environments.
• Review 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