SUMMARY:

• Over 6 years of strong professional experience in Information technology as a Microsoft Certified MSSQL server Database Administrator on Production, Development, Test, UAT and Cloud environment with details oriented, Supporting, Managing and Troubleshooting skills.
• Additionally, possess extensive knowledge and experience in design, configuring, administering and maintaining SQL Servers 2008R2, 2012, 2014, 2016, 2017 version with different editions. Also have the strong ability in Database Management, Installation, Configuration, Designing Databases, Managing server and Database security, Backup and Restore, HA & DR solutions like AlwayOn, Clustering, Mirroring, Log shipping, upgrade and migrate database, Performance tuning, managing Lock, Block, SQL & T - SQL queries, Apply SP & Hot fix, Proactive monitoring, and handling complex production issues.
• Excellent knowledge and experience on using all native and third-party tools like Idera, EMC AppSync, DDBoost, Data Domain, SolarWind, ServiceNow, RedGate, ERwin for database development and administration which include Data Modeling, writing store procedures, index, functions, views, joins.
• I have strong background of working on high-end servers, would like to establish a fulfilling proactive career and looking to contribute my skills in the best possible way for achieving the company's goals.
• Have solid working experience as a Database Administrator in MSSQL Server (2017/2016/2014/2012/ 2008 R2) in Prod, Dev and Test (Clustered, Stand Alone, and VM Servers) Environments.
• Strong professional knowledge and experience on Advanced Installation and Configuration, Monitoring, Health Check and Maintenance with troubleshooting capabilities.
• Extensive work experience in TempDB configuration, Table Partitioning, shrinking, compression,
• Broad experience in applying latest Service Packs, patches, and hotfixes
• Good experience in configuring Database mail and automation of administrative tasks such as Maintenance plans, Database refresh, Scrubbing, Auto PMI and Alerts using SQL Server Agent
• Performed Scheduled jobs to automate different database related activities including backup, backup verification, monitoring database health, disk space, Memory, and CPU.
• Strong knowledge and experience in capacity planning and implementing disaster recovery solutions- database Backup, Restore, Point-in-Time Recovery in accordance with RTO and RPO guidelines.
• Hands on experience in Designing, implementing, configuring, monitoring, and administering Always on SQL Server 2012/2014/2016
• Decent experience in Configuring & Managing SQL Server Fail-Over Clustering on Physical and VMware instance
• Installed, Configured and Maintained Database Mirroring using automatic Fail-Over in SQL Server
• Configured Log Shipping as Standby Database from Production database for Reporting purposes
• Configure and Maintain Transactional Replication
• Proven experience in the areas of Troubleshooting, Performance Tuning, Monitoring Server and Database activities, disk space Utilization, lock, block, deadlock, index management, slow running queries using different Native and Third-party tools and DMVs, DMFs, and DBCC commands.
• Have strong experience on Query Optimization, Execution Plan, Live Query Stats, SQL Server Profiler, Extended Events, Database Engine Tuning Advisor, Performance Monitor, Activity Monitor
• Have solid experience with different types of Index Creation, Modification and Rebuild, Statistics updates, Writing Stored Procedures.
• Created and Managed users, roles, security at object and Schema level. Managed Server and Database Level Permission for individual and group service accounts.
• Configure and maintain Transparent Data Encryption (TDE) on Server and Database Level.
• Experienced in implementing SQL Server security, managing users, granting/revoking access, Role based Security, Dynamic data masking, Row Level Security, Security auditing, and monitoring to comply with Microsoft and industry best practices.
• Implemented Server Audit Specification on Dev\UAT Environment. Created Audit folder and grant full control to it. Experience on STIG to hardening the system.
• Experienced in upgrading SQL Server (2005/2008/2008 R2) instances to SQL Server 2012/2014/2016 .
• Migrate Database from Oracle 10g/11g, MySQL to SQL Server 2012/2014.
• Migrated on Premise SQL Server Database to SQL Database in Azure Cloud (IAAS and PAAS).
• Export & Import data from Excel File, Flat file, CSV file to/from SQL Server Database and Vice Versa.
• Great working experience in Install, Configuring and administering SQL Server Reporting Services
• Developed, Deployed, and Managed Reports using SSRS and Report Builder 3.0/2.0
• Managed Security for Reports and Reporting Server.
• Installed, Configured, and Administered SQL Server Integration Services (SSIS), Data Tools.
• Skilled in ETL Operations, Batch Process, Developed and Deployed SSIS Packages using DTS, BIDS, SSDT, Managed Security for SSIS package. Developed Data Warehouse using SSAS
• Having excellent experience in SQL Server and Database Architectures, Database Design, Data Modeling using Normalization and E-R Diagram.
• Expertise in need assessment, Backward and Forward Engineering, Conceptual, Logical and Physical data Modeling using Erwin/Toad Data Modeler and Native Tools.
• Competent in writing T-SQL batches and developing Stored Procedures, User Defined Functions, Triggers, SQL joins, Views, Sub-queries.
• Proficient in TSQL Scripting for creating, modifying tables, Index (Cluster/Non-Cluster), Constraints.
• Efficient in execute PowerShell scripting to run automatic Jobs.
• Have strong knowledge and working experience in Operating Systems (O/S) - Windows Server 2008 R2, Windows Server 2012 R2 and Active Directory Domain Services.
• Installed, Configured VMware and Managed Database Instances in Virtual Environment.
• Worked with Team Foundation Server (TFS)
• Establishes and builds strong working relations and partnerships with Business Units and Senior Management
• Having excellent verbal, written and presentation skills, Independent problem solving, team player, proactive, multi-tasking and prioritizing skills, detail oriented and excellent interpersonal skills
• Administer and monitor 24/7 applications and systems, developing automated alerts to warn of failure

TECHNICAL SKILLS SUMMARY:

Operating System: Windows Server 2016, 2012R2, 2012, 2008R2, Windows 10/7

Databases Management System: SQL Server 2017/2016/2014/2012/2008 R2/2005, MS Access and MySQL.

Database Design & Data Modeling: Normalization, ER-Diagram (ERD), ERWin, Toad Data Modeler, SSDD (SQL Server Database Diagram)

ETL & Data Warehouse: SSDT/BIDS, SSIS/DTS, BCP, Import/Export Wizard, Visual Studio

Reporting Tools: SQL Server Reporting Service (SSRS), Report Builder (3.0,2.0).

SQL Native Tools: Activity Monitor, Performance Monitor, Extended Events, SQL Server Profiler, Database Tuning Advisor, Execution Plan, Job Activity Monitor, Built-in Standard Reports, DBCC, DMVs, DMFs, SQL Server Configuration Manager, Statistics, Query Store, SSMS

Third-Party Tools: IDERA, EMC AppSync, RoyalTS, Service Now, Red Gate, SolarWinds, DDBoost, Splunk, Remedy

Languages: SQL, T-SQL, DML, DDL, Visual Basic, PowerShell

Upgrade/Migration: SQL Server to SQL Server, Oracle to SQL, MySQL to SQL, SQL to Azure Database, MS Access/Excel to SQL Server, SSMA, DMA

Networking: Active Directory, Setup TCP/IP, IPSec, SSL, Setup DNS Server, Create User and Authentication, Adding Host computer under Domain Controller.

Hardware/Storage: SAN, NAS, RAID, iSCSI, Dell EMC

Virtualization Technology: VMware Workstation, Virtual Box (installation, configuration & maintenance) on Windows Multipoint Server.

Cloud: Configure, Manages and Migration from On-premises Server to Azure database & SQL Server on Azure Virtual machine

PROFESSIONAL WORK EXPERIENCES:

Confidential, Dallas, TX

MSSQL - Database Administrator

Responsibilities:

• Worked as Production Support DBA to Supports day to day operational activities for the database platform like health checks, Implementation and Deployment, DDL & DML operation, managing Security for server and Database level, application developers, business analysts and users overseeing SQL Server 2012 to 2016 on a very large scale Dealing with service requests tickets, C-Task, Incidents through Service-Now.
• Installed, Configured, and Maintained SQL Server 2017, 2016, 2014 and 2012 in Development, Test, UAT and Production Environment.
• Provides Database assistance and problem support to application developers, business analysts and users overseeing SQL Server 2012 to 2017 on a very large scale
• Configured, Managed and Troubleshoot SQL Server Failover Clustering with multiple FCI as HA solution on SAN using RAID levels.
• Broad experience in Configured, managed, and monitored SQL Server Transactional & Snapshot Replication using Replication Dashboard and troubleshooting replication agent jobs, latency
• Performed performance tuning to improve the performance for Server, Database by optimize and troubleshoot or modifying SQL/TSQL long running queries, Store procedure, create Index, rebuild & reorganize Index,
• Used different Native and Third-Party tool like Execution Plan, SQL Server Profiler, Extended Events, Query Store, Standard Reports, Database Tuning Advisor, SolarWinds, Activity Monitor for Performance Related monitoring and Troubleshooting.
• Experienced in using DBCC commands, DMVs, DMFs and custom SP to monitor the server health, database consistency, diagnose and resolving Lock, Block, Dead locks issue, SQL server Memory and TempDB uses.
• Monitoring System performance like High CPU and memory bottlenecks, I/O, processes wait-time, response time, physical memory, and space availability.
• Proficiently worked on T-SQL scripting, Table Partitioning, creating and modifying Tables, Index (Cluster/Non-Cluster), Views, Stored Procedures, Triggers, Constraints and variables,
• Have used TFS and CMS to deploy Changes and implementation in different environments.
• Experienced in maintaining and supportingVery Large Database more than 5 TB
• Developed, Implemented & Managed DR (Disaster Recovery) Solutions by Performed regular backups, restores and worked on Database refresh for prod/test/dev environments including mission critical database by using Native and third-party tools.
• Designed and Implemented RPO, RTO and SLA, Setup Retention Policy, Backup Verification. Point-in-Time Recovery,
• Creating, monitoring and troubleshooting SQL Jobs, Alerts, Maintenance plan in SQL Server.
• Responsible for Monitored Server Activity, Error Log, database health, cleaning history and solving problem as needed
• Applied SP (Service Pack) and hot fix on SQL Server on a routine maintenance work
• Worked on annual data archive project.
• Implemented & Managed Database and Data Security Solutions, TDE (Transparent Data Encryption), Row Level Security, Dynamic Data Encryption, Role based Security Policy.
• Responsible for Managed User Privileges, Securing SQL Server, Creating and granting permissions on various Objects on server and database level.
• Provides support in Capacity planning, forecasting database growth, Database Designing and Configured Linked Server
• Performed database/infrastructure logical, physical design, and configured storage for data and log files, Backward and Forward Engineering, Creating E-R Diagram.
• Export & Import data from/to Excel File, Flat file, and MS Access to/from SQL Server databases
• Provide technical leadership to Upgrade SQL Server 2012 instances and databases to 2016
• Managed Client Requests and Provide ON Call Support.

Environment: Windows Server 2016,2012, 2008r2, SQL Server 2017, 2016, 2014, 2012, 2008r2, AD, CyberArk, Idera, DDBoost, EMC AppSync, Data Domain, PagerDuty, Beyond Compare, RoyalTS, Entrust, Outlook, PowerShell, ASP and ASP.net. Service-Now, Loop up, TFS, SharePoint, Cisco, WebEx, SolarWinds, Redgate, Visual Studio 2015, ETL Processing.

Confidential, Arlington, VA

SQL Server Database Administrator

Responsibilities:

• Responsible for Supports day to day operational activities for the database platform like service requests and tickets, monitoring, performance tuning, troubleshooting performance issue
• Worked as Production Support DBA overseeing SQL Server 2008R2 to 2016 on a very large scale Provides Database and problem support to application developers, business analysts and users
• Installed, Configured, and Maintained SQL Server 2016, 2014, 2012 in Development, UAT, Production Environment, On Premises, Cloud Environment and VM Machine.
• Decent experience in Configured and Maintains AlwaysOn Availability Group using SQL Server 2016/2014/2012 with Synchronous Asynchronous automatic-failover mode.
• Configured, managed, and monitored Transactional Replication and Log Shipping.
• Performed performance tuning to improve the performance for Server, Database by optimize and troubleshoot or modifying SQL/TSQL long running queries, Locks, Blocks, and Dead locks.
• Proficiently worked on T-SQL scripting, Table Partitioning, creating and modifying Tables, Index (Cluster/Non-Cluster), Views, Stored Procedures, Triggers, Functions, Constraints and variables,
• Used different Native and Third-Party tool for Performance Related monitoring and Troubleshooting purposes like Execution Plan, SQL Server Profiler, Database Tuning Advisor, Activity Monitor
• Experienced in using DBCC commands, Query Store, DMVs and DMFs to monitor the server health, database consistency, diagnose problems, and performance tune
• Experienced in maintaining and supportingVery Large Database more than 3 TB
• Developed, Implemented & Managed DR (Disaster Recovery) Solutions by Performed regular backups, restores for prod/test/dev environments including mission critical database.
• Implemented & Managed DR (Disaster Recovery) Solutions according to RPO, RTO and SLA, setup Retention Policy, Backup Verification. Point-in-Time Recovery, jobs, Alerts, Notification with Maintenance plan in SQL Server.
• Install, configure and use Third party backup and monitoring tools such as Red Gate
• Responsible for Monitored Server Activity, Error Log, database health, space usage, cleaning history and solving problem as needed
• Worked on Database refresh in Dev/Test servers with PROD data and reinstate the server
• Managed Security User Privileges Granting/deny/revoke access server and database level Implemented & Managed Database and Data Security Solutions
• TDE (Transparent Data Encryption), Row Level Security, Dynamic Data Encryption, Role based Security Policy Provides support in capacity planning, forecasting, and Database Designing
• Provide Production Support and Deploy Changes/SPs/Queries in Production Environment
• Performed database/infrastructure logical, physical design, and configured storage for data and log files, Backward and Forward Engineering, Creating E-R Diagram.
• Provide technical leadership to Upgrade SQL Server 2008 and 2008R2 instances and databases to 2012/2014/2016 and Migrate Database from Oracle 10g/11g, MySQL to SQL Server 2012/2014
• Setup, Configure, & Manage Azure SQL Database Instances on Azure VM Machine
• Installed and Configured SQL Server Services (SSRS), Developed, Deployed and managed Reports, Upgraded and Migrated Reports and Reporting Server, Managed Security for Reports and Server
• Installed and Configured SQL Server Integration Services (SSIS), Developed & Deployed SSIS packages to perform various ETL operations, Managed Security for SSIS Packages
• Managed Client Requests and Provide on Call Support.

Environment: Windows Server 2012, 2008R2, 2003R2 IIS 7.5, 6.5, SQL Server 2016, 2014, 2012, 2008R2, AD, ServiceNow, TFS, ASP and ASP.net, Visual Studio 2010/2015, Visio, SharePoint, WebEx, SolarWinds, Idera, RedGate, My SQL, ETL Processing.

Confidential, Mahwah, NJ

SQL Server DBA

Responsibilities:

• Worked for the UPS’s SQL Team where my primary focus on performance tuning, troubleshooting and in-depth root cause analysis (RCA) for database related issues.
• Hands on experience on Monitoring performance tuning, troubleshooting long running queries, locks, deadlocks and performance issue, jobs, Upgraded/Migrated SQL Server 2005/2008 to SQL Server 2012 and Transferred Logins, Data and Log files, backup files, and Jobs for side-by-side Upgrade/Migrate
• Installed, Configured and maintain SQL Server 2005, 2008 R2, 2012, in Dev, Test, and Production Environment
• Applied SP/Hot Fixes on SQL server Instances to address Security and upgraded related issues
• Worked on Database refresh in Dev/Test servers with PROD data
• Configured, Monitored and troubleshoot Mirroring with Automatic Fail-Over and Replication (Transactional)
• Optimized the databases by troubleshoot SQL Server slow running queries /Stored Procedures/Views, creating various clustered, non-clustered indexes, Rebuilding the indexes at regular intervals for better performance.
• Fine Tune and improve Database Performance using SQL Server Profiler, Execution Plan, DMV, DBCC, Activity Monitor, extended event and system SP
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification and Analyzed Failed Jobs and Provide resolutions
• Developed, maintained and implemented database backup and recovery plans for Production Managed Backup/Restore, Point-in-Time Recovery including backup verification
• Responsible for securing SQL Server environment, involved in creation and granting permissions on various Objects, created the guideline to secure SQL Servers, Data Encryption for data security in Database
• Monitored Server Activity, Error Log, space usage, database health, backup verification, cleaning history and solving the problem as needed
• Developed and deployed SSIS Packages from different sources like SQL Server Database, Flat file, CSV, Excel and Export & Import data from the Flat file (CSV, Excel) to SQL Server Database
• Migrated SSIS Packages from SQL Server 2005 to SQL Server 2012
• Installed, configured and deployed SSRS reports from BIDs/SSDT. Provided access to SSRS reports.
• Configured Linked Server
• Provided 7 x 24 Production support for the database and application issues

Environment: SQL Server 2005, 2008R2, 2012, IIS 7.5 Windows Server, 2003R2, 2008R2, 2012 ASP, ASP.net, Java, AD, PeopleSoft Application, Oracle, My SQL, Service-Now, OpNet, and SQL SentryOne, SSIS, SSRS, MS Excel, MS Access