Ruth Abe

240-***-****

**** ******* ****

Pittsburgh PA, 15205

ads44l@r.postjobfree.com

Objectives

An experienced SQL Server DBA with detail oriented and troubleshooting having more than 4years of professional experience in different Microsoft products as a SQL Server Database Administrator. Solid working experience in managing large databases, backup/recovery, configuring and managing HA solutions. As a DBA professional and troubleshooting experience include SQL Server database administration, gathering and analyzing business requirement and Operating Systems, Monitoring, Performance Tuning, stored procedures, functions, constraints and views etc. Working experience entails strong knowledge on using database third party tools like SolarWinds, REDGATE, ServiceNow, Jira as ticketing tool and TSM as backup tools.

Education and Training

Pursuing Associates Degree in Computer Sciences (University of the People)

MCSA SQL Server 2016 Database Administration

Pursuing 70-764 Administering a SQL Database infrastructure

Pursuing 70-765 Provisioning SQL Databases

Certification

Microsoft Technician Associate Database Administration

Experience

CITIZENS CARE INC

SQL Server Database Administrator Jan/2018- Present

Responsibilities:

•Regular monitoring of servers, which includes backup jobs monitoring, Disk space monitoring, Services monitoring, and blocking monitoring and troubleshooting using SSMS. Responsibilities:

•Database Migration from On Prem to AWS RDS

•Installation, Upgrades, Patching and Configuration of MS SQL Server 2016, 2014, 2012, 2008R2 in different 32/64-bit production, test, and development environments.

•Responsibilities include performance monitoring, security, backups, patches, troubleshooting, refresh, and data recovery, minimize downtime, maintain various environments, perform testing and documentation of processes. Proven working experience as a Database administrator.

Creation and maintenance of Databases, creating Roles and managing user permissions

and Admin groups.

Automate maintenance plan jobs in SQL Server agent and task scheduler: such as backup database, index rebuilding, index reorganizing, cleaning up, and updating statistics.

Assist in the development of new application systems and database changes.

Supports day to day operational duties for the database platform such as service now

requests and tickets, and other tasks as assigned or expected from DBAs.

Responsible for Securing SQL server, user management, assigning permissions and roles.

Perform database deployments (After work hours) and provide support for application releases

Support all areas of the enterprise, ensuring all databases run at optimal performance

Administer and monitor 24/7 applications and systems, developing automated alerts to

warn of failure

Provide DBA support and technical expertise for multiple applications in development, test, QA and production - SQL Server 2008R2, 2012, and 2014 environments

Participating in on call rotation.

Experience in Implementing high availability with Always on Availability and Failover Clustering with Disaster Recovering.

Hands on experience trouble shooting when SQL Server is Paging out.

Perform database performance analysis and optimization, define bottlenecks, manage testing and production implementation.

Prepare reports on administration best practices, new technologies, etc., and recommend enhancements and configuration changes to improve and optimize the environment.

Work with project teams as required to design technical solutions to address project requirements.

Work with leadership to research, define, interpret, and analyze complex, unstructured technical database problems and recommend solutions, and implement them.

Ability to work with a team to provide written responses to technical proposals and /or reports/documentation for delivery.

Capital Health & Human Services

SQL Server Database Administrator JAN/2017 - NOV/2018

Responsibilities:

•Installation, Upgrades, Patching and Configuration of MS SQL Server 2016, 2014, 2012, 2008R2 in different 32/64-bit production, test, and development environments.

•Regular monitoring of servers, which includes backup jobs monitoring, Disk space monitoring, Services monitoring, and blocking monitoring and troubleshooting using SSMS.

•Ensuring data recovery, maintenance, Data integrity and space requirements for physical database.

•Creation and maintenance of Databases, creating Roles and managing user permissions and Admin groups.

•Automate maintenance plan jobs in SQL Server agent and task scheduler: such as backup database, index rebuilding, index reorganizing, cleaning up, and updating statistics.

• Supports day to day operational duties for the database platform such as service now requests and tickets, and other tasks as assigned or expected from DBAs

•Responsible for Securing SQL server, user management, assigning permissions and roles.

•Perform database deployments (After work hours) and provide support for application releases

•Assist developers with MS SQL Server issues and questions

•Administer and monitor 24/7 applications and systems, developing automated alerts to warn of failure

•Provide DBA support and technical expertise for multiple applications in development, test, QA and production - SQL Server 2008R2, 2012, and 2014 environments

•Expertise Implementing high availability with Always On Availability and Failover Clustering with Disaster Recovering

Skills

4 Years of Database Administration on MSSQL Server 2016,2014, 2012, 2008R2.

Experience in Migrating from SQL server 2008R2 to 2012, 2014 and 2016 by using In-Place upgrade process as well as side-by-side upgrade process.

Experience in Supporting Different High Availability & Disaster Recovery scenarios like Always-On Availability Groups, Clustering, Replication models, Log Shipping and Database Mirroring.

Designs and maintains access and security administration

Served as support for database administration tasks including configuration management, backup/ restores and recovery models, performance optimization, and space management.

Experienced with DMS (Database Migration Services) tools to migrate data from On- premises to Cloud.

Experience in Database Migration from On-Prem to AWS RDS

Experience in setting up and managing database security by creating new users, roles, and provide required user privileges in development, test, training environments.

Experience in implementing operational automation using scripts.

Experience using PowerShell. (Still learning)

Experience handling Locks, Deadlocks, Detect CPU, I/O, Memory Bottlenecks, Optimization, Performance tuning of SQL Server databases using Extended events, DMVs, Activity Monitor, SQL Profiler, DB Tuning wizard, and third-party tool. (SOLARWINDS AND REDGATE) Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities, Re-Indexing, Updating Statistics, performing Maintenance Tasks.

Diagnosed job errors and implemented solutions.

Experience in importing/exporting data from various sources of data into SQL Server Databases and vice versa

Provide 24 X 7 Production Database on Call Support per the published schedule, with the expectation of after-hours support for unplanned service disruptions as well as planned maintenance windows.

Perform database performance analysis and optimization, define bottlenecks, manage testing and production implementation.

Have a flair for technology and willing to take up challenging assignments

Have excellent analytical, problem solving, communication and interpersonal skills with ability to interact with people at all levels and can work as part of a team or independently.

Devoted and Quick learner with ability to master and implement recent technologies.

Excellent professionalism, communication, and interpersonal skills.

Ability to communicate proactively to management any potential issues that may hinder the ability to meet project deadlines

Contact this candidate