Sql Server Maintenance

MasthanBabu

Mobile: + ** -901******* Email: **************@*****.***

OBJECTIVE:

As a ERP Application Support and SQL DBA Support looking for challenging SQL server And ERP Applications roles in the space to utilize my technical expertise and leadership skills in full potential. TECHNICAL SKILLS:

Having 3+ Years of experience as SQL Server DBA. Exploring new version and using current version features wherever applicable as per client requirement.

Experience in Administration of SQL Server 2005, 2008, 2008R2, 2012, 2017 and 2019 (Installations, Back- ups & Restore, security, Log shipping, Database Mirroring, Replication (Transaction replication), Cluster and Always on.

Experience on Installing, configuring, monitoring and troubleshooting SQL Server. Experience in Applying Service Packs, Cumulative Updates and hot fixes to SQL Server 2008, 2008R2 and 2012, 2016, & 2017.

Have experience in Creating Logins and Users and managing Roles and User permissions. Have experience on solving Orphan User issues.

Experience on Page level restore, Point-in-time Restore & piecemeal restore. Experience on purging data and Archiving data in large databases as per the client requests. Have Experience in scheduling Alerts, Jobs, Maintenance plan and Configuring DB Mail. Have experience in configuring SQL Server Alerts for Disk space, Log file space, Backups, CPU. Experience in Configuring and troubleshooting disaster recovery feature Log Shipping and Replication. Experience in configuring Database Mirroring and Providing load balancing option by creating Snapshots Experience on Configuring and Troubleshooting High availability feature like SQL Clustering Experience on Configuring and Troubleshooting Always On Availability Group. Experience in identifying and troubleshooting of blockings and deadlock issues. Knowledge on identifying and troubleshooting of performance bottle necks like memory usage, CPU Utiliza- tion, Disk I/O and User connections.

Have experience on solving Fragmentation by performing Rebuild and Reorganize Indexes on tables. Have Experience in Upgrade (in place/ Side by side) and Migration activity from SQL server 2005 to SQL server 2012 and 2012 to 2016.

Provided after hours and 24/7 database maintenance and Production on call support. Closing the tickets with in the SLA time and Monitoring the SLA. Ability to effectively multitask, meet deadlines, quickly adapt to different project environments and ability to work with different team sizes across geographical locations. ACADEMIC:

MCA (Master of Computer Application) from Jawaharlal Nehru Technological University Kakinada in 2016. CERTIFICATION:

MS SQL : MCP, MCSA (2012&2014)

PROFESSIONAL EXPERIENCE:

Working Currently as MS SQL DBA From HCL TECHNOLOGY at May -20-2019 to till date. Worked as MS SQL Server DBA From METROINFRASYS PVT LTD at April – 2017 to May-2019. TECHNICAL SKILLS:

RDBMS Packages : MS SQL Server 2005, 2008, 2008R2, 2012, 2014, 2016,2017&2019. Operating Systems : Windows server 2012, 2008R2/2008, 2016. Tools : SNOW, SCOM & TSM, Red-gate

Applications : Symphony, ERP Applications (AXIS, CPOS, POS) & IBM Filenet. PROJECT:

Project name : National Informatics Centre Services Inc. Role : Database Administrator

Duration : June 2019 to till date

Team Size : 04

Client : National Informatics Centre Services Inc. Operating System : Windows 2008R2/2012R2/2016

RDBMS : SQL Server 2005/2008R2/2012,2014,2016,2017& 2019. Tolls : Snow, TSM & SCOM

DESCRIPTION:

National Informatics Centre Services Inc. (NICSI) was established in 1995 as a section-25 company under National In - formatics Centre, Ministry of Communications &Information Technology, Government of India for providing and procuring IT solutions for multiple e-governance projects undertaken by NIC, Deity, Governments and Government Or - ganizations (like Public Sector Undertakings).

With a turnover of more than Rs. 902.45 crore, NICSI is a leading IT company with a government facing focus and more than 17 years of experience in assisting government organizations by providing state of art and cost effective so- lutions for all their growing ICT needs. These solutions are delivered through purchase of products and services from high quality vendors, empanelled with NICSI. NICSI’s procurement processes are fully compliant with GFR rules of Gov - ernment of India

RESPONSIBILITIES:

Involving in Installation, Configuring and Maintenance of SQL Server Instances. Applying Service Packs and Hot fixes.

Migration of databases from SQL Server 2008 to SQL Server 2014 and 2014 to 2016, Maintained 2000+ databases in size 2GB to TB’s.

Troubleshoot various problems that arise in day-to-day work and fix the issues. Creating Logins and user as per application team request. Providing Security by giving access permission to users at various levels. Fixing Orphaned User Issues.

Identifying, Analyzing and Resolving performance issues of the server. As per user request working on database refreshment and restorations. Dealt space issues such as TEMPDB full, Log file full, Data file full. Reorganize and Rebuild Indexes as per Application team request. Verified Database consistency using DBCC commands. Creating the maintenance plans for weekly maintenance of databases. Scheduling and maintaining Maintenance plans, Jobs and Alerts.

Maintaining the Database Consistency with DBCC commands and use DMV’s to monitor the database health at regular intervals.

Creation of Logins, Users and Granting rights, Assigning Permissions and Mapping user databases. Reviewing SQL Server and SQL Server Agent Error Logs. Monitoring and Troubleshooting Log Shipping, Mirroring & Replication. Dealt with Blockings, Locks & Deadlocks effectively in high time. Adding more Data files for a database as per client request. Monitor and Troubleshooting like Cluster and always on. Good Team player and ensuring for the client satisfaction by achieving the targets on time based on the SLA as a team and personal.

Provided after shift hours and 24/7 database maintenance and Production support to Client and users. PROJECT:

Project name : LVP Eye Institute

Role : ERP Executive

Duration : April 2017 to May 2019

Client : LV Prasad Eye Institutions

Operating System : Windows 2008R2/2012R2

RDBMS : SQL Server 2005/2008R2/2012

Tools : SNOW & Red-gate

Applications : Symphony, CPOS & Axis

DESCRIPTION:

LVPEI's community outreach program began in May 1998, with the aim of making high-quality, appropriate eye care accessible to all. GPR ICARE focuses on both the geographically removed as well as the economically disadvan- taged groups.

To develop high quality self-sustaining eye care services in neglected areas of India and other parts of the developing world

To train all cadres of eye care personnel for the provision of and efficient eye care services

To participate in planning eye health initiatives in the developing world RESPONSIBILITIES:

Involving in Installation, Configuring and Maintenance of SQL Server Instances. Applying Service Packs and Hot fixes.

Creating Logins and user as per application team request. Providing Security by giving access permission to users at various levels. Troubleshooting various problems that arise in a day-to-day work and fix the issues. As per user request working on database refreshment. Identifying, Analyzing and Resolving performance issues of the server. Deal space issues such as TEMPDB full, Log file full, Data file full. Migration of databases from SQL Server 2005 to SQL Server 2008R2/2012. Troubleshoot various problems that arise in day-to-day work and fix the issues. Monitoring and Troubleshooting Log Shipping, Mirroring & Replication. Monitoring and Troubleshooting Always on and cluster Verified Database consistency using DBCC commands. Planning & Performing Backups and Restoring of the databases. Adding new databases to availability groups, creating new Availability groups for new Databases and configuring backup preferences as per requirements.

Managing Transaction log and Data file size growth and shirking of databases Managing Backup and disk Space issues(Mdf full, Ldf full & Temp db full) Scheduling and maintaining Maintenance plans, Jobs and Alerts. Reorganize and Rebuild Indexes as per Application team request. Fixing Orphaned User Issues.

Reviewing SQL Server and SQL Server Agent Error Logs. Monitoring and Troubleshooting Log Shipping.

Deal with Blockings, Locks & Deadlocks effectively in high time. Prepare the recommendations sheet for L&R for stock update details in CPOS. Clear the PO,DC & invoice related issues.

Maintain the stock related information and provide the required team Create Discounts schemes as per the client requests. Clear the POS related issues like DC retrieve and DC scanning issues. Create and add new locations and location ids in CPOS as per client request Removing purge data in database as per the user request. Maintain the load balance in CPOS servers.

Maintain database health reports and daily sales report. Restoring db’s from prod to test environment

Sorting and Run the L&R day-to-day work for sales figures and stock figures.

[MasthanBabu J]

Place : Chennai

Contact this candidate