Pa

SUMMARY:

 Have an Extensive knowledge in .net and SQL Server DBA with (5 years) hands-on experience in SQL
Server 2000/2005 & 2008, 2012.
 Involved in SQL Server technologies Backup & Recovery, Log Shipping, Security health checking &
Employee Validation, Blocking & Deadlocking issues.
 Migrating from SQL Server 2000 databases into SQL Server 2005 & 2008.
 Expertise and Interest include Administration and Production Support for Large (VLDB) and Complex
Databases.
 Automating the Database Maintenance tasks by creating Jobs and Alerts.
 Regular/ scheduled Server maintenance, Service pack & Hotfix Installation, Build Installations, backups
/ Restores SQLissues.
 Automating the Database Maintenance tasks by creating Jobs and Alerts.
 Experience Working With Production 24/7 and Development Environments.
 Worked with Third Party Backup solutions like SQL Lite speed for MS SQL Server and Tivoli Storage
Manager (TSM).
 Strong knowledge in SQL Server disaster recovery, backup/restore, migration, and upgrade.
 Working experience in a fast-paced environment with developers and support staff.
 Creating Database users, controlling access to SQL Server and making sure right people get access
to right data and looking after the security issues.
 Server Setup / Configurations, Database Maintenance tasks, Environment Refreshment ,Database
Mirroring Setup and maintenance, Analytical troubleshooting of environment issues.
 Experience in Database Documentation, prepared data management outline documentation.
 A team player with excellent communication, analytical and inter-personal skills.
 Worked on different ticketing toolsRemedy , Onyx, ANZ Manage now and IBM Maximo, IBM Manage
now.
 Hands on Experience in Crystal Report’s and Db2 SQ’s and Db2 SQL
.

TECHNICAL SKILLS:

Operating System Windows 2000/2003&2008 Severs

Languages C, C++, .net

RDBMS MS SQL Server 2000/2005 &2008

Commercial Applications Ms Office

Tools TSM
PROFESSIONAL EXPERIENCE:

Assignment 1:

Role: SQL servers DBA

Description:

Edcon is the leading clothing, footwear and textiles (CFT) retailing group in southern Africa trading through
a range of retail formats. The Company has grown from opening it's first store in 1929, to 12 retail brands
trading in 1173 stores in South Africa, Botswana, Namibia, Mozambique, Swaziland, Lesotho and
Zambia.Edcon's retail business has, through recent acquisitions, added top stationery and homeware
brands as well as general merchandise to its CFT portfolio. We are maintained 80 production servers out
of 100 rest of the servers Dev/Test SQL servers.

Environment: MSSQL Server 2000/2005& 2008 R2

Duration : Aug 2014 to till date

Responsibilities:

 Database Backups & Restoration, Backup Strategies, Scheduling Backup jobs.

 Using Database maintained internal tool CONMON, to manage all the servers info ,DB changes
activities and also new servers added list and commission / decommission servers list .
 Granting rights to the users to access the Applications.
 Monitoring the scheduled full backup jobs on daily basis, troubleshooting failed daily full backup jobs
 Worked on Service level agreements (SLA).
 Worked on SPOTLIGHT monitoring tool.
 Automated of weekly and daily maintenance jobs.
 Worked on Environment Refreshment activities based on Service Request(SR).

 Regular checking of the database consistency using DBCC commands to minimize complexity. Work
as part of a team and provide 24 x7 supports when required.
 Worked on incident / problem tickets and tasks based on the users and customers request.
 Maintained disk and db capacity report on monthly basis.
 Based on the project requirement installing SQL server 2008R2/2012 / 2005&2000.
 Worked on week end maintenance activities.
 Troubleshooting and working knowledge on TSM third party backup tool.
 Captured db capacity report on monthly basis.

Assignment 2:

Role :SQL DBA

Description: The Insurance center of the MEGA life and health Insurance Company is licensed to issue
health and life insurance. It provides affordable insurance for those who need it most: the self employed,
individual and families, small business and Medicare beneficiaries.
Project Requirement:

The insurance center needed to consolidate its servers and increase the performance of its core application
to efficiently manage the company’s increasing number of subscribers.

Environment: MSSQL Server 2000 / 2005& 2008 R2

Duration : Aug 2012 to July 2014

Responsibilities:

1. Installing SQL Server and apply Service Packs.

2. Monitoring and working incident tickets .
3. Migrated data from SQL Server 2005 to 2008R2.
4. Configured Database Mirroring.
5. Creation and maintenance of Databases, creating Roles and managing user permissions, resolving Blocks
and deadlocks
6. Experience in providing excellent 24X7 Production support
7. Monitoring SQL server LOGS (Enterprise manager), Application logs (Event Viewer) and analyzing the
logs.
8. Used Windows Performance monitor to monitor CPU & Memory usage and SQL Server Profiler to monitor
and record database activities of particular users, applications
9. Gathered and maintained database full backup report on daily basis.
10. Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively
monitoring the performance of SQL Server databases.

Assignment 3:
Online Statement is developed to manage the overall activities of Banking System. The software
includes four modules viz., Deposits, Loans, Clearing, and Remittance. The Online Statement enables
easy transactions and reduces complexity in performing the operations like opening a new account,
 closing of account and transfer of amount from one branch to another branch on customer request. This
Online Statement provides still ore facilities in case of claiming loans for staff, NRI.

Environment: MSSQL Server 2000 / 2005& 2008 R2

Duration Sep 2010 to July 2010

Responsibilities:

 Migrated SQL server 2005 to SQL Server 2008 in Microsoft Windows Server 2003 R2 Enterprise
Edition SP2.
 Configured Log shipping from one production server to the reporting server.
 Heavily used Transactional Replication, Configured Transactional replication between Primary
Server and three Read–Only servers and experience in troubleshooting replication problems.
 Used Merge Replication, Configured Replication Publisher to subscriber and subscriber to
publisher and experience in troubleshooting replication problems.
 Maintained Operators, Alert Notifications, Jobs, Job Steps and Schedules.
 Used SQL Profiler for troubleshooting, monitoring, tuning of SQL Server and SQL code.
 Scheduled and monitored all maintenance activities including database consistency check, index
de fragmentation.
 Expert in using DBCC Commands and dynamic management views for finding out long running
queries

Assignment 4

Role: SQL Server DBA

Description:
AHS is a Michigan based Health care staffing services provide to hospitals, Nursing homes etc. AHS finds
candidates to various clients and bills them periodically for the services provided each client facility has
requirements based on expertise to cover working shifts on given days. While building the process, HS
records pieces of relevant information on these candidates, availability of shifts and days they are willing to
work, expiration dates of candidates, medical screening etc.

Environment: MSSQL Server 2000/2005

Duration :Dec 2009 to may 2010

Responsibilities:
 Responsible for health of db servers, databases, performance, availability, security, upgrades, etc
 Backup client databases and perform database restore and run consistency checks from SQL Server
and application. Performs and monitors daily database operations and set-up backup schedules.
 Monitor the status of Maintenance jobs – schedule to run daily and on weekends (tasks like rebuilding
indexes, Shrink Database, and Database complete backup).
 Creating users and giving appropriate Permissions.
 Maintenance of Log shipping.Implementation of SQL Logins, Roles and Authentication Modes as a part
of Security Policies for various categories of User Support.
 Excelled in resolving all alerts, identifying the need for missing monitors.
 Configuring and creating new monitor that gets generated with appropriate failure information to the
team.
 Regular checking of the database consistency using DBCC commands to minimize complexity.
 Work as part of a team and provide 24 x7 supports when required.

EDUCATION: