SUMMARY:

• A Microsoft Certified Professional with around 7 years of professional working experience as SQL Server Database Administrator (DBA).
• Supporting, managing and troubleshooting experience in SQL Server instances and databases in different environments like (Development/Test/UAT and Production) in On - Premises as well as Azure and AWS Cloud Environment.
• Possess strong knowledge and experience in configuration, administration and maintenance of SQL Servers 2008/2008R 2/ 2012/2014/2016 versions with different editions.
• Experts in Database Management, Administration and development including installation, configuration, backup, restoration, HA/DR solution like Replication, AlwaysOn Availability Group, Clustering, Log shipping, Mirroring, upgrading, migration, apply patches/ Patch Management, troubleshooting, supporting clients, Database Monitoring, Performance Tuning, managing Locks, Blocks, and Deadlocks, Ensure Server & Database Security.
• Excellent knowledge and experience in Database Development and Business Intelligence, which includes Data Modeling, SSIS, SSRS, SQL, TSQL, Writing Stored Procedures, Functions, Joins, Cursors, triggers, views, Constraints, and writing, Deploying and Managing SSIS Packages for ETL and writing, Deploying and Managing SSRS reports and including SSRS reporting Server and Data Sources. Experience on third party Tools DDBoost, MS VISIO, ServiceNow and Erwin. 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

SUMMARY OF EXPERTISE:

• Have solid professional knowledge and experience on Advanced Installation and Configuration of SQL Server, Monitoring and Health Check, Reporting, and Maintenance with troubleshooting capabilities.
• Have Strong working experience as a Database Administrator in MS SQL Server (2016/2014/2012/ 2008 R2/ 2008/ 2005) in Prod, Development and Test (Clustered, Stand Alone, Cloud and VM Servers) Environments
• Extensive work experience in applying high availability solutions and apply latest Service Packs, patches, and hotfixes
• Good experience in automation of administrative tasks such as Maintenance plans, Jobs, and Alerts using SQL Server Agent
• Proven experience in the areas of Troubleshooting, Performance Tuning, Monitoring Server & database health, disk space Utilization, query optimization, lock, block, deadlock, index fragmentation, slow running queries using execution plan and other native and third-party tools
• Have solid experience with Index Tuning, Index Creation and modification
• Have Strong work experience on DMVs and DMFs and DBCC commands
• Configure and maintain Transparent Data Encryption (TDE) on Server Level and Database level
• Experienced in implementing SQL Server security, Managing users, granting/revoking access, data masking, auditing, and monitoring to comply with Microsoft and industry best practices
• Managed Server, Database, Object, Role, and Schema Level Permission for individual and group service accounts
• Hands on experience in configuring, monitoring, and administering ‘Always On’ on SQL Server 2012/2014/2016
• Configured WSFC Clustering in VMware Environment and Installed FCM and SQL Cluster
• Hands on experience configuring different types of Replication using Publisher, Distributor and Subscriber server and syncing data between them
• 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
• Strong knowledge and experience in implementing disaster recovery solutions- database Backup, Restore, and Point-in-Time Recovery in accordance with RTO and RPO guidelines.
• Installed, Configured, and administered SQL Server Integration Services (SSIS)
• Skilled in ETL Operations, Export & Import data from Excel File, Flat file, CSV file to/from SQL Server Database using SSDT
• Developed, deployed and implemented security for SSIS Packages
• Configured and automated SQL Server Agent jobs using SSIS packages
• Experienced in upgrading SQL Server (2005/2008/2008 R2) instances to SQL Server 2012/2014/2016
• Migrate Database from Oracle 11g, MySQL to SQL Server 2012/2014
• Export & Import data from My-SQL and Access databases to SQL Server and Vice Versa
• Having excellent experience in SQL Server and Database Architectures
• Have wide knowledge and experience in Database Design and Development, and Data Modeling using Normalization and ERD Diagrams
• Expertise in need assessment, logical/physical database design, reverse/forward engineering using Erwin/Toad Data Modeler and native tools
• Proficient in writing T-SQL batches and developing Indexes, Stored Procedures, User Defined Functions, CTEs, Triggers, SQL joins, Views, Cursors, table variables, sub-queries
• Have Basic knowledge on PHP, DHTML/HTML and PowerShell.
• Installed, Configured, and Managed Azure SQL Database Instances in VM Machines
• Migrated On-Premises Database Servers and Data to Azure SQL VM and Azure SQL Databases
• Configured and automated on-premises SQL jobs in Azure environment using on-premise linked servers
• Configured and managed hybrid Architecture Like: Always On and add Secondary replica from On-Premises server to SQL Server on Azure VM machine
• Deployed and managed Active and Standard Geo-replication for Azure SQL Database.
• Installed, Configured and managed SQL Servers and databases in AWS EC2 instances
• Migrated on premise SQL Databases to AWS RDS SQL databases using DMS (Data Migration Services)
• Used Export-Import wizard, BCP tool and database scripting wizard to migrate the database schema and data from on-Premise server to Amazon RDS SQL database.
• Implemented Transparent Data Encryption (TDE) on RDS SQL databases
• Implemented Secure Socket Layer (SSL) to encrypt the data travelling from database server to application on RDS SQL databases
• Configured and managed hybrid high availability solution between on-premise and Amazon Cloud instances
• Created different SQL Server maintenance plans and automated them in AWS environments
• 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
• Worked with Team Foundation Server (TFS)

TECHNICAL EXPERTISE:

Databases Experience: SQL Server 2016/2014/2012/2008/2005 , MS Access and MySQL, PostgreSQL

Upgrade/Migration: SQL Server to SQL Server, Oracle to SQL, MySQL to SQL, SQL Server to Azure Database, SQL Server to RDS (AWS), Excel to SQL Server, SSMA, DMA, DMS

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

SQL Native tools: Activity Monitor, Performance Monitor, Extended Events, SQL Server Profiler, Database Tuning Advisor, Execution Plan, Job Activity Monitor, Built-in Standard Reports, BIDS/DTS, DMVs & DMFs, DBCC, SQL Server Configuration Manager, Live Query Statistics, Query Store, SSMA, DMA

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

Azure Expertise: Configuration, Manages and Migration from On-premises Server to Azure database & SQL Server on Azure Virtual machine.

AWS Expertise: Configuration, Manages and Migration from On-premises Server & Databases to AWS Ec2 instance & RDS databases

Languages: SQL, T-SQL - DDL, DML, DCL, TCL, Visual Basic, HTML, PowerShell6

Database Connectivity: ADO.NET, OLEDB, ODBC Connection

ETL/Data Warehouse Tools: SQL Server Integration Services (SSIS), SSDT, Export/Import Wizard, DTS, BCP

Reporting: SQL Server Reporting Services (SSRS), Report Builder 3.0/2.0

Data Modeling Tools: SQL Server Data Diagram (ER-Diagram), Erwin, Toad Data Modeler, MS VISIO

Third party tools: DDBoost, SCOM, SolarWinds, Remedy, ServiceNow

Networking & Security: Active Directory, Setup TCP/IP, Setup DNS Server, Shared Memory, User and Authentication, IPsec, SSL.

Hardware/Storage: SAN, RAID, ISCSI

PROFESSIONAL EXPERIENCE:

Confidential, Owing Mills, MD

Database Administrator

Responsibilities:

• Worked for the CareFirst’s SQLDBA Team where my primary focus was on securing database and servers, migrating SQL Servers, configuring High Availability structures, troubleshooting and in-depth root cause analysis (RCA) for database related issues.
• Installed, Configured, and Maintained SQL Server 2016, 2014 in Development, UAT and Production Environment on Premises and Cloud Environment
• Implemented Secure Socket Layer (SSL) certificate to encrypt the connection to the database servers from user and application
• Configured &Managed Database and Data Security Solutions applying TDE (Transparent Data Encryption), Row Level Security, Column level encryption, Dynamic Data Encryption, Role based Security Policy, Security Auditing
• Created server logins, database users, custom database roles, assigned users to specific roles and ensured only the required privileges are granted to the users
• Applied SP (Service Pack)/ Hot Fixes on SQL Server Standalone Instances to address security and upgraded related issues
• Configured SQL Server Transactional Replication between Publisher and Subscriber server
• Troubleshoot the data synchronization issues between Publisher and Subscriber servers in Replication environment.
• Configured & Managed HA (High Availability) Solutions including monitoring and troubleshooting database Log Shipping, AlwaysOn and SQL Clustering.
• Managed Fail-Over Clustering and AlwaysOn using SQL Server 2014 and 2016
• Installed Service pack, cumulative updates and patches in AlwaysOn and Fail-Over Clustering instances
• Implemented &Managed DR (Disaster Recovery) Solutions according to RPO, RTO and SLA, setup Retention Policy, Backup Verification
• Designed and Implemented Backup Strategies for Development, UAT, Production Instances and Databases to reduce storage consumption
• Upgraded third party backup application DDBoost on all Production, Dev/Test servers and change the storage server directory
• Developed, & implemented database maintenance plans like, Index rebuild or re-organize, update statistics.
• Designed and Implemented Point-In-Time Recovery Strategies
• Perform Database Refresh and Implement Data Masking for Development and Test Environment
• Performed performance tuning for TSQL codes having poor performance
• Monitored Server and Database Activity, Error Log, space usage, database health, backup verification, cleaning history and solving problem as needed
• Troubleshoot performance issues related to query optimization, tempdb, log file growing fast, identify and release Lock, block and deadlock
• Used SQL Server Profiler, Extended Event, Database Engine Tuning Advisor, Performance Monitor, and Activity Monitor to analyze and monitor performance of the system.
• M igrated On-Premises Database Servers and Data to Amazon AWS Ec2 Instances and RDS SQL databases
• Used Data Migration Services (DMS) and Export-Import wizard to migrate data between On-Premise SQL Server and RDS SQL databases
• Implemented SSL encryption on RDS SQL database instance for securing data on transit
• Implemented Transparent Data Encryption (TDE) on RDS SQL databases
• Perform Migration of SQL Server 2008 R2, and 2012 R2 Database to SQL Server 2014, 2016
• Installed and Configured and administered SQL Server Reporting Services (SSRS)
• Installed and Configured SQL Server Integration Services (SSIS)
• Developed, Deployed and Configured automated SQL Server jobs using SSIS Packages
• Exported, Imported data from SQL Server to Text file, Excel file and CSV format using SSIS packages and also BCP tool and vice versa.

Work Environment: Windows Server 2016, 2012 R2, 2008 R2, IIS 7.5, 6.5, SQL Server 2016, 2014, 2012, 2008 R2, TDE, SSL, AWS Cloud (Ec2 & RDS), DDBoost, SCOM, ServiceNow, SharePoint, Visual Studio 2013/2015, SSDT, BCP

Confidential, Arlington, VA

SQL Server Database Administrator

Responsibilities:

• Worked for the Confidential ’s SQL Team where my primary focus on performance tuning, troubleshooting and in-depth root cause analysis (RCA) for database related issues.
• Installed, Configured, and Maintained SQL Server 2016, 2014, 2012 in Development, UAT and Production Environment on Premises and Cloud Environment
• Applied SP (Service Pack)/ Hot Fixes on SQL Server Instances to address security and upgraded related issues
• Implemented & Managed HA (High Availability) Solutions including monitoring and troubleshooting database Log Shipping, AlwaysOn and Clustering.
• Configured database Replication as Merge and Transactional Replication between Publisher and Subscriber servers.
• Resolved any data synchronization issues in Replication environment and ensured data is syncing up to real time.
• Implemented &Managed DR (Disaster Recovery) Solutions according to RPO, RTO and SLA, setup Retention Policy, Backup Verification
• Designed and Implemented Backup Strategies for Development, UAT, Production Instances and Databases
• Developed, & implemented database maintenance plans
• Designed and Implemented Point-In-Time Recovery Strategies
• Perform Database Refresh and Implement Data Masking for Development and Test Environment
• Configured &Managed Database and Data Security Solutions applying TDE (Transparent Data Encryption), Row Level Security, Column level encryption, Role based Security Policy, Security Auditing
• Performed both auditing in SQL Server and Database level to ensure the security of the data
• Wrote T-SQL scripts, Views, Triggers, Stored-Procedures, Functions and also TSQL Scripts for creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check)
• Performed performance tuning for TSQL codes having poor performance
• Monitored Server Activity, Error Log, space usage, database health, backup verification, cleaning history and solving problem as needed
• Used SQL Server Profiler, Extended Event, Database Engine Tuning Advisor, Performance Monitor, and Activity Monitor to analyze and monitor performance of the system.
• Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance purposes as well
• M igrated On-Premises Database Servers and Data to Azure SQL VM (IAAS) and Azure SQL databases (PAAS)
• Configured and automated on-premises SQL jobs in Azure environment using on-premise linked servers
• Hands on experience using Data Migration Assistant (DMA) tool to migrate schema and data from on-premise databases to Azure SQL VM and Azure SQL Databases
• Perform Migration of SQL Server 2005, and 2008 R2 Database to SQL Server 2012, 2014
• Perform Migration of MS Access 2010 databases into MS SQL Server 2005 and 2008R2
• Installed and Configured and administered SQL Server Reporting Services (SSRS)
• Exported and Imported data from SQL Server database to Text file, Excel file and CSV format using Export-Import wizard and SSDT tool
• Configured automated jobs using SQL Server Agent by Integration Services (SSIS) Packages.
• Installed and Configured SQL Server Integration Services (SSIS), Developed, Migrated and Managed security of SSIS Packages

Work Environment: Windows Server 2012, 2008 R2, IIS 7.5, 6.5, SQL Server 2016, 2014, 2012, 2008 R2, Azure VM, Azure SQL, Oracle 10g, ER-Win, SolarWinds, Remedy, SharePoint, ASP, Visual Studio 2010/2013, SSDT

Confidential, New York City, NY

Database Administrator

Responsibilities:

• Migrated SQL Server 2005 and 2008 to SQL Server 2008 R2 and 2012
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Applied SP (Service Pack) on SQL Server 2008R2 and 2012 in Clustered Environment
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
• Expertise in T-SQL writing stored procedures, triggers and functions.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Experience in Disaster Recovery Planning and Security Management operations.
• Proficiency and expertise in Backup/Recovery, Disaster recovery and planning.
• Having hands on experience in DR processes including Log shipping and Database Mirroring.
• Configured, managed, and monitored Peer to Peer, Transactional Replication and Merge replication.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN
• Having Experience on Data center servers and handling over 1.4 TB databases.
• Troubleshoot performance problems, fine-tuning of databases, queries and index Analysis.
• Handling Memory configurations for SQL Server 2012, SQL Server 2008 R2 on Windows Server 2012.
• Experience in mentoring team members and writing documentation.
• Managed Client Requests and Provide On Call Support.

Environment: Windows Server2012 R2, 2008 R2, IIS, SQL Server 2014, 2012, 2008 R2, TDE, SharePoint, OPNET, MSVISIO, ServiceNow