Remote SQL Developer

Karmak

Carlinville (IL)

On-site

USD 90,000 - 120,000

Full time

9 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Karmak is seeking a SQL Developer to design, develop, and maintain our SQL Server environments. You will act as a technical consultant for clients, providing architectural guidance and troubleshooting complex data issues to ensure optimal performance and reliability.

You will collaborate with Product Owners and QA, develop technical artifacts, and contribute to deployment and data integrity across development and production environments. 5+ years of experience and a related degree are preferred.

Qualifications

  • 5+ years of experience in data modeling and relational database design.
  • Strong proficiency in SQL Server and T-SQL.
  • Experience reviewing customer environments and providing architectural guidance.
  • Bachelor's degree in a related field or equivalent professional experience.
  • Proficient in performance tuning and query optimization.

Responsibilities

  • Design and develop database systems with reliability and stability.
  • Develop and troubleshoot stored procedures, scripts, and functions.
  • Tune queries and optimize execution plans.
  • Collaborate with DevOps on deployment scripts and source control.
  • Review customer environments to identify bottlenecks and propose optimizations.
  • Provide Tier 3 support for complex production issues.

Skills

SQL Server
Azure SQL Database
T-SQL
Query optimization
Execution plan analysis
Set-based logic
Performance tuning
DevOps collaboration

Education

Bachelor's degree in a related field

Tools

Visual Studio SSDT
VSTS / Azure DevOps

Job 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.
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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Remote SQL Developer
Remote SQL Developer

Karmak, Inc. • Carlinville (IL)

Remote
USD 90,000 - 120,000
Remote SQL Developer & Performance Engineer
Remote SQL Developer & Performance Engineer

Karmak • Carlinville (IL)

On-site
USD 90,000 - 120,000
Remote SQL Developer & Performance Engineer
Remote SQL Developer & Performance Engineer

Karmak, Inc. • Carlinville (IL)

Remote
USD 90,000 - 120,000
Senior SQL Developer
Senior SQL Developer

Irth Solutions • Redmond (WA)

On-site
USD 90,000 - 130,000
Associate Implementation Specialist
Associate Implementation Specialist

Karmak, Inc. • Carlinville (IL)

On-site
USD 65,000 - 90,000
Job Title SQL Developer / Data Migration Specialist
Job Title SQL Developer / Data Migration Specialist

Communitybrands • United States

Remote
USD 90,000 - 130,000
Remote work flexibility
Health, dental and vision coverage
Matched retirement savings plan
.NET/SQL Developer, Sr.
.NET/SQL Developer, Sr.

Prosum • Los Angeles (CA)

On-site
USD 100,000 - 130,000
Senior SQL DBA
Senior SQL DBA

DistantJob • United States

Remote
USD 120,000 - 160,000
Associate Implementation Specialist - Remote
Associate Implementation Specialist - Remote

Karmak • Carlinville (IL)

On-site
USD 48,000 - 50,000
Database Developer
Database Developer

Innovative Development, LLC • Radnor

On-site
USD 90,000 - 130,000
PTO
Medical, Dental, and Vision
Health Savings accounts
+7