SUMMARY:

• A certified SQL Server DBA with over 6 years of professional experience in Database Administration, Design, Development, and Support of MS SQL Server 2016,2014, 2012, 2008R2, and 2005 in Production, UAT and Development Environments.
• Experience in Performance Tuning, Index Tuning, Execution Plan, Query Optimization, Reports, Backup and Disaster Recovery.
• Solid experience in SQL Server high availability solutions, including AlwaysOn Availability Groups, and SQL Server Clustering (Active - Active, Active-Passive).
• Proficient in SQL/T-SQL Scripts, indexes, stored procedures, views, triggers, and functions.
• Proven ability to identify the root cause of database issues with the expertise to troubleshoot and resolve issues promptly.
• Hold exclusive knowledge of database security including data encryption and decryption.
• Working knowledge of SQL server upgrades and migrate using various versions and editions.
• Experienced in ETL operations across heterogeneous sources for small and large scale data warehouse.
• Developed and deployed several report using SSRS.
• Expertise in using SQL Server tools as well as third-party tools efficiently like ERWin , Toad Data Modeler , SQL Sentry/SentryOne , Idera , Redgate, OpNet,SolarWinds and Tableau.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2012, 2008R2, 2003R2

Virtualization: VMWare, and VSphere. Managed Database Servers and Databases in Virtual Environment, Azure Cloud, AWS (EC2, Redshift, RDS)

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

SQL Server Tools: SSMS, Query Analyzer, Performance Monitor, SQL Server Profiler, BIDS/Data Tools, Database Tuning Advisor, SSIS, SQL Server Configuration Manager, Activity Monitor, Job Activity Monitor, Execution Plan, DMVs, DMFs, DBCC, Index Tuning Advisor

Data Modeling Tools: ERWin, Toad Data Modeler

Reporting Tools: SSRS, Report Builder

Data Migration/ETL Tools: SSIS, Backup/Recovery, Detach/Attach, Import/Export Tool, DTS

Hardware/Storage: SAN, RAID

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server Database Administrator

Responsibilities:

• Created stored procedures, functions, Queries, views and other database objects.
• Executed performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Developed SSIS packages using Lookup Transformations, Merge Joins, and Derived Columns with Multiple Data Flow tasks.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases. Involved in Extracting, Transforming and Loading (ETL) data from Excel, Flat File to MS SQL Server by using SSIS services.
• Deployed and Debugged SSIS packages for import, export and bulk insert data with transformations from various data sources.
• Installed, Configured, and administered SQL Server Reporting Services.
• Developed and Deployed Reports using SSRS.
• Developed periodic SSRS reports in BIDS used to generate daily, weekly, monthly and quarterly reports.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Managed and applied Service Pack to SQL Server 2014 and 2012, 2008R2 in development, test and production environment.
• Performed different daily routine backup jobs by using maintenance plan.
• Carried Out manual and automation schedule backup job.
• Performed tail log backup for a point in time recovery based on the disaster recovery.
• Restore Database from backup file Server to production.
• Created documentations for an upgrade and migrate databases.
• Solid hands-on skills in migrating/upgrading SQL Server /2008R2&SQL Server 2005, 2008/2008R2 to 2012 and 2014 and applying service packs.
• Monitoring Server and databases Performance tuning (Disks space, lock, and block, query running slow).
• Schedule jobs to automate different database related activities including backup, monitoring database health, disk space and backup verification.
• Monitor SQL Temp DB, Server Error Log, and Usage space.
• Configured and Maintained AlwaysOn in 2012 on Virtual machine.
• Configured Manage and maintain Transactional Replication.
• Managed and maintained two NODE active-passive clusters.
• Created, modify tables, Index (Clustered/Non-Clustered), Constraints (Unique/Check), Views, Developed different Maintenance Plans for database monitoring.
• DMV command to check database conditions, Rebuilding indexes and other database Maintenance purposes.
• Performed database consistency checks with DBCC, Defrag, Index tuning and monitoring error logs.
• Expert in analyzing the execution plan and index management for better Query Optimization.
• Applied SP (Service Pack) on SQL Server 2008 (SP4), 2012(SP3).
• Created Trace file using SQL Profiler then review it for further steps.
• Tune queries which are running slow using Perfmon, Profiler, and Statistics I/O by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Worked with Windows team to failover the cluster when needed after Windows patching.
• Created jobs, Scheduling Jobs, Alerts using SQL Server agent and handle error logs for troubleshoots.
• Created DB master key, symmetric keys, asymmetric keys and certificates for encryption.
• Performed partition for efficient management of database tables.
• Troubleshoot performance issues such as locking, blocking and deadlocks on production database using tools like SQL Server Profiler.

Environment: SQL Server2014, 2012,2008R2, Windows Server 2012, 2008 R2 64 bit, SQL Profiler, PerfMon, Execution Plan, Activity Monitor, SSIS, T-SQL, SQL Agent

Confidential, SILVER SPRING, MD

SQL Server Database Administrator/DBA

Responsibilities:

• Supported day to day operational activities for the database platform like service requests and tickets, monitoring, performance tuning, troubleshooting long-running queries, locks, deadlocks and performance issue like CPU, I/O, Memory bottlenecks.
• Installed, Configured, and Maintained SQL Server 2008 R2, 2012, in development, test, and production environments.
• Installed SQL Server 2012 in a test environment to be the future production environment
• Configured Backups, involved in restoring the database to point- in- time in case of issues, and optimization jobs for various purposes and DBA notifications like job failures, disk issues, critical events.
• Implemented high availability with AlwaysOn Availability Groups, Mirroring, Replication and Failover Clustering.
• Upgraded SQL Server 2000 to SQL Server 2008 R2 and SQL Server 2005 to SQL Server 2012
• Applied SP (Service Pack) and Hot Fixes on SQL Server 2008 R2, and 2012.
• Installed, Configured, and Administered SQL Server Reporting Services (SSRS), and Developed, Deployed and Managed Reports for associates and upper management using SSRS, Crystal Reports and Report Builder.
• Involved in completing database design including conceptual, logical and physical data models
• Created and managed schema objects such as tables, views, indexes, stored procedures, and triggers and maintained referential integrity.
• Exported data from SQL Server to multiple destination/format such as Flat file, CSV file, Oracle, MySQL, Access and ODBC/OLEDB data sources.
• Import data from multiple sources such as Flat file, CSV file, Oracle, MySQL, Access and ODBC/OLEDB data sources to SQL Server.
• Migrated Oracle 10g/11g, MySQL 5.1/5.5 databases to SQL Server 2008R2 and 2012.
• Performed Performance Monitoring, and Troubleshooting using SQL Profiler, Execution Plan, Database Tuning Advisor and tracing and optimizing long running queries.
• Wrote T-SQL scripts including Stored Procedures, triggers, and functions.
• Scheduled to Rebuild and reorganize the index.
• Worked on managing Lock, Block, and deadlocks.
• Performed Database administration including monitoring and tuning, job automation, maintenance task, backup recovery, analyze database performance.
• Created and Managed Jobs, Setup Alerts, SQL Mail Agent and Scheduling SSIS Packages.
• Implemented SQL Server security and Object permissions.
• Implemented TDE, and closely worked with System Admin to setup IPSec and SSL.
• Installed, Configured, Developed and administered SQL Server Reporting Services (SSRS).

Environment: SQL Server 2012, 2008 R2, 2005, Windows server 2012, 2008 R2, 2003