Hi, I’m
Shivanshu Srivastava
Database Engineer
Gurgaon
Summary
Enthusiastic Data Professional well-versed in designing and optimizing data systems to address dynamic data needs of the organization. Eager to assume ownership and take on added responsibilities to drive team success.
Overview
7
years of professional experience
Work History
SCA Technologies
Technical Lead - Database
10.2022 - Current
Job overview
- Worked with team of business analysts to understand new requirements and led technical design discussions for the same.
- Took charge of any intermediate discussions and proactively coordinated with teams and team members as the development phase progressed further.
- Mentored junior developers through regular 1-on-1 meetings, providing guidance on best practices and coding standards.
- Instituted code review practices that fostered an environment of constructive feedback exchange among team members leading to better overall code quality and maintainability.
- Took up Root Cause Analysis of Production Bugs and used it to identify patterns to set up processes to improve application robustness.
SCA Technologies
Senior Database Engineer
11.2020 - 09.2022
Job overview
- Developed, debugged, tested code as per functionality and produced production-ready code.
- Troubleshooted Performance issues by refactoring existing SQL queries, indexing, identifying and correcting underlying legacy design issues.
- Performed comprehensive database health checks, identifying areas of improvement for optimal performance.
- Developed custom SQL scripts for complex reporting requirements and analytical needs.
Infosys Ltd.
Senior Systems Engineer
04.2019 - 11.2020
Job overview
- Set up ETL workflows in Microsoft SSIS for data load into Data Warehouse from 20+ source systems.
- Configured alerting mechanisms for any failure in the data pipelines and debugged the source of error.
- Owned the data load at the data warehouse and in case of issues, reached out to multiple teams and aligned them for timely data load and report generation thereafter.
Infosys Ltd.
Systems Engineer
10.2017 - 03.2019
Job overview
- Troubleshooted data integration issues and closed them within the SLA.
- Drafted technical documents outlining data flows in different data pipelines for business stakeholders.
- Managed and monitored the data pipelines for highest level of availability.
Education
University of Petroleum And Energy StudiesDehradun
B.Tech from Petroleum Engineering
04.2001
University Overview
- Final Grade: 3.51/4 CGPA
- Program Coordinator at UPES SEG Student Chapter
Skills
Database Schema design
SQL Server T-SQL Development
SQL Server Performance Troubleshooting
Problem-solving aptitude
Issue investigation
Timeline
Technical Lead - Database
SCA Technologies
10.2022 - Current
Senior Database Engineer
SCA Technologies
11.2020 - 09.2022
Senior Systems Engineer
Infosys Ltd.
04.2019 - 11.2020
Systems Engineer
Infosys Ltd.
10.2017 - 03.2019
University of Petroleum And Energy Studies
B.Tech from Petroleum Engineering
04.2001