Job DescriptionExperienced Senior MS SQL Database Developer with 3-5 years of expertise in designing, developing, and optimizing complex database solutions. Adept at performance tuning, data modelling, and managing enterprise-scale databases. Strong analytical thinker with excellent problem-solving skills and a proven ability to lead database teams, mentor junior developers, and collaborate with cross-functional stakeholders.What are we looking for in you?Database Development: MS SQL Server (2012/2014/2016/2019)Programming & Scripting: T-SQL, Stored Procedures, Functions, TriggersDatabase Optimization: Indexing, Query Performance Tuning, Execution PlansETL & Data Integration: SSIS, Bulk Data Load, CDC, ReplicationReporting & BI: SSRS, Power BI, Data WarehousingCloud & Automation: Azure SQL Database, Automation using PowerShellSecurity & Compliance: Role-Based Access, Encryption, GDPR, HIPAATeam & Project Management: Agile/Scrum methodologies, Mentoring Junior Developers, Stakeholder CommunicationComplex DBA Tasks: High Availability (HA), Disaster Recovery (DR), Clustering, Always On Availability GroupsProblem Solving & Analytical Thinking: Root Cause Analysis, Troubleshooting Database Bottlenecks, Performance Tuning StrategiesRequirementsDesign and develop high-performance SQL databases with optimized indexing and partitioning strategies.Write and optimize complex T-SQL queries, stored procedures, and triggers for maximum efficiency.Perform query tuning, indexing strategies, and execution plan analysis to improve performance.Develop ETL pipelines using SSIS to extract, transform, and load data from various sources.Implement database security measures including encryption, role-based access control, and compliance with industry standards.Work closely with developers, business analysts, and leadership to support application development and data analytics needs.Lead database development teams, mentor junior developers, and provide technical guidance on SQL best practices.Manage database deployments, upgrades, and maintenance, ensuring high availability, disaster recovery, and business continuity.Solve complex database performance and scalability issues using deep analytical and problem-solving skills.Automate database tasks using PowerShell and other scripting tools to improve efficiency.