NoriceJohnson

Cell 470-***-****/ advgii@r.postjobfree.com/ Atlanta GA

Professional summary

A skilled Database Administrator with 5 years of experience and a good background in database management and development. Ability to manage different projects at the same time while adhering to strict deadlines. Well versed in backup and recovery, High Availability and Disaster recovery. Excellent verbal and written communication skills with willingness to learn and grow my skills. EXPERIENCE

Carmax - SQL Server Database Administrator

Atlanta Ga- 06-2020 - present

● Responsible for database migration from SQL Server 2016-2019

● Perform backup and recovery in ways that meets the business RPO and RTO

● Administer, support and monitor by proactively resolving database issues and maintaining servers

● Responsible for configuring and supporting SQL server always on high availability groups and other disaster recovery solutions

● Execute automation and maintenance tasks using SQL agent and task scheduler

● Secure SQL servers, database and objects by creating user logins with appropriate roles, monitoring of user accounts, passwords and TDE encryptions

● Set up and configured DB mail and created jobs as part of SQL monitoring for any job failure

● Provide access, roles and login permissions for users as well as developers to help with assigned tasks

● Expertise in index tuning, rebuild and reorg strategies

● Configure and maintain database servers and processes including monitoring of system health and performance

● Maintain database response times in 24x7 production environments

● Regular monitoring of services, which includes maintenance jobs, disk space monitoring, service, monitoring, and block monitoring using SEM (SQL enterprise manager)

● Monitoring standby database to ensure high availability

● Assist with deploying SSIS packages in Visual studio and code review

● Experience working with windows server, including active directory Delta Dental Insurance -MS-SQL server database Administrator Atlanta ga 8-2018- 04/2020

● Upgraded from 2008R2 to SQL 2012, to 2016

● Handled administration of SQL server 2005 to 2017 providing productions to for over 500 instances

● Developed and executed scripted change request and accordance with change control procedures

● Established and scheduled database backups, making sure that the backup schedules met the recovery requirements on a daily as well as monthly basis

● Worked on T-SQL scripts, stored procedures, DMVs, views, functions, triggers and also made use of Powershell for automation

● Deployment of SSIS packages for SQL server objects and report

● Worked on service request an incident tickets in order to facilitate workflow

● Monitor rise and optimize system performance, Susan Sql, profiler and database engine tuning advisor

● Performed all aspects of database management, including insulation, patching back up, recovery performance, tuning security administration, and space management

● Set up an configure DB email and creating jobs to send out an email whatever any Sql jobs fail

● Created database and logins with permission per request

● Created and modified tables, stored procedures, views, index is user defined functions and triggers requirements on SQL server requirements

● Managed index fragmentation to improve performance SKILLS

● Always on high-availability

● SQL profiler

● Database Tuning advisor

● Disaster recovery

● Backup and restore

● Database security

● Data migration

● Performance tuning, and monitoring

● Database upgrade and patches

● Windows

● SSIS

● DBCC

● MS Access

● Database design

● DMV’s

Contact this candidate