SUMMARY:

• A self - motivated, responsible and reliable DBA with a set of strong technical skills.
• I am a Senior Database administrator with extensive experience in SQL database administration in SQL 2005, SQL 2008/R2, SQL 2012, 2014 and 2016.
• Expert in Query Performance Optimization, SQL Server Set up, Installation, Version Upgrade, Architecting database in a physical and virtual environment.
• Configuring and managing AlwaysOn High Availability Groups, Active/Passive SQL Server Failover Clustering, designing and Implementing Database Backup-Restore & Disaster Recovery Strategies, Configuring high availability features such as Transactional and Snapshot Replication, Database Monitoring and Log-Shipping.
• I have configured and supported SQL Server on AWS-EC2 and RDS DB instances. I have also supported MapR/Hadoop environments for Data Warehouse Environments.
• Experience on monitoring, troubleshooting and performance tuning using SQL Server native clients and third-party tools on highly transactional production environments
• Extensive knowledge on configuring and managing SQL Server 2016/2014/2012 AlwaysOn High Availability Groups
• Profound experience in installation, configuration, maintaining and administering SQL Server 2016, 2014, 2012, 2008R2, 2008, 2005 and 2000 in different environments (development, test and production servers).
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization, building Referential Integrity, and Constraints.
• Experience in database access control management following the least-privilege administrative principle
• Experience in Query Optimization & Performance Tuning by identifying index fragmentation, optimizing Execution Plans for proper usage of indexes, horizontal and vertical partitioning.
• Experience in SQL Server Query-Store of SQL 2016, Resource Governor, and Performance Data Collector.
• Profound experience on SQL Server database Disaster Recovery/High Availability options using Availability Group, Database Mirroring, Log shipping, Database Replication, and Snapshot to ensure minimal downtime and data loss.
• Migrating/Upgrading databases from SQL Server 2005 to SQL Server 2008/2008R2; SQL Server 2008/2008R2 to SQL Server 2012; SQL Server 2012 to SQL Server 2014; SQL Server 2012/14 to SQL Server 2016
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS, Import/Export and SSIS packages.
• Installing and maintaining SQL Server Reporting Services (SSRS) for building and deploying multi-valued parameterized and complex reports including matrixes, charts, and gauges in SSRS.
• Experience in creating and supporting database administration automation scripts.
• Profound insights to determine priorities, and plans to meet critical deadlines.
• Experience on proactive monitoring practices and follow up on reactive situations by analyzing SQL Server Error Logs, Windows Events log, database files space usages, SQL Server Agent Jobs history/logs etc.

TECHNICAL SKILLS:

Database: SQL Server 2016, 2014, 2012, 2008R2/2008, 2005, and 2000; MS Access 2010, 2003 & 2000

Third-Party Monitoring Tools: SolarWinds (Database Performance Advisor), EM7, SentryOne, DBTuna, Newrelic, SQLDBManagerPlus, Solarwinds Server & Application Monitor (SAM)

ETL Tools: SSIS, DTS, BCP

Reporting: SSRS (SQL Server Reporting Services/Server)

Data Modeling: Toad Data Modeler, SSDD, ERWin etc.

Programming: SQL, T-SQL, and basic knowledge on Linux

Operating System: Windows Server 2012/2008R 2/2008/2003/2000 , Windows XP/NT4.0, VMware, Linux

Hardware/Storage: SAN, RAID AWS-Cloud management services SQL Server on RDS and EC2 instances

EXPERIENCE:

Senior SQL DBA

Confidential, NY

Responsibilities:

• Monitor and manage SQL Server 2016/2014/2012 servers and AlwaysOn High Availability Groups on Production and Staging Environments
• Upgrading and Migrating SQL Server 2005 to SQL Server 2008/2008R2; SQL Server 2008/2008R2 to SQL Server 2012; SQL Server 2012 to SQL Server 2014; SQL Server 2012/14 to SQL Server 2016
• Installed and configured SQL server 2016/2014/2012/2008 R2/2008 and customized them based on Microsoft’s best practices.
• Automate database monitoring and maintenance activities such as Backups, Indexes, and Alerts.
• Creating Tables, Views, Indexes (Clustered and Non-Clustered), Constraints (Unique, check, default).
• Perform and monitor performance load testing on production and staging
• Monitor and maintain the performance of SQL server with built-in SQL Server tools like SQL Server Extended Events, Profiler trace, Database Engine Tuning Advisor, using DMV/DMF and DBCC commands.
• Backup and restoring databases including point-in-time Recovery.
• Configuring and maintaining database mirroring, Log shipping, and Replications
• Administering SQL Server Reporting Services (SSRS).
• Extracting, transforming and loading (ETL) data from different data sources and loading to the appropriate format by creating SSIS package and deploying the package.
• Assist database developers to optimize SQL Queries, Stored Procedures, and triggers.
• Support and configure SQL Server on AWS-EC2 and RDS instances;
• Support MapR/Hadoop environments for Data Warehouse Environments

SQL DBA

Confidential, Washington, DC

Responsibilities:

• Monitor and manage SQL Server 2000-2008R2 servers
• Upgrade and Migrate SQL Server 2000 to SQL Server 2005; SQL Server 2005 to SQL Server /2008R2
• Install and configure SQL server 2000 to 2008R2 and customize them based on best practices
• Automate different database maintenance activities including Backups, Rebuilding/Reorganizing Indexes
• Creating Tables, Views, Indexes (Clustered and Non-Clustered), Constraints (Unique, check, default).
• Manage and monitor the performance of SQL server by using SQL Server tools like SQL Server Extended Events, SQL Server Profiler trace, SQL Server Agent, and Database Engine Tuning Advisor, using DMV/DMF and DBCC commands.
• Installing, configuring and maintaining database mirroring (automatic fail-over), Log shipping from production database, and Replications (Transactional) for Reporting purpose
• Administering SQL Server Reporting Services (SSRS). Develop, deploy and manage Reports
• Extracting, transforming and loading (ETL) data from different data sources and loading to the appropriate format. Creating SSIS package and deploying the package.
• Assist database developers to optimize SQL Queries, Stored Procedures, and triggers.

SQL DBA

Confidential, Reston, VA

Responsibilities:

• Installed, Configured, and Managed SQL Server 2008/2005/2000 in Development, Test, and Production Environment.
• Monitored performance using SQL Server profiler, windows performance monitor and Database engine tuning advisor (analyzed and fine-tuned long running queries, stored procedures and slow running servers).
• Created documentation for installation, monitoring procedures, security policies, configuration changes, migration procedures, and best practices.
• Managed logins and users (adding logins, roles, groups to the Windows server 2012-2000)
• Backed up and Restored mission critical databases and system databases.
• Created and configured database mirroring and log shipping, replication database for high availability and disaster recovery.
• Worked with developers to tune up SQL/T-SQL queries, stored procedures, triggers and functions.
• Developed SSIS packages to extract, transform and load into the production database from OLTP database.

SQL DBA

Confidential

Responsibilities:

• Installed, configured and managed SQL Server 2005 & 2000 in development, test and production Environments
• Installed, configured and maintained Database Mirroring using automatic fail-over option.
• Configured Log Shipping from Production database for Reporting purposes.
• Configured and maintained Replications (Transactional and Snapshot).
• Installed, configured, and administered SQL Server Reporting Services (SSRS).
• Developed, Deployed, and Managed Reports and Report Security.
• Upgraded SQL Server 2000 databases to SQL Server 2005.
• Applied SP (Service Packs) and Hot Fixes on SQL Server 2000 and 2005.
• Assisted Database Developers to optimize SQL queries and Stored Procedures.
• Export & Import data from Flat/CSV files to/from SQL Server Database using DTS, and BCP.
• Monitor SQL Server error logs, space usage, events, jobs, customer complaints, and daily routine works.
• Used DBCC to check database conditions, rebuilding indexes and other maintenance purposes.