About this role
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.
Tired of cold applications?
Sign up with Clera and we'll reach out the moment a role actually fits you — no more spraying applications into the void.
Know someone who'd be great for this?