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.
Apply To This Job