Remote SQL Developer

Karmak, Inc.

Carlinville (IL)

Remote

USD 90,000 - 120,000

Full time

11 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Karmak, Inc. is seeking a SQL Developer to design, develop, document, and maintain our database environment.

You will also serve as a technical consultant for clients, reviewing environments, providing architectural guidance, and troubleshooting data issues to ensure performance and reliability. You will design and implement database systems, optimize complex queries, and collaborate with DevOps for deployments and source control.

Qualifications

  • 5+ years in data modeling and relational design (Tables, Indexes, Keys, Triggers).
  • Proficient in SQL Server (2012-2019) and Azure SQL Database.
  • Advanced query optimization and execution plan analysis skills.
  • Experience with deployment scripts, source control, and DevOps.

Responsibilities

  • Design, develop, document, and maintain database systems for reliability.
  • Develop and troubleshoot stored procedures and complex T-SQL.
  • Tune queries and optimize set-based logic to improve performance.
  • Collaborate with DevOps on deployment scripts and source control.
  • Review client environments and provide architectural guidance.

Skills

SQL Server
Azure SQL Database
T-SQL
Visual Studio SSDT
Azure DevOps

Education

Bachelor's degree

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 (CTE).
  • 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 • Carlinville (IL)

On-site
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
Remote Associate Installation Specialist
Remote Associate Installation Specialist

Karmak • Carlinville (IL)

On-site
USD 50,000 - 70,000
SQL Developer
SQL Developer

Ethereum Technologies LLC • Columbus (OH)

On-site
USD 90,000 - 130,000
SQL Developer
SQL Developer

Valiant Technologies LLC • Columbus (OH)

On-site
USD 90,000 - 120,000
SQL Developer
SQL Developer

Robotics Technologies LLC • Columbus (OH)

On-site
USD 80,000 - 110,000
SQL Developer
SQL Developer

Quantum Technologies LLC • Columbus (OH)

On-site
USD 90,000 - 120,000
.NET/SQL Developer, Sr.
.NET/SQL Developer, Sr.

Prosum • Los Angeles (CA)

On-site
USD 100,000 - 130,000