Microsoft SQL Server Developer / Architect - Baltimore, MD

Dice is the leading career destination for tech experts at every stage of their careers. Our client, TechniPros, LLC, is seeking the following. Apply via Dice today!Job Title: Microsoft SQL Server Developer / ArchitectLocation: Baltimore, Maryland (Hybrid)Can do Only W2, No C2CJob Summary:We are seeking an experienced Microsoft SQL Server Developer / Architect to design and maintain enterprise database architectures supporting complex business applications, high-volume transactions, reporting environments, and analytics platforms. The ideal candidate will possess strong expertise in SQL Server, T-SQL, ETL processes, reporting technologies, performance tuning, and Azure-hosted database environments.Key Responsibilities:Design and maintain scalable enterprise database architectures.Develop advanced SQL Server solutions using T-SQL, stored procedures, functions, views, triggers, and database objects.Design and implement ETL processes to integrate data across applications, reporting platforms, cloud services, and external systems.Create and optimize reporting and analytics solutions using SSRS, SSAS, and Power BI.Lead data modeling initiatives supporting workflow automation, claims management, reporting, and analytics.Perform query tuning, indexing strategies, execution plan analysis, and database performance optimization.Support Azure-hosted SQL Server environments to ensure availability, security, and operational efficiency.Collaborate with architects, developers, business analysts, and stakeholders to deliver scalable database solutions.Support deployment automation, version control, release management, and CI/CD processes.Contribute to database governance, architecture reviews, technical documentation, and modernization initiatives.Required Skills:Strong experience with Microsoft SQL ServerExpertise in T-SQLHands-on experience with SSISExperience with SSRSExperience with SSASProficiency with Power BIExperience with Azure DevOpsKnowledge of Azure Virtual MachinesExperience with Azure Blob StorageFamiliarity with Azure MonitorStrong knowledge of database normalization and dimensional modelingExperience with data warehousing concepts and enterprise data architectureExpertise in database performance tuning and optimizationExperience implementing database security, auditing, and governance standardsKnowledge of CI/CD and DevSecOps practicesPreferred Qualifications:Bachelor's degree in Computer Science, Information Technology, Engineering, Information Systems, or related field.Master's degree preferred.7+ years of SQL Server development and database architecture experience.5+ years of experience designing enterprise database environments and reporting platforms.Experience supporting Federal, State, or Local Government modernization initiatives.Experience in insurance, healthcare, claims processing, workers' compensation, legal services, financial services, or other regulated industries.Familiarity with claims lifecycle management, case management systems, and regulatory reporting environments.Experience designing enterprise reporting solutions using Power BI, SSRS, SSAS, and self-service BI platforms.Experience supporting Azure-hosted SQL Server environments, including storage, backups, and cloud-native database management.Experience with Azure DevOps, automated deployments, schema version control, and CI/CD pipelines.Knowledge of Azure Key Vault, Azure networking, monitoring platforms, and cloud security practices.Microsoft Certified Azure Database Administrator Associate, Azure Data Engineer Associate, or related certifications are highly desirable.Soft Skills:Excellent communication and interpersonal skillsStrong analytical and troubleshooting abilitiesProblem-solving mindsetAbility to collaborate with cross-functional teamsStrong stakeholder management skillsAbility to engage with technical teams and executive leadershipBest Regards:Emma WPhone:Email: