SUMMARY

• An experienced SQL Server DBA having excellent troubleshooting, managing instances, databases, disaster recovery, backup, recovery, developing and managing reports.
• SSIS packages, database migration, upgrade, proactive monitoring, performance tuning, High Availability, and TSQL is looking for a SQL Server DBA job. Self - motivated team player wif excellent verbal and writing communication skills.
• Strong business and technical vision wif TEMPeffective people skills. Managed, maintained, Modify and secured Production environment 24/7. Looking for full time permanent or contract opportunity where I could explore my experiences to job done on time.
• Working experience on Cloud Environment
• Experience on AlwaysOn High Availability and Mirroring
• Working experience on VMware and ESXi 6.5

PROFESSIONAL EXPERIENCE

Confidential

SQL Server DBA

Responsibilities:

• Support over 1900 SQL instance and 15000 databases
• Build SQL Server in Cloud environment. Which include SQL server Installation and Configuration.
• Created documentation to install SQL 2014 and 2016
• Install SQL Server 2012, 2014, and 2016 in Shared and Dedicated environment.
• Turn on Encryption. Configure Firewall, TCP-IP
• Hosting different size of empty shell Databases in Production, Development, and Test environments wif different service tiers (standard and premium) using PowerShell script.
• Create automation jobs for Backup database, Rebuild index, Shrink database, and Update Statistics, Cleanup History wif teh PowerShell script
• Creating Service Account and Agent Account. Also perform on Server inventory and Database inventory
• Installed, Configured, and administered SQL Server Reporting Services (SSRS) and SSIS
• Configuring AlwaysOn Availability Groups and add teh databases to teh AG Groups
• Configured and maintainedDatabase mirroringwif High Safety and High Availability wif automatic failover. Monitor mirroring by using mirroring monitoring wizard.
• Maintain and troubleshoot AlwaysOn Availability group
• Implement system monitor to find teh bottlenecks of servers in CPU, Disk I/O and memory devices to improve teh server as well as database performance.
• Monitoring database health, job alert, and index fragmentation
• Support Application DBA and System Integrator (System Admin)

Confidential

SQL Server DBA

Responsibilities:

• Installed, Configured, and Administered SQL Server 2008 R2, 2012 in development, test, and production environments.
• Data modeling:
• Worked on data modeling projects from scratch
• Strong Theoretical and Practical work experience on Conceptual, Logical, and Physical Data Model
• Worked on different Data Modeling projects using Toad Data Modeler on designing Logical & Physical Database.
• Backup, Recovery, Restore, Disaster Recover
• Work experience and strong knowledge in Disaster Recovery.
• Created automation job for full and Transitional databases backup
• Taken manual backup on demand to rebuilt/ restored databases
• Single or multiple table backup
• Database Automation:
• Created Backup jobs for different types of backup like FULL, Differential, and Transaction Log.
• Created Jobs for database maintenance Index fragmentation, rebuild, and database statistics update
• Installe, Configured and Managed Database Mirroring wif High Safety and High Availability automatic failover
• Installed, Configured, and administered SQL Server Reporting Services (SSRS).
• Created, Developed, and Deploy Reports using DTS and SSDT
• Developed Ad-hoc Reports using Report Builder
• Manage report by using Report manager
• SSIS (SQL Server Integration Service)
• Create SSIS packages for Import data from text file, excel file to SQL Server Database using data tools
• Debugged and Deployed SSIS packages for import, export and bulk insert data.
• Created automation job by using SSIS

Confidential

Security Management

Responsibilities:

• Created and Managed users, roles, security at object level, data encryption.
• Applied SP (Service Pack) on SQL Server 2008 R2 (SP4) and SQL Server 2014 (SP1)
• Database Programming:
• Writing T-SQL, User Define Function, Trigger. Create and modified Stored-Procedures. Assisted Database Developers to optimize SQL queries and Stored Procedures
• Performance, Monitor, and Troubleshoot
• Tools I used to monitor database Perfmon, Activity monitor, resource monitor, & SQL profiler
• Excellent trouble shooting experience on error log, SQL Error Logs, & Windows event log
• Tuning queries which are running slow using Profiler and Statistics I/O by using different counters in terms of evaluating joins, indexes, updating Statistics, and code modifications.
• Proficient in resolving performance problems lock, block, and deadlocks
• Create and modify stored procedures, TSQL, and PowerShell script.
• Checked Database Health by using DBCC and DMVs
• Manage and maintain drive space issue (Storage) including log file and TempDB growth pattern.
• Daily Activities:
• Daily routine DBA tasks like handling user's permissions, space issues on Production
• Monitor and Handle maintenance Jobs.
• Enable and Disable SQL Jobs when necessary
• Monitor ticket queue by resolving incidents and completing requests

Confidential, Suitland, MD

SQL Server DBA

Responsibilities:

• Server Build: Installed, Configured, and Managed SQL Server 2008R2, & 2012 in development, test, and production environment
• Backup, Recovery, Restore
• Create backup strategy plan for production databases.
• Setup automation job for database backup
• Performed manual backup as needed and Restored Database from backup file Server.
• Monitor different daily routine backup jobs done by using maintenance plan.
• Troubleshooting backup jobs failed issues.
• Database Programming:
• Writing T-SQL, User Define Function, Trigger. Create and modified Stored-Procedures. Assisted Database Developers to optimize SQL queries and Stored Procedures
• Database High Availability:
• Configured, and Maintained Database Mirroring including automatic fail-over option in SQL Server 2008R2
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Database Upgrade:
• SQL Server 2005 to SQL Server 2008 R2
• Oracle 10gR2/11gR2 databases to SQL Server 2008 R2
• SSIS/DTS: Export & Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP. Export & Import data from/to databases like Oracle, My-SQL, and Access to/from SQL Server
• Migration:
• SQL Server 2005 to SQL Server 2008R2. Migrated Oracle 10g, MySQL, Sybase database into MS SQL Server 2008R2
• Patch Management:
• Applied SP (Service Pack) on SQL Server 2008 R2
• Database Monitoring and Performance Tuning:
• Worked on database monitoring and Performance tuning. Including index, fragmentation, and update statistics, query optimization.
• Database Monitoring and Performance tuning using Perfmon and SQL profiler
• Managed SQL Server Error Logs, space usage, growth pattern.
• Experience on SQL server normal behavior on LOCK, BLOCK and deadlock.
• Scheduled job automation different activities such monitoring database health, disk space, job alert, index monitoring, stats monitoring