Microsoft SQL Server Developer / Architect - Baltimore, MD

Microsoft SQL Server Developer / Architect - Baltimore, MD

Posted 1 week ago by TechniPros, LLC

Apply
Negotiable
Undetermined
Hybrid
Remote or Baltimore, Maryland
Apply
Auditing Automation Azure Blob Storage Azure DevOps Business Intelligence Business Operations Business Requirements Cloud Computing Cloud Services Cloud Technology Computer Science Continuous Integration and Continuous Delivery Dashboard Data Architecture Database Administration Database Architecture Database Management Database Security Data Governance Data Management Platforms Datamodel Data Modeling Data Protection Strategy Data Quality Data Warehousing DevOps DevSecOps Dimensional Modeling Enterprise Application Software Executive Leadership External Auditing Extract Transform Load (ETL) File Servers Financial Services General Insurance Indexing Information Systems Information Technology Lifecycle Management Management Management Process Microsoft 365 Microsoft Azure Microsoft SQL Servers Operational Efficiency Power BI Query Tuning Release Management Scalability Software Development SQL (Programming Language) SQL Server Analysis Services SQL Server Reporting Services Ssas Tabular Stakeholder Management Technical Documentation Version Control Workflow Automation Workflows

Summary: The Microsoft SQL Server Developer / Architect role involves designing and maintaining enterprise database architectures to support complex business applications and high-volume transactions. The position requires developing advanced SQL Server solutions and implementing robust ETL processes while collaborating with various stakeholders. The role also includes optimizing database performance and supporting Azure-hosted SQL Server environments. This hybrid position is based in Baltimore, MD, and requires extensive experience in SQL Server development and database architecture.

Key Responsibilities:

  • Design and maintain enterprise database architectures that support complex business applications, high-volume transactions, reporting environments, and long-term scalability requirements.
  • Develop advanced SQL Server solutions utilizing T-SQL, stored procedures, views, functions, triggers, and database objects that support mission-critical business operations.
  • Design and implement robust ETL processes that integrate data across applications, reporting platforms, cloud services, and external systems while maintaining data quality and consistency.
  • Create and optimize reporting and analytics solutions using SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BI, and related business intelligence technologies.
  • Lead data modeling initiatives that support claims management, workflow automation, regulatory reporting, operational analytics, and enterprise decision-making.
  • Analyze and optimize database performance through query tuning, indexing strategies, execution plan analysis, resource optimization, and architectural improvements.
  • Support Azure-hosted SQL Server environments by designing solutions that maximize availability, performance, security, and operational efficiency.
  • Collaborate with developers, architects, business analysts, and stakeholders to translate business requirements into scalable database and reporting solutions.
  • Support database deployment automation, version control, release management, and CI/CD processes that improve development efficiency and reduce deployment risk.
  • Contribute to database governance standards, architecture reviews, technical documentation, and modernization initiatives that strengthen the overall data ecosystem.

Key Skills:

  • Bachelor's degree in Computer Science, Information Technology, Engineering, Information Systems, or a related technical discipline; Master's degree preferred.
  • Seven (7) or more years of SQL Server development and database architecture experience supporting enterprise applications and business-critical systems.
  • Five (5) or more years of experience designing and supporting enterprise database environments, data models, reporting solutions, and analytics platforms.
  • Demonstrated expertise developing advanced SQL Server solutions utilizing T-SQL, stored procedures, ETL processes, reporting technologies, and performance optimization techniques.
  • Experience designing scalable database architectures that support high-volume transaction processing, reporting, analytics, and enterprise application workloads.
  • Strong understanding of database normalization, dimensional modeling, data warehousing concepts, and enterprise data architecture principles.
  • Experience implementing database security controls, data governance standards, auditing mechanisms, and data protection strategies.
  • Proven ability to analyze and resolve complex database performance issues involving queries, indexing, infrastructure resources, and application workloads.
  • Excellent communication and collaboration skills with the ability to engage technical teams, business stakeholders, and executive leadership.

Salary (Rate): undetermined

City: Baltimore

Country: United States

Working Arrangements: hybrid

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:
Job Role: Microsoft SQL Server Developer / Architect
Location: Baltimore, MD (Hybrid)
Employment Type: W2

What You'll Do

  • Design and maintain enterprise database architectures that support complex business applications, high-volume transactions, reporting environments, and long-term scalability requirements.
  • Develop advanced SQL Server solutions utilizing T-SQL, stored procedures, views, functions, triggers, and database objects that support mission-critical business operations.
  • Design and implement robust ETL processes that integrate data across applications, reporting platforms, cloud services, and external systems while maintaining data quality and consistency.
  • Create and optimize reporting and analytics solutions using SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BI, and related business intelligence technologies.
  • Lead data modeling initiatives that support claims management, workflow automation, regulatory reporting, operational analytics, and enterprise decision-making.
  • Analyze and optimize database performance through query tuning, indexing strategies, execution plan analysis, resource optimization, and architectural improvements.
  • Support Azure-hosted SQL Server environments by designing solutions that maximize availability, performance, security, and operational efficiency.
  • Collaborate with developers, architects, business analysts, and stakeholders to translate business requirements into scalable database and reporting solutions.
  • Support database deployment automation, version control, release management, and CI/CD processes that improve development efficiency and reduce deployment risk.
  • Contribute to database governance standards, architecture reviews, technical documentation, and modernization initiatives that strengthen the overall data ecosystem.

Core Technologies:

  • Microsoft SQL Server
  • T-SQL
  • SSIS
  • SSRS
  • SSAS
  • Power BI
  • Azure DevOps
  • Azure Virtual Machines
  • Azure Blob Storage
  • Azure Monitor

Required Qualifications:

  • Bachelor's degree in Computer Science, Information Technology, Engineering, Information Systems, or a related technical discipline. Master's degree is preferred.
  • Seven (7) or more years of SQL Server development and database architecture experience supporting enterprise applications and business-critical systems.
  • Five (5) or more years of experience designing and supporting enterprise database environments, data models, reporting solutions, and analytics platforms.
  • Demonstrated expertise developing advanced SQL Server solutions utilizing T-SQL, stored procedures, ETL processes, reporting technologies, and performance optimization techniques.
  • Experience designing scalable database architectures that support high-volume transaction processing, reporting, analytics, and enterprise application workloads.
  • Strong understanding of database normalization, dimensional modeling, data warehousing concepts, and enterprise data architecture principles.
  • Experience implementing database security controls, data governance standards, auditing mechanisms, and data protection strategies.
  • Proven ability to analyze and resolve complex database performance issues involving queries, indexing, infrastructure resources, and application workloads.
  • Excellent communication and collaboration skills with the ability to engage technical teams, business stakeholders, and executive leadership

Preferred Qualifications:
  • Experience supporting Federal, State, or Local Government agencies and participating in modernization initiatives involving large-scale enterprise applications and data platforms.
  • Experience working within workers' compensation, insurance, healthcare, claims processing, financial services, legal services, or other highly regulated environments that manage sensitive data and complex business workflows.
  • Familiarity with claims lifecycle management, adjudication systems, case management platforms, hearing management processes, and regulatory reporting environments.
  • Experience designing enterprise reporting and analytics solutions utilizing Power BI, SSRS, SSAS, dashboard technologies, and self-service business intelligence platforms.
  • Experience supporting Azure-hosted SQL Server environments, including performance optimization, storage configuration, backup strategies, and cloud-native database management practices.
  • Familiarity with Azure DevOps, automated database deployments, schema version control, CI/CD pipelines, and DevSecOps best practices.
  • Knowledge of Azure Key Vault, Azure Blob Storage, Azure networking, monitoring platforms, and enterprise cloud security practices.
  • Microsoft Certified Azure Database Administrator Associate, Azure Data Engineer Associate, or related database architecture certifications are highly desirable.

Best Regards:

Tanuja P
Phone:
Email:

Apply
Similar Jobs
Loading data...