02 Sep
|
Numerator
|
India
Core SQL Server Expertise
* 10+ years of hands-on experience in Microsoft SQL Server development and database administration support.
* Solid 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.
📌 Senior SQL Server Developer (India)
🏢 Numerator
📍 India