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.
Essential Functions
• 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.
Essential Knowledge, Skills and Abilities
• Technical Stack: Proficient in SQL Server ([redacted]), 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.
The above statements describe the general nature and level of work being performed in this job. They are not intended to be an exhaustive list of all duties. Additional responsibilities may be assigned by Karmak.
