SQL SERVER DATABASE ADMINISTRATOR

JAGAN MOHAN

Mailid:adsxts@r.postjobfree.com

Mobile: +91-849*******

Summary

•Having total 6+years of experience in IT and working as a MS SQL Server Database Administrator for Production, Development and Test Environments.

•Experience in Installation and Configuration of MS SQL Server 2008R2, 2012, 2014, 2016, 2017 and applying Service packs\Hot fixes.

•Good Experience in migration of SQL servers from lower to higher version.

•Hands on experience in DBA activities like SQL Server Maintenance, Database health check, Disk Space management, Security Issues, Database Backup and Recovery, RPO and RTO.

•Have good experience in implementation of HA\DR solutions like Log Shipping, Database Mirroring, SQL Clustering and Alwayson High Availability.

•Experience in implementing Snapshot and Transactional Replication models.

•Experience in implementation of Distributed Alwayson in 2019 SQL Server.

•Experience in creating and scheduling Jobs, Alerts and setting Notifications.

•Good experience in setting up Backups strategies based on business requirement and recovering the data in case of database crash or failure.

•Experience in Configuring Maintenance jobs for Clean-up History, Update Statistics, Index Reorganizing\Rebuilding, and Database Integrity.

• Experience in User databases and moving System databases from one disk to another as well as one Server to another.

•Experience in implementation of SQL Server security and Object permissions like maintaining, creation, configuring permissions and assigning roles to users.

•Good experience in Identifying and Troubleshooting of database related problems by using System Tables, DBCC commands, DMV’s and Third party monitoring tools.

•Experience in identifying and troubleshooting of Locking, Blocking, and Deadlock and CPU issues.

•Involved in defining a trace, specifying trace events, selecting data columns and managing traces using SQL Profiler.

•Experience in Creating and Acknowledging\Solving of Incidents\Tickets based on OLA\SLA, and creating based on requirement and Implementing of Changes.

•Perform Server level tuning, performance monitoring, Index Tuning, Query Tuning.

•Well experience in ITIL process and compatible in Team environment.

•Hands on experience in database refresh.

•Experience in 24x7 Production support.

Education

•Graduated from JNTU Ananthapur in the stream of Computer’s.

Work Experience

•Currently working in CIPL from July 2020 to till date.

•Previously worked in HUL from July 2018 to June 2020.

•Previously worked in ExxonMobil from July 2016 to June 2018.

Technical Skills

•RDBMS : SQL Server2008 R2/2012/2014/2016/2017

•Tools : Profiler, Data Tuning Advisor.

Project:3

Company : CIPL.

Title : Data Base Administrator.

Responsibilities

•Day-to-Day administration of live Production SQL servers.

•Handling Incidents and implementing of Changes as per the direction of team lead.

•Performing proactive monitoring daily for Production servers and correcting if any abnormal issues based on the priority.

•Installations of SQL server 2008, 2008R2, 2012, 2014and2016 apply patches and perform post installations.

•Perform database refresh regularly and perform post migration steps.

•Creating Logins, Users and Roles, and giving required permissions to them and troubleshooting of database connectivity problems.

•Defining the best database backup strategies and suggest to application team on recovery models for databases to resolve log file related issues especially on production servers.

•Troubleshooting of Disk Space, Tempdb, Data file and Log file related issues.

•Configuring high availability solutions Log Shipping and Mirroring, and Troubleshooting of Log Shipping and Mirroring related errors.

•Deploying Integration Services and Reporting Services.

•As a part high availability and disaster recovery solutions, configured log shipping,

Database mirroring, SQL clustering, Always on and Replication.

•Identifying databases growth and performing data purging or increasing size of the disks.

•Monitoring and troubleshooting of Fragmentation levels, Blocking, Deadlocks, CPU and Memory related problems.

•Regular checking of the database consistency using DBCC commands.

•Back up master & system databases and restoring them when necessary

•Providing week end On-Call support as a Primary\Secondary on rotation basis.

•Refreshing databases as per client request.

Project: 2

•Company : Hindustan Unilever Limited (HUL).

•Title : Associate Software Engineer.

Responsibilities

•Day-to-Day administration of live Production SQL servers.

•Handling Incidents and implementing of Changes as per the direction of team lead.

•Performing proactive monitoring daily for Production servers and correcting if any abnormal issues based on the priority.

•Installations of SQL server 2008, 2008R2, 2012, 2014and2016 apply patches and perform post installations.

•Perform database refresh regularly and perform post migration steps.

•Creating Logins, Users and Roles, and giving required permissions to them and troubleshooting of database connectivity problems.

•Troubleshooting of Disk Space, Tempdb, Data file and Log file related issues.

•Defining the best database backup strategies and suggest to application team on recovery models for databases to resolve log file related issues especially on production servers.

•Configuring high availability solutions Log Shipping and Mirroring and Troubleshooting of Log Shipping and Mirroring related errors.

•Deploying Integration Services and Reporting Services.

•As a part high availability and disaster recovery solutions, configured log shipping,

Database mirroring, SQL clustering, Always on and Replication.

•Identifying databases growth and performing data purging or increasing size of the disks.

•Monitoring and troubleshooting of Fragmentation levels, Blocking, Deadlocks, CPU and Memory related problems.

•Regular checking of the database consistency using DBCC commands.

•Back up master & system databases and restoring them when necessary

•Providing week end On-Call support as a Primary\Secondary on rotation basis.

•Refreshing databases as per client request.

Project: 1

•Company : ExxonMobil.

•Title : Associate Software Engineer.

Responsibilities

•Installing SQL Server 2005, 2008R2, 2012 and 2014.

•Creating databases as per Client requirement

•Providing day to day support and maintenance of SQL Server databases and services

•Creation of users and assigning roles to the users.

•Providing Security by giving access permission to users at various levels

•Responsible for space allocation and backup strategies.

•Checking the status of Backups and Restoration of databases.

•Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

•Ensuring high availability of the database by exploiting the concepts of log shipping and database mirroring.

•Monitoring disk spaces, Log space issues.

•Creating and scheduling jobs, migrate the databases from SQL Server 2005 to 2008R2.

•Troubleshooting the failed jobs-based alerts.

•Setting up maintenance plans for daily backup, rebuild, reorganizing and update statistics.

•Monitoring the database mirroring and Log Shipping.

•Trouble shooting blocking, space issues.

•Responsible for Refreshing databases as per client request.

Contact this candidate