Karmak · 17 hours ago
SQL Developer
United States
Full-time
Remote
Senior Level
$85K/yr - $95K/yr
5+ years expKarmak, Inc. is seeking a SQL Developer to assist in the design, development, documentation, and maintenance of their database environment. The role involves client consultation, performance engineering, and troubleshooting complex data issues to ensure optimal performance and reliability.
Business IntelligenceSoftware
Responsibilities
Implement database systems based on requirements with a focus on reliability and stability
Develop and troubleshoot advanced stored procedures, scripts, and functions
Tune queries, provide expertise on set-based operations, and use diagnostic tools to optimize execution times
Work with DevOps to manage deployment/rollback scripts and oversee database source control and build processes
Create technical artifacts (schemas, design docs, requirements) and assist Product Owners and QA in testing efforts
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
Act as a Tier 3 technical resource to investigate and resolve complex production issues directly with customer stakeholders
Qualification
Required
Proficient in SQL Server (2012-2019), Azure SQL Database, T-SQL, Visual Studio SSDT, and VSTS (Azure DevOps)
5+ years of experience in data modeling and relational database design (Tables, Indexes, Keys, Triggers, etc.)
Beyond indexing, must possess the ability to refactor inefficient T-SQL patterns, such as eliminating unnecessary cursors, resolving nested subquery bottlenecks, and optimizing Common Table Expressions (CTEs)
Deep expertise in interpreting graphical execution plans to identify 'heavy hitters' like Sorts, Hashes, and Implicit Conversions that signal suboptimal code patterns
Proven ability to write 'Searchable' queries and apply set-based logic rather than procedural approaches to ensure the SQL Optimizer can create the most efficient paths
Skill in identifying 'wait statistics' and blocking issues when reviewing a customer's environment to determine if the lag is code-based, resource-based, or a result of deadlocking
5+ years of experience; ability to operate with minimal supervision in a team-oriented, cooperative environment
Bachelor's degree in a related field or equivalent professional experience
Company
Karmak
Karmak. is a provider of business management solutions for commercial transportation industry.
201-500 employees
Funding
Current Stage
Growth StageLeadership Team
Jim Allen
Board Member
Recent News
2026-01-20
Automotive News Canada
2023-12-23
Company data provided by crunchbase