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 MoreSkills
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 LessDescription
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 LessDescription
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