SQL Server DBA Resume

SUMMARY:

8 plus years of SQL Server Administration skills including backup, recovery, upgrade, maintenance, security, and database development.
Extensive experience in Backup and Restore Strategies for point - in-time recovery.
Experience in creating logins and users with appropriate permissions on server and database level.
Extensively involved in installation and upgrade of MS SQL Server versions 2008, 2008R2, 2012, 2014 and 2016.
Good knowledge and Experience in maintaining T-SQL scripts, stored procedures, triggers, tables and indexes.
Expertise in creating Jobs and Maintenance Plans to rebuild Indexes, Update Statistics and Check Database Integrity.
Experience in Setting up High Availability (HA) and Disaster Recovery (DR) solutions such as Log Shipping, Replication, Mirroring, Clustering and Always On.
Experience in configuring Database Mail and creating Operators to get notified of job failures and performance issues.
Experience in using SQL traces, DMVs, and Windows Performance Counters for monitoring and tuning SQL Server database performance.
Expert in scheduling, maintaining and troubleshooting SQL Server Integration Service (SSIS) packages for Data Extraction, Transformation and Loading (ETL).
Experience in configuring SQL Server Reporting Service (SSRS), deploying reports, assigning permissions, and scheduling reports subscriptions.
Experience in on-call production support.
Solid interpersonal, analytical and problem-solving skills; Motivated, diligent and strong team player.

PROFESSIONAL EXPERIENCE:

SQL Server DBA

Confidential

Install and configure SQL Server 2012/2014/2016 on production and non-production servers.
Patches SQL Server instances.
Deploy database code changes during production release.
Create Schemas, Tables, Constraints, Indexes, Views, Stored Procedures, Functions and Triggers.
Migrate SQL Server databases from 2008 to SQL Server 2012/2014/2016 using backup and restore.
Perform security related tasks including creating logins, database roles and users; Manages permissions to grant, deny or revoke.
Schedules jobs using SQL Agent to backup databases, reorganize/rebuild indexes, update statistics, check database integrity and cleanup job history as part of maintenance plan.
Configure Database Mail; create SQL Agent Operators to be notified of job failures and alerts.
Create Alerts to monitor CPU utilization, blockings and long running queries.
Use Windows Performance Monitor to capture server level metrics for monitoring and troubleshooting resource utilization.
Resolve issues related to slow performance caused by blocking, deadlocks, long running queries and connectivity issues using DMVs and SQL Profiler trace.
Analyze database growth patterns for Capacity Planning, and also partition data into multiple files and filegroups.
Install, configure, and administer SQL Server Reporting Service (SSRS).
Export and Import data from other data sources like flat files using SQL Server Integration Service (SSIS).
Configure Failover Cluster Instances in Always On High Availability Group.
Set up Replication, Log shipping and Mirroring for Disaster Recovery.
Participate in on-call rotation to support SQL Server production issues.
Keep documentation of SQL Server implementations and changes.

SQL Database Administrator

Confidential

Installed and configured SQL Server 2008R2/2012 on production and non-production servers.
Migrated SQL Server 2005 to SQL Server 2008R2 and 2012.
Designed and implemented comprehensive Backup and Disaster Recovery strategies.
Created SQL Logins, Users, Roles and permissions enforcing Security Policy.
Creating Tables, views, Stored procedures, Indexes and Triggers.
Tuned SQL queries using SQL Server Profiler and Database Tuning Advisor.
Used Log shipping and database Mirroring for Disaster Recovery of database.
Created maintenance plan to rebuild and reorganize Indexes to eliminate index fragmentation.
Created and maintained SSIS packages to Extract, Transform and Load data from CSV files, MS Excel and Access databases.

Database Administrator

Confidential

Conducted database and reporting requirement analysis.
Performed installation of SQL server 2005, 2008 and 2008R2.
Worked with database developers to perform system tests.
Monitored database performance using Perfmon and server-side traces.
Scheduled and monitored databases jobs on regular basis.
Involved in creating tables, indexes, triggers, views and stored procedures.
Generated reports on regular basis using SSRS.
Integrated data from Excel and Access into SQL server database through SSIS.
Performed Log shipping for disaster recovery.

TECHNICAL SKILLS:

Database systems: MS SQL Server 2016/2014/2012/2008/2008 R2, MS Access

DB Utilities: Profiler, SSMS, DTA, T-SQL, Idera Diagnostic Manager

Development Tools: Visual Studio, SQL Server Data Tools

Operating Systems: Windows Server (2003 - 2012)

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship