Skip to content
Go to homepage

site

  • About
  • Our Team
  • Job Openings
  • Contact

This site uses cookies to improve the user experience! Would you like to allow cookies?

Cookie Settings

These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work.

These cookies help us understand and improve the use and performance of our services including what links visitors clicked on the most, and how they interact with the various areas and features on our website and apps.

SQL SME Developer (Subject Matter expert)

Job #: 26-02397
Pay Rate: Not Specified
Job type: contractor
Location: Remote, NJ
Apply Now Back to Search
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 Now Back to Search
Go to corporate home page
Copyright © 2026 TechDigital Group
  • linkedin
  • facebook
Monster Strategic Talent Solutions