> Markdown version of [/jobs/ext/2580853-senior-microsoft-sql-server-developer-sql-ssrs-business-systems](https://www.wearedevelopers.com/jobs/ext/2580853-senior-microsoft-sql-server-developer-sql-ssrs-business-systems). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Microsoft SQL Server Developer - SQL, SSRS & Business Systems - **Company:** MEP CONSULTING SERVICES LLC - **Location:** Spring, TX, United States - **Experience:** Expert - **Salary:** $90,000.0 - **Contract:** Temporary contract - **Skills:** Query Performance, Data Analysis, Business Software, Business Systems, Databases, Database Queries, Database Storage Structures, Microsoft SQL Server, Standard Sql, SQL Stored Procedures, SQL Databases, SQL Server Reporting Services, SQL Server Agent, Transact-SQL, Freeform SQL, Sql Optimization, Data Management, Tools for Reporting, SQL Server Management Studio (SSMS) - **Published:** August 5, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=e55fc8c709ba3273 ## About the Role We are looking for an experienced Microsoft SQL Server Developer to join our team as a full-time, in-office employee. This is not an entry-level SQL position. We are looking for someone who knows Microsoft SQL Server extremely well and is comfortable working directly with complex business databases. The successful candidate must be able to investigate unfamiliar databases, understand how tables and data relate to each other, write complex SQL queries, safely update data, and develop reports and database objects that support real-world business requirements., Experience working with databases supporting any of the following would be a significant advantage: * Accounting * ERP systems * Distribution * Inventory management * Purchasing * Sales order processing * Manufacturing * Bill of Materials (BOM) * Work in Process (WIP) * Production * Job costing Experience with SYSPRO ERP would be an additional advantage, but is not required. Understanding the business side of the data is valuable because much of the work involves turning business requirements into accurate SQL queries, reports, integrations, and solutions. The Person We Are Looking For We are looking for someone who genuinely enjoys working with SQL and data. You should be the type of person who can open an unfamiliar database containing hundreds of tables and be comfortable investigating it, understanding relationships, tracing data, and figuring out how the system works. You should also understand the responsibility that comes with having access to production databases. We need someone who knows the difference between simply knowing SQL syntax and knowing how to work safely and responsibly with business-critical data. Attention to detail is extremely important., If you are extremely strong in Microsoft SQL Server but do not have extensive accounting, distribution, or manufacturing experience, we still want to hear from you. SQL Server expertise is the #1 requirement. Business and ERP knowledge can be learned. We need someone who already knows SQL Server at an advanced level and can demonstrate that knowledge., * How many years of hands-on Microsoft SQL Server experience do you have? * Less than 1 year * 1-2 years * 3-5 years * 5-10 years * 10+ years * How would you rate your Microsoft SQL Server / T-SQL skills?, * How many years of hands-on experience do you have creating reports using Microsoft SQL Server Reporting Services (SSRS)? * None * Less than 1 year * 1-2 years * 3-5 years * 5+ years ## Description You will work extensively with Microsoft SQL Server and business application databases. Your responsibilities will include: * Writing simple and complex SQL queries * Joining and analyzing data across multiple related tables * Understanding existing database structures and relationships * Investigating unfamiliar databases to determine where and how information is stored * Writing complex queries involving: * INNER and OUTER JOINs * Subqueries * Common Table Expressions (CTEs) * Aggregations * CASE statements * Temporary tables * Window functions * Creating and maintaining SQL Views * Creating and maintaining Stored Procedures * Writing and executing INSERT, UPDATE, and DELETE statements * Troubleshooting incorrect or inconsistent data * Developing reports using Microsoft SQL Server Reporting Services (SSRS) * Creating datasets and SQL queries for reports * Adding parameters, filters, calculations, grouping, and other reporting functionality * Troubleshooting and improving existing SQL queries and reports * Optimizing SQL queries for performance * Working with users to understand business requirements and translate those requirements into SQL queries and reports * Supporting reporting, integration, automation, and data-related projects Required Skills The most important requirement for this position is strong, hands-on Microsoft SQL Server experience. Candidates must have advanced knowledge of: * Microsoft SQL Server * SQL Server Management Studio (SSMS) * Complex SQL queries * Multi-table joins * Views * Stored Procedures * INSERT, UPDATE, and DELETE statements * Database relationships * Query troubleshooting * Query performance and optimization * SQL Server Reporting Services (SSRS) We are specifically looking for someone who can be given a business question or reporting requirement and independently determine: What tables contain the information? How are those tables related? How should the data be joined? What SQL needs to be written to produce the correct result? The person should not require someone else to write the SQL or explain basic database concepts to them., * Which of the following have you personally created or worked with in Microsoft SQL Server? (Select all that apply.) * Complex SELECT queries * INNER / LEFT / RIGHT joins * Queries joining 5+ tables * CTEs * Subqueries * Temporary tables * Window functions * INSERT statements * UPDATE statements * DELETE statements * Views * Stored Procedures * Functions * SQL Agent Jobs * Query performance optimization * Indexes * SSRS reports * Have you personally written SQL UPDATE statements against a production or business database? * Yes * No * Have you personally created Stored Procedures in Microsoft SQL Server? * Yes * No * Have you personally created Views in Microsoft SQL Server? ## Related Videos - [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one) - [Hacking MSSQL on Cloud. All of them. How I became sysadmin on Azure, AWS, GCP and Alibaba.](https://www.wearedevelopers.com/videos/100339-hacking-mssql-on-cloud-all-of-them-how-i-became-sysadmin-on-azure-aws-gcp-and-alibaba) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Automated MS SQL Server database deployments with dacpacs and Azure DevOps](https://www.wearedevelopers.com/videos/334-automated-ms-sql-server-database-deployments-with-dacpacs-and-azure-devops) - [Crypto-secure Data Management with In-Database Blockchain](https://www.wearedevelopers.com/videos/632-crypto-secure-data-management-with-in-database-blockchain) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) ## Related Articles - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Where To Find Software Engineering Jobs](https://www.wearedevelopers.com/magazine/396-where-to-find-software-engineering-jobs) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [7 Most Popular Web Developer Jobs in Europe](https://www.wearedevelopers.com/magazine/163-7-most-popular-web-developer-jobs-in-europe)