PROFESSIONAL SUMMARY:

A motivated and experienced Microsoft SQL Server Production DBA with 6+ years in SQL Server installation, configuration, automation, Backup and Recovery, High Availability & Disaster Recovery, Data Migration, Database monitoring, Database security, Performance Tuning, and Administration of MS SQL Server 2016/2014/2012 R2/2008/2008R2/2005. A quick learner who is versatile, detail orientated and a team player with ability to multi task, including excellent written and verbal communication skills.

SKILL:

RDBMS: Microsoft SQL Server 2016/2014/2012 R2/2008R2/2008/2005

Technologies/SQL Tools: SSMS, T - SQL, SSIS, SSRS, SQL Profiler, DBCC utilities

Operating Systems: Windows Server 2003/2008/2008 R 2/2012/2014/2016 , windows 10, windows 8, windows 7, window XP, VM (Virtual Machine)

Vendors DB tools: Solarwinds, Redgate, DPA (Database Performance Analyzer), IDERA

Reporting Tools: SSRS, Crystal Reports, Tabular Reports

Domains: Telecommunication Industry, Healthcare Industry, IT Services, Financial Industry

PROFESSIONAL EXPERIENCE:

SQL Server DBA

Confidential, Norcross, GA

Responsibilities:

• Managed and configured MSSQL Server versions for production, staging, and testing environments. (SQL-2016/2012R2/2008R2/2005)
• Participated in SQL Server migration from and 2016
• Successfully installed different versions of SQL server on production environment
• Reorganized indexes on a recurring basis to improve database performance
• Experienced in query optimization and tuning through analyzing execution plans, index optimization and statistics
• Experienced in Extracting, Transforming and Loading (ETL) data from MS Excel, flat files, and Oracle to MS SQL Server using SSIS packages
• Extensively utilized various features of SSIS projects and packages (control flow tasks, data flow tasks, transformations, data migrations. transferring data in and out of tables)
• Knowledgeable in advanced database objects: views, stored procedures, functions, triggers, partitioned tables, and indexes
• Created, scheduled, and maintained plans for regularly scheduled Transactional, Differential, and Full Backups based on the recovery models
• Worked with AlwaysOn Availability Groups (AAG), and High Availability Disaster Recovery (HA/DR) from implementation to troubleshooting
• Implemented High Availability solutions which included failover clustering, AAG, Log Shipping, Database Mirroring, and Replication
• Configured database mail for application purposes and for sending database alerts
• Maintained SQL Server security by using PowerShell, SQL logins, s, server roles and database roles
• Monitored server resources such as CPU, disk usage and memory usage of the servers using Task Manager and third party tools like IDERA, Solarwinds, and Redgate
• Consolidated databases into fewer servers to cut software and infrastructure costs
• Administered and sometimes created SQL Server Reports using SSRS for the business and management teams
• Employed strong analytical and logical problem solving skills using my ability to adapt to emerging technologies
• Provided emergency 24 x 7 on-call support on a rotating basis

Environment: MS SQL Server 2014/2012R2/2008R2/2008, VMware, T-SQL, SSIS, SSRS, Visual Studio 2010, Windows PowerShell ISE, and Windows Server

Data Analyst/MS SQL Server DBA

Confidential, NY, NY

Responsibilities:

• Participated in installing SQL Server instances on physical servers and VMs
• Monitored general health of servers by using SQL native tools and third party tools
• Helped in writing T-SQL queries depending on clients’ needs
• Created and maintained databases, created roles and managed permissions
• Audited databases monthly for user transactions, logins, and removed orphan users
• Exposed to Extracting, Transforming, and Loading (ETL) data using BCP utility, DTS, and SSIS services
• Installed and maintained SQL Server 2012R2/2012/2008R2/2008 on Test, Development, and Production Environments
• Investigated database incidents by checking event and error logs, and fixed the problems
• Backed up and Restored databases using Redgate Backup and SQL native methods
• Created and maintained plans for regular scheduled Transaction, Differential, and Full Backups
• Experienced in upgrading MS SQL Servers using in-place and side-by-side upgrades
• Performed SQL Server patching in production and staging SQL Server environments
• Good experience in Always On Availability (AG), and High Availability(HA)/ Disaster Recovery (DR) installations and troubleshooting
• Hands-on experience with designing, installing, troubleshooting, managing and configuring MS SQL Server 2005/2008/2008 R2/2012/2012R2

Environment: MS SQL Server 2014/2012R2/2012/2008R2/2005, VMware, Visual Studio 2010, Redgate Backup, SolarWinds, and SQL Sentry Performance Analyzer

IT - Support

Confidential, Secaucus, NJ

Responsibilities:

• Installed and configured computer hardware operating systems and applications
• Translated complex technical issues to clients in a way that end users could understand
• Logged customer and employee queries and maintained records in run book
• Checked computer hardware to make sure they were functional and installed printers
• Maintained privacy of computer systems and networks via vulnerability software
• Scheduled upgrades and maintenance of computer systems with seamless interference
• Implemented recovery processes to restore lost data caused by users or system failures
• Assisted in procurement of computer accessories and supplies
• Tracked all instances of support by creating IT tickets using ticket tracking software
• Performed other duties as assigned by manager

Network Administrator

Confidential

Responsibilities:

• Managed network and Internet connectivity throughout the organization.
• Evaluated, tested, and deployed software and hardware upgrades to the company’s network infrastructure
• Assisted in the configuration and deployment of core and peripheral network devices
• Monitored network devices, services, to ensure SLA was followed
• Collected and reviewed network utilization data for capacity and planning purposes
• Assisted in developing, implementing, testing, and maintaining disaster recovery plans
• Interfaced with vendors for procurement & maintenance of all IT infrastructures
• Worked closely with team members to provide end-user support and issue resolutions
• Maintained up-to-date knowledge of emerging tools and technologies
• Researched, evaluated and recommended new technologies to support business requirements.
• Created and maintained documentation for all processes and procedures