SUMMARY:

• Immense practical experience in SQL Server Security, Maintenance, Backup, Recovery and implementation of High Availability and Disaster Recovery as SQL Server Database Administrator.
• Excellent interpersonal abilities with the capacity of building and maintaining strong professional relationships with teams, programmers and technical staff at all levels.
• Having a creative flare with the ability to think outside of the box.
• Natural capacity for leadership and enjoys supporting the development of team members.
• Able to assume responsibility for achieving outcomes and making sound decisions
• Sound time management capabilities, able to successfully balance multiple and competing priorities.
• Experience of T - SQL Programming in writing Stored Procedures, Triggers, Functions and Joins.
• Expertise in DDL, DML and using Aggregate Functions.
• Exposure and Experience of Always on Availability groups in SQL Server 2012 and 2014.
• Hands on experience in SQL Server Clustering implementation and administration
• Hands on experience in SQL Server and Database Performance Tuning.
• Highly skilled in Setting up, monitoring and troubleshooting Replication, Database Mirroring and Log shipping.
• Expert in creating Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, task assignment and tracking.
• Experience on Azure SQL Database.
• Hands on experience in using SQL Server Integration Services (SSIS) including package creation, shrinking databases, updating stat, backing up databases and deploying packages.
• Experience working on Amazon Web services (AWS).
• Strong customer service skills and experience in consulting users, resolving problems and meeting specific technical and business needs.
• Highly proficient in understanding end user requirements and submitting efficient and quick solutions with a solid background in technical and problem-solving concepts.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2005,2008/2008R 2/2012/2014/2016 and MS Access.

Operating Systems: Windows Server 2003/2003R2/2008/2008R2/2012/2012R2 and Windows XP/Vista/7/8/8.1 and 10.

ETL Tools: SQL Server Integration Services (SSIS).

Reporting Tools: SQL Server Reporting Services (SSRS).

Database Tools: SQL Profiler, SQL Tracer, System Monitor, Database Engine Tuning Advisor, SSMS, PowerShell Scripting.

Languages: TSQL.

Third Party Tools: Idera, Spotlight and Redgate.

Other Applications: MS Office 2003/2007/2010/2013/2016, VMware, SharePoint and Python

PROFESSIONAL EXPERIENCE:

Confidential, Ashburn, VA

SQL Server DBA

Responsibilities:

• Installed, configured and managed SQL Server 2014 and 2016.
• Managing SQL Server security including implementation of logins, roles, authentication modes and SQL Server audits for various users.
• Performance tuning and optimization of servers in production and test environment.
• Migrated databases from SQL Server 2014 to 2016 in test and production environments.
• Planned, defined, designed and analyzed databases using conceptual, logical and physical models.
• Configuring databases and monitoring health of server on daily bases and work on tickets based on priorities.
• Creating, modifying and managing tables, indexes, constraints, views, stored procedures and triggers.
• Working on Azure SQL Database.
• Scheduling database maintenance tasks to improve performance.
• Analyzing and optimizing T-SQL queries using execution plans and created indexes. planning and implementation of database backup and automation of backups using maintenance plans.
• Writing and creating PowerShell scripts to automate configuration changes or software updates to SQL Servers.
• Configured and managed Replication, Log Shipping and Always on Availability.
• Configuring database mail, operators and alerts to monitor server health and jobs.
• Creating SQL Server Agent jobs and maintenance plans to automate tasks such as index maintenance, backup jobs and update statistics.
• Regular monitoring of SQL Server agent jobs, checking event logs and error logs of any issues.
• Designing and development of SSIS packages to load data from different sources.
• Writing and executing upgrade scripts for making changes to the production server.
• Identifying and troubleshooting performance bottlenecks of CPU, Memory, I/O and disk space.

Confidential, Washington, DC

SQL Server DBA

Responsibilities:

• Managed Production and Test MS SQL Server 2012/2014 and provide support to development environments.
• Troubleshooted and resolved database integrity issues, performance issues, blocking and deadlocking.
• Migrated MS SQL Server 2012 database into MS SQL Server 2014 following established procedures.
• Administered SQL server security by creating user logins, monitoring the user accounts and granting of privileges.
• Created and deployed packages using SSIS, scheduled Jobs and Alerts using SQL Server Agent.
• Performed SQL Server and Database Maintenance regularly and as needed.
• Implemented & managed database clustering, failover and load balancing.
• Performed identification of SQL Server poor performances using performance monitor, activity monitor, DMVs and MS SQL trace tools.
• Run DBCC commands to check database consistency. backed up system and user databases regularly and restored them when necessary.
• Implemented Disaster recovery and High Availability plans of Log shipping, Replication and Always on Availability.
• Collaborated with network operators, application developers and DBAs to enhance end user experience.

Confidential, Washington DC

SQL Server DBA

Responsibilities:

• Installed service packs and patches on SQL Server 2008 R2 and 2012.
• Administered SQL Server Security by creating logins, passwords and roles.
• Implemented Disaster Recovery and High Availability plans of Log-shipping, replication and SQL server clustering.
• Monitored the database server performance and when required tuning of the TSQL-queries, stored procedures.
• Backed up and recovered databases and tuning up for better performance.
• Handled SQL Server job creation/automation, alerts and troubleshooting errors.
• Monitored the performance of the server using SQL Profiler, Performance monitor, Dynamic Management Views and Events.
• Developed Reports using SQL Server 2008R2/2012 Reporting Services (SSRS) and MS Access and generating Custom Reports and different types of Tabular Reports, Matrix Reports, and drilldown reports in multiple formats using multi-dimensional objects.
• Worked with TSQL programmers in writing Stored Procedures, Triggers and Functions.
• Rebuild and re- organized indexes periodically and when needed.
• Provided 24/7 technical support and monitoring.