SUMMARY

• 7+ years of hands - on experience in SQL Server implementation, maintenance, administration and 24x7 support.
• Hands on experience on High Availability/Disaster Recovery (HADR) solutions; Failover Clusters and AlwaysOn Availability Groups, Replication, Log Shipping and Mirroring.
• Experienced in installation, configuration, maintenance and optimization of SQL Server HADR solutions.
• Experienced with partially contained databases.
• Experienced in Performance Tuning, Backup and Recovery, Query Optimization and Security.
• Experienced in Upgrade/Migration of MS SQL Server 2005/2008 to MS SQL Server 2008R2, 2012 and 2014.
• Experienced in monitoring the health and performance of SQL servers as well as home grown applications using SQL Server native tools and several other third party solutions.
• Adept at T-SQL, stored procedures, tables, indexes, views, functions, and triggers.
• Expert in creating DTS packages to utilize SSIS functionalities and DB dependency resolutions.
• Created various SSIS, SSRS and SSAS Packages to serve company needs.
• Familiar with PCI Compliance Standards required for Retail Industry.
• Expert in using DTA/Extended Events/PerfMon/SQL Profiler/Scripts and other third party tools to resolve bottlenecks, dead locks and slow running queries.
• Able to benchmark and load test new instance builds for performance with DB load simulators.
• Responsible for securing SQL Server, user management, assigning permissions and roles.
• Strong System Administration background in Windows and Linux environments.
• Experienced in creating technical documentations and process archiving and change management.
• Experienced in working independently as well as in team-oriented environments.
• Expert in problem solving, analysis and conflict resolutions.
• Experienced in supporting and maintaining large databases and troubleshooting their problems.
• Excellent analytical, communication and interpersonal skills.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, HTML, VB, .NET, Java, PERL, ASP, PHP and XML

ETL Tools: SSIS, BI (BIDS/SSDT).

Data Modeler: SSAS, SQL Developer Data Modeler, TOAD Data Modeler.

Reporting & Audit Tools: SSRS, Report Builder and SSDT, Idera SQL Compliance Manager and SQL Secure.

Backup Software: SQLBackup, LiteSpeed, RedGate, Idera SQLSafe, VEEAM and Backup Exec.

RDBMS & Tools: SQL Server 2005/2008/2008 R2 and 2012, MS Access 2003/2007/2010/2013 Oracle 11gR2, MySQL 5.0+, SQL Loader and Export/Import, PowerShell.

Operating System: Windows 7,8, 10, Windows NT/ 2000/2003/2008 and 2008R and 2012 servers

Virtualization: VMware and Hyper-V

Third Party Tools: RedGate, Spotlight, and IderaSQLsuite, Toad Development Suite, phpMyAdmin, Olas’s Maintenance Scripts, Iometer, PuTTY, Wireshark.

DB Query Tools: MS SQL Server Query Analyzer, SQL Profiler, ETL, SSMS, Enterprise Manager, PL/SQL Developer, Toad for SQL/MySQL/Oracle.

PROFESSIONAL EXPERIENCE

Confidential, Washington D.C

MS SQL Server DBA

Responsibilities:

• Responsible for installing, configuring, and maintaining AlwaysOn Availability Groups and Failover clusters.
• Writing and improving SQL Server T-SQL queries.
• Created necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.
• Responsible for providing SQL Server problem resolution and 24x7 production support and server outages.
• Responsible for disaster recovery and high availability solutions and large scale database migrations from SQL server 2005 to SQL server 2008R2 and 2012.
• Created and migrated partially contained databases within AlwaysOn Availability Groups.
• Created automation of day to day operations, critical SQL server alerts and repetitive tasks.
• Monitored the health and performance of SQL, server instances and home grown applications using Extended Events, SQL server Profiler, PerfMon and other third party tools.
• Tested newly built servers for performance impact with DB load simulators.
• Setup and maintained Log Shipping between various environments.
• Created necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.
• Operated and oversaw database and log backups and restoration, planning backup strategies, and scheduling.
• Backed up master & system databases and restoring them when necessary.
• Optimized the Indexes, adding/deleting them when necessary for better performance.
• Verified backups and error logs on the servers and troubleshoot any failures or alert problems, and open trouble tickets if necessary to work with technicians from other departments.
• Responsible for Installing, configuring and maintaining SQL failover clustering for production environments.
• Worked with installation, configuration and creation of SSRS.
• Deciding whether clustering, log shipping, mirroring, replication, etc are the right fit to solve a business problem
• On-call troubleshooting for SQL Server service outages
• Responsible for securing SQL Server, user management, and taking care of permissions and roles.

Confidential, Washington D.C

MS SQL Server DBA

Responsibilities:

• Responsible for installing, configuring, and maintaining AlwaysOn Availability Groups and Failover clusters.
• Responsible for providing SQL Server problem resolution and 24x7 production support and server outages.
• Responsible for installing and configuring MS SQL Server 2005, 2008, 2008R2 and 2012 on Windows 2003, 2008, 2008R2 and 2012 and applying service packs and security fixes on these MS SQL Servers.
• Responsible for disaster recovery and high availability solutions and large scale database migrations from SQL server 2005 to SQL server 2008R2 and 2012.
• Created and migrated partially contained databases within AlwaysOn Availability Groups.
• Created automation of day to day operations, critical SQL server alerts and repetitive tasks.
• Monitored the health and performance of SQL, server instances and home grown applications using Extended Events, SQL server Profiler, PerfMon and other third party tools.
• Tested newly built servers for performance impact with DB load simulators.
• Setup and maintained Log Shipping between various environments.
• Created necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.
• Operated and oversaw database and log backups and restoration, planning backup strategies, and scheduling.
• Backed up master & system databases and restoring them when necessary.
• Optimized the Indexes, adding/deleting them when necessary for better performance.
• Verified backups and error logs on the servers and troubleshoot any failures or alert problems, and open trouble tickets if necessary to work with technicians from other departments.
• Responsible for Installing, configuring and maintaining SQL failover clustering for production environments.
• Involved in improving database performance using Extended Events, SQL Profiler, Trace Flags, Execution plan and DTA and third party tools.
• Worked with installation, configuration and creation of SSRS.
• Responsible for securing SQL Server, user management, and taking care of permissions and roles.

Confidential, Phoenix, AZ

SQL Server DBA Consultant

Responsibilities:

• Installed and configured SQLServer2012/SQLServer2008 R2/ SQLServer2008 with backup jobs, database mail and configuration options.
• Upgraded SQL Servers with latest service packs.
• Migrated SQL Server databases from SQL Server 2005 to SQL Server 2008 R2.
• Created, administered & maintained SQL Server Databases on Production, Test and Staging for various groups and ensured the availability of the database Servers.
• Configured and maintained transactional replication for flow of data from QA and Dev. Server to the replica servers.
• Monitored data activities like database status, logs, space utilization, locks and long transactions.
• Implemented SQL standards in writing stored procedures, Triggers, Views, SQL functions.
• Worked with developers to optimize the code if required to minimize the duration and look if the indexes were used appropriately.
• Involved in resolving deadlock and blocking issues for concurrent users.
• Provided appropriate access to users except system databases owners.
• Refreshed databases for pre or post data loads activities.
• Supported SQL server developers working on different projects with various requests.
• Converted and redesigned existing DTS packages to SSIS packages.
• Developed SSIS packages to import and export data from existing systems to upgraded system.
• Used database utility programs and 3rd party utilities to monitor database performance, such as Blocking, expensive queries, Memory utilization.

Confidential, Spring Valley, NY

Database Adminstrator

Responsibilites:

• Responsible for MS SQL Server 2005 and 2008 and database administration.
• 24x7 critical production support for hundred and ten SQL Servers out of which 75 were mission critical production support.
• Created database maintenance plans for SQL backups, optimization, and integrity check and t-log backups.
• Created checklists for proper/unattended install of SQL Server, applied service packs and security fix.
• Involved in validating SQL Servers, which was installed on validated environments.
• Configured and maintained transactional and Snapshot replication for 3 environments.
• Worked with SQL Disaster Recovery processes and documented/revised those processes.
• Worked with capacity planning, database sizing and monitoring.
• Created databases, tables, indexes, stored procedures and triggers, alerts and maintained user permissions.
• Involved in creating DTS Packages to import and export operations in and out of SQL Servers.
• Applied monthly patches and hot fixes. Worked with application team to test the successful upgrades.
• Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.

Confidential, Oklahoma City, OK

Associate Database Administrator

Responsibilities:

• Responsible for MS SQL Server 2005 and 2008 and database administration.
• 24x7 critical production support for hundred and ten SQL Servers out of which 75 were mission critical production support.
• Created database maintenance plans for SQL backups, optimization, and integrity check and t-log backups.
• Created checklists for proper/unattended install of SQL Server, applied service packs and security fix.
• Involved in validating SQL Servers, which was installed on validated environments.
• Configured and maintained transactional and Snapshot replication for 3 environments.
• Worked with SQL Disaster Recovery processes and documented/revised those processes.
• Worked with capacity planning, database sizing and monitoring.
• Created databases, tables, indexes, stored procedures and triggers, alerts and maintained user permissions.
• Involved in creating DTS Packages to import and export operations in and out of SQL Servers.
• Applied monthly patches and hot fixes. Worked with application team to test the successful upgrades.
• Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
• Installed and configured SQL Server Analysis services (SSAS) for data warehousing projects.