SUMMARY

• Certified SQL Server Database Administrator with 6+ years of experience development and production support to maintain business processes.
• Experienced in installation, configuration, patching, upgrade, and migration of servers.
• Detail-oriented and motivated to drive projects from start to finish as part of a dynamic team.
• Setup and manage high availability like cluster and alwaysOn on production, Test, and Development environments.
• Installing, configuring and troubleshooting SQL Server 2005, 2008, 2008R2, 2012, 2014, 2016.
• Upgrade and Applying the latest Service Packs and cumulative updates.
• Creating and modifying tables, Index, Constraints, Views, Stored Procedures, and Triggers.
• Creating logins, users, roles, and granting permission based on the principle of minimum privilege
• Data Security, Backup & Recovery
• Configured Peer-to-peer replication from scratch and troubleshot as problems arise.
• Configured data management warehouse through SQL server's Data Collection utility to gather information about disk usage, query statistics, and server activity.
• Setting up disaster recovery solutions using Log shipping, Mirroring, Always On in windows clustering environments for High Availability.
• Worked in Active/Passive and Active/Active cluster environment.
• Configured and managed SQL Server snapshot, transactional and merge replication Implemented side-by-side Upgrades and migration and in-place upgrade of MS SQL Server.
• Created SQL Agent jobs to automate data refreshes from production to UAT servers.
• Performed data transformation from various data sources to SQL Server using SSIS, Import/Export and BCP utilities, Bulk insert
• Automation of tasks like backup, index maintenance using SQL agent and maintenance plan.
• Using Performance Data Collector, Activity Monitor, Database Engine Tuning Advisor (DTA), Profiler, Perfmon, and Extended Events for Performance Tuning & Optimization.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Ability to detect and troubleshoot Server CPU, memory, I/O, disk space and resource contention.
• Rebuilding and reorganizing of indexes
• Experience in supporting Very Large databases (VLDBs) up to 4TB database.
• Planning and implementing disaster recovery to ensure minimal downtime and data loss.
• Setting up, monitoring and troubleshooting replication, log shipping and database mirroring.
• Creating and maintaining Always On availability groups.
• Identifying and troubleshooting locking and blocking issues by utilizing DBCC commands, DMV's and DMF's.

PROFESSIONAL EXPERIENCE

Confidential, Tacoma, Washington

SQL Server DBA

• Installation, configuration and administration of SQL Server 2008/2008R2/2012/2014.
• Apply service pack and security fixes as necessary.
• Create databases, tables, views, and store procedures.
• Rebuild indexes at regular intervals for better performance.
• Modify databases and database objects as per requests.
• Extract data from various sources like Oracle, Excel and Text file from Client servers
• Manage concurrency issues like blocking, deadlocking and locking.
• Import/Export data from other data sources like flat files using Import/Export wizard and SSIS.
• Create Logins with appropriate roles, granting permission to users and groups.
• Migration of databases from SQL Server 2005 to SQL Server 2008R2/2012 server.
• Configure Database mail, operators and alerts to monitor server health and jobs
• Perform Backups and Recovery of databases.
• Reviewing and fixing issues with database backups, maintenance, and other common faults.
• Experience in Disaster Recovery Planning and Security Management operations.
• Configure and support replication and log shipping in both SQL 2008 and 2012.
• Work closely with the developers and testing team to resolve Bugs and defects.
• Mentor team members and write documentation.
• Create Clustered and Non-Clustered Indexes to improve the performance of database.
• Data refresh at table level and database refreshes across production/non-prod environments.
• Install and configure SQL Server Reporting Services(SSRS).
• Perform Database Upgrades from 2008/2008R2 to 2012 and 2012 to 2014.
• Create and schedule jobs and troubleshooting the failed jobs.
• Evaluate CPU, Disk I/O and Memory related bottlenecks, blocking and deadlocks using Perfmon.
• Extensively work on DBCC commands and Dynamic Management Objects

Environment: SQL Server 2008/2012 Enterprise, Windows Server 2008/2012 Enterprise, Microsoft Visual Studio, SQL Server Reporting Service 2012/2016, SSMS, SQL Profiler, Spotlight.

Confidential - Long Beach

SQL Server DBA

• Installed and configured SQL 2014/2012/2008R2/2008 servers in clustered and non-clustered.
• Installed and configured Active-Passive Clustered nodes and performed fail-over from one node to another when there is a need to apply patch.
• Evaluated user permissions and granted access to authorized users using least privileges policy.
• Created & Manipulated data, tables, views, indexes, using SSMS & T- SQL Scripts.
• Performed backups and restores as requested by the customer.
• Worked on Policy Based Management, Resource Governor, performance data collector, and Transparent Data Encryption (TDE).
• Migrated SQL Server 2008 to SQL 2012.
• Worked on Query Optimization, Client/Server connectivity, Performance Tuning.
• Reviewed SQL Server Error Logs and Application Logs to resolve issues.
• Monitored and Troubleshoot SQL Jobs.
• Database Consistency Checks using DBCC utilities.
• Configured Database Mail, Setup Alert, Created Linked Server.
• Conducted consistency checks on the database and analyzed the fragmentation on the indexes.
• Performed Data Extraction, Transformation and Load (ETL) using Integration Services (SSIS).
• Installed, Configured and Managed Database Mirroring, Replication, Always-on and Fail-Over Cluster Servers on SQL Server 2012.
• Experience in Normalization, Database design, and Performance Analysis.
• Supported very large databases (VLDBs) and Complex Databases.
• Handled multiple SQL Instances on Cluster environment for server Consolidation projects built on SAN using RAID levels.
• Experience in daily database maintenance and administrative tasks like Space issues, Transaction log file size growth, Connectivity issues and regular monitoring of SQL Server error logs and windows event viewer.

Environment: MS SQL Server 2012/ 2008 R2 / 2008, Windows Server 2012/2008/2003, SSIS, SSRS, Visual Studio, SSMS, SQL profiler, Database Engine Tuning Advisor, Idera, RedGet.

Confidential

Junior SQL Server DBA

• Installed and configured stand-alone clustered SQL Server 2008/2005, SSIS and SSRS.
• Migrated databases from SQL Server 2005 to SQL Server 2008.
• Performed job scheduling, create operators and alerts sing SQL Server agent service.
• SQL Development- write and troubleshoot SQL Code and design of views, triggers, indexes, constraints.
• Managed Backup, Restore, recovery strategy and Security of databases.
• Implemented database security measures, specify users and user access levels for each database.
• Troubleshoot, monitored, optimized and tuned using Database Tuning Advisor & profiler
• Maintenance plan mainly backup, database integrity, indexing, and statistics updates.
• Plan, Implement and test full disaster recovery at all levels of SQL Server.
• Created and managed indexes, tables, views, and stored procedures. High availability and disaster recovery solutions like mirroring, log shipping, replication, and clustering.
• Experienced in implementing operational automation using TSQL scripts and GUI.
• Modified existing databases and database management systems with developers to make changes.
• Backups, restores, database shrink operations, DBCC commands.

Environment: SQL Server 2008R2/2008/2005, Windows Server 2005/2003/2000, SQL Profiler, Visual Studio, SSMS, Erwin.