SUMMARY

• Seven Plus years of SQL Server Database Administration experience on Development, Sandbox, Test, and Production environments.
• Experience in Installing, Configuring, Managing, Migrating/Upgrading Database, and Troubleshooting issues related to SQL Server 2014/2012/2008 R 2/2008/2005/2000 .
• Monitoring Database Performance and Tuning using SQL Server Profiler, Database Tuning Advisor, Activity Monitor, and Performance Monitor.
• Automating Jobs, Creating Maintenance Plans, Creating, Reorganizing, and Rebuilding Indexes.
• Experience on SQL Server Security and Audit Management.
• Experience on SQL Server High Availability and Disaster Recovery solutions, including Database Backup/Restore, Log shipping, Mirroring, Replication, AlwaysOn Availability Group, and Failover Clustering.
• Experience in Creating Stored Procedures, Triggers, User Functions, and Views.
• Experience on applying Service Packs and Hot Fixes.
• Excellent customer support on a 24/7 availability.
• Proficient in creating Index, Views, Complex Stored Procedures and appropriate User defined functions.
• Experience in creating scheduling Jobs, Alerts, and SQL Mail Agent
• Dynamic, result oriented, self - motivated individual and always eager to learn new things with excellent communication, interpersonal and presentation skills
• Ability to work on fast-paced work environment.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and maximize performance, implementing technology solutions, and training /supporting end users.
• Performance, implementing technology solutions, and training /supporting end users.

TECHNICAL SKILLS

Database: SQL Server 2014/2012/2008 R 2/2008/2005/2000 .

SQL Server Tools: SQL Profiler, Database Tuning Advisor, Performance Monitor, Activity Monitor, SQL Server Utility, Extended Events, Event Viewer, Central Management Server, Query Analyzer.

BI Tools: SSIS, SSAS, SSRS, DTS, BCP, MSP

Content Management: QC/ALM, JIRA, Discovery, System Center Operations Manager (SCOM-SQL Server Configuration Manager), Visual Studio, TFS

Data Modeling: SQL Server Database Diagram (SSDD), Visio

Programming Languages: T-SQL

Platforms: Windows Server 2012R2/2012, 2008R2/2008/2003; Windows 7/8/10/Vista/XP

Cloud platforms: AWS

AWS Services: EC2, VPC, Databases, VPC, S3, Cloud Watch, Cloud trial, SNS, SQS, SWF, EBS

Ensuring Availability: incident management and on-call

Monitoring tools: OEM(Oracle) transition and ownership; IDERA(SQL) Configuration and wonership

Hardware: SAN, RAID, PC, zip drive.

PROFESSIONAL EXPERIENCE

Confidential

MS SQL Server DBA

Responsibilities:

• Installing, Configuring, and Managing MS SQL Server 2014 and 2016 in Development, Sandbox, Test, and Production environments.
• Migrating Databases from SQL Server 2008/2008 R2 to SQL Server 2014/2016
• Monitoring SQL Server 2014/2012/2008 R 2/2008/2005/2000
• Performance tuning and optimization.
• Resources capacity planning and Projection.
• Ensuring Company’s Global database support.
• Proactively working with Management and Infrastructure Team.
• Granting access for SQL Server Database users using the principle of giving least privilege.
• Resolving low disk space alerts, connection issues and failed jobs.
• Designed Company’s database disaster recovery plan with 8 team members.
• Identifying and troubleshooting CPU, Memory and I/O bottle necks.
• Configured database mail in all SQL Servers.
• Designing and implementing the backup and restore plan according to company’s Recovery Time Objective (RTO) and Recovery Point Objective (RPO).
• Preparing Standards and Company’s Best Practices.
• Creating Jobs and alerts in SQL Server Agent.
• Configured SQL Server Agent and automating alerts and maintenance plan jobs.
• Troubleshooting and root cause analysis for slow running quires, missing index, outdated statistics, blocking and deadlocking issues.
• Expertise on using SQL Server Profiler, Database tuning Advisor, Dynamic management views, sys tables and DBCC commands for troubleshooting.
• Resolving and monitoring database auditing.
• Regularly checking SQL Server and database overall health check.
• Configuring Central Management Server for multi-server administration.
• Supporting and monitoring 24*7 Production environments.
• Consolidated multiple ticketing systems, improving communication and ticket turnover rate by 5%.

Confidential

SQL Database Administrator

Responsibilities:

• Installed, Configured, and Managed MS SQL Server 2008R2 and 2012 in Development, Test, and Production environments.
• Managed Security and Maintained users and logins on SQL Server.
• Created Stored Procedures, Views, Functions, Triggers, and Index.
• Configured and Monitored SQL Server Log Shipping and Failover Clustering.
• Configured and Maintained AlwaysOn Availability Group in clustered environment.
• Performance Monitoring for Blocking, Locking, Deadlock, Resource Bottleneck (I\O, Memory, CPU utilization), and Index Fragmentation.
• Performance Monitoring/Tuning using SQL Server Profiler, Database Tuning Advisor, Windows Performance Monitor, Activity Monitor, and Query Analyzer.
• Importing/Exporting data to/from Comma Separated Values (CSV), Flat files, Excel, Access, and Oracle using SSIS, DTS, BCP utility.
• Performed Database Migration/Upgrade from different versions of SQL Server.
• Created Documentation for Installation, Security policies, Configuration changes, Migration, and Deployment procedures.
• Participated on database design.
• Applied Service Packs and Hot Fixes on SQL Server 2008R2/2012.