Hello, I'm

Yash Srivastava

Senior SQL Database Developer

Specializing in MS SQL Server, T-SQL scripting, advanced query performance optimization, and scalable schema design with over 5 years of hands-on expertise.

View Projects Get in Touch

About Me

I am a results-driven SQL Database Developer based in Noida, India, possessing over 5 years of professional experience building, scaling, and fine-tuning robust backend database architectures. My core competencies center around MS SQL Server and MySQL, T-SQL scripting, execution plan analysis, custom indexing strategies, and complex query optimization.

Beyond enterprise data layers, I bring a practical, hands-on approach to system engineering—ranging from advanced structural schema design to exploring modern interactive web interfaces. I thrive on translating complex performance bottlenecks into lightning-fast, highly optimized data pipelines.

Location: Noida, India
Experience: 5+ Years
Industry: Database Engineering & Software Development
Email: yash.srivastava@example.com

Professional Experience

2021 – Present

Senior SQL Database Developer

Enterprise Data Solutions

Noida, India

  • Architected, developed, and maintained complex T-SQL scripts, stored procedures, triggers, and user-defined functions for high-volume database operations.
  • Analyzed graphical execution plans to diagnose performance degradations, implementing strategic index designs and query refactoring to slash execution time.
  • Managed database schema constraints, foreign key relationships, and automated maintenance workflows to maintain absolute data integrity.
  • Collaborated closely with software engineering teams to align backend storage models with frontend application performance parameters.
MS SQL Server T-SQL Performance Tuning Indexing Stored Procedures
2019 – 2021

Database Developer

TechCore Systems

Noida, India

  • Designed normalized relational database schemas and implemented safe update routines and window functions in MySQL and SQL Server environments.
  • Optimized large legacy data queries involving Common Table Expressions (CTEs) and deduplication routines.
  • Authored comprehensive technical documentation for data migrations, schema updates, and routine backup protocols.
MySQL MS SQL Server CTEs Data Validation

Technical Expertise

Database Technologies

MS SQL Server MySQL Relational Schemas Database Design

Scripting & Querying

T-SQL Stored Procedures Window Functions CTEs Triggers

Performance & Tuning

Execution Plans Query Optimization Indexing Strategies Data Validation

Tools & Software

MySQL Workbench SQL Server Management Studio (SSMS) Git

Key Projects

Enterprise Query Optimization Suite

Addressed severe report-generation bottlenecks caused by unoptimized legacy queries scanning millions of historical transaction rows.

My Role: Lead Database Developer

Impact: Reduced average query execution runtime by 68% across critical end-of-month reporting procedures.

MS SQL Server T-SQL Execution Plans Indexing

Automated Data Deduplication Pipeline

Developed a secure backend pipeline utilizing Common Table Expressions (CTEs) and window functions to identify and purge redundant user records safely.

My Role: Backend Developer

Impact: Improved overall database storage efficiency and eliminated data anomaly errors in downstream user analytics.

MySQL CTEs Window Functions Data Integrity

Education

Computer Software Application (CSA) Trade

National Skill Training Institute (NSTI)

Technical Training & Certification

Focused on core computer software engineering principles, system architecture, and application development workflows.

Get In Touch

I am currently open to senior database development and engineering opportunities. Feel free to reach out via email or connect on LinkedIn.

yash.srivastava@example.com LinkedIn Profile GitHub Profile