Sravan Kumar S.

Sravan Kumar S.

Technical Lead

Hyderabad , India

Experience: 6 Years

Sravan Kumar

Hyderabad , India

Technical Lead

21766.9 USD / Year

  • Notice Period: Days

6 Years

Now you can Instantly Chat with Sravan Kumar!

About Me

Seeking better opportunity where I can utilize my skills and capabilities having professional qualificationand work experience.Having total 12.6 years of experience as a Technical Lead.8 years of experience in database migration from on premises SQL ...

Show More

Portfolio Projects

Description

Responsible for checking daily live issues and create tickets.Deploying the merge change requests to production database servers.Checking the Mesh jobs by login into remote VM and check the files moved from in folder to out folder.Deploying Config excel sheets for updating the UAT database for patient registrar.Checking scheduled subscription mails to clients went daily and nothing failed.

Show More Show Less

Description

Support ETL SSIS jobs created by developer and executing for exporting data.Deploying changes in ETL server with SSIS packages and creating job with schedules.Deploying SQL scripts from Git repo changed folder to production and committing the changes to production.

Show More Show Less

https://Capsplus.CastandCrew.Com

Data migration from old legacy project to latest cloud using SSIS

Contribute

I am the primary person involved in data migration from old to new cloud hosting environment

Description

I am the primary person involved in data migration from old to new cloud hosting environment

Show More Show Less

Description

Responsible for creating SSRS reports based on clients request.Creating data sets by SQL queries and stored procedures and adding parameters to the reports.Deploying SSRS reports to reporting server by means of SSDT tool.Creating schedules to send SSRS reports to clients via emails.Creating and granting user permissions to view modify and download report server reports datasets and datasources.

Show More Show Less

Description

Responsible for complete maintenance of SQL Server 2012 Databases Daily checking the production database maintenance project Continua builds Monitoring the transactional log shipping from Continua builds Monitoring the daily full and transactional log backups from Continua builds Monitoring the daily Production Index Maintenance Builds from Continua builds Monitoring the daily Production Performance Maintenance Builds from Continua builds

Show More Show Less

Description

Responsible for complete maintenance of IIS Web site hosting and administration Daily checking the health of IIS server application pools. Monitoring the Application pool memory and logs. Deploying the code to IIS App server through VSTS Azure Devops tool. Creating Builds and Releases through VSTS Azure Devops. Merging the code from Trunk to master and creating branches for release Fixing deployment issues like timeouts and reinitiating the releases.

Show More Show Less

Description

Responsible for complete maintenance of IIS Web site hosting and administration Daily checking the health of IIS server application pools. Monitoring the Application pool memory and logs. Deploying the code to IIS App server through VSTS Azure Devops tool. Creating Builds and Releases through VSTS Azure Devops. Merging the code from Trunk to master and creating branches for release Fixing deployment issues like timeouts and reinitiating the releases.

Show More Show Less

Description

Responsible for complete application and maintenance of AWS RDS SQL Server 2012 Databases Migration Lajit companies data into CAPS PLUS multi-tenant application with the help of SSIS package Handling orphan data of Lajit to migrate into CAPS PLUS with SQL insert query in SSIS package dataflow tasks Refreshing CAPS PLUS PROD data in to CAPS PLUS UAT and CAPS PLUS PRE-PROD environments using VSTS(Visual Studio Team Services) On demand prod backup build and refresh Preprod data release build

Show More Show Less

https://Www.Capspayroll.Com

Data migration from old legacy project to latest cloud using SSIS

Contribute

Have worked in support role

Description

Lajit Accounting Software is used for creating budgets of events projects and reporting costs for work hours

Show More Show Less

Www.pharmaertrack.com

Making the daily db refresh from Dev to production

Contribute

Database Administrator implemented monitoring for replication for sql servers through powershell

Description

Pharma Etrack is a clinical health domain mainly focused on information regarding latest trends in pharma health latest research works are gathered and updated in the pharma dashboard tool

Show More Show Less

Description

Responsible for complete maintenance of SQL Server 2008 databases Managed daily production, stage and qa environment database backups Automated messaging services on server failures for task completion and success Daily checking the issues like backup failures and resolve the issues Monitoring the tempdb full and transactional log full issues Implementation and maintaining of replication Maintain database consistency check using DBCC commands Performing database Health checkups Participation in weekend reviews with team members Working as part of a team and provide 24x7 support when required

Show More Show Less