{"schemaVersion":"jobsearcher.job.v1","id":"d403e8eae6c036192717e2fe","url":"https://jobsearcher.com/jobs/d403e8eae6c036192717e2fe","canonicalUrl":"https://jobsearcher.com/jobs/d403e8eae6c036192717e2fe","title":"Senior SQL Developer","description":"Senior Data Engineer – SQL Pipelines Other Area(s) Remote Full-Time Apr 6, 2026\r\nInserso is seeking a hands-on Senior Data Engineer to design, build, and troubleshoot SQL-based data pipelines supporting mission-critical DevSecOps operations for the Air Force Reserve Command at Robins AFB. This role is focused on building and maintaining production data pipelines — not reporting or dashboard development. The ideal candidate has strong SQL coding skills, hands-on experience working with large datasets, and a proven track record of diagnosing and resolving complex data issues in operational environments. This position requires someone who can go beyond writing queries and take full ownership of data pipeline performance, reliability, and scalability across both NIPR/SIPR environments. Pipelines in this environment are code-first, built using SQL Server, C#/.NET microservices, and scheduling frameworks.\r\nResponsibilities Build and maintain end-to-end data pipelines (ETL/ELT) that move, transform, and load large-scale datasets reliably in production environments.\r\nWrite and optimize complex SQL using stored procedures, CTEs, window functions, and performance tuning techniques.\r\nDesign, develop, and maintain SQL Server 2016+ databases including stored procedures, functions, triggers, views, and other database objects.\r\nDiagnose and resolve data inconsistencies, failed pipeline jobs, and performance bottlenecks in production environments.\r\nDesign and implement data warehousing solutions, including incremental load strategies, staging patterns, and large-volume data handling.\r\nImplement and maintain database security measures to protect sensitive data across NIPR/SIPR environments.\r\nTroubleshoot and resolve database-related issues in both production and development environments.\r\nCollaborate on data modeling decisions including normalized vs. denormalized schema design.\r\nParticipate in code reviews and ensure adherence to coding standards and best practices.\r\nMentor junior developers and provide technical guidance on SQL Server development and pipeline engineering.\r\nCollaborate with application developers, system administrators, and stakeholders to deliver effective data solutions.\r\nContribute to pipeline documentation, runbooks, and data architecture documentation.\r\nSupport the team's ongoing migration to Azure cloud infrastructure as the effort progresses.\r\nRequired Skills/Experience Must be a U.S. Citizen with an active Secret Clearance.\r\nBachelor's degree in Computer Science, Information Technology, a related field, or equivalent experience.\r\n5–8 years of experience building data pipelines, data engineering solutions, or production database systems.\r\nDemonstrated experience troubleshooting production data pipelines and resolving performance issues under operational conditions.\r\nDeep understanding of SQL Server architecture including database engine, storage engine, and query processor.\r\nExtensive experience with T-SQL: stored procedures, functions, triggers, views, CTEs, and window functions.\r\nProficiency in SQL Server 2016 or later (2022 preferred).\r\nStrong understanding of indexing strategies, query optimization, and performance tuning.\r\nSolid understanding of relational database design principles, normalization, and dimensional modeling (star schema, fact/dimension tables).\r\nExperience designing and implementing incremental ETL processes including watermark strategies, staging tables, and idempotent load patterns.\r\nUnderstanding of data warehousing concepts including slowly changing dimensions, batch loading, and large-scale data handling.\r\nExperience working with large datasets (millions+ records) in production environments.\r\nStrong understanding of database security principles and experience implementing security measures.\r\nExperience with .NET/C# for pipeline or application development — our environment uses a code-first pipeline architecture built on C# microservices alongside SQL Server.\r\nPreferred Skills/Experience Experience with pipeline scheduling and orchestration tools (SQL Agent, Hangfire, or similar).\r\nExperience with Agile development methodologies.\r\nSQL Server certification (e.g., Microsoft Certified: Azure Data Engineer Associate).\r\nExperience with data visualization tools (Power BI or Tableau) — secondary to pipeline work.\r\nExperience with Python or PySpark for data processing tasks.\r\nFuture-Relevance as We Migrate to Azure Familiarity with ETL/ELT tooling (SSIS, Azure Data Factory, or similar) — not currently in use but relevant as cloud migration progresses.\r\nExposure to NoSQL databases — our current environment is SQL Server RDBMS, but awareness of NoSQL concepts is a plus.\r\nExperience with cloud-based database solutions (Azure SQL Database, AWS RDS) — we are targeting Azure adoption and this experience will become directly applicable.\r\nExperience with database administration tasks in hybrid on-prem/cloud environments.\r\nPhysical and/or Mental Qualifications Excellent communication, interpersonal, and collaboration skills.\r\nAbility to effectively communicate technical concepts to both technical and non-technical audiences.\r\nAbility to work independently and as part of a team.\r\nAbility to prioritize tasks and manage time effectively.\r\nAbility to adapt to changing priorities and requirements.\r\nEOE, including Disability/Vets. Reasonable accommodation will be made for qualified individuals with a disability, where such accommodation will not impose an undue hardship during the application process and on the job.\r\nJ-18808-Ljbffr","company":"Inserso","rawCompany":"inserso","city":"Warner Robins","state":"GA","isRemote":false,"isActive":false,"createdAt":"2026-07-04T01:49:12.048Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"}],"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 SQL Developer","description":"Senior Data Engineer – SQL Pipelines Other Area(s) Remote Full-Time Apr 6, 2026\r\nInserso is seeking a hands-on Senior Data Engineer to design, build, and troubleshoot SQL-based data pipelines supporting mission-critical DevSecOps operations for the Air Force Reserve Command at Robins AFB. This role is focused on building and maintaining production data pipelines — not reporting or dashboard development. The ideal candidate has strong SQL coding skills, hands-on experience working with large datasets, and a proven track record of diagnosing and resolving complex data issues in operational environments. This position requires someone who can go beyond writing queries and take full ownership of data pipeline performance, reliability, and scalability across both NIPR/SIPR environments. Pipelines in this environment are code-first, built using SQL Server, C#/.NET microservices, and scheduling frameworks.\r\nResponsibilities Build and maintain end-to-end data pipelines (ETL/ELT) that move, transform, and load large-scale datasets reliably in production environments.\r\nWrite and optimize complex SQL using stored procedures, CTEs, window functions, and performance tuning techniques.\r\nDesign, develop, and maintain SQL Server 2016+ databases including stored procedures, functions, triggers, views, and other database objects.\r\nDiagnose and resolve data inconsistencies, failed pipeline jobs, and performance bottlenecks in production environments.\r\nDesign and implement data warehousing solutions, including incremental load strategies, staging patterns, and large-volume data handling.\r\nImplement and maintain database security measures to protect sensitive data across NIPR/SIPR environments.\r\nTroubleshoot and resolve database-related issues in both production and development environments.\r\nCollaborate on data modeling decisions including normalized vs. denormalized schema design.\r\nParticipate in code reviews and ensure adherence to coding standards and best practices.\r\nMentor junior developers and provide technical guidance on SQL Server development and pipeline engineering.\r\nCollaborate with application developers, system administrators, and stakeholders to deliver effective data solutions.\r\nContribute to pipeline documentation, runbooks, and data architecture documentation.\r\nSupport the team's ongoing migration to Azure cloud infrastructure as the effort progresses.\r\nRequired Skills/Experience Must be a U.S. Citizen with an active Secret Clearance.\r\nBachelor's degree in Computer Science, Information Technology, a related field, or equivalent experience.\r\n5–8 years of experience building data pipelines, data engineering solutions, or production database systems.\r\nDemonstrated experience troubleshooting production data pipelines and resolving performance issues under operational conditions.\r\nDeep understanding of SQL Server architecture including database engine, storage engine, and query processor.\r\nExtensive experience with T-SQL: stored procedures, functions, triggers, views, CTEs, and window functions.\r\nProficiency in SQL Server 2016 or later (2022 preferred).\r\nStrong understanding of indexing strategies, query optimization, and performance tuning.\r\nSolid understanding of relational database design principles, normalization, and dimensional modeling (star schema, fact/dimension tables).\r\nExperience designing and implementing incremental ETL processes including watermark strategies, staging tables, and idempotent load patterns.\r\nUnderstanding of data warehousing concepts including slowly changing dimensions, batch loading, and large-scale data handling.\r\nExperience working with large datasets (millions+ records) in production environments.\r\nStrong understanding of database security principles and experience implementing security measures.\r\nExperience with .NET/C# for pipeline or application development — our environment uses a code-first pipeline architecture built on C# microservices alongside SQL Server.\r\nPreferred Skills/Experience Experience with pipeline scheduling and orchestration tools (SQL Agent, Hangfire, or similar).\r\nExperience with Agile development methodologies.\r\nSQL Server certification (e.g., Microsoft Certified: Azure Data Engineer Associate).\r\nExperience with data visualization tools (Power BI or Tableau) — secondary to pipeline work.\r\nExperience with Python or PySpark for data processing tasks.\r\nFuture-Relevance as We Migrate to Azure Familiarity with ETL/ELT tooling (SSIS, Azure Data Factory, or similar) — not currently in use but relevant as cloud migration progresses.\r\nExposure to NoSQL databases — our current environment is SQL Server RDBMS, but awareness of NoSQL concepts is a plus.\r\nExperience with cloud-based database solutions (Azure SQL Database, AWS RDS) — we are targeting Azure adoption and this experience will become directly applicable.\r\nExperience with database administration tasks in hybrid on-prem/cloud environments.\r\nPhysical and/or Mental Qualifications Excellent communication, interpersonal, and collaboration skills.\r\nAbility to effectively communicate technical concepts to both technical and non-technical audiences.\r\nAbility to work independently and as part of a team.\r\nAbility to prioritize tasks and manage time effectively.\r\nAbility to adapt to changing priorities and requirements.\r\nEOE, including Disability/Vets. Reasonable accommodation will be made for qualified individuals with a disability, where such accommodation will not impose an undue hardship during the application process and on the job.\r\nJ-18808-Ljbffr","datePosted":"2026-07-04T01:49:12.048Z","dateModified":"2026-07-04T01:49:12.048Z","hiringOrganization":{"@type":"Organization","name":"Inserso","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Warner Robins","addressRegion":"GA","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"d403e8eae6c036192717e2fe"},"url":"https://jobsearcher.com/jobs/d403e8eae6c036192717e2fe"}}