Database Administrator Sql Server
Resume:
Happy Williams
Email : *********@*****.*** 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