SQL SME Developer (Subject Matter expert)

TechDigital Group; Maryland; Hybrid; USD 120,000 - 180,000; Full time

Job summary

TechDigital Group seeks an experienced SQL Server/ETL/BI professional to design, develop, and optimize data solutions in a large enterprise environment in Maryland. The role covers SQL development, SSIS ETL, SSRS/Power BI reporting, and data warehousing to enable robust analytics.

Ideal candidates bring deep database architecture and performance tuning expertise, with experience in healthcare, insurance, finance, or other large-scale applications.

Qualifications

• 14–18 years of SQL Server experience.
• Enterprise ETL development using SSIS.
• Enterprise reporting using SSRS/Power BI.
• Database architecture and design experience.
• Production support and performance tuning expertise.
• Healthcare, insurance, finance, or large enterprise application experience preferred.

Responsibilities

• Develop and optimize stored procedures, functions, views, triggers, and T-SQL queries.
• Analyze execution plans and improve query performance.
• Troubleshoot blocking, deadlocks, and long-running queries.
• Design enterprise database architectures and data models.
• Design and implement SSIS ETL packages.
• Develop reports and dashboards with SSRS/Power BI.
• Monitor performance and troubleshoot production incidents.
• Support data warehousing and BI solutions.

Skills

SQL Server

T-SQL

Performance Tuning

SSIS

SSRS

Power BI

Data Warehousing

Data Modeling

OLTP Architecture

Security & Governance

Job description

Primary Responsibilities

SQL Development

• Develop and optimize: Stored Procedures, Functions, Views, Triggers, T-SQL Queries
• Analyze execution plans and improve query performance.
• Troubleshoot blocking, deadlocks, and long-running queries.
• Design efficient indexing strategies.
• Implement database performance tuning.

SSIS Development

• Design and develop SSIS packages.
• Build ETL processes for: Data integration, Data migration, Data warehouse loading
• Handle data transformation and cleansing.
• Automate file imports and exports.
• Monitor SSIS package execution and troubleshoot failures.

SSRS Development

• Design and develop operational and executive reports.
• Create dashboards and analytical reports.
• Implement report subscriptions and automated delivery.
• Optimize report performance.

Database Architecture & Design

• Design enterprise database architecture.
• Create logical and physical data models.
• Perform normalization and denormalization.
• Establish database standards and best practices.
• Design highly scalable OLTP and reporting solutions.
• Design multi-tenant and enterprise application databases.

Performance & Troubleshooting

• Conduct root cause analysis.
• Resolve production incidents.
• Monitor wait statistics.
• Analyze memory, CPU, and I/O bottlenecks.
• Tune indexes and statistics.
• Improve SQL workload efficiency.

Data Warehouse & Business Intelligence

• Design dimensional models.
• Implement data marts and enterprise data warehouses.
• Build reporting and analytics platforms.
• Support Power BI, SSRS, and BI solutions.

Required Technical Skills

SQL Server

• SQL Server 2016/2019/2022, T-SQL, Query Optimization, Performance Tuning, Indexing, Partitioning, Replication, Always On Availability Groups

Integration & Reporting

• SSIS, SSRS

Database Design

• Data Modeling, OLTP Architecture, Data Warehousing, Star Schema, Database Security, Data Governance

Good to have Knowledge

SQL Server Administration

• Install, configure, and maintain SQL Server environments.
• Manage SQL Server upgrades, patching, and migrations.
• Configure security, roles, permissions, and auditing.
• Perform backup, recovery, and disaster recovery planning.
• Manage Always On Availability Groups, Failover Clustering, and replication.
• Monitor database health and capacity planning.

Experience

• 14– 18 years of SQL Server experience.
• Enterprise ETL development using SSIS.
• Enterprise reporting using SSRS/Power BI.
• Database architecture and design experience.
• Production support and performance tuning expertise.
• Healthcare, insurance, finance, or large enterprise application experience preferred.