Sr SQL Server Developer

Core SQL Server Expertise

• 10+ 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 Development

• Strong 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 & Optimization

• Expert 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 Maintenance

• Backup and Recovery strategy management.
• Database integrity checks and consistency validation.
• Index rebuild and reorganize strategies.
• Disaster Recovery and High Availability support.

Troubleshooting & Production Support

• Root 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 Skills

• Requirement gathering and solution design.
• Technical mentoring and code reviews.
• Stakeholder communication.
• Documentation and knowledge transfer.
• Agile/Scrum development methodologies.

Disclaimer: This job posting and Location 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.