SQL SME Developer (Subject Matter expert)

SQL SME Developer (Subject Matter expert) Location: Remote Job Type: Contract Experience :14+ Years MUST Mandatory Skills:

• SQL Development, Microsoft Azure, SSIS Development, SSRS Development, Database Architect experience,
• Build ETL processes for: Data integration, Data migration, Data warehouse loading, Business Intelligence
• The SQL Server Engineer / SQL Server SME is responsible for designing, developing, optimizing, and supporting enterprise SQL Server environments both on-premises and in Microsoft Azure.
• The role serves as the subject matter expert (SME) for database architecture, performance tuning, ETL solutions, reporting services, and cloud migration initiatives.

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.