PROFESSIONAL SUMMARY:

• MS SQL Server DBA with 5 years experience looking for a SQL Server database administrator position
• Extensive experience in installation, configuration, upgrading, migration, backup and disaster/recovery, performance tuning, high availability solutions, security, and data transformation in MS SQL Server environment.

TECHNICAL SKILLS:

Database ( RDBMS): SQL Server 2008, 2008 R2, 2012, 2014, MS Access,

SQL Tools: SQL Server Management Studio, Upgrade Advisor, Query Analyzer, SQL Profiler, Database Tuning Advisor, Index Tuning Wizard, SQLCMD, SQL Configuration Manager, and SQL Server Data Diagram

High availability: SQL clustering, always on availability, mirroring, log shipping, replications

ETL Tools: SSIS

Reporting: SSRS (SQL Server Reporting Services/Server)

Operating Systems: Windows server 2008/2012, Active Directory, VMware, Cloud Computing

Web Application: SharePoint Enterprise

Web Server: IIS 6.0

Monitoring Tools: System Monitor, Counter, Windows Event Logs, Activity Monitor, DMV, Idera

Other Tools: SQL Server Migration Assistant, ODBC/DB Link, Toad Data Modeler, Redgate

PROFESSIONAL EXPERIENCE:

Confidential, Arlington/VA

Database Administrator

Responsibilities:

• Installed, Configured & Maintained SQL Server 2008, 2008R2,2012 on standalone and clustered Servers
• Successfully upgrade and apply service packs, patches
• Migrated databases from My SQL and Oracle to SQL Server
• Implemented periodic security controls to manage database users and their appropriate level of permission and data encryption
• Extensive knowledge in documenting and implementing database backup and recovery for DR solutions and point - in-time recovery
• Automated daily database refreshes from production on-demand database refreshes from Production to Test environments involving different versions of SQL Server
• Created and modified database structure using Data Definition Language (DDL) statements to create tables, indexes, store procedures, functions, views and trigger
• Manage very large databases (VLDB)
• Table partition to improve I/O access
• Importing and exporting data between SQL Server and other sources such as Flat file, CSV file, Oracle, My SQL, Access, ODBC/OLEDB data sources, etc. using SSIS and Import/Export Wizard, BCP
• Generated reports using SSRS (SQL Server Reporting Services) and deployment, managed reports and managed reports security
• Experience in creating and maintaining High Availability solutions including Database Mirroring, Log Shipping, and Replication (transactional replication)
• Monitored and scheduled automation jobs using SQL Server Agent and maintenance plan
• Configured Database Mail, Operator, notifications to send and receive database related information
• Monitored databases for optimal performance and diagnosed performance problem using SQL Profiler, Wait Stats, DMV’s (Dynamic Management View), Activity Monitor, Extended Events, Error log, Windows Performance Monitor
• Identified and Optimized poorly-performing queries to improve system performance
• Used SQL execution plan to find the cost and running process for TSQL code and optimized poorly written code
• Developed script to find missing indexes, unused indexes and duplicate indexes and created appropriate indexes to optimize slow running queries
• Rebuilding / monitoring the indexes at regular intervals for better performance.
• Troubleshoot day-to-day problems encountered on Production and Non-Production environments
• Run various DBCC commands to checks database consistency
• Ability to work independently and in a team environment
• Available On-call support to ensure database operations
• Check ticketing system and work on requests as a Production DBA.