Sourav Kumar Email & Phone Number

Singapore

Kolkata, West Bengal, India

Pune, Maharashtra, India

Bengaluru, Karnataka, India

- Worked as, a Technical Leader at Voya India, previously known as VFISLK Software.- Leading a team of 7-8 members, responsible for handling critical projects and providing technical guidance.- Improved response time by implementing efficient processes and optimizing performance of queries and databases.- Implementing security models with role hierarchy and minimum privileges, ensuring data integrity and confidentiality,building CICD pipelines by using Streams and Tasks.- Managing warehouse creation and sizing based on performance requirements.Providing technical support, resolved ad-hoc requests, and ensured smooth operations of critical production databases.Achievements: - Successfully optimized team size from 15 members to a more efficient model of 7 members (4 technical experts and 3 junior members), resulting in a cost reduction of ~35%.- Automated scripting and deployment processes, reducing the time required for database creation from ~4 hours to ~40 minutes.

Bengaluru, Karnataka, India

- Worked as, a Technical Leader at Voya India, previously known as VFISLK Software.- Leading a team of 7-8 members, responsible for handling critical projects and providing technical guidance.- Improved response time by implementing efficient processes and optimizing performance of queries and databases.- Implementing security models with role hierarchy and minimum privileges, ensuring data integrity and confidentiality,building CICD pipelines by using Streams and Tasks.- Managing warehouse creation and sizing based on performance requirements.Providing technical support, resolved ad-hoc requests, and ensured smooth operations of critical production databases.Achievements: - Successfully optimized team size from 15 members to a more efficient model of 7 members (4 technical experts and 3 junior members), resulting in a cost reduction of ~35%.- Automated scripting and deployment processes, reducing the time required for database creation from ~4 hours to ~40 minutes.

Hyderabad, Telangana, India

- Worked as a Snowflake Administrator for 5 years, managing critical production databases for multinational clients.- Expertise in creating database objects, interpreting logs, configuring clusters, managing user accounts, integrating with web servers, and providing technical support.- Played a key role in the successful migration of applications to the Snowflake environment, resulting in improved performance and scalability.- Collaborated with clients to understand requirements and provide effective solutions, ensuring customer satisfaction.- Developed and deployed database objects, performed data copy operations, and managed user roles and access permissions.- Utilized continuous data protection features, such as time travel and zero copy cloning, to enhance data availability and recovery.- Conducted performance management activities, including query profiling and clustering, to optimize database performance.- Analyzed historic data using information schema and account usage, providing valuable insights for decision-making.- Implemented security models with role hierarchy and minimum privileges, ensuring data integrity and confidentiality.Played a key role in warehouse creation and sizing based on performance requirements.

Hyderabad, Telangana, India

- As a DataStage ETL Developer my work is to extract data from DB2 environment and then after transform and load that data was loaded in the MemSQL environment.- Preparing DataStage Jobs for different tables which used to transform data through different stages and then loading into MemSQL Database.- For multiple loading Jobs there were multiple JIL files to run those DataStage Jobs through Autosys in a batch. Autosys is a automated service. So preparing Jil files for particular DataStage Jobs.

Mumbai, Maharashtra, India

- Managed and created Oracle databases.- Created and administrated database objects like table, views, indexes, etc.- Involved in user account management: creating users, disabling users, responsibility management.- Monitored the scheduled backups and referred the backups in case of failures.- Created table spaces, users and roles for test environment.- Performed logical backup using exports & imports utilities.- Involved in monitoring &managing the data files growth.- Troubleshot oracle errors.- Documented all DB Changes.- Involved in the enhancement implementation by doing impact analysis, design, development and testing.- Interacted with the end customer for addressing the clarifications and issues raised

Bachelor Of Technology (B.Tech.), Computer Science And Engineering

I completed my 4 years engineering course here.

Heigher Secondary Board, Science