Sr DB developer

Job Description

About the Role: We are looking for a Senior Database Developer with 7 to 8 years of hands-on experience designing, developing, and optimizing SQL Server database systems. The ideal candidate will specialize in complex T-SQL development, stored procedure design, query performance tuning, and SSIS package maintenance to ensure optimal performance, data integrity, and reliability across our enterprise platforms.

Core Technologies

• SQL Server / T-SQL, Stored Procedures, Performance Tuning, SSIS, SSRS

Key Responsibilities

• T-SQL & Stored Procedure Development: Design, build, and maintain highly optimized stored procedures, complex queries, functions, triggers, and database views to support business applications.
• Performance Tuning & Optimization: Analyze execution plans, indexes, locks, deadlocks, and query statistics to identify bottlenecks and optimize database performance.
• SSIS Development & Maintenance: Build, deploy, debug, and maintain complex SSIS (SQL Server Integration Services) packages for ETL data pipelines and integration tasks.
• Data Quality & Integrity: Implement database constraints, transaction handling, and error logging to ensure data consistency and accuracy across systems.
• Database Architecture & Support: Collaborate with software engineering and analytics teams to design scalable schema architectures, perform code reviews, and support production database deployments.
• Reporting (Advantage): Design, develop, and update reports using SSRS (SQL Server Reporting Services) to support operational and analytical business needs.

Required Skills & Qualifications

• 7–8 years of dedicated experience as a SQL Server / Database Developer.
• Expert-level proficiency in T-SQL, including advanced stored procedure logic, dynamic SQL, CTEs, and window functions.
• Deep expertise in database performance tuning (Index tuning, Execution Plan analysis, Profiler/Extended Events, Query Store).
• Strong hands-on experience with SSIS ETL packages (development, configuration, scheduling, error handling, and maintenance).
• Solid understanding of relational database concepts, normalization, dimensional modeling, and database security best practices.
• Strong problem-solving, troubleshooting, and analytical skills for debugging production database issues.

Preferred / Added Advantages

• Experience developing and supporting SSRS reports.
• Exposure to database deployment automation (CI/CD tools, Azure DevOps, or SQL Server Data Tools / SSDT).
• Familiarity with cloud database platforms (Azure SQL Database, AWS RDS). Hybrid