Sr. SQL Developer

As a skilled Senior SQL Developer with over 4 years of experience, your role will involve designing, developing, and supporting relational databases. You will be working with MS SQL Server 2008 and above, managing large-scale databases, and optimizing database performance in production and development environments. Key Responsibilities: - Design, develop, and maintain relational databases while ensuring data integrity through normalization, denormalization, and referential integrity. - Write and optimize complex Transact-SQL (T-SQL) queries, stored procedures, functions, views, and triggers. - Implement business logic and workflows using advanced database objects and indexing strategies. - Develop, deploy, and maintain SSIS packages for ETL processes, data transformation, and migration workloads. - Perform query tuning, index tuning, and overall database performance optimization using DMVs, execution plans, and best practices. - Utilize SQL Server Management Studio (SSMS), SSIS, and SSRS for database development, reporting, and integration tasks. - Manage data migration and transformation using Bulk Copy Program (BCP), Data Transformation Services (DTS), and conversion from legacy systems. - Collaborate closely with .NET developers, offering guidance on SQL query best practices and troubleshooting. - Handle large-scale user databases, applying partitioning and other techniques for scalability and performance. - Create and maintain technical documentation, and assist in presentations and knowledge sharing within the team. Qualifications: - 4+ years of experience with MS SQL Server 2008 and above. - Strong knowledge of database design principles including normalization, denormalization, and referential integrity. - Expertise in T-SQL (DDL, DML, DCL), transaction isolation levels, and advanced query writing including window functions. - Experience with XML data types and indexing strategies. - Hands-on experience designing and deploying SSIS packages and working with SSRS. - Proven skills in query tuning, index tuning, and database performance optimization. - Familiarity with ETL processes and data migration tools like BCP and DTS. - Experience managing large databases and applying horizontal partitioning. - Excellent analytical, problem-solving, communication, and interpersonal skills. - Ability to work collaboratively in a team environment and guide junior developers.,