Microsoft SQL Server Developer / Architect - Baltimore, MD

TechniPros (Baltimore MD, USA) Follow 16 hours ago

Job Title: Microsoft SQL Server Developer / Architect

Location: Baltimore, Maryland (Hybrid)

Can do Only W2, No C2C

Job 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 Server
Expertise in T-SQL
Hands-on experience with SSIS
Experience with SSRS
Experience with SSAS
Proficiency with Power BI
Experience with Azure DevOps
Knowledge of Azure Virtual Machines
Experience with Azure Blob Storage
Familiarity with Azure Monitor
Strong knowledge of database normalization and dimensional modeling
Experience with data warehousing concepts and enterprise data architecture
Expertise in database performance tuning and optimization
Experience implementing database security, auditing, and governance standards
Knowledge of CI/CD and DevSecOps practices

Preferred 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.