Demo

Software Developer (SQL)

Prairie Consulting Services
Allen, TX Contractor
POSTED ON 5/11/2026
AVAILABLE BEFORE 6/6/2026

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

Salary : $59 - $62

If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

What is the career path for a Software Developer (SQL)?

Sign up to receive alerts about other jobs on the Software Developer (SQL) career path by checking the boxes next to the positions that interest you.
Income Estimation: 
$97,257 - $120,701
Income Estimation: 
$123,167 - $152,295
Income Estimation: 
$107,385 - $134,565
Income Estimation: 
$128,473 - $158,030
Employees: Get a Salary Increase
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at Prairie Consulting Services

  • Prairie Consulting Services Chicago, IL
  • Local to Chicago ONLY 3 days on-site in Chicago Senior DevOps (Resiliency Focus) Engineer The ideal Resiliency Engineer candidate will develop resiliency s... more
  • 2 Days Ago

  • Prairie Consulting Services Chicago, IL
  • Resumes ONLY Chicago ONLY - Hybrid 3 days onsite in Chicago Will not respond to all of the phone calls and emails I get on asking for Corp to Corp. If you ... more
  • 2 Days Ago

  • Prairie Consulting Services Chicago, IL
  • Program Manager -Oracle ERP Long Term Contract W2 only. No sub Firm. **Opportunity with Direct Client** Project Description: Consolidation of complex ERP s... more
  • 2 Days Ago

  • Prairie Consulting Services Chicago, IL
  • We’re Hiring: Senior Security Architect/ Security Technology Lead - SaaS Platform Hybrid - 3 days/ week in office - Downtown Chicago Contract role We’re lo... more
  • 3 Days Ago


Not the job you're looking for? Here are some other Software Developer (SQL) jobs in the Allen, TX area that may be a better fit.

  • Software Guidance & Assistance Dallas, TX
  • Software Guidance & Assistance, Inc., (SGA), is searching for a Software Developer (Java/Python) for a CONTRACT assignment with one of our premier Financia... more
  • 2 Days Ago

  • Triunity Software Plano, TX
  • Role: Full Stack Developer. Location: Plano, TX. ONLY W2 NOT C2C Candidates Can apply. Candidates with career Gap Can also applicable. Responsibilities; De... more
  • 1 Month Ago

AI Assistant is available now!

Feel free to start your new journey!