What are the responsibilities and job description for the Software Developer (SQL) position at Prairie Consulting Services?
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