SUMMARY:

• An experienced Microsoft certified SQL Server Database Administrator wif seven years of professional experience in different Microsoft products. As a DBA professional and troubleshooting expert
• My experience includes SQL Server database administration, data modeling, gathering, and analyzing business requirement and Operating Systems. Solid working experience in managing large databases, backup/recovery, high availability solution like Mirroring
• Log shipping, Replication and SQL Failover Cluster and Always - On, developing and managing reports using SQL Reporting Services (SSRS), Monitoring, Performance Tuning, stored procedures, triggers, functions, constraints, and views etc.
• Possess strong knowledge and experience in configuration, administration, and maintenance of SQL Servers 2008/2008R 2/2012/2014/2016/2017/2019 versions wif different editions.
• Working experience entails strong knowledge on using database third party tools like OpNet, SolarWinds, Idera, ERWin, Visio.
• me have Strong business and technical vision wif effective people skills, ability to manage multiple complex projects, innovative and creative problem solver, results oriented, and TEMPhas an aptitude for learning and can maximize resources while possessing a sense of urgency.

TECHNICAL SKILLS:

Databases: SQL Server 2019, 2017, 2016, 2014, 2012, and 2008R2

Database Tools: Profiler, Database Tuning Advisor, Execution Plan, Query Analyzer,SSMS, SSIS, SSRS

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

SSIS/DTS: DTS, SSIS Package create, manage, deploy, upgrade, and migrate packages.

Performance Tuning tools: Profiler, Execution Plan, PerfMon, Database Tuning Advisor, DMV, Windows Performance Monitor

Database High Availability: Strong knowledge and experience in configuring and administering High Availability Database Solutions like Database Mirroring, Always On, Replication, Log shipping, Cluster Database.

Windows Server and Active Directory: Experience in administering Windows Server 2019, 2016, 2012, 2008 R2, AD (Active Directory), Domain, monitoring user activities, VMware.

Large Database/VLDB: Proven ability to handle Database of more than 3 TB in Size.

Security: Experience wif Security and Audit Management like Security, Encryption, TDE (Transparent Data Encryption)

Upgrade/Migrate: Migrated and Upgraded databases from 2008 R2, 2012 to higher version.

Service Pack: Applied Service Pack (SP) and hot fixes for Databases and Operating Systems

Documentation: CHM, HTML, DOC, DOCX and PDF format

Third Party Tools: Idera, SpotLite, Erwin,SolarWinds, and Visio.

Development Tools: Visual Studio (VB), Visual Studio 2010/2012/2015, BIDS, SSDT

Networking: Active Directory, TCP/IP, Network Switches, Network Hubs, Network Printer.

Hardware/Storage: SAN, RAID

Ticketing Tools: Cherwell, BMC Footprint, ServiceNow, JIRA.

Cloud/Azure: Azure Services, Migrated on premises databases and Legacy products on Azure, deployed products on Azure, Setup development and test environment on Azure.

PROFESSIONAL EXPERIENCE:

SQL Server Database Administrator/ MS SQL DBA

Confidential, Washington, DC

Responsibilities:

• Primary focus is 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 2019, 2017, 2016 and 2014 in Development, UAT and Production Environment on Premises and Azure Cloud Environment
• Implemented Secure Socket Layer (SSL) to encrypt teh connection to teh 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 teh required privileges are granted to teh 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 teh 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 teh 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 teh system.
• Migrated 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-Premises 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.

Environment: Windows Server 2019, 2016, 2012 R2, 2008 R2, IIS 7.5, 6.5, SQL Server 2019, 2017, 2016, 2014, 2012, 2008 R2, TDE, SSL, SCOM, ServiceNow, SharePoint, Visual Studio 2013/2015, SSDT, BCP

MS SQL Server Database Administrator

Confidential, Suitland, MD

Responsibilities:

• Applied SP/Hot Fixes on SQL server Instances to address Security and upgraded related issues
• Worked on Database refresh in Dev/Test servers wif PROD data and reinstate teh server
• Supports day to day operational activities for teh database platform like service requests and tickets, monitoring, performance tuning, troubleshooting long running queries, locks, deadlocks and performance issue like CPU, me/O, Memory bottlenecks
• Have used TFS to deploy script in different environments( prod/test/dev)
• Migrate/Upgraded SQL server instances from SQL Server 20 & 2014
• Managed Security of SQL Serversand Databases Logins, Users, Granting/ deny/ revoke access and Database Encryption/Decryption
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space management and backup verification etc.
• Assisted Database Developers to optimize and troubleshoot SQL Server slow running queries /Stored Procedures/index/Function/Views
• Working wif BI Team to deploy SSIS Package in different environment on daily basis
• Involved in report migration from Dev to Test/Prod and adding Data source/ managing security f report and create data driven subscription
• Fine Tune and improve Database Performance using SQL Server Profiler, Execution Plan,
• DMV, DBCC, indexes, Activity Monitor
• Optimized teh database by creating various clustered, non-clustered indexes and indexed views
• Configured and Maintained AlwaysOn Availability Group using SQL Server 2014/2012 wif
• Synchronous automatic-failover mode
• Monitored Server Activity, Error Log, space usage, database health, backup verification, cleaning history and solving problem as needed
• Developed, maintained and implemented database backup and recovery plans for Production,
• Test and Development environments including mission critical databases
• Provided 7 x 24 Production support for teh database and application issues

Confidential, Washington, DC

SQL Database Administrator/SQL DBA

Responsibilities:

• Installed, Configured, and Managed SQL Server 2005, 2008, 2008R2, 2012 in development, test, and production environment
• Installed, configured, maintain, and monitored troubleshoots SQL Server Fail Over- Clustering
• Configured and Maintained Log Shipping as Standby database for Reporting Purposes.
• Securing SQL Serversand Databases, manage users, Data encryption, granting/ revoking. access
• Data Encryption and Data Decryption for data security in Database & Column level
• Managed Backup/Restore, Point-in-Time Recovery including backup verification, security.
• Have worked in database Performance tuning SQL profiler, Execution Plan, Database tuning
• Advisor, Activity Monitor, Performance Monitor
• Optimized teh database by creating various clustered, non-clustered indexes and indexed. views
• Used T-SQL, Stored-Procedures, Triggers, Function, Views, Indexes
• Developed and maintained scripts, utility jobs or implement needed software for database. maintained
• Processed data dump and Exported & Imported data from Flat file, CSV file, Oracle, My-SQL, and Access to/from SQL Server Database using DTS, SSIS, and EXP/IMP tool
• Installed and Configured SQL Server Reporting Services (SSRS)
• Developed and Managed Report in SSRS (SQL Server Reporting Services) including securities
• Setup automated jobs for different purposes including backup, monitoring database health, disk space, backup verification, and moving databases from environment to environment. including creating test environment
• Developed Different Maintenance Plans such as backups, index management, fragmentation. management, cleaning history, deleting old files.

Environment: Windows Server2008 R2, 2003 R2, SQL Server 2012, OpeNet, DotNet, AD (Active Directory), applications: Registration System, Reporting System, Booking System, Time Sheet, and Payroll& HR.