SQL SERVER DATABASE ADMINISTRATOR

JAGAN MOHAN

Mailid:adl36c@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,2019 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.

•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 Anantapur in the stream of Computer’s.

Work Experience

Currently working in PFMS from July 2020 to till date.

Previously worked in HUL from May2016 to June 2020.

Previously worked in ExxonMobil from May 2014 to Apr 2016.

Technical Skills

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

Tools : Profiler, Data Tuning Advisor.

Operating System : Windows Server 2003/2008/2012.

Project:3

Company : PFMS.

Title : DBA 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.

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 : Senior 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.

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: 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