Post Job Free

Resume

Sign in

Database Administrator Sql Server

Location:
Peachtree Corners, GA
Posted:
January 18, 2024

Contact this candidate

Resume:

Happy Williams

Email : ad2vmm@r.postjobfree.com 1-404-***-****

PROFESIONAL SUMMARY

Database Administrator with about 7 years’ experience in designing, implementing, and maintaining SQL Server solutions in an Enterprise environment. A passionate, enthusiastic, detail-oriented, reliable and self- motivated team player with passion to impact knowledge. I have experience in the healthcare and finance industry as well.

AREAS OF EXPERTISE

Database Security

Replication

Database Maintenance

AlwaysOn availability groups

Indexing

Database upgrades

Performance tuning

SQL Azure migration

T- SQL

Log Shipping

Failover Clustering

Database monitoring tools

and application support

Troubleshooting capabilities

Configurations

PROFESSIONAL EXPERIENCE;

Dove Technology- Norcross, Atlanta – October 2022 to date SQL Server Database Administrator

Monitoring database size and disk space in Production, Staging & Development environments.

Backing up and restoring databases as a Disaster Recovery Maintenance and Contingency plans.

Configuring Replication and Log Shipping as High Availability Solutions and Disaster Recovery

Creating logins and granting access to user by assigning server and database roles.

Database administration activities including installation, configuration, capacity planning and space management.

Configuring AlwaysOn availability groups.

Optimizing queries by creating clustered, non-clustered indexes and indexed views.

Conducting Performance Tuning using SQL Profiler and Windows Performance Monitor.

Scheduling Maintenance plans (Rebuild and Reorganize indexes, backup and clean-ups).

Handling ETL processes using SQL server integration service (SSIS)

Working with developers, support and QA team to maintain all database environment

Using Replication Monitor to check the performance of replication

Importing flat files into SQL database using SSIS

Developing reports using SQL Server reporting services (SSRS) UPS HealthCare, Duluth, Atlanta June 2020-August 2022 Healthcare Quality Assurance Specialist

Managed multi-client and site-specific projects simultaneously to ensure all procedural, personnel, and regulatory updates are effectively and efficiently implemented.

Chair for site Quality Working Committees that included Quality Management System metric trend reviews with multi-disciplinary group.

Performed thorough root cause analysis on effective investigative facilitation for site non- conforming events and noted areas of risk within facility.

Maintained all product releases for clients

Training management and warehouse associates-retaining rosters and rostering in EQMS

Followed standard Operating Procedures to verify and received products into the integrated production software with high accuracy.

Ensured timely order fulfilment including receipt of customer priority healthcare products into the warehouse facility.

Dove Technology-Atlanta, February 2017– March 2020 SQL Server Database Administrator

Performing database upgrades, Backup and Recovery plans

Conducting Performance Tuning using SQL Profiler and Windows Performance Monitor.

Configuring Log Shipping as High Availability Solutions and Disaster Recovery

Migration of data across different databases and different servers.

Setting up profiler trace to capture activities on the server.

Analysing Event viewer to check errors related to replication, Mirroring and log shipping.

Monitoring database size and disk space in Production, Staging & Development environments.

Backing up and restoring databases as a Disaster Recovery, Maintenance and Contingency plans

Optimizing queries by creating clustered, non-clustered indexes and indexed views.

Conducting Performance Tuning using SQL Profiler and Windows Performance Monitor.

Scheduling Maintenance plans (Rebuild and Reorganize indexes, backup and clean-ups Education and Certificates

MICROSOFT CERTIFIED-AZURE DATADASE ADMINISTRATOR ASSOCIATE-2021 MBA-FINANCE -2011-UNIVERSITY OF GHANA

BACHELOR OF SOCIAL STUDIES EDUCATION -2006-UNIVERSITY OF EDUCATION, WINNEBA, GHANA



Contact this candidate