Senior SQL Server Database Administrator

Microsoft Certified Professional with over 8 Years of working experience in Database administration and managing of multiple MS SQL server databases in production and non production environments (SQL Server 2005/2008/2008R2/2012/2014/2016).

Primarily concerned with managing the SQL servers hosted on Microsoft window 2003/2008R2/2012/2012R2 servers running on physical and virtual hardware platforms in a 24x7 production environment using SQL native monitoring Tools and third party products

Areas of Expertise Include :

Tools and Technology:

RDBMS: MS SQL Server 2014, 2012, 2012R2, 2008R2, 2008.

Operating Systems: Windows 2005, 2008, 2008R2, 2012 & 2012R2.

Database Tools:SSIS, SSRS, DTS, BCP, ODBC, SQL OLEDB, BIStudio, Data service, Crystal Reports.

Languages : Visual Basic, PowerShell, and T-SQL

Modeling Tools : MS Visio and Erwin.

Monitoring Tools : SQL profiler, Performance monitor and Activity Monitor

3rd party tools : Iderea, Redgate, Spotlight, Sql secure, Sql compare, & TOAD for SQL.

Architecture:Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP.

Hardware: SA, IBM AS/400, HP, Compaq, Dell, Cisco routers.

Other Tools: MS Visual Source Safe, Source Control, MS Visio, VMware, Jira, SharePoint, Master Data Services (MDS), Active directory

Education And Certification:

Bachelor Degree Holder

Microsoft certified database administrator in SQL Server 2012/2014

Professional Summary

8 years of experience in Database Administration, Development and Support of MS SQL Server 2016/2014/2012/2008R2/2008/2005 in Development, Test, and Production Environments.

Experience in Installing, Configuring, upgrading and Administering SQL Server in highly transactional production development and testing database Servers 2016/2014/2012/2008R2/2008/2005 in standalone and clustered environment.

Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2005/2008/2012/2014/2016.

Experience in databases Encryption for securing the data.

Experience in Disaster Recovery Planning, Execution and Testing at remote side.

Experience in using SQL Server Tools like DTS, Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.

Migration experience from MS SQL Server 2005/2008 to MS SQL Server 2014/2016.

Experience in Manage Service Account (MSA) & Grouped Manage Service Accounts (gMSA).

Experience on applying Service Pack & Security Patch on Geo Cluster environment.

Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them).

Expertise in Database tuning, indexing tables, optimizing statistics. Identify and troubleshoot storage bottlenecks CPU, Memory, I/O, Disk space and other resource contention.

Experience in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration and synchronization.

Experience in implementing high availability and Disaster recover solutions using Log shipping, Mirroring, Replication (Snapshot/Transactional), Failover cluster and Always On.

Experience in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services).

Experience in using SSIS for data extraction, transformation and loading (ETL) across different databases sources like Oracle, MS Access, Excel and flat files.

Enabling transparent database encryptions (TDE) on a new server.

Experience on creating and maintains on SQL Virtual Machine running at VM ware and Microsoft Hyper-V environment.

Exelon Corporation

March 2017 – Present

Baltimore, Maryland

Senior SQL Server DBA.

Responsibilities:

Installation of MS SQL Server enterprise on Clustered Production, Test and Development boxes.

Migrated databases from SQL Server 2005/2008 to SQL Server 2014/2016.

Configured 3 Node widows failover clustering and SQL 2014 Always-ON.

Performed SQL service pack & security patch on failover cluster and AVG.

Installed and configured SQL Server Reporting Services.

Regularly monitor the performance of UAT and PROD server (CPU, Memory, I/O) using SQL Profiler, Performance monitor, DMVs, Wait Stats and Events.

Experience in T-SQL writing Stored Procedures, Functions and Triggers.

Created login id, passwords and roles in production and non-production environment.

Experience on creating and maintains on SQL Virtual Machine running at VM ware and Microsoft Hyper-V environment.

Used Power Shell to execute batch files and other scripting tasks.

Set up transactional and snapshot replication among SQL Server 2008/2012 boxes.

Auditing stored procedures for optimization and improving performance.

Backing up system and user databases and restoring them when necessary.

Schedule the jobs for the Database Maintenance.

Re-align the database structure for performance and space management.

Run DBCC commands to check the database consistency and shrink the databases.

Extensively used DMV, SQL profiler and performance Monitor, and Performance Dash board for troubleshooting.

Maintain index rebuild and re-organize indexes periodically.

Transfer data among SQL boxes using SSIS, BCP, and Back up & restore.

Created Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, task assignment and tracking.

Provide 24/7technical support and monitoring.

Environment:

Microsoft SQL Server 2005/2008/2012/2014/2016, Windows 2003/2005/2008/2012/2012R2, SSIS, SSRS, Management Studio, Enterprise Manager, TFS, LiteSpeed, Spotlight, Scom Alert, Microsoft Excel 2013, Performance Monitor, SQL Profiles, Microsoft Dash Board, Replication Monitor, Mirroring Monitor, Microsoft Visual Studio, Microsoft Visio, service center.

WGI, INC

Feb, 2015 – Feb, 2017

Marylad, USA

Title: Senior SQL Server DBA.

Responsibilities:

Developed and automated daily, weekly and monthly system maintenance tasks such as database backup, Mirroring, database integrity verification, indexing and statistics updates.

Implemented the Data Collector to capture the CPU, DISK, Memory counters.

Implemented table partitioning to improve performance and data management.

Implemented database and SQL Query Tuning to improve performance of loads.

Reduced the deadlocks by using the SQL Server Profiler hence the performance of the query is tuned.

Applied service pack and security patch on clustered and Always-On environment.

Created automatically running stored procedures for day-end operation using SQL Server agent

Implementing different Development and Test Server instances for the Application Development Team and to co-ordinate Development and Testing Environments and keep them updated.

Provided daily support, troubleshooting, monitoring, optimization ad tuning of server, and SQL server environments across entire system.

Created logins and roles with the appropriate permissions.

Designed and deployed SQL Server Integration Services (SSIS) Packages, with error handling, environmental and SQL server package configurations.

Successfully implemented database mirroring between Primary server and Mirror Server.

Implemented log shipping to support DR servers, worked on high availability concepts like clustering.

Assisted in maintaining and updating the SharePoint platform.

Provided 24 X 7 dedicated supports for SQL Server production server.

Environment:

MS SQL Server Enterprise 2005/2008/2012 Windows Server 2003/2005/2008, SSRS, SSIS, MS SQL Management Studio, MS Business Intelligence.

Al Jaber L.E.G.T Engineering & Contracting(ALEC) PLC August, 2013 – January, 2015

Dubai, UAE

Title: MS SQL SERVER DBA Administrator

Responsibilities:

Installation of MS SQL enterprise servers on production, test and development boxes.

Worked on logins, aliases, and groups to the databases and granting/revoking permissions on Database objects.

Wrote stored procedures, Triggers, Views, Functions.

Extensively used SQL Server Management Studio, SQL profiler, SSIS, and SQL mail services.

Performance tuning by dropping and rebuilding index.

Auditing stored procedures for optimization and improving performance.

Data Transfers between various systems using BCP and SSIS.

Performance tuning on the Production, Staging and development Servers.

Database and log backups and restoration, backup strategies, scheduling backups. Backing up master and system databases and restoring them when necessary.

Regularly maintained database for database consistency check using DBCC

Schedule the jobs for the Database Maintenance.

Create a customized report using SQL Server Reporting Services.

Created Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, security breach, etc.

Environment:

MS SQL Server Enterprise 2005/2008/2012 Windows Server 2003/2005/2008, SSRS, SSIS, MS SQL Management Studio, MS Business Intelligence.

Action International LLC

June, 2010– July, 2013

Dubai, UAE

Title: Jn. DBA Administrator

Responsibilities:

Actively participated in gathering Business Requirements and System Specification from users.

Day to day database maintenance operations, SQL server database backup-restore point in time recovery, job scheduling in a real time production and Stage environments.

Oversee backup, clustering, mirroring and failover and send (automate) daily status report and confirm that the database is up and running as expected.

Involved in partition of the tables, Index to improve the performance, estimated the table space to hold the ETL process and bulk data flow from source to target.

Fine tuning of database objects and server to ensure efficient data retrieval.

Involved in performance tuning, optimization of stored procedures and queries.

Troubleshoot database performance issues and tune database objects by using traces and profiler.

Proficient in working with production change management and change control procedure.

Developed various T-SQL stored procedures & functions for data validation process.

Created and maintained various databases for Production, Development and Testing using SQL Server and planning the location of data, index, and Transaction log files on the disk.

Supported Development team in deploying and testing the application.

Experienced in contacting Microsoft and other vendors for product and technical support.

Provided 24*7 supports to SQL application developers in implementing the applications on production server.

Environment:

MS-SQL Server 2005/2008, Windows 2003/2005, Crystal Report, MS-Project

Reference:

Available up on request

Contact this candidate