Pravin Gupta

Software Engineer

Mphasis•  October 2021 - Present

Design, develop, and implement MS SQL Server SSIS ETL jobs to effectively process high-volume data sources. Designed and developed SSIS packages to move data from various sources into destination flat files and databases. Troubleshoot previous SSIS packages to solve issues Performance tuning existing scripts and processes Manage SQL Server databases. Configure and maintain database servers and processes. Monitor system's health and performance. Incident/Change/Problem Management using Service Now (SNOW) and JIRA. Responsible for 24/7 production technical support. Perform scheduled maintenance and support release deployment activities after hours. Tested troubleshooting methods and documented resolutions for inclusion in the knowledge base for support team use.