Microsoft SQL Server Developer / Architect-Baltimore, MD, Harrisburg, PA, Dover, DE, Richmond, VA, Charleston, WV

TechniPros (Baltimore MD, USA) Follow 20 days ago

Contract 55 USD

Apply Now

Job Title

Microsoft SQL Server Developer / Architect

Location

Baltimore, Maryland (Hybrid)

Duration

Long-Term Contract

Employment Type

Contract (Local Candidates Only)

Rate (if available)DOE (Depends on Experience)

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