PROFESSIONAL SUMMARY:

• Microsoft Certified database administrator with six years of extensive experience in detail oriented, analytical and troubleshooting experience across different version and editions of MS SQL server.
• Proficient in areas of Installation, Configuration, Migration, Maintenance, Performance Tuning, Security, SSIS, SSRS, ETL, Data Modeling, Disaster recovery and design, as well as development of database objects including stored procedures, triggers, views, functions, constraints etc.
• Experienced in providing 24/7 support on production and non - production environments.
• Appreciate challenges, steep learning curves, and high pressure deadlines.
• I am a committed team player, self-motivated with the ability to communicate at all levels.
• Extensive experience in Installing, Configuring, Managing, Migrating/Upgrading Database, and Troubleshooting issues related to SQL Server 2016/2014/2012/2008 R2/2008/2005
• Monitoring Database Performance and Tuning using SQL Server Profiler, Database Tuning Advisor, Activity Monitor, and Performance Monitor
• Automating Jobs, Creating Maintenance Plans, Reorganizing, and, Rebuilding Indexes
• Experience on SQL Security and Audit Management
• Experience on SQL Server High Availability and Disaster Recovery solutions, including Database Backup/Restore, Log shipping, Mirroring, Replication, Always On Availability Group and Failover Clustering
• Experience in Creating Stored Procedures, Triggers, user defined Functions, and Views
• Experience on applying Service Packs and Hot Fixes
• Export and import data from different data sources such as Flat files, Excel, Access, and Oracle into SQL and vice versa
• Excellent customer support on a 24/7 availability

TECHNICAL SKILLS:

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

Performance Tools: Database Tuning Advisor, SQL Profiler, Extended Event, System monitor, Query Analyzer, Activity monitor, Performance Monitor, Event Viewer, IDERA

BI tools: SSIS, SSAS, SSRS

Data Modeling: SQL Server Diagram(SSDD), Visio 2003/2007

Programing Languages: T-SQL

Operating Systems: Windows 7/8/10/Vista/XP

Hardware: SAN, RAID, VMware

Networking Related Expertise: Managing User accounts using Active Directory, Implementation of TCP/IP, Configured workstations for IP based LAN TCP/IP, DNS and SMTP

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

SQL Database Administrator

Responsibilities:

• Installed, configured, and managed MS SQL Server 2016/2014/2012 in Development, Test, and Production environments
• Migrated databases from SQL Server 2008/2008 R2 to SQL Server 2014/2016
• Performed Performance Monitoring and Tuning using windows and SQL performance monitoring tools (i.e. system monitor, perform, task manager, extended events, SQL profiler, activity monitor, DBCC, DTA & DMVs)
• Used DBCC commands, DMVs and DMFs to check database integrity, index fragmentation and statistical updates
• Administrated the MS SQL Server security by enforcing security policy, created Logins with appropriate roles, monitored user accounts, created user groups, and granted minimum possible privileges to users and groups
• Resolved low disk space alerts, connection issues and failed jobs
• Identified and Troubleshoot CPU, Memory and I/O bottle necks
• Configured database mail in all SQL Servers
• Planed, designed and implemented backup and restore plans according to company’s Recovery Time Objective (RTO) and Recovery Point Objective (RPO)
• Created jobs and alerts in SQL Server Agent
• Developed parameterized and non-parameterized store procedures, functions, triggers, views and other T-SQL codes
• Configured SQL Server Agent job and automated alerts and maintenance plan.
• Performed root cause analysis for slow running quires, missing index, outdated statistics, blocking and deadlocking issues
• Resolved and Monitored database auditing
• Setup and Configured database AlwaysOn in Synchronized and Asynchronized mode
• Imported and Export data from/to flat file, access, excel to/from SQL Server databases using SSIS and Import/Export wizard
• Deployed and Automated SSIS Packages using SQL Server Agent Jobs
• Configured various event driven e-mail notification process in SSIS packages
• Provided Production Support 24x7

Confidential, Washington, DC

SQL Database Administrator

Responsibilities:

• Configured and installed of MS SQL Server 2008/2008R2
• Researched, designed and performed database migration from SQL Server 2008/R2 to SQL Server 2012/2014
• Performed, designed and implemented comprehensive backup plan and disaster recovery strategies
• Configured and supported Mirroring and Log shipping
• Configured database mail and created profiles and accounts for appropriate users
• Enhanced and monitored performance using performance monitor, Extended Event, SQL profiler, Tuning Advisor and Activity Monitor
• Assisted to design and create databases, tables, views, stored procedures and triggers
• Rebuilt and reorganized index
• Analyzed and optimized expensive queries and store procedures
• Set up and maintained security at the database and server level
• Automated jobs for different purposes including backup, monitoring database health, disk space, backup verification
• Developed different maintenance plans such as backups, index management, fragmentation management, cleaning history deleting old files
• Monitored server activity, Error Log, Space usage, and solving problems as needed
• Developed parameterized and non-parametrized stored procedures, functions, triggers, views and other T-SQL codes
• Supported end users/clients various departments with regards to connection and data access issues
• Prepared documentations for the best practice
• Created and managed database objects, scheduled jobs, maintenance plans, alerts SSIS packages in SQL Server
• Applied Service Packs and Hot Fixes on SQL Server 2008R2/2012
• Implement and maintain database security, replication, SQL Clustering, Stand by server, DTS, Log Shipping and SQL Mail to manage small, medium and large SQL Server 2000 projects