SQL Developer @Karmak, Inc.
Software Development
Salary unspecified
Remote Location
πŸ‡ΊπŸ‡Έ USA Only
Employment Type full-time
Posted 1wk ago

[Hiring] SQL Developer @Karmak, Inc.

1wk ago - Karmak, Inc. is hiring a remote SQL Developer. πŸ’Έ Salary: unspecified πŸ“Location: USA

Role Description

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.

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

Qualifications

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

Benefits

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

Company Description

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.

Before You Apply
️
πŸ‡ΊπŸ‡Έ Be aware of the location restriction for this remote position: USA Only
β€Ό Beware of scams! When applying for jobs, you should NEVER have to pay anything. Learn more.
SQL Developer @Karmak, Inc.
Software Development
Salary unspecified
Remote Location
πŸ‡ΊπŸ‡Έ USA Only
Employment Type full-time
Posted 1wk ago
Apply for this position
Did not apply βœ“
Applied βœ“
Sent Follow-Up βœ“
Interview Scheduled βœ“
Interview Completed βœ“
Offer Accepted βœ“
Offer Declined βœ“
Application Denied βœ“
Unlock 135,000+ Remote Jobs
️
πŸ‡ΊπŸ‡Έ Be aware of the location restriction for this remote position: USA Only
β€Ό Beware of scams! When applying for jobs, you should NEVER have to pay anything. Learn more.
Apply for this position
Did not apply βœ“
Applied βœ“
Sent Follow-Up βœ“
Interview Scheduled βœ“
Interview Completed βœ“
Offer Accepted βœ“
Offer Declined βœ“
Application Denied βœ“
Unlock 135,000+ Remote Jobs
Γ—
Apply to the best remote jobs
before everyone else

Access 135,000+ vetted remote jobs and get daily alerts.

4.9 β˜…β˜…β˜…β˜…β˜… from 500+ reviews

⚑ 138,968+ remote jobs, refreshed hourly

πŸ”” Real-time alerts: Apply first, direct to employer

πŸ›‘οΈ Vetted companies, no scams, true remote only

Unlock All Jobs Now

Maybe later