SQL Developer

BuzzClan LLC•Lewisville, TX

5d•Hybrid

About The Position

We are seeking a highly skilled and detail-oriented SQL Developer to design, develop, and optimize business-critical SQL Server solutions across the enterprise data platform. This role is responsible for building and enhancing SQL Server databases, T-SQL code, SSIS integration packages, SSRS reports, and SSAS analytical models that support key business processes, reporting, and analytics.

Requirements

Bachelor's degree in Computer Science, Information Technology, Information Systems, Engineering, or a related field.
5+ years of hands-on SQL Server development experience in enterprise environments.
Experience developing with: Microsoft SQL Server Database, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS).
Experience designing and building database objects, ETL packages, reports, and analytical models.
Experience delivering enhancements, service requests, and defect fixes through a formal release process.
Experience supporting solutions in production, including Root Cause Analysis and release support.

Nice To Haves

Experience with Azure DevOps, Git, or other source control and release management tools.
Experience with cloud data platforms such as Azure Data Factory, Azure SQL, Snowflake, or Databricks.
Familiarity with ITIL processes including Incident, Problem, and Change Management.
Experience working in Agile or DevOps environments.
Advanced SQL Server performance tuning and query optimization skills.

Responsibilities

Design, develop, and deliver SQL Server solutions across Database, SSIS, SSRS, and SSAS components.
Translate business and functional requirements into technical designs, data models, and database solutions.
Develop, test, and deploy new functionality as well as enhancements to existing solutions.
Participate in design reviews, code reviews, and unit testing to ensure quality and adherence to standards.
Prepare technical documentation, including data mapping, data flow, and deployment artifacts.
Support production deployments, release activities, and post-deployment validation.
Design, develop, and optimize SQL Server database objects, including: Tables, Views, Stored Procedures, Functions, Indexes, Complex T-SQL Queries.
Implement application business logic within stored procedures, functions, and T-SQL code.
Performance tune queries and stored procedures using execution plan analysis and indexing strategies.
Develop enhancements to existing queries, stored procedures, and database objects.
Deliver database changes through source control and standard change and release processes.
Troubleshoot and resolve data integrity, performance, and application-related database defects.
Design, develop, and deploy SSIS packages and ETL workflows for enterprise data movement.
Build control flow, data flow, and transformation logic in line with development standards.
Implement error handling, logging, restartability, and data validation within packages.
Enhance and optimize existing SSIS packages for performance, reliability, and maintainability.
Troubleshoot and resolve data load failures and package execution issues.
Design, develop, and deploy SQL Server Reporting Services (SSRS) reports, datasets, and subscriptions.
Build parameterized, drill-through, and performance-optimized report designs.
Validate report data accuracy against source systems.
Deliver report enhancements and modifications requested by business users.
Investigate and resolve report execution failures and performance issues.
Develop and maintain SQL Server Analysis Services (SSAS) multidimensional and tabular models.
Build measures, KPIs, hierarchies, and calculations using MDX or DAX.
Configure and tune cube processing, partitions, and refresh schedules.
Ensure analytical models accurately reflect underlying business data.
Investigate and resolve cube processing failures and data discrepancies.
Provide production support for SQL Server databases, SSIS packages, SSRS reports, and SSAS models, including participation in an on-call rotation as required.
Investigate, troubleshoot, and resolve production incidents and data issues within agreed SLA commitments.
Perform Root Cause Analysis (RCA) on recurring incidents and implement permanent code-level fixes.
Monitor scheduled jobs, ETL loads, report subscriptions, and cube processing, and remediate failures.
Recommend improvements to database design, ETL processes, reporting, and monitoring to improve stability and operational efficiency.
Apply approved data fixes, service requests, and production validations as needed.