The role involves developing and maintaining complex SQL Server databases, including stored procedures, ETL packages, and performance optimization. You will also provide production support, manage database integrity, and mentor team members on technical best practices.
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.
“I was the first applicant for a remote marketing position that got listed on the company website the same day I applied. Had an interview within 48 hours!”
— Sarah J.
·
Marketing Manager
★★★★★
Verified
