> Markdown version of [/jobs/ext/4346487-lead-sql-server-developer](https://www.wearedevelopers.com/jobs/ext/4346487-lead-sql-server-developer). 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). --- # Lead SQL Server Developer - **Company:** U S A CONSULTING INC - **Location:** Baltimore, MD, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Clean Code Principles, Query Performance, Agile Methodology, Application Integration Architecture, Business Logic, Software Suite, Microsoft Azure, Software Quality, Code Review, Databases, Data Conversion, Data Integrity, Data Security, Relational Databases, Database Design, Database Development, Database Schema, Entity Framework, Github, Microsoft SQL Server, Systems Development Life Cycle, Standard Sql, Application Data, Software Engineering, Software Systems, SQL Stored Procedures, SQL Server Reporting Services, SQL Server Integration Services, System Testing, Transact-SQL, Management of Software Versions, Enterprise Software Applications, Database Migration, Redgate, Software Coding, Software Version Control - **Published:** October 21, 2026 - **Apply:** https://www.dice.com/job-detail/292f5680-a1fa-4ca0-bfc4-8f8df98359b0 ## About the Role We are seeking an experienced Lead Data Developer to lead database development activities for the Maryland Pension Administration System (MPAS). The ideal candidate will have extensive hands-on experience in Microsoft SQL Server and T-SQL development, with expertise in stored procedures, functions, views, triggers, database schema design, data modeling, and query performance optimization., The successful candidate will bring strong technical leadership, Agile team experience, and at least five years of pension administration system experience, along with the ability to resolve complex database issues and ensure compliance with Agency and State software development standards., * 8+ years of hands-on T-SQL development experience, including stored procedures, functions, views, and triggers. * Strong experience with Microsoft SQL Server 2016 or later. * Demonstrated expertise in database schema design, relational data modeling, and implementation of application business logic within SQL Server. * Experience analyzing execution plans and optimizing queries, indexes, stored procedures, and overall database code performance. * Proven experience leading or coordinating database development teams in an Agile environment. * At least 5 years of pension administration system experience. * Experience establishing database coding standards, reviewing SQL code, and mentoring other developers. * Experience collaborating with application developers on database design, data access patterns, and application integration. * Strong troubleshooting and analytical skills, with the ability to resolve complex database development and performance issues. * Excellent written and verbal communication skills. * Ability to work independently while coordinating development activities across technical teams. Preferred Qualifications * Experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS). * Familiarity with database source control, schema versioning, and migration tools such as Flyway or Redgate. * Understanding of Entity Framework Core data access patterns and how application code consumes SQL Server database objects. * Experience using Azure DevOps and GitHub for source control, work tracking, collaboration, and development workflows. * Experience working in enterprise Agile development environments. * Prior experience supporting the State of Maryland or working on Maryland state government technology initiatives. ## Description Working under the direction of the Agency\'s Systems Development Unit, the Lead Data Developer will oversee database development standards, review database code, mentor other data developers, and collaborate with application developers to implement reliable and high-performing database solutions. This is a database development role, not a database administration (DBA) position, with a primary focus on implementing business logic, optimizing SQL code, and supporting application development., * Lead database development activities supporting the MPAS application suite and related enterprise systems. * Assign, coordinate, and review T-SQL development tasks while mentoring data developers and promoting consistent coding practices. * Establish and maintain database coding standards, naming conventions, documentation requirements, and development best practices. * Design, develop, test, and maintain SQL Server stored procedures, functions, views, and triggers that implement MPAS business logic. * Collaborate with application developers to design, evolve, and maintain database schemas, data models, and application data structures. * Develop and maintain database migration scripts, schema changes, and data conversion routines to support application enhancements and releases. * Analyze SQL Server execution plans to identify performance bottlenecks and optimize queries, indexes, stored procedures, and other database objects. * Troubleshoot complex database defects, investigate root causes, and implement solutions that improve performance, reliability, and maintainability. * Conduct unit, integration, and system testing of database code to ensure accuracy, data integrity, and alignment with application requirements. * Work closely with application development teams to ensure efficient database access and appropriate integration between application code and database objects. * Participate in Agile planning, estimation, code reviews, and technical discussions to support timely delivery of database development work. * Create and maintain technical documentation covering database designs, business logic, data models, migration procedures, and performance improvements. * Recommend database development techniques and tools that improve code quality, maintainability, and delivery efficiency. * Follow all applicable Agency and State software development policies, standards, and guidelines.