{"schemaVersion":"jobsearcher.job.v1","id":"38a74fbdc044f196ae47bbab","url":"https://jobsearcher.com/jobs/38a74fbdc044f196ae47bbab","canonicalUrl":"https://jobsearcher.com/jobs/38a74fbdc044f196ae47bbab","title":"Senior Microsoft SQL Server Developer – SQL, SSRS & Business Systems","description":"We are looking for an experienced Microsoft SQL Server Developer to join our team as a full-time, in-office employee.\nThis 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.\nThe 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.\nWhat You Will Be Doing\nYou will work extensively with Microsoft SQL Server and business application databases.\nYour responsibilities will include:\nWriting simple and complex SQL queries\nJoining and analyzing data across multiple related tables\nUnderstanding existing database structures and relationships\nInvestigating unfamiliar databases to determine where and how information is stored\nWriting complex queries involving:\nINNER and OUTER JOINs\nSubqueries\nCommon Table Expressions (CTEs)\nAggregations\nCASE statements\nTemporary tables\nWindow functions\nCreating and maintaining SQL Views\nCreating and maintaining Stored Procedures\nWriting and executing INSERT, UPDATE, and DELETE statements\nTroubleshooting incorrect or inconsistent data\nDeveloping reports using Microsoft SQL Server Reporting Services (SSRS)\nCreating datasets and SQL queries for reports\nAdding parameters, filters, calculations, grouping, and other reporting functionality\nTroubleshooting and improving existing SQL queries and reports\nOptimizing SQL queries for performance\nWorking with users to understand business requirements and translate those requirements into SQL queries and reports\nSupporting reporting, integration, automation, and data-related projects\nRequired Skills\nThe most important requirement for this position is strong, hands-on Microsoft SQL Server experience.\nCandidates must have advanced knowledge of:\nMicrosoft SQL Server\nSQL Server Management Studio (SSMS)\nComplex SQL queries\nMulti-table joins\nViews\nStored Procedures\nINSERT, UPDATE, and DELETE statements\nDatabase relationships\nQuery troubleshooting\nQuery performance and optimization\nSQL Server Reporting Services (SSRS)\nWe are specifically looking for someone who can be given a business question or reporting requirement and independently determine:\nWhat tables contain the information?\nHow are those tables related?\nHow should the data be joined?\nWhat SQL needs to be written to produce the correct result?\nThe person should not require someone else to write the SQL or explain basic database concepts to them.\nBusiness Experience – Strongly Preferred\nExperience working with databases supporting any of the following would be a significant advantage:\nAccounting\nERP systems\nDistribution\nInventory management\nPurchasing\nSales order processing\nManufacturing\nBill of Materials (BOM)\nWork in Process (WIP)\nProduction\nJob costing\nExperience with SYSPRO ERP would be an additional advantage, but is not required.\nUnderstanding 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.\nThe Person We Are Looking For\nWe are looking for someone who genuinely enjoys working with SQL and data.\nYou 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.\nYou 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.\nAttention to detail is extremely important.\nWork Schedule\nThis is a full-time, in-office position.\nWorking Hours: 8:00 AM – 5:00 PMLunch: 1-hour lunch break\nThis is not a remote position.\nMost Important Requirement\nIf 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.\nSQL Server expertise is the #1 requirement.\nBusiness and ERP knowledge can be learned.\nWe need someone who already knows SQL Server at an advanced level and can demonstrate that knowledge.\nPay: From $90,000.00 per year\nBenefits:\nDental insurance\nHealth insurance\nPaid time off\nVision insurance\nApplication Question(s):\nThis position is 100% in-office, Monday–Friday, 8:00 AM–5:00 PM, with a 1-hour lunch break. Are you able and willing to work this schedule in our office?\nYes\nNo\nHow many years of hands-on Microsoft SQL Server experience do you have?\nLess than 1 year\n1–2 years\n3–5 years\n5–10 years\n10+ years\nHow would you rate your Microsoft SQL Server / T-SQL skills?\nBeginner\nIntermediate\nAdvanced\nExpert\nWhich of the following have you personally created or worked with in Microsoft SQL Server? (Select all that apply.)\nComplex SELECT queries\nINNER / LEFT / RIGHT joins\nQueries joining 5+ tables\nCTEs\nSubqueries\nTemporary tables\nWindow functions\nINSERT statements\nUPDATE statements\nDELETE statements\nViews\nStored Procedures\nFunctions\nSQL Agent Jobs\nQuery performance optimization\nIndexes\nSSRS reports\nHave you personally written SQL UPDATE statements against a production or business database?\nYes\nNo\nHave you personally created Stored Procedures in Microsoft SQL Server?\nYes\nNo\nHave you personally created Views in Microsoft SQL Server?\nYes\nNo\nHow many years of hands-on experience do you have creating reports using Microsoft SQL Server Reporting Services (SSRS)?\nNone\nLess than 1 year\n1–2 years\n3–5 years\n5+ years\nWork Location: In person","company":"Mepconsultingservicesllc","rawCompany":"mepconsultingservicesllc","city":"Spring","state":"TX","isRemote":false,"isActive":false,"createdAt":"2026-08-08T14:03:09.318Z","occupations":[{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"},{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Senior Microsoft SQL Server Developer – SQL, SSRS & Business Systems","description":"We are looking for an experienced Microsoft SQL Server Developer to join our team as a full-time, in-office employee.\nThis 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.\nThe 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.\nWhat You Will Be Doing\nYou will work extensively with Microsoft SQL Server and business application databases.\nYour responsibilities will include:\nWriting simple and complex SQL queries\nJoining and analyzing data across multiple related tables\nUnderstanding existing database structures and relationships\nInvestigating unfamiliar databases to determine where and how information is stored\nWriting complex queries involving:\nINNER and OUTER JOINs\nSubqueries\nCommon Table Expressions (CTEs)\nAggregations\nCASE statements\nTemporary tables\nWindow functions\nCreating and maintaining SQL Views\nCreating and maintaining Stored Procedures\nWriting and executing INSERT, UPDATE, and DELETE statements\nTroubleshooting incorrect or inconsistent data\nDeveloping reports using Microsoft SQL Server Reporting Services (SSRS)\nCreating datasets and SQL queries for reports\nAdding parameters, filters, calculations, grouping, and other reporting functionality\nTroubleshooting and improving existing SQL queries and reports\nOptimizing SQL queries for performance\nWorking with users to understand business requirements and translate those requirements into SQL queries and reports\nSupporting reporting, integration, automation, and data-related projects\nRequired Skills\nThe most important requirement for this position is strong, hands-on Microsoft SQL Server experience.\nCandidates must have advanced knowledge of:\nMicrosoft SQL Server\nSQL Server Management Studio (SSMS)\nComplex SQL queries\nMulti-table joins\nViews\nStored Procedures\nINSERT, UPDATE, and DELETE statements\nDatabase relationships\nQuery troubleshooting\nQuery performance and optimization\nSQL Server Reporting Services (SSRS)\nWe are specifically looking for someone who can be given a business question or reporting requirement and independently determine:\nWhat tables contain the information?\nHow are those tables related?\nHow should the data be joined?\nWhat SQL needs to be written to produce the correct result?\nThe person should not require someone else to write the SQL or explain basic database concepts to them.\nBusiness Experience – Strongly Preferred\nExperience working with databases supporting any of the following would be a significant advantage:\nAccounting\nERP systems\nDistribution\nInventory management\nPurchasing\nSales order processing\nManufacturing\nBill of Materials (BOM)\nWork in Process (WIP)\nProduction\nJob costing\nExperience with SYSPRO ERP would be an additional advantage, but is not required.\nUnderstanding 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.\nThe Person We Are Looking For\nWe are looking for someone who genuinely enjoys working with SQL and data.\nYou 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.\nYou 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.\nAttention to detail is extremely important.\nWork Schedule\nThis is a full-time, in-office position.\nWorking Hours: 8:00 AM – 5:00 PMLunch: 1-hour lunch break\nThis is not a remote position.\nMost Important Requirement\nIf 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.\nSQL Server expertise is the #1 requirement.\nBusiness and ERP knowledge can be learned.\nWe need someone who already knows SQL Server at an advanced level and can demonstrate that knowledge.\nPay: From $90,000.00 per year\nBenefits:\nDental insurance\nHealth insurance\nPaid time off\nVision insurance\nApplication Question(s):\nThis position is 100% in-office, Monday–Friday, 8:00 AM–5:00 PM, with a 1-hour lunch break. Are you able and willing to work this schedule in our office?\nYes\nNo\nHow many years of hands-on Microsoft SQL Server experience do you have?\nLess than 1 year\n1–2 years\n3–5 years\n5–10 years\n10+ years\nHow would you rate your Microsoft SQL Server / T-SQL skills?\nBeginner\nIntermediate\nAdvanced\nExpert\nWhich of the following have you personally created or worked with in Microsoft SQL Server? (Select all that apply.)\nComplex SELECT queries\nINNER / LEFT / RIGHT joins\nQueries joining 5+ tables\nCTEs\nSubqueries\nTemporary tables\nWindow functions\nINSERT statements\nUPDATE statements\nDELETE statements\nViews\nStored Procedures\nFunctions\nSQL Agent Jobs\nQuery performance optimization\nIndexes\nSSRS reports\nHave you personally written SQL UPDATE statements against a production or business database?\nYes\nNo\nHave you personally created Stored Procedures in Microsoft SQL Server?\nYes\nNo\nHave you personally created Views in Microsoft SQL Server?\nYes\nNo\nHow many years of hands-on experience do you have creating reports using Microsoft SQL Server Reporting Services (SSRS)?\nNone\nLess than 1 year\n1–2 years\n3–5 years\n5+ years\nWork Location: In person","datePosted":"2026-08-08T14:03:09.318Z","dateModified":"2026-08-08T14:03:09.318Z","hiringOrganization":{"@type":"Organization","name":"Mepconsultingservicesllc","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Spring","addressRegion":"TX","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"38a74fbdc044f196ae47bbab"},"url":"https://jobsearcher.com/jobs/38a74fbdc044f196ae47bbab"}}