Description

Job Summary We are seeking an experienced Microsoft SQL Server Developer / Architect to design, develop, optimize, and maintain enterprise-scale database architectures and reporting solutions supporting mission-critical business applications. The ideal candidate will possess extensive expertise in SQL Server development, database architecture, ETL processes, business intelligence, cloud technologies, and performance optimization. This role requires strong experience working within complex enterprise environments and the ability to deliver scalable, secure, and high-performing database solutions.

Key Responsibilities

• Design and maintain enterprise database architectures supporting complex business applications, high-volume transactions, reporting environments, and long-term scalability.
• Develop advanced Microsoft SQL Server solutions utilizing T-SQL, Stored Procedures, Views, Functions, Triggers, and other database objects.
• Design, develop, and implement robust ETL processes using SSIS and related technologies.
• Integrate data across enterprise applications, reporting platforms, cloud services, and external systems while ensuring data quality and consistency.
• Create, optimize, and support reporting and analytics solutions using SSRS, SSAS, Power BI, and related BI technologies.
• Lead enterprise data modeling initiatives supporting operational analytics, workflow automation, regulatory reporting, and decision-making processes.
• Analyze and optimize database performance through query tuning, indexing strategies, execution plan analysis, and resource optimization.
• Design and support Azure-hosted SQL Server environments to maximize availability, performance, security, and operational efficiency.
• Collaborate with developers, architects, business analysts, and stakeholders to translate business requirements into scalable database solutions.
• Support database deployment automation, schema version control, release management, and CI/CD processes.
• Contribute to database governance, architecture reviews, technical documentation, and modernization initiatives.
• Implement database security controls, auditing mechanisms, data governance standards, and data protection strategies.

Required Skills 7+ years of Microsoft SQL Server Development and Database Architecture experience. 5+ years of experience supporting enterprise database environments, reporting platforms, analytics solutions, and data models. Strong expertise in Microsoft SQL Server. Advanced T-SQL programming experience. Extensive experience with SSIS (SQL Server Integration Services). Strong experience with SSRS (SQL Server Reporting Services). Experience with SSAS (SQL Server Analysis Services). Expertise in Power BI development and reporting solutions. Experience designing and implementing ETL processes. Strong knowledge of database normalization and dimensional modeling. Experience with data warehousing concepts and enterprise data architecture. Strong database performance tuning and optimization skills. Experience with indexing strategies and execution plan analysis. Experience supporting Azure SQL Server environments. Hands-on experience with Azure DevOps. Experience with Azure Virtual Machines. Experience with Azure Blob Storage. Experience with Azure Monitor. Knowledge of CI/CD pipelines and database deployment automation. Experience implementing database security, governance, and auditing controls. Excellent communication and stakeholder engagement skills.

Preferred Qualifications Bachelor's Degree in Computer Science, Information Technology, Engineering, Information Systems, or related discipline. Master's Degree preferred. Experience supporting Federal, State, or Local Government agencies. Experience working within highly regulated industries such as: Workers' Compensation Insurance Healthcare Claims Processing Financial Services Legal Services Familiarity with claims lifecycle management and adjudication systems. Experience with case management platforms and hearing management systems. Experience designing enterprise reporting and analytics platforms. Familiarity with self-service BI and dashboard technologies. Experience supporting Azure-hosted SQL Server environments and cloud-native database practices. Experience with Azure DevOps, DevSecOps, schema version control, and automated database deployments. Knowledge of Azure Key Vault and Azure networking. Microsoft Certified Azure Database Administrator Associate certification. Microsoft Azure Data Engineer Associate certification. Related database architecture certifications are highly desirable.

Soft Skills Strong analytical and problem-solving abilities. Excellent verbal and written communication skills. Strong collaboration and teamwork skills. Ability to communicate effectively with technical teams and executive leadership. Strong organizational and documentation skills. Ability to manage multiple priorities in a fast-paced environment. Strong stakeholder management capabilities. Ability to lead architecture discussions and modernization initiatives.

Additional Notes Hybrid position based in Baltimore, Maryland. Local Maryland candidates only. Candidate must be able to successfully pass a State of Maryland background investigation. Experience with enterprise-scale database modernization initiatives is highly preferred. Strong experience in SQL Server architecture, BI, cloud technologies, and performance optimization is required.

Mandatory Skills Microsoft SQL Server T-SQL SSIS SSRS SSAS Power BI ETL Development Database Architecture Data Modeling Data Warehousing Performance Tuning Query Optimization Indexing Strategies Azure DevOps Azure Virtual Machines Azure Blob Storage Azure Monitor CI/CD Pipelines Database Security Database Governance Enterprise Reporting Azure SQL Server Environments

Key Skills

Education

Any Graduate