SQL Developer

Karmak, Inc. • Carlinville, IL

8d

About The Position

The SQL Developer assists in the design, development, documentation, and maintenance of Karmak's database environment. Beyond internal development, this role serves as a technical consultant for our clients, interacting directly with customers to review their specific environments, providing architectural guidance, and troubleshooting complex data issues to ensure performance and reliability surpass expectations.

Requirements

• Technical Stack: Proficient in SQL Server (2012-2019), Azure SQL Database, T-SQL, Visual Studio SSDT, and VSTS (Azure DevOps).
• Database Architecture: 5+ years of experience in data modeling and relational database design (Tables, Indexes, Keys, Triggers, etc.).
• Advanced Query Optimization: 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).
• Execution Plan Analysis: Deep expertise in interpreting graphical execution plans to identify "heavy hitters" like Sorts, Hashes, and Implicit Conversions that signal suboptimal code patterns.
• SARGability & Set-Based Logic: 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.
• Environmental Diagnosis: 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
• Professionalism: 5+ years of experience; ability to operate with minimal supervision in a team-oriented, cooperative environment.
• Education: Bachelor's degree in a related field or equivalent professional experience.

Responsibilities

• Design & Development: Implement database systems based on requirements with a focus on reliability and stability.
• Complex Programming: Develop and troubleshoot advanced stored procedures, scripts, and functions.
• Performance Engineering: Tune queries, provide expertise on set-based operations, and use diagnostic tools to optimize execution times.
• Deployment & DevOps: Work with DevOps to manage deployment/rollback scripts and oversee database source control and build processes.
• Lifecycle Management: Create technical artifacts (schemas, design docs, requirements) and assist Product Owners and QA in testing efforts.
• Data Integrity: Develop data movement strategies and resolve bugs or performance issues across development and production environments.
• Client Consultation: Conduct technical reviews of customer database environments to identify bottlenecks and recommend optimization strategies.
• External Troubleshooting: Act as a Tier 3 technical resource to investigate and resolve complex production issues directly with customer stakeholders.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 251-500 employees