SUMMARY:

• More than Six years of IT experiences in MS SQL Server Database Administration
• Experienced in Relational Database Management Systems (RDBMS)
• Excellent experience on monitoring and tuning Database Server performance
• Expertise in implementation of Database Server Security Mechanisms
• Solid experience in Back up and Disaster Recovery procedures
• Installed, Configured and Administered Databases in Test, Dev and Production environments
• Great knowledge on virtualization such as VMware and Azure - Iaas, Paas and Saas
• Experienced in HA solutions on Log Shipping, Mirroring, Replication and Clustering on virtual machines
• Great knowledge in T-SQL; developed SP, Triggers and Views
• Experienced in administering AD (Active Directory)/ Domain and users Activities
• Hands-on experience in upgrading and migrating from one version to another version
• Created Jobs and Maintenance tasks for Database Automation
• Configured and Managed Always-ON (AAG) for HA and DR solution
• Created SSIS packages and SSRS reports
• Managed deployment of SQL Databases on Virtual Machine (VM)
• 24 X 7 Production Database on-call support s
• Excellent communication skills and great team player with a reputation of integrity, strong analytical and problem-solving skills, Self-motivated and Proactive person

TECHNICAL SKILLS:

Database: SQL Server 2016/2014/ 2012/2008 R2/2005, MS Access

Operating Systems: Windows Server 2012/2008 R2/2003 R2, VMware

Programming Languages: SQL, T-SQL, XML, HTML, JavaScript, ASP and ASP.net

Network Topologies: Active Directory, TCP/IP

Hardware/Storage: SAN, RAID, ISCSI

Third Party Tools: Idera, ER-Win, Toad, Solar-wind

PROFESSIONAL EXPERIENCE:

Confidential, DC

SQL Server Database Administrator (DBA)

Responsibilities:

• Installed, configured, monitored, administered and troubleshooting of SQL Server 2016, 2014, 2012, 2008R2
• Migrated and upgraded SQL Server Database Software from 2005 and 2008R2 to 2012, 2014, 2016
• Implemented Backup strategy and Point-in-time recovery for production and development environments Based on RPO and RTO in SLA
• Configured Always-On for High availability and Disaster Recovery Solution
• Implemented and managed Replication and Mirroring for data distribution and disaster recovery
• I have done performance tuning activities by using different tools like; Execution plan, SQL profiler, Performance monitor
• Created and managed Maintenance plans (automation) for Index rebuild and update Statistics, History clean up tasks
• Resolved Dead locks/long running Queries by using different tools like; Profiler, DMV and Stored procedures
• Performed Client/Server connectivity.
• Performed Query optimization, indexing, and troubleshooting SQL Server related issues
• Managed Disk I/O, CPU and Memory bottle neck for better performance
• Monitored server performance and integrity using DMV, DBCC, DMF and Profiler,
• Responsible for securing SQL Server environment, involved in creating and granting permissions, logins, groups, roles on various objects
• Monitored Event viewer, SQL error logs and Log file viewer for software and hardware related errors
• Used Business Intelligence tools to create and deploy SSRS Reports and SSIS Packages
• Defined SQL Server standards for HA based on Applications requirements
• Capacity planning for Databases considering the Database growth, Backups, SP, Hotfix and HA Solutions
• Applied SP (Service Pack)/ Hot Fixes on SQL Server Instances to address security and upgraded related issues

Work Environment: Windows Server 2012, 2008 R2, 2003 R2, SQL Server 2014, 2012, 2008R2, 2005, AD (Active Directory), Applications, Reporting System and Databases, SQL Profiler, Activity Monitor, SQL Agent

Confidential, NJ

SQL Server Database Administrator (DBA)

Responsibilities:

• Responsible for monitoring and making recommendations for Database Server performance improvement
• Configured and managed Active/Passive Clustering on virtual machines
• Administered, configured and managed Replication and Mirroring for HA, DR and load balancing
• Implemented and Managed SQL server Database security for both data at rest and live data
• Created guide line, Policy, Audit and TDE to secure SQL Servers
• Managed long running queries by sing DMV, DMF, SP and Profiler
• Performed Table partitioning and data archival activities for very large Databases (VLDB) for better performance
• Set up Backup/Recovery, disaster recovery solutions according to RPO and RTO in SLA
• Automated different maintenance tasks like; DB health check, rebuild index, update Statistics
• Monitored database server health using third party tool Idera
• Setup Database mail, alerts and notification for Server and DB status
• Performed upgrading from SQL Server 2000 to 2012
• Worked closely with Developers; reviewed and optimized SQL scripts, Indexes and complex Queries
• Handled memory configurations for SQL server database software
• I have done rebuilding / monitoring Indexes at regular intervals for better performance
• Performed capacity planning and optimization for SQL server databases
• Performed Physical and Logical database design using ERWin and SQL Server Database Diagram

Work Environment: Windows Server 2012, 2008 R2, 2003 R2, SQL Server 2012, 2008R2, 2005, AD (Active Directory), Applications, Reporting System and Databases

Confidential

SQL Server Database Administrator (DBA)

Responsibilities:

• Performed installing, configuring, monitoring and troubleshooting & Administration of SQL Server 2005, 2008R2
• Responsible for securing SQL server environment, involved in creation and granting permissions on various Objects, created the guide line to secure SQL Servers.
• Created SOP for all SQL Server activities like - installing SQL Servers, applying service packs and security fixes.
• Backed up and restored user and System Databases
• Configured and maintained Log Shipping for HA and DR
• Performed ETL process by using Export/Import utility, BIDS from source to destination.
• Created and deployed SSIS Packages and configured SSIS Catalogue
• Performed installing, configuring and managing of Security, Permissions and Roles of Reporting Server
• SQL server memory allocation, Temp-DB configuration
• Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency check and index defragmentation
• Performed SQL Server tuning techniques to optimize SQL queries and stored procedures
• Configured security and access to databases

Work Environment: Windows Server 2008 R2, 2003 R2, SQL Server 2008 R2, 2005, AD (Active Directory), Applications, Reporting System and Databases