SUMMARY:

• Microsoft Certified SQL Server Database - Administrator (DBA) strong knowledge on SQL Server Installation, Configuration, Data Modelling, Backup-Restore, Disaster Recovery, Monitoring, Troubleshooting, Performance Tuning, Query Optimization, Replications, AlwaysOn, Mirroring, Clustering, Log-Shipping and proficient in writing SQL/T-SQL scripts - Stored Procedures, Functions, Triggers, Constraints, and Views. I have in-depth knowledge and experience with Database Security, Encryption, TDE (Transparent Data Encryption), and Column level Encryption, Dynamic Data Masking, Creating login and giving permissions in SQL server and Active Directory. Also hands-on experience in native tools such as Execution Plan, Profiler, Extended Event, Database Tuning Adviser, and ER-Diagram. Third party tools like RedGate, Idera, SolarWinds, Spotlight, and ERWin. Hands-on experience in SSIS, SSRS, SSAS, and Data Migration Using SSMA for Oracle to SQL, MySQL to SQL,DB2 to SQL Server, also managing Very Large Databases (VLDB)
• I have communication/social skills and the ability to manage multiple complex projects having innovated. Also I am a creative problem solver, results oriented. Experienced with Software Development Life Cycle (SDLC) such as requirement gathering & analysis, design, development, testing, implementation, & maintenance. Have excellent knowledge on in place and side-by-side migration.
• Besides that I also hold hands on experiencing Operating Systems (Windows 2012R2, 2008 R2, and 2003) and maintain Active Directory.
• Self-motivated, team player with excellent verbal, written, and communication skills with business analysis and technical knowledge.

TECHNICAL SKILLS:

Databases: SQL Server 2016, 2014, 2012, 2008, 008r2, 2005, 2000.

Windows Server and Active Directory: Experience in administering Windows Server 2012r2, 2008, 2003 r2, AD (Active Directory), Domain, DNS, File server, Monitoring user activities, and VMware.

SQL Server Tools: SQL Server Management Studio (SSMS), Execution Plan, Activity Monitor, Extended Event, SQL Profiler, Database Tuning Advisor, Index Tuning Wizard, Query Analyser, BCP, SQLCMD, Upgrade Advisor, SQL Configuration Manager, Client and Server Network Utilities, and Surface Area Configuration. Business Intelligence Development Studio(BIDS)

Third Party Tools: Idera, SolarWinds, ERWin, and Toad for SQL Server Admin.

Programming: SQL, T-SQL, Scripting, debugging, and improved performance stored procedures, Functions, View and Triggers.

Performance Tuning: Server Optimization and Performance Tuning, Query Optimization, Experience in resolving lock, block, Dead Locks or long/slow running Task Manager, Performance Monitor, Activity Monitor. Tune the performance using different Tools - Execution Plan, Profiler, Extended event, Database Tuning Advisor, DMV, and SolarWinds Diagnostic tool.

Database High Availability: Strong knowledge/experience in configuring and administering High Availability Database Solutions like AlwaysOn, Replication, Clustering, Mirroring, and Log-shipping Database.

Backup/Recovery: Strong knowledge and working experience in Database Backup and Disaster Recovery. Experienced with Point-in-Time Recovery. Restored Database from backup.

Security: Experience with Security and Audit Management like Security, Encryption, TDE (Transparent Data Encryption), Column level Security, Dynamic Data Masking, AES, and 3DES.

Creating Login and User: Creating login and giving permissions in SQL server and Active Directory based on Server level, Database level and object level.

Upgrade/Migrate: Migrated Oracle, MySQL, Sybase to SQL Server and Upgraded databases from MS SQL Server 2005, 2008 R2, 2012 to higher version, SQL to Azure.

Application Server: Administered IIS application server, and deployed applications.

Service Pack: Applied Service Pack (SP) and Hot Fixes for Standalone, Clustering, AlwaysOn Instances, and Operating Systems.

Azure SQL: Create databases, Create Storage and container, Migration data to Using Data-tier Application Export and Import (BACPAC), by Generating a Script, DMA, create Azure VM machine, and Azure SQL Data Sync.

Reports Development/Management: Report Development, deploy, manage, migrate, and upgrade reports and Report Server. Strong expertise on configuring and developing report using BIDS (Business Intelligence Development Studio), SSDT (SQL Server Data Tools), and Report Builder.

Data Modelling: ERWin, SSDD (SQL Server Database Diagram).

SQL Scripting/Web Technologies: SQL, T-SQL, PowerShell, HTML, VBScript, ASP, .Net Technologies: VB. NET, and ASP.NET.

Dot Net Technologies: .Net Technologies: VB. NET, and ASP.NET.

Development Tools: Visual Studio (VB), Visual Studio2010/2012, 2015, 2017, BIDS, and SSDT.

VMWare/Virtual Box: Knowledge and experience of Installing, and working on VMWare/ Virtual box.

PROFESSIONAL EXPERIENCE:

Confidential, MD

SQL Server Database Administrator

Responsibilities:

• Database Administration and Managing Development, Test and Production Servers/Instances and Databases.
• Upgraded SQL Server 20 R2 Databases into SQL Server 2012, 2014, and 2016.
• Applied Service Pack (SP) and Hot Fixes stand-alone and clustering environment, and in AlwaysOn servers.
• Migrated MySQL and Oracle Databases into SQL Server 2012 and 2014.
• Database High Availability:
• Installed, Configured, and Managing Database AlwaysOn, Clustering, Replication, Mirroring, and Log Shipping.
• Installed, Configured and Maintaining Fail-Over Cluster Servers in SQL Server 2008, 2008 R2, 2012 & 2014.
• Used DBCC and ALTER statements to check and manage database consistency, index fragmentation/reorganizing/rebuilding, and update statistics.
• Monitor and resolve deadlock for client issues. Troubleshooting connectivity issues, Permissions etc.
• Monitoring SQL server performance using Activity Monitor, profiler to find performance.
• System performance monitoring by I/O, processes wait-time, response time, physical memory, network bandwidth with traffic, connection conjunction, and space availability.
• Memory allocation, table partitioning, adding devices, and moving data for better performance.
• Monitoring, Troubleshooting Instances, Databases, and Queries using different tools.
• Query Execution plans, Profiler, Database Tuning Advisor, PerfMon /Task manager, Activity Monitor, Server Logs, Agent Logs and Error Logs, Event Logs, DMV (Dynamic Management View), Maintain Indexes, and Statistics Management.
• Database Automation:
• Created Backup jobs for different types of backups like FULL, Differential and Transaction Log.
• Created Jobs for database maintenance Index fragmentation, reorganizing/ rebuild, and database statistics.
• Data Modelling:
• Worked on different Data Modelling projects including ERWin Modeller on designing Logical & Physical Database.
• Index/Constraints:
• Created and managed Indexes (Cluster/Non-Cluster), and Constraints.
• Security Management:
• Created and Managed login, roles, security at object level, data encryption, TDE and Dynamic Data masking.
• Repo ETL Tools: Used ETL tools like DTS, SSIS, SSAS, Creating SSIS package, Deploy the package in different source and Import/Export, BCP (Bulk Copy), to import & export data from flat files, and excel to MS SQL Server databases.
• Reports:
• Installed, Configured, and administered SQL Server Reporting Services (SSRS.)
• Developed Reports using SSRS.
• Developed Ad-hoc Reports using Report Builder.
• Deployed Reports and managed security for reports.

Work Environment: AWS, Azure SQL, SQL Server 2016, 2014, 2012, 2008 R2, Windows Server 2012R2, 2008 R2, AD (Active Directory), Financial Applications, Enterprise Reporting System, IIS, Dot Net.

Confidential, Washington DC

MS SQL Database Administrator

Responsibilities:

• Wrote T-SQL, Trigger, and Stored-Procedures. Assisted Database Developers to optimize SQL queries and Stored Procedures.
• Used DBCC to check database conditions, and Rebuilding indexes and other database Maintenance purposes as well.
• Installed, and configured and Maintained Database mirroring using automatic fail-over option in SQL Server 2008R2. Configured Log Shipping as Standby database from Production database for Reporting purposes. Configured and Maintained Replications.
• Strong on database Monitoring and Performance tuning. Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification. Monitor SQL Server Error Log, and space usage
• Strong knowledge and working experience in Database Backup and Disaster Recovery. Experienced with Point-in-Time Recovery. Restored Database from backup.
• Worked Data modelling and generated E-R Diagram. Data modelling tool using SQL Server Data Diagram.
• Wrote T-SQL, Trigger, and Stored-Procedures. Assisted Database Developers to optimize SQL queries and Stored Procedures.
• Used ETL tools like DTS, SSIS, SSAS, Creating SSIS package, Deploy the package in different source and Import/Export, BCP (Bulk Copy), to import & export data from flat files, and excel to MS SQL Server databases.
• Data from/to Oracle, MySQL, and Access Database including flat files like text, Excel, and CSV files to SQL Server 2005/2008r2 and 2012.
• Installed, Configured, and administered SQL Server Reporting Services. Developed Reports using SSRS. Deployed Reports. Developed Ad-hoc Reports using Report Builder 3.0, 2.0.

Work Environment: SQL Server 2012, 2008 r2, 2008, 2005, 2000 Windows Server 2012R2, 2008, 2003r2, AD (Active Directory), and Applications in .Net Platform.