Sr DB developer

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).

#LI- Hybrid #LI-GK1

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.