OBJECTIVE:

Played the role of Database Administrator in SQL Server 2005/2008/2012 Technologies, I am looking forward to be associated with a company where my technical expertise will be used and enhance further in development of Enterprise Applications.

PROFESSIONAL SUMMARY:

• Having 8+ years of experience in IT industry with strong skills in SQL Server Administration as Production support Database Administrator.
• Experience in installation and configuration of Microsoft SQL server 2000, 2005, 2008, 2008 R2, 2012 and 2014 versions.
• Managing Database security by Creating Users, logins and by assigning Roles and permissions
• Ensuring successful and periodical Backups, Restoration and configuring maintenance plans.
• Configured and Worked on CMS.
• Experienced with troubleshooting of database issues.
• Migrated Lower Versions (SQL 2005, 2008 and 2008 R2) databases (system and user databases) to SQL 2012 and 2014 SQL Server.
• Maintaining the Performance Tuning and Query Tuning.
• Utilization of DBCC commands for maintaining database consistency
• Updating Patches to SQL Servers
• Experience in working with Log shipping.
• Experience in working with Database Mirroring.
• Experience in working with Snapshot and Transactional Replications.
• Experience on cluster server patching.
• Experience on Always on High Availability
• Scheduled and maintained routine Jobs, Operators Alerts and Maintenance Plans.
• Improving Efficiency in Database including Reindexing, Updating statistics and performing other maintenance tasks.
• Daily activities include monitoring the database, checking errorlogs, checking the log file size and free space in the data drives, connectivity of the Servers.
• Linked Server Creation and Maintenance
• Database Mail Configuration.

TECHNICAL SKILLS:

Operating System: Windows XP, Server 2003/2008/2012 and Windows 7.

Ticketing Tools: BMC Remedy and HEAT (Front Range)

Languages: Transact - SQL (T-SQL)

Databases: SQL SERVER 2000/2005/2008/2008 R2/2012/2014

SQL Server Tools: Enterprise Manager, Query Analyzer, SSMS, Spotlight and Solarwinds Ignite (DPA), SQL Native, Commvault, Avamar and Net Backup

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Experience in providing Production support for Databases and Servers.
• Installing, Configuring and Administering SQL server 2000, 2005, 2008, 2008 R2, 2012 and 2014.
• Applying Service packs.
• Performing Database maintenance activities like Backups, Restoring etc.
• Checking Blocking Issues using Activity Monitor.
• Monitoring disk drive space, Database file sizes.
• Performance Tuning and Query Tuning.
• Monitor the status of Maintenance jobs - schedule to run daily and on weekends (tasks like rebuilding indexes, reorganizing indexes, Shrink Check DB and Update Statistics).
• Creating logins, users and giving appropriate permissions.
• Migrated databases from SQL Server and 2008 R2.
• Script out the logins by using revlogin scripts in SQL Server 2000, 2005, 2008 and 2008 R2.
• Configured Snap shot and Transactional Replication on SQL Server 2005 and 2008.
• Resolving the replication issues.
• Deployment of SSIS Packages.
• Backup and Restoration of SQL Server Analysis Cube databases.
• Executing the scripts on Test and Production Environments.
• Creating linked servers and mapped to appropriate servers.
• Creating SQL Server jobs and scheduling the job timings.
• Plan growth and changes (capacity planning)

Confidential

Responsibilities:

• Experience in providing Production support for Databases and Servers.
• Installing, Configuring and Administering SQL server 2000, 2005, 2008, 2008 R2 and 2012.
• Applying Service packs.
• Performing Database maintenance activities like Backups, Restoring etc.
• Checking Blocking Issues using Activity Monitor.
• Monitoring disk drive space, Database file sizes.
• Performance Tuning and Query Tuning.
• Monitor the status of Maintenance jobs - schedule to run daily and on weekends (tasks like rebuilding indexes, reorganizing indexes, Shrink Check DB and Update Statistics).
• Creating logins, users and giving appropriate permissions.
• Migrated databases from SQL Server and 2008 R2.
• Script out the logins by using revlogin scripts in SQL Server 2000, 2005, 2008 and 2008 R2.
• Configured Snap shot and Transactional Replication on SQL Server 2005 and 2008.
• Resolving the replication issues.
• Deployment of SSIS Packages.
• Backup and Restoration of SQL Server Analysis Cube databases.
• Executing the scripts on Test and Production Environments.
• Creating linked servers and mapped to appropriate servers.
• Creating SQL Server jobs and scheduling the job timings.

Confidential

Responsibilities:

• Experience in providing Production support for Databases and Servers.
• Installing, Configuring and Administering SQL server 2000, 2005, 2008 and 2008 R2.
• Applying Service packs.
• Performing Database maintenance activities like Backups, Restoring etc.
• Checking Blocking Issues using Activity Monitor.
• Monitoring disk drive space, Database file sizes.
• Performance Tuning and Query Tuning.
• Monitor the status of Maintenance jobs - schedule to run daily and on weekends (tasks like rebuilding indexes, reorganizing indexes, Shrink Check DB and Update Statistics).
• Creating logins, users and giving appropriate permissions.
• Migrated databases from SQL Server and 2008 R2.
• Script out the logins by using revlogin scripts in SQL Server 2000, 2005, 2008 and 2008 R2.
• Configured Snap shot and Transactional Replication on SQL Server 2005 and 2008.
• Resolving the replication issues.
• Deployment of SSIS Packages.
• Backup and Restoration of SQL Server Analysis Cube databases.
• Executing the scripts on Test and Production Environments.
• Creating linked servers and mapped to appropriate servers.
• Creating SQL Server jobs and scheduling the job timings.
• Experienced on Database Mirroring and Log shipping.

Confidential, Omaha

Responsibilities:

• Experience in providing Production support for Database and Applications.
• Installing, Configuring and Administering SQL server 2005.
• Performing Database maintenance activities like Backups, Restoring etc.
• Checking Blocking Issues using Activity Monitor.
• Creating Jobs and Sending Alerts using Database Mail.
• Monitoring disk drive space, Database file sizes.
• Performance Tuning and Query Tuning.
• Monitor the status of Maintenance jobs - schedule to run daily and on weekends (tasks like rebuilding indexes, reorganizing indexes, Shrink CheckDB and Update Statistics).
• Analyzing, Identifying and Resolving performance issues of the server
• Creating logins, users and giving appropriate permissions.

Confidential

Responsibilities:

• Installing, Configuring and Administering SQL server 2005.
• Performing Database maintenance activities like Backups, Restoring etc.
• Ensuring high availability of the database exploiting the concepts of Database Mirroring etc.
• Monitor the status of Maintenance jobs - schedule to run daily and on weekends (tasks like rebuilding indexes, defragmenting Databases, Shrink Database, and Database complete backup).
• Analyzing, Identifying and Resolving performance issues of the server.