For Employers

Karmak, Inc.

Remote SQL Developer

Posted a day ago
5-10 years experience
Apply Now

Please mention DailyRemote when applying

?Not checked yet0100
Resume Match Score

See how much of this job your resume covers, and what’s missing.

Want a recruiter to go through it line by line?

Get professional review

Tailor your resume to this job

One click makes a copy of your resume for this role, scores it against the posting, and proposes edits line by line. Your default resume is never changed.

  • Job match score for this posting
  • Edits you accept or skip, no invented facts
  • Download it when it reads right: TXT free, PDF with Premium

Create a cover letter for this job

Upload your resume and we draft a letter for this exact role, tailored to what it asks for.

  • Tailored to this role
  • Based on your resume
  • Fully editable
AI Summary

The SQL Developer will design, develop, and maintain database systems while providing technical consulting and architectural guidance to clients. This role also involves troubleshooting complex production issues and optimizing database performance through advanced query tuning.

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 (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.

Karmak is committed to creating a diverse and inclusive work environment, and is an equal opportunity employer.

 

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.

 

 

Automatically Apply to the Best Remote Jobs

Stop the endless job search. Our AI finds and applies to the best jobs for you.

Try it Now
Keep looking

Similar Jobs

See all Remote Software Development jobs →

Senior Solution Engineer - EU & UK

Full Time United Kingdom Software Development

Senior Solution Engineer - North America

Full Time North America Software Development

Service Integration Lead (SIAM) — Federal Health IT

Full Time United States Software Development

Azure Cloud Senior Engineer and Architect

Full Time India Software Development

Healthcare RCM Professionals: Interview on AI Integration Workflows

Freelance United States $350 per year Software Development

Journeyman Application Developer

Full Time United States $100K - $130K per year Software Development
Apply Now

Personalize your Remote Job Search in 3 Easy Steps!

Featuring 218,236+ Jobs in Software Development

Answer easy questions

Answer easy questions

218,236+ jobs across 15+ categories

Get your best job matches

Get your best job matches

Only hand-screened, legit jobs

Find a remote job faster

Find a remote job faster

No ads, scams, or junk

“I was the first applicant for a remote marketing position that got listed on the company website the same day I applied. Had an interview within 48 hours!”

Sarah J. — Sarah J. · Marketing Manager ★★★★★ Verified