Resume

Sign in

SQL SERVER DBA

Location:
Pittsburgh, PA
Posted:
April 22, 2021

Contact this candidate

Resume:

Helen Ogom

412-***-****

Pittsburgh PA, *****

adlvuo@r.postjobfree.com

Objectives

An experienced SQL Server DBA with detail oriented and troubleshooting having more than 5 years 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, triggers, functions, constraints and views etc. Working experience entails strong knowledge on using database third party tools like SolarWinds, and ServiceNow, Jira as ticketing tool.

Education and Training

Associates Degree in Sciences

MCSA SQL Server 2016 Database Administration

Pursuing 70-764 Administering a SQL Database infrastructure

Pursuing 70-765 Provisioning SQL Databases

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:

•Installation, Upgrades, Patching and Configuration of MS SQL Server 2017, 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. Additional responsibilities to define users, minimize downtime, maintain various environments, perform testing and documentation of processes. Proven working experience as a Database administrator.

Expertise in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.

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.

INTEGRITY HOME HEALTH CARE

SQL Server Database Administrator JAN/2016 - NOV/2017

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

•Deploying SSIS packages and SSRS reports

•Provide DBA support and, test, QA and production - SQL Server 2008R2, 2012, and 2014 environments

•Participating in on call rotation.

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

Skills

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

Experience in Migrating from SQL server 2008R2 to 2012, 2014, 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.

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)

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.

Formulates policies, procedures, and standards relating to database management, and monitors transaction activity and utilization.

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