Senior SQL Server Developer
Core SQL Server Expertise10+ years of hands-on experience in Microsoft SQL Server development and database administration support.Strong expertise in T-SQL programming and database design.Advanced knowledge of relational database concepts, normalization, and data modelling.Developing complex Stored Procedures, Functions, Views, and Triggers from scratch.Writing highly optimized T-SQL code for large-scale enterprise applications.Expertise in temporary tables, table variables, CTEs, cursors, and windowing functions.ETL DevelopmentStrong hands-on experience in ETL design, development, deployment, and support.Extensive experience using SQL Server Integration Services (SSIS). Building complex SSIS packages for data extraction, transformation, and loading.Working with multiple data sources including SQL Server, Oracle, Flat Files, Excel, XML, and APIs.Performance Tuning & OptimizationExpert in SQL Performance Tuning and Query Optimization.Identifying and resolving blocking, deadlocks, and long-running queries.Execution Plan analysis and query optimization.Index analysis, creation, maintenance, and optimization including Partitioning strategies for large databases.Database MaintenanceBackup and Recovery strategy management.Database integrity checks and consistency validation.Index rebuild and reorganize strategies.Disaster Recovery and High Availability support.Troubleshooting & Production SupportRoot cause analysis of database performance issues.Production incident management and resolution.Query tuning in mission-critical environments.Database monitoring and proactive issue identification.Release deployment and post-production validation.Soft SkillsRequirement gathering and solution design.Technical mentoring and code reviews.Stakeholder communication.Documentation and knowledge transfer.Agile/Scrum development methodologies.Senior Microsoft SQL Server Developer with 10+ years of experience in database development, ETL solutions, performance tuning, and production support. Expertise in designing and developing complex stored procedures, SSIS packages, SQL Server Agent Jobs, and high-performance database solutions. Proven experience in query optimization, database maintenance, data warehousing, and troubleshooting mission-critical applications within enterprise environments.Strong SQL Server development experienceGood knowledge of T-SQL, stored procedures, functions, views and triggersExperience with query optimisation and performance tuningStrong understanding of database design, indexing and execution plansExperience working with large-volume databasesGood understanding of SQL Server Always On / high-availability conceptsExperience with ETL/data migration would be an advantageAbility to troubleshoot complex SQL and database-related issuesGood understanding of database security and access managementExperience working within an Agile development environment