We provide IT Staff Augmentation Services!

Database Administrator  Resume

CT

SUMMARY:

  • Five plus years of experience in Database Administration for large databases in SQL Server 2016, 2014, 2012 and 2008 R2
  • Expertise in Database Administration on Production Server with server configuration, patch, upgrade, maintainence and migrate databases.
  • Expertise in database Disaster Recovery procedures, developed and documented disaster recovery plans and backup and recovery strategies for production environment.
  • Expertise and proficiency in SQL Server Security Management operations.
  • Experience with High Availability solutions such as Cluster, Replication, Mirroring, AlwaysOn and Log Shipping.
  • Worked on upgrading SQL Server 2005 to 2008 R2 and 2008 R2 to 2012, 2014 and 2016
  • Expertise in troubleshooting SQL issues/performance problems, fine - tuning of databases, index Analysis and Monitored appropriate disk storage requirements for the databases by using execution plans, Trace, statistics, index tuning wizard
  • Experience working in SharePoint 2010.
  • Experience in data migration between two environments with SSIS and Export Import wizard.
  • Strong experience in mentoring team members and writing documentation.
  • Designed data Partitioning solutions for tables and indexes.
  • Experience in maintenance plans to perform index de-fragmentation, reorganize index, rebuild index, and update the index statistics.
  • Experience in using Performance Monitor, SQL Profiler and optimizing the queries, Extended Events, tracing long running queries and deadlocks.
  • Experience in providing 24 x 7 production support and on call rotation.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2003/2008 R2/2012, Windows XP/ Vista / 7, VMware 10

Database: MS SQL Server 2016/2014/2012/2008 R2/2005

Language: T-SQL

Reporting/Migration Tool: SSRS (SQL Server Reporting Services), SSIS, Crystal Report

Other Tools: SharePoint 2010, Remedy Ticketing System, JIRA, ManageEngine.

MS Office: Word, Excel, Access, Outlook and PowerPoint.

PROFESSIONAL EXPERIENCE:

Confidential, CT

Database Administrator

Responsibilities:

  • Installed, configured and administrating SQL Server 2016, 2014 and 2012 in Production, Test and DEV environments.
  • Responsible for tracking, resolving and documenting database related incidents and requests.
  • Daily reviewing of SQL related processing (e.g.: database backups, maintenance, monitoring) and reporting to ensure SLAs are maintained.
  • Working extensively on performance tuning using native tools like SQL Profiler, Extended Events, Performance Monitor, DBCC, Store Procedures, and DMVs.
  • Responsible for the implementation of SQL database changes into the production environment ensuring adherence to production standards
  • Responsible for maintaining and expanding disaster recovery documentation and procedures as they pertain to SQL processing and environments.
  • Designing and implementing comprehensive Backup plan using SQL Server Maintenance Plan.
  • Rebuilding and reorganizing indexes at regular intervals for better performance.
  • Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
  • Set up and manage Transactional Log Shipping, SQL server Mirroring and Transactional Replication.
  • Working on implementing AlwaysOn Availability Groups for High Availability and replicas for reporting and backup.
  • Configured Database mail and alerts.
Confidential, MD

Database Specialist

Responsibilities:

  • Installed SQL Server 2014 and 2012 in all environments.
  • Migrated database SQL server 2008 R2 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition
  • Configured and maintained AlwaysOn Availibility Group in SQL Server 2012.
  • Managed user permission by adding them in AD and user tables.
  • Configured and managed replication such as Transactional, Merge and Peer to peer Replication
  • Checked Database Health by using DBCC Commands and DMVs
  • Rebuilding / monitoring the indexes at regular intervals for better performance.
  • Monitor databases for block, dead lock, resource utilization by sessions, and captured long running queries.
  • Configured and maintained maintenance plan for incremental backup plan for all databases.
  • Monitored SQL server performance using SQL Profiler to find performance and deadlocks.
  • Used SSIS tools of SQL Server to populate data from various data sources, deploying packages for different data loading operations for ETL application.
Confidential, NJ

Database Administrator

Responsibilities:

  • Upgraded SQL server 2008 R2 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition
  • Installed, Configured, and Managed SQL Server 2008, and 2012 in development, test and production environment
  • Experience in Using DMVs, Performance Dashboard, and tracking Performance Counters
  • Monitor, reorganize or rebuild indexes at regular intervals for better performance
  • Recovering the databases from backup in disasters and Implementing Point-In-Time Recovery
  • Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
  • Extensively worked on Dynamic Management Views (DMV) in SQL Server 2008R2 & 2012
  • Monitoring SQL server performance using SQL Profiler to find performance and deadlocks
  • Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2008
  • Experienced in configuring log Shipping and Mirroring for SQL Server 2008 R2.

Hire Now