SUMMARY:

• 7+ years of IT experience in Database Administration, Design Development and Support of MS SQL Server 2014/2012/2008 R2/2005 in Production, Test, Development and Cluster Server Environments.
• Enrolled users, maintained system security, and controlled and monitored user access to the database, operating 24/7, with 40 - 50 concurrent users at any given time.
• Master in performing administrative tasks: Database Files Management, Backup/Restore, Security Management, Database Mirroring, Data Integration and Synchronization.
• Solid experience on HA SQL Server solutions, including Replication Models (Snapshot/Transactional) and SQL Server Clustering (Active-Active, Active-Passive).
• Extensive Microsoft s, broad SQL server troubleshooting skills, Database Optimization using recommended techniques and latest tools available in the market.
• Experience in using SQL Server Tools like DTS, Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.
• Extensive use of DTS/SSIS in SQL Server, Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients.
• Highly self-motivated, committed, detail and goal oriented; Strong work ethic, integrity with a positive and can-do attitude

SQL TECHNICAL SKILLS:

• SQL Server 2014, 2012, 2008R2, 2008, 2005 and 2000
• Mirroring, Log Shipping, Replication and Fail-over Clustering
• SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Profiler/Server Side Trace, Database Tuning Advisor(DTA), Query Analyzer, DBCC, DMV, Idera, Redgate
• Pursuing MS SQL DBA
• Windows Server 2003, 2008, 2008/R2, 2012,2012R2, VMWare, Windows XP/Vista/7
• Hardware/Storage: SAN, RAID/EMC
• T-SQL, PowerShell PS2, Batch (DOS)

PROFESSIONAL EXPERIENCE:

Senior SQL Server DBA

Confidential

Responsibilities:

• Responsible for installation, configuration, migration, capacity planning and complete administration of different versions of SQL Server ( ) on Windows ( R2) Servers.
• Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).
• Responsible for monitoring several Prod and non-Prod SQL Servers with different versions across the company using different monitoring tool, Red-Gate, IDERA Diagnostic Manager, Native SQL alert and notification.
• Eliminated months of production server issues by systematically troubleshooting and resolving the problem with no further downtime.
• Improved vital processing jobs by reducing process duration by 60%.
• Architected High Availability and Disaster Recovery solutions within business (RPO) and (RTO) and implemented successfully (Classic Failover Cluster, AlwaysON Availability Groups, Mirroring & log shipping).
• Researched and applied latest MSFT recommended security patches and avoid any security breaches.
• Designed, developed and deployed SSIS packages in 2012 and 2008R2 SQL servers.
• Installed and configured SSRS using Scale-Out configuration behind Network Load Balancing (NLB) for regular http and secured (https) report manager.
• Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.
• Worked with Application Developers to design databases and tables to support development activities and achieve optimal efficiency.
• Involved in Capacity Planning and Process Automation to increase quality and consistent service delivery for customers.
• Created and Modified Tables, Stored Procedures, Indexes, User-defined Functions, and Triggers as required.
• Created different maintenance plans to monitor the database for example for Error log, Space usage, Automated backup and checking database health.
• Monitored Server resources (RAM, CPU and I/O subsystem) using Performance and Resource Monitors to identify resource bottlenecks.
• Performed database migration into SQL Server 2008, reports into SSRS and applications into IIS Servers.
• Developed PowerShell Script to automate repetitive tasks, Schedule using Windows Task Scheduler.
• Involved in drafting and preparation of Database Administration and Development Guide.
• Applied Service Pack (SP) and hot fixes on SQL server 2008R2, 2012.

MS SQL Server DBA

Confidential

Responsibilities:

• Responsible for installation, configuration, and maintenance of MS SQL Server on various environments.
• Responsible for Performance tuning of SQL servers by managing the use of disk space, memory and CPU.
• Responsible for routine Backups and Restoration.
• Managed SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Implemented log shipping between two instances of servers using log shipping configuration or via scripts by creating a Monitor server and a shared Folder.
• Used DTS as an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.