Now you can Instantly Chat with Vilasagaram!
About Me
Having 6.7 years of experience into SQL Server 2008, SQL Server 2012 and SQL Server 2016 database administration and SSIS Package development and deployment. Experience in databases creation, backup and restoration with different recovery models. Imp...
Show MoreSkills
Positions
Portfolio Projects
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 LessDescription
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 LessDescription
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 LessDescription
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 LessContribute
Database Administrator implemented monitoring for replication for sql servers through powershell
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