SUMMARY

• Over six years of experience in Database Administration in SQL Server 2012, 2008 R2 and 2005, More than 16 years in IT related field.
• Expertise in SQL Server Disaster Recovery Planning and Security Management.
• Proficient in server configuration, patch, upgrade, maintenance and migrate databases.
• Specialized in T - SQL, writing stored procedures, triggers and functions.
• High availability solution such as Windows Clustering, Replication, Mirroring, Log Shipping and Always-On.
• Data migration between two environments with SSIS, Detach/Attach and Import/Export.
• Creating Crystal report using SSRS.
• Strong experience and passion in mentoring team members and writing documentation.
• Designed data Partitioning solutions for tables and indexes from conception to completion.
• Strong Experience in creating jobs, alerts, SQL Mail Agent and SSIS Packages.
• Creating maintenance plans to perform index de-fragmentation, reorganize index, rebuild index and update statistics.
• Implementing different types of Replication Models such as Peer-to-Peer, Merge, Transactional and Snapshot on basis of business specification.
• Perform integrity checks, methods include configuring the database maintenance plan wizard and DBCC utilities.
• Expertise in troubleshooting SQL issues by using SQL Tools like, execution plans, statistics, index tuning wizard, perfmon, DMV and Activity monitor.
• Performance Monitor using SQL Profiler, optimizing queries, tracing long running queries and deadlocks.
• Upgrading SQL Server lower version to the higher version, capacity planning and risk management.

TECHNICAL SKILLS

Operating Systems: Windows Server 2003/2008 R2/2012, Windows XP/ Vista / 7, VMware, Citrix, Hyper V

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

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

Data Modeling: SQL Server Database Diagram, RedGate, VISIO

Other Tools: Remedy, JIRA, UNIX, Oracle 10g/11g, Dynatrace 5.0, 6.0, Fiddler, Wire Shark, SiteScope, Perfmon, Profiler, Tuning Adviser, DMV, DBCC

PROFESSIONAL EXPERIENCE

Confidential, Alexandria, VA

SQL Server DBA

Responsibilities:

• Providing 24x7 dedicated production support for SQL Server problem resolution and server outages.
• Installation, configuration SQL 2012 on Windows Server 2008 R2, applying service packs, security fixes on MS SQL Servers.
• Responsible for a large scale database migration from SQL server 2008 R2 to 2012.
• Creating T-SQL, stored procedures, tables, views, functions, triggers and indexes.
• Database, log backups, restoration, planning backup strategies and scheduling.
• Rebuilding Indexes at regular intervals for better performance.
• Always-On High Avialbiltity, Disaster Recovery configuration and maintenance.
• Verify backups, error logs, troubleshoot any failures, alert problems and open trouble tickets if necessary to work with technicians from other departments.
• Installation, configuration and maintenance of SQL Server 2012 Fail over clustering.
• Responsible for configuring and maintaining Transactional replication.
• Involve in Change / Incident Management Process and using Remedy tool notify requests and open new requests.
• Using third party tool Red Gate, ensuring all the databases are backing up on the regular basis and then restoring this databases on requests.
• Improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
• Responsible for securing SQL Server, user management, permissions and roles.
• Scheduling jobs and alerts using SQL Server Agent.

Confidential, Reston VA

SQL Server DBA

Responsibilities:

• Installed, Configured and Administered SQL Server 2008 R2.
• Backed up databases using Full, Differential and Transactional log backup methods.
• Restored Database from database backups with Point-in-Time Recovery.
• Run DBCC to check physical, logical consistency of the database and Rebuild indexes.
• Monitor Server Activity, Error Log, space usage and solving problem as needed.
• Maintained server level, database level, object level security best practices by creating logins, users, configuring permissions and assigning different roles to users.
• Created SQL Server Event, Maintenance Plans and Performance Condition Alerts.
• Scheduled jobs to automate different database related activities including Backup, Monitor Database health, Disk space and Backup verification.
• Set up Merge, Transactional and Snapshot Replication on remote server.
• Configured, administered Fail-Over Clustering, Transactional Log shipping, Replication and Database Mirroring using SQL Server 2008.
• Implemented troubleshooting of SQL Server performance issues using SQL Tools, execution plans, Trace, statistics, index-tuning wizard and other tools.
• Created, reorganized and rebuilt indexes and constraints.
• Performed database migration from R2.
• Install and apply Service Packs (SP) on SQL Server 2005, 2008 and 2012.
• Performed Export & Import of databases from / to Flat file, excel Access, Oracle and MySQL to / from SQL Server Database using SSIS and BCP.
• Experienced in Creating, Modifying tables and Relationship management and Views.
• Performed writing T-SQL, Trigger and Stored Procedures.
• Creating user accounts with appropriate privileges and database security.
• Performance tuning, maintaining and troubleshooting database problems.

Confidential, Herndon, VA

SQL Server DBA

Responsibilities:

• Creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures and Triggers.
• Installed, Configured, Managed SQL Server in development, test and production environment.
• Configured Log Shipping as Standby database from Production database.
• Monitored Database Performance using profiler and engine tuning advisor.
• Database Backup, Restore and Point-in-Time Recovery.
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space and backup verification.
• Developed Different Maintenance Plans for database monitoring.
• Monitor Server Activity, Error Log, disk space usage, solving problem as needed and applied SP (Service Pack) on SQL Server 2005, 2008 R2.
• Upgrading SQL Server 2005 to SQL Server 2008 R2.
• Installed, Configured and Maintained Database Mirroring, Fail-Over Clustering, Log Shipping as Standby database from Production database for Reporting purposes.
• Configured and Maintained Replications (snapshot, merge and Transactional).