SQL Server DBA Resume

SUMMARY:

Four years hands - on professional experience in SQL Server database as a DBA
Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring and Replication
Strong knowledge in Configuring SQL Server Agent, create, maintain and monitor jobs
Experience in troubleshooting and resolving frequent database issues including integrity issues, replication, Error log, mirroring, connectivity, and security related issues etc.
Experience in installing and configuring SQL Server, applying patches and fixes
Scheduling SQL Server jobs to monitor disk space, CPU activity and index fragmentation.
Extensive experience in using SSIS, SSRS and BCP to import/export data from different sources of data into SQL Server Databases and vice versa.
Strong knowledge in setting up and managing database security by creating new users, roles, profiles, and provide required user privileges in development, test, training and production environments.
Solid Experience monitoring, troubleshooting and performance optimization related issues.
Solid experience working in a high availability environment.
Have excellent analytical, problem solving, communication and interpersonal skills with ability to interact with people at all levels and can work as part of a team or independently
Devoted and Quick learner with capability to master and implement new technologies
Excellent presentation and documentation skills

TECHNICAL SKILLS:

Databases: Microsoft SQL Server 2005/2008/2012/2014/2016, TSQL, MS Access, MySQL

Tools: SSIS, SSMS, SQL Doctor, BCP, Import and Export Wizard, Profiler, SQL Diagnostic Manager, Spotlight, Database Tuning Advisor (DTA), Failover cluster manager, Task scheduler.

Microsoft Office: Word, Excel, Power Point, Outlook, Access)

Operating System: Windows server 2005, windows server 2008, Window Server 2012R2 and Vista/windows 7, Windows 8/Windows 10

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server DBA

Responsibilities:

Performed database monitoring and Performance tuning.
Monitor Servers activity, and worked with clients to solve different problems.
Performed index and statistics management.
Performed database integrity checks using DBCC utilities and maintenance plan configuration wizard.
Monitoring SQL server performance using profiler to find performance
Implemented troubleshooting of SQL Server performance issues using SQL Server Profiler, Trace, Index tuning wizard and Database Engine Tuning Advisor (DTA).

Confidential

SQL Server DBA

Responsibilities:

Performed database monitoring and Performance tuning.
Installed, Configured, and Administered SQL Server 2005 and 2008 in development, test, and production environment
Extensively used SQL native tools like SQL profiler, Database tuning advisor (DTA), Performance monitor
Solid Experience in installing and configuring SQL Server, applying patches and fixes
Used tools like SSIS, SSRS and Import/Export, BCP (Bulk Copy), to import & export data from flat files, and excel to MS SQL Server databases.
Created Databases, Performed database monitoring, and Performance tuning.
Imported data from Excel, Flat file and BCP to SQL Server Database using SSIS.
Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
Created and Managed users, roles, security at object level, data encryption.
From/to MySQL, and Access Database including flat files like text, excel, and to SQL Server 2005/2008/2012.
Work experience and strong knowledge in disaster recovery.
Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
Wrote T-SQL Scripts for database backup jobs and daily/weekly jobs.
Backing up, restoring the database manually and scheduling the jobs and Maintenance Plans.
Installed, Configured, and administered SQL Server Reporting Services (SSRS)
Installed, Configured and Managed Database Mirroring, Replication and Log Shipping.
Installed, Configured and Maintained Fail-Over Cluster Servers in SQL Server 2005 & 2008.
Installed, Configured and maintained Always On High Availability Group in SQL Server 2012
Installed, Configured, and Administered SQL Server 2005, 2008 and 2012 in development, test, and production environment.
Installed and Configured Operating System, Windows Server (2000, 2003, 2005 & 2008).
Migrated MS SQL Server 2005 to MS SQL Server 2008.
Imported and exported data from Excel, Flat file and BCP to SQL Server Database.
Created Backup jobs for different types of backup like FULL, BULk LOGGED, and SIMPLE Differential and Transaction Log.
Created Jobs for database maintenance Index fragmentation, rebuild, database statistics.
Configured Database mail
Changed recovery Model to the effectiveness of the backup and restore options
Changed database state form READ ONLY to READ and WRITE
Created multiple connections to database and changed RESTRICED USER and ROLLBACK IMMEDIATE.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship