![As a Database Consultant performed various activities not limited to
Operating System(s) : Windows 2003 , 2008 ,2008 R2 and 2012 Servers
Database: MS SQL Server 2000 ,2005, 2008 R2 , 2012 , 2014, 2016
Managing servers of Microsoft , General Electric Corporate ,GE Power ,GE Oil
& Gas, Transportation , GE Health care servers (more than 400 servers ) ,
databases ranging from 1 GB to 5 TB size.
I was responsible for end-to-end delivery and Production support (24x7) globally for 50+
mission critical revenue related Applications. These are very high business impacting,
Incident Management Tools that include Enterprise Work Surface , MS-Solve [Built on MS
Dynamic CRM], Clarify (Amdocs), kronos, smartsignal, bwise and other critical
applications. Entire operation process has been adopted from Operational Framework and
ITIL for critical support and operational excellence. Goal is to make sure that the supported
systems have 99.999% availability
Responsibilities:
 Maintaining and managing servers owned by the team. These servers are
Windows 2003/2008/2012, SQL Server 2000 ,2005, 2008 R2 , 2012 , 2014, 2016
 Monitoring Clusters and troubleshooting Cluster Issues , Performing failovers
 Creating Databases and building Servers based on client requirements.
 Upgrading the service packs in stand alone servers , clusters.
 Migrating , upgrading sqlserver to higher versions.
 Deploying Application Builds
 Applying cumulative updates.
 Changing service account password in stand alone servers , clusters , cloud
servers
 Moving data to tapes
 Migrating data from Oracle to SQL servers
 Creating oracle and sql server linked servers
 Auditing SQL Server Security
 Setting up of disaster recovery servers.
 Trouble Shooting performance issues and fixing them.
 Analysing Hardware , Max memory and Min memory etc
 Analysing blockings , wait types , query execution plans , indexes
 Analysing IO Cost , cpu , memory
 Configured Always on in SQL Server 2012. Troubleshooting issues related to
always on. Performing Failovers in Always on for maintenance activities.
 Configuring Mirroring, replication, loghsipping, clustering setup between database
servers/instances.
 Running SQL Server profiler to troubleshoot the data issues reported by users.
 Providing and revoking access to users
 Creating and managing login , fixing login issues](https://image.slidesharecdn.com/5759fad6-5cd1-46d2-a94d-6435c3e0d2e8-161121142234/85/DBA-Trainer-RESUME-2-320.jpg)
DBA Trainer RESUME
- 1. RESUME Mohammed Arif 13-6-437/A/98/5/1 Khader Bagh,ToliChowki Hyderabad-500028, E-mail:arif.531531@gmail.com Telangana, India. :+917331142003 Professional Snapshot: I am Arif. I have worked for General Electric company for 3 years as a Lead consultant , solution architect and database administrator for SQL Server. Previously I have worked for Microsoft for 5 years. I am also a online trainer for SQL Server and provide efficient trainings and help trainees in building efficient resumes and provides continuous support to them. I live in Hyderabad, India. When I joined Microsoft Since then I have been supporting everything which comes under the umbrella of Microsoft technologies which includes SQL Server Database Engine, Windows servers, installation, uninstallation, setting up of new servers and new environments . Performance tuning, backup, restore, replication, log shipping, mirroring and my favorite AlwaysOn technologies and In-Memory OLTP , setting up of clusters , Upgrading servers , clusters , creating jobs for automating tasks , upgrading service packs etc. I have worked on toughest SQL Server related issues. I have worked with many customers to assist them in various issues. I also work as a freelancer for clients on SQL Server projects. Providing expert solutions to customer problems with best practices followed in the industry. Even worked on setting up of alerting systems like SCOM , HP's SITESCOPE. I have also expertize on Application support , Internet information services , SQL Azure , Window Azure , system administration. Along with providing training on all DBA concepts, I also focus on trainings on realtime topics and Realtime issues and their best solutions. Certifications: Microsoft Certified Solutions Expert (MCSE) Administering MicrosoftSQL Server 2012/2014 Databases
- 2. As a Database Consultant performed various activities not limited to Operating System(s) : Windows 2003 , 2008 ,2008 R2 and 2012 Servers Database: MS SQL Server 2000 ,2005, 2008 R2 , 2012 , 2014, 2016 Managing servers of Microsoft , General Electric Corporate ,GE Power ,GE Oil & Gas, Transportation , GE Health care servers (more than 400 servers ) , databases ranging from 1 GB to 5 TB size. I was responsible for end-to-end delivery and Production support (24x7) globally for 50+ mission critical revenue related Applications. These are very high business impacting, Incident Management Tools that include Enterprise Work Surface , MS-Solve [Built on MS Dynamic CRM], Clarify (Amdocs), kronos, smartsignal, bwise and other critical applications. Entire operation process has been adopted from Operational Framework and ITIL for critical support and operational excellence. Goal is to make sure that the supported systems have 99.999% availability Responsibilities:  Maintaining and managing servers owned by the team. These servers are Windows 2003/2008/2012, SQL Server 2000 ,2005, 2008 R2 , 2012 , 2014, 2016  Monitoring Clusters and troubleshooting Cluster Issues , Performing failovers  Creating Databases and building Servers based on client requirements.  Upgrading the service packs in stand alone servers , clusters.  Migrating , upgrading sqlserver to higher versions.  Deploying Application Builds  Applying cumulative updates.  Changing service account password in stand alone servers , clusters , cloud servers  Moving data to tapes  Migrating data from Oracle to SQL servers  Creating oracle and sql server linked servers  Auditing SQL Server Security  Setting up of disaster recovery servers.  Trouble Shooting performance issues and fixing them.  Analysing Hardware , Max memory and Min memory etc  Analysing blockings , wait types , query execution plans , indexes  Analysing IO Cost , cpu , memory  Configured Always on in SQL Server 2012. Troubleshooting issues related to always on. Performing Failovers in Always on for maintenance activities.  Configuring Mirroring, replication, loghsipping, clustering setup between database servers/instances.  Running SQL Server profiler to troubleshoot the data issues reported by users.  Providing and revoking access to users  Creating and managing login , fixing login issues
- 3.  Created new scripts as part of service improvements.  Configured Always on in SQL Server 2012. Troubleshooting issues related to always on. Performing Failovers in Always on for maintenance activities.  Configuring Mirroring, replication, clustering setup between database servers/instances.  Troubleshooting performance issues.  Running SQL Server profiler to troubleshoot the data issues reported by users.  Providing and revoking access to users  Creating and managing login , fixing login issues  Proficiency and Expertise in SQL Server Backup/Recovery, Disaster recovery and planning.  Creating and updating documents with latest information and Creating KB Articles for the issues so that team knows about the resolution.  Setting up performance counters to measure performance.  Created jobs to track the CPU Usage , Mem Usage , Flow of requests between nodes of sqlserver in always on, to keep a track of queries being executed to analyse them to trouble shoot in case of blockings , performance issues etc  Troubleshoot issues related to Terminal Servers Farm. Providing Group policy restrictions in terminal servers.  Running SQL Server profiler to troubleshoot the data issues reported by users.  Checking the Stored Procedures code , Debugging the Stored Procedures to trouble shoot the SQL Server Jobs issues, application’s related sql jobs issues.  Identifying the issues in code and reporting to dev team. Monitoring azure based applications , Instances , SQL servers in azure.  Doing diagnostic check in azure like health of worker roles , CPU usage , Memory usage , IO , certicates etc.  Adding , Updating certificates in azure.  Doing deployments in azure.  Providing and revoking access to users.  Scripting and Creating and Automating maintenance activities like backup jobs, Monitoring disk spaces etc.  Creating scheduled windows jobs in Windows Task Scheduler.  Troubleshooting Replication, Database Mirroring issues.  Smoke testing the availability of Applications, Flow of user requests between the Web servers and sql servers , trafiic redirection and load between servers  Modifying the configuration files. Troubleshooting IIS website issues.  Performing Smoke tests on the applications and resolving the issues observed so that the user don’t face any issues.  Administer MS SQL server by creating user Logins with appropriate roles, granting and denying login privileges, monitor the user accounts, creation of groups, granting database and application roles to users and groups.  Schedule and maintain routine Jobs, Tasks, and Alerts.
- 4.  Constantly checking functionality of the environment and taking necessary action when an alert is thrown from alerting mechanism by taking a prompt action based on its severity and considering the resolution of the issues as most primitive tasks.  Proficiency and Expertise in SQL Server Backup/Recovery, Disaster recovery and planning.  Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.  Experience in automating process by creating jobs, and error reporting using Alerts, SQL Mail Agent.  Planning Backup strategies and regularly monitoring and confirm that backups have been made and successfully saved to a secure location and restoring backups to a test server in order to verify that we can restore them.  Monitoring and resolving disk space issues to ensure that SQL Servers won’t run out of disk space.  Checking OS, SQL Server, Security, and other logs for unusual events.  Refreshing the data as per client to the client requirement.  Managing configuration file, checking connection by creating UDL file.  Flatten/Rebuild, Renaming, Static IP and wins mapping etc., as per requirement.  Migration of website and server as per requirement.  Taking Backups using Lite Speed tool.  Use of SIEBEL’s MSE and Microsoft’s ITSM ticketing system, Service Now for Creating and managing the tickets.  Investigate the reported issues, keep the ticket records and ensure resolution of issues and close the requests with in SLA.  Creating and updating documents with latest information and Creating KB Articles for the issues so that team knows about the resolution.  Providing KTs on application and SQL server to the new joiners in the team and helping them in resolving the issues.  Troubleshooting network and connectivity issues Academic Record:  M-Tech (Computer Science Engineering) with 84% from JNTU , A.P , India.  B-Tech (Computer Science Engineering) with 79% from JNTU , A.P, India.  Intermediate (MPC) with 95.6% marks from Vikas College in 2005, A.P, India.  S.S.C with 83.8% marks from Bodhini School in 2003,A.P, India. Place: Hyderabad ARIF MD M.Tech. (CSE)