T-SQL Developer

Job Description Job Summary Synechron is seeking an experienced T-SQL Developer to lead the development and optimization of high-quality SQL Server database solutions. The successful candidate will design efficient database structures, develop complex queries and procedures, and collaborate with cross-functional teams to enhance business processes. This role is essential in supporting data-driven decision-making, system performance, and maintaining best practices across the organization's data infrastructure. Software Requirements Required Skills: - Strong proficiency in T-SQL (SQL Server 2016/2019 or higher), including writing stored procedures, functions, and complex queries - Expertise in database optimization, indexing, and query tuning for high performance - Experience with SQL Server Management Studio (SSMS) and Data Tools - Familiarity with relational database design, normalization, and data modeling - Knowledge of ETL processes and data warehousing concepts Preferred Skills: - Experience with SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) - Familiarity with cloud data platforms such as Azure SQL Database or Azure Synapse - Knowledge of scripting languages like PowerShell or Python for automation - Exposure to other database systems (e.g., Oracle, PostgreSQL) is a plus Overall Responsibilities - Develop, test, and optimize T-SQL queries, stored procedures, and functions to support enterprise applications and analytics - Design and implement database structures, indexes, and query strategies to maximize performance and data integrity - Collaborate with developers, data engineers, and analysts to understand data requirements and translate them into efficient database solutions - Monitor system performance, troubleshoot issues, and recommend improvements for query and database design - Implement best practices for database development, security, and disaster recovery - Participate in peer code reviews, testing, and deployment of data solutions - Contribute to the evaluation and adoption of new data platform tools and technologies - Document database schemas, processes, and best practices for ongoing maintenance and knowledge sharing Technical Skills (By Category) Programming Languages: - Essential: T-SQL (SQL Server) - Preferred: Powershell, Python for automation scripting Database Design & Optimization: - Essential: Indexing strategies, query tuning, stored procedure development - Preferred: Data warehousing including ETL processes, implementing data marts Cloud & Data Platforms: - Preferred: Azure SQL, Azure Synapse, or other cloud-based SQL services Development Tools & Methodologies: - Essential: SQL Server Management Studio (SSMS), Data Tools, version control (Git) - Preferred: Azure Data Studio, DevOps pipelines for database deployment Data & Analytics: - Essential: Knowledge of data modeling, normalization, and relational database best practices - Preferred: Experience with data lakes, BI tools (Power BI), or analytics integrations Experience Requirements - Minimum of 3+ years of hands-on experience developing, optimizing, and supporting SQL Server databases in enterprise environments - Proven experience designing complex queries, stored procedures, and database schemas for high-availability systems - Demonstrated success in performance tuning, query optimization, and indexing strategies - Experience working with cross-functional teams including developers, analysts, and data engineers - Industry experience in finance, healthcare, or large-scale enterprise systems is desirable; other data-driven industries also acceptable Day-to-Day Activities - Develop and optimize SQL queries, stored procedures, and scripts to support application data needs - Collaborate with developers, data engineers, and analysts to design database schemas and data models - Monitor database performance, resolve bottlenecks, and implement indexing or query improvements - Support data integration activities and data quality initiatives - Participate in code reviews, deployment planning, and performance testing - Document database architectures, processes, and best practices for team use - Evaluate new database tools and techniques to improve efficiency and scalability - Troubleshoot and resolve data issues impacting system performance or reporting Qualifications - Bachelor's degree in Computer Science, Information Technology, Engineering, or related fields; Master's degree preferred - Relevant certifications such as Microsoft Certified: Azure Data Engineer, or equivalent, are advantageous - Proven experience managing enterprise-level SQL Server databases and supporting data operations Professional Competencies - Strong analytical and problem-solving skills for diagnosing complex database issues - Excellent communication skills for collaborating with technical teams and non-technical stakeholders - Ability to work independently, manage multiple priorities, and deliver results on time - Proactive attitude towards learning new data technologies and continuous process improvement - Attention to detail and a focus on delivering reliable and optimized database solutions S YNECHRON'S DIVERSITY & INCLUSION STATEMENT Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative Same Difference is committed to fostering an inclusive culture promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more. All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant's gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law. Candidate Application Notice