SQL DBA Resume

SUMMARY

4 Years of experience as SQL Server DBA (2008, 2008R2, 2012, 2014, 2016 and 2017) in Production and non - production environments.
Installation and Configuration of MS SQL Server in Windows environment.
Good experience in Migration/Up-gradation of Databases from SQL 2005 and 2008R2 to SQL 2012, 2014 and 2017.
Involved in capacity planning for new in frastructures.
Configuring and Monitoring Log Shipping, AlwaysOn, Database mirroring.
Knowledge in configuring Transactional Replication.
Planning & perform all types of Backup's and Restore of the databases.
Hands on experience of implementing Database Maintenance plans.
Experience in controlling the User Privileges, Monitoring and Security issues as per client's Standard.
Performing health checks like backups, Disk Space, Jobs/Maintenance plans, SQL service status, Logs
Performed Database Refresh tasks from production to Non-Production Servers.
Resolving the Disk space, Temp DB full and Log files issues.
Having basic understanding and knowledge of Microsoft Azure AZ-900 Fundamentals.
Applying Service Packs and Security patches for the servers as released/requested.
Experience in Configuring AlwaysOn and troubleshooting.
Having customer handling experience from Onsite.
Maintaining a centralized inventory with all details as below.

TECHNICAL SKILLS

Databases: MSSQL, Linux And Aws

Ticketing Tools: Jira service desk and ServiceNow

Server Tools: Jump Box

Maintenance Tools: Zabbix

Key Skills: MS Excel, MSSQL Server, Database Administration, Technical support, troubleshooting, performance tuning, Application Support, Database consultation, High Availability, Disaster recovery, backup Management, Monitoring.

PROFESSIONAL EXPERIENCE

Confidential

SQL DBA

Environment: MS-SQL Server 2005,2008R2, 2012, 2014, 2016 and 2017, Windows 2008, 2012 R2 and 2016

Responsibilities:

Providing day-to-day Support and Maintenance for SQL Server databases.
Installation and Configuration of MS SQL Server in Windows environment.
Performing health checks like backups, Disk Space, Jobs/Maintenance plans, SQL service status, Logs
Monitoring SQL Server logs and Windows logs.
Involved in capacity planning for new infrastructure.
Creating Logins, Assigning Roles for the requested users for SQL server post building of SQL server.
Creating databases as per business requirement.
Configuring HA solutions like log shipping, Database mirroring and Always-on.
Created KB articles for all the Incidents we receive on daily basis.
Experience in database migration from Lower to Higher versions.
Good Experience in Performance tuning activities like verifying the slow running queries.
Refreshing Database from Production to Test/dev Environment as per request.
Mitigating various risks such as Database recovery model, backup.
Mitigating vulnerability servers and updating the SQL Server patches and service packs.
Working on various infrastructure changes and supporting various DR activity.
Working on SNOW incidents and providing 24/7 support.

Confidential

Linux Admin

Environment: CA siteminder

Responsibilities:

Monitoring the system performance and tuning using monitoring tools
Job scheduling and automating process using CRONTAB
To work on User administration tasks of users& group administrations.
Installing packages on Linux servers using Yum and RPM utilities.
LVM disk management.
Patching management to the servers.
OS upgrade activities.
Restarting the services.
Installing & configuring various services like NFS, Apache web server, Samba, FTP.
Setup NFS & Samba File sharing on windows and Linux servers
Prepare required documentation & SOP’s.
Worked Directly with The Customers to Understand the Case and Customer Requirement.
Updating YUM repository.
Monitoring of Linux servers like CPU, Memory, Disk utilization.
Adding Users Assigning Roles and Provisioning of Users.
Troubleshooting and Fixing Site Minder Issues by Directly Interacting with Customers and Providing Solutions.
Preparing RCA (Root Cause Analysis) for the Major Issues.
Reviewing and Maintaining Logs for Production Failures.
Coordinating and Supporting All Major and Minor Changes in Production Environment as Per the Change Management Control Process.

Confidential

Engineer

Environment: SAP

Responsibilities:

As an Engineer, I am responsible for providing support for troubleshooting requirements in the Engineering Infrastructure service or Product/Package Implementation space.
You are expected to apply know-how with minimal or broad supervision and be involved in implementation, integrated testing, debugging and documentation and may be required to work as on-call support or in shifts.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship