Back to search
Prairie Consulting Services Linkedin · Posted 22d ago

Software Developer (SQL)

Allen, Indiana, United States

Linkedin
Continue to application Add your email once, then Caio opens the original posting.

Indexed description

We’re looking for a SQL Server SME who understands what “bare metal” really means.

Not someone who just writes SQL.

We’re talking about engineers who think in performance, architecture, and system behavior under load—and know how to make databases behave in high-transaction, high-availability environments.

The mission

You’ll be supporting a mission-critical on-prem Push-to-Talk platform in the public safety communications space, where database performance directly impacts system reliability.

If something slows down, breaks, or scales poorly—it matters immediately.

What you’ll be doing

This is a hands-on SQL engineering role focused on deep optimization work:

  • Optimize and refactor high-performance stored procedures, UDFs, and triggers
  • Improve query execution using SQL Server 2022 tools (Query Store, Extended Events, Profiler)
  • Redesign and optimize physical database structures for performance and storage efficiency
  • Support high availability architecture and transaction-heavy workloads
  • Strengthen database security through roles, permissions, and access control models
  • Modernize legacy database components using current SQL Server capabilities

You’ll also work within an Agile team—owning deliverables through sprint cycles and collaborating across engineering, QA, and product stakeholders.

Environment

  • Hybrid: Allen, TX (3 days onsite / 2 remote)
  • 3-6 month contract (with potential extension)
  • SQL Server 2022 environment
  • Agile delivery model

Who tends to thrive here

We typically see strong alignment from engineers coming out of:

  • Banking / financial systems
  • High-volume e-commerce platforms
  • Regulated industries (legal, compliance-heavy systems)
  • Any environment where SQL performance = operational stability

If you’ve ever inherited a slow, messy database and had to actually fix it, this will feel familiar.

What we’ll ask for

Must Haves:

  • 5+ years of experience in SQL Development
  • MS SQL Server - deep knowledge of SQL 2022
  • Advanced T-SQL Development and are capable of writing performing stored procedures, UDFs, and triggers
  • Physical database design including optimization of storage
  • Performance: SQL profiler, Extended Events and Query Store
  • High Availability Support
  • Modernization: refactor legacy databases utilizing modern SQL Features
  • Security: Roles and permissions


Qualifications

Bachelor’s degree in Computer Science, Computer Engineering, or related field

Please include examples of:

  • SQL performance tuning (before/after impact if possible)
  • Stored procedure or query optimization work
  • Database refactoring in complex systems
  • Security role/permission restructuring
  • High availability or large-scale transactional environments

(Links must be accessible without permissions)

Not for vendors

Free. 20 seconds. No password. See every match in this search.

Create a free Caio profile to unlock the full index and keep your job-search signal for future recommendations.

Unlock free search