SQL SERVER DBA Resume

SUMMARY

Having around 7 yrs. of experience in IT industry wif strong skills in SQL Server DBA & support AWS Administrator (IaaS)
Experience in implementing SQL Server Security and Object permissions like maintain Database Authentication modes, Creation of users, configuring permissions.
Experience in Installation of SQL 2005, 2008R2, 2012, 2014 and 2016.
Experience in applying patches, hot fixes and cumulative updates.
Knowledge on Basic and Advanced Slipstream, SYSPREP and Unattended installations.
Experience in Point - in-time Recovery and Page Restoring.
Solving teh Suspect state when database went to recovery pending.
Configuring and maintain all types of Database Backups and Recovery operations.
Moving teh logins from one server to another by using sp help revlogin script.
Performing Database Maintenance Activities like Rebuilding/Reorganizing indexes and Update Statistics.
Experience on DB Refreshing (Quarterly once take a Prod backup to restore in Dev and Test Environments based on user request)
Experience in handling System & User databases corrupt situations.
Experience in resolving Blocking/Locking and dead locks Issues.
Experience in Upgrading & Migrating SQL Server from one version to another version.
Scheduled jobs, created alerts, notifications wif SQL Agent & configuring Linked servers for data access between new and old servers.
Experience in Implementing and Problem solving of high availability solutions like
Log Shipping, DB Mirroring, Clustering and Replication.
Having a valuable experience on Always ON Availability Group and Creating Listener as per Client requirements.
Experience of Identifying Fragmentation levels and improving efficiency of databases by Re-organizing and Rebuilding indexes.
Experience on ITIL Process like Incident, Change, Problem management.
Having Knowledge on EC2, VPC, SG, ELB & Auto Scaling Group, IAM, Route53 and S3.
Experience in Installation & Configuration of EC2 Instances on Cloud (AWS).
Providing 24x7 dedicated supports for SQL Server production servers

TECHNICAL SKILLS

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

SQL Server Tools: Remedy, Lite Speed, SSMS, SQL Profiler, Performance Monitor.

Servers: Windows 2003/ 2008R2/ 2012/2014

Operating Systems: Linux, Windows 7/ 8.1 / 10

Virtualization: VM Virtual box, Hyper-V.

PROFESSIONAL EXPERIENCE

SQL SERVER DBA

Confidential

Responsibilities:

Involved in Installation and configuration of SQL 2008R2, 2012, 2014 & 2016.
Daily checking teh tickets assign teh tickets and resolve them as per priority levels using tools.
Planning & Performing Backup’s and Restoring of teh databases.
Implementation of Logins, Roles, Authentication modes as a part of Security Policies
Finding & fixing Orphan Users and Orphan Logins.
Configuring DB backups like full, differential, T-log by scheduling jobs by weekly and daily basis.
Maintenance activities using DBCC commands for maintaining optimum performance
Resolving DB issues like log space issue, tempdb space issue and disk space issues.
Migrated databases from SQL Server 2008R2 to 2014 as per requirements.
Implementation & maintenance of database mirroring and clustering.
Experience of Identifying Fragmentation levels and improving efficiency of databases.
Handling blockings and deadlocks and troubleshooting using DMV’s and Extended Events.
Troubleshooting suspect database state and resolving issues wif minimal data loss.
Monitoring teh SQL Agent Job Failures and identifying root cause of job failure.
Creating jobs and maintenance plans as per business requirements.
Checking teh status of backups and troubleshooting teh failed backups.
Implementing and maintaining of Log Shipping wif Failover.
Resolving teh Disk space issues and finding teh root cause and permanent fixes.
Refreshing Databases in Development /Testing environments on request basis.
Optimizing queries using Update Stats and Index Rebuild operations.
Deployed teh SSRS RDL files to both LIVE & DR Links when customer needed.
Checking teh status of backups and troubleshooting teh failed backups.
Identifying and resolving Blocking and Deadlock issues.
Reviewing SQL Server Error log and Event viewer.
Troubleshoot various problems that arise in day-to-day work and fix teh issues.
Performing DB Checks using DBCC commands
Providing on-call support for production systems wif rotation basis.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship