We provide IT Staff Augmentation Services!

Database Administrator Resume

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

Database Administrator

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

Database Administrator

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

Database Administrator

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

Database Administrator

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

Database Administrator

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.

Hire Now