Microsoft SQL Server Developer​/Architect

At 4A Consulting, we turn complexity into opportunity. Founded in 2014 and headquartered in Baltimore, MD, we are a women-owned, boutique consulting firm specializing in delivering innovative, data-driven solutions to both the Federal Government and Fortune 500 clients. Our team blends deep industry knowledge with advanced technologies to design tailored strategies that drive measurable and sustainable outcomes. We pride ourselves on an agile, collaborative approach that helps organizations navigate challenges and seize emerging opportunities in a rapidly evolving digital landscape.

At 4A, we don’t just deliver projects, we build trusted partnerships that empower our clients to lead with confidence in the digital age.

We are seeking a Microsoft SQL Server Developer / Architect to design, develop, and optimize enterprise database architectures supporting large-scale business applications, analytics, reporting, and modernization initiatives. This role combines advanced SQL development expertise with database architecture leadership.

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

• 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…