Michael A. Watford

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

Lawrenceville, VA 30043

Cell Phone: 770-***-****

E-mail: acs5rd@r.postjobfree.com

EDUCATION: DeVry Institute of Technology, Decatur GA 30033, CIS, BS Degree 10/2000

Boston University, Boston MA, 02215 MIS, ADV Database MGT/BI 05/2012

CERTIFICATIONS: Certified Microsoft SQL Server 2012 Administration,

CompTIA Security Plus+ ce

SUMMARY

I Offer 16-years’ experience and background supporting IT Systems using various Microsoft SQL Server Databases Tools i.e. SSIS/SSAS/SSRS. Worked on many platforms including Windows 2003/2008/2012. I provide excellent IT systems computer support to end users and business professionals. I worked with High Availability environments including Log Shipping, Failover Clustering, Always on Availability Groups, Replication, Mirroring and Data Warehousing, I demonstrate highly-skilled troubleshooting ability, leading to millions of dollars of increased revenues due to improved efficiencies. Certified Microsoft SQL Server Administration, develops, implements, and maintains large databases, ensuring system security and effective operation. I provide excellent customer support and end-user training.

Provides effective Software/Hardware, web based applications and database support, implementation, end-user training, data analysis, and expert solutions to problems.

WORK EXPERIENCE

01/2015 – Present, Sr. SQL Server Database Administrator, Department of Defense, Norfolk, VA.

Oversee, manage, and administer multiple network database, application, and administrative support servers in support of command operational test programs

Provide technical guidance to managers and functional users to resolve staff problems and inquiries on database systems.

Implement and maintain database security by creating users and assigning privileges.

Maintain user and group permissions within the SharePoint environment, monitoring storage quotas and interfacing with COTF IT.

Perform daily SQL tasks including checking SQL error logs, available physical disk space, event viewer, jobs for failed completion, backups and log sizes, and outstanding active or blocked transactions.

Diagnose and resolve problems in response to customer reported incidents.

Analyzes data, evaluates quality, identifies errors and trends, create plans for error correction and reversal of negative trends in data quality.

Maintain databases for data storage, manipulation and retrieval Run weekly indexing and integrity checks.

Develop purge and archive criteria and procedures for historical application data.

Perform database administration for Warfare Capability Baseline (WCB) and other database applications across multiple environments (such as test, development, and production) as well as network platforms.

Continued

Page 2

Receive and conduct training to include completion of all COTF IT required trainings and interface with COTF IT.

Provide complex, technical analytical system support and serves as the DBA for critical command information systems.

Responsible for providing technical support for the database environment which includes single, clustered and mirrored servers.

Conduct database tuning and performance monitoring to increase response time.

12/2013 – 01/2015, Sr. SQL Server Database Administrator National Credit Union Administration, Austin, TX.

Provides information technology, application support assistance to NCUA Liquidation Analysts Serves as the AMAC, Division of Finance representative for the inventory of credit union computer systems by creating and managing the inventory of the hardware.

Automates administrative processes by considering interrelationships of datasets and meaningful reporting using SSIS/SSRS. Applies knowledge of various automation functions and capabilities to select the best project to complete task.

Perform information system administration and database administration.

Serves as the AMAC liaison with outside vendors regarding various aspects of liquidated credit union computer systems; such as, restoring and backing up data, obtaining forensic data, imaging hard drives, and post-liquidation setup of computer systems for accessing credit union data.

Prepare information products including models, figures, tables, and written documentation from original analyses.

Creates and manages AMAC internal databases and provides database support to AMAC staff.

Serve as an information system Security Administrator.

Monitor file and data maintenance through evaluation of file storage needs to ensure accessibility and search ability of the organization’s enterprise documents.

Provides detailed written reports to AMAC management regarding inventory and data

Receive computers systems and data from liquidated credit union systems.

Implement new processes and evaluate changes to improve process flow.

Writing VBA Code for Microsoft Excel and Microsoft Access to create automated processes.

Used system development life cycle to design application to support user needs

Page 3

11/2011 – 12/2013, Sr. SQL Server Database Administrator, Incomm Atlanta, GA, 30303.

Manage 1108 Databases SQL Servers running on 220 Instances.

Oversee 32 instances 480 Database production databases and disaster recovery site

Work with Development team software developers to design, ERD, and creating stored procedures.

Manage system upgrades, issues, performance tuning, Clustering and replication for SQL Server 2005

Conduct SharePoint training to the organization’s users for basic and advanced SharePoint functionality.

Challenged the team to engage in problem solving using new technologies available to them.

Create and conduct policy in regards to database administration backup and recovery processes.

Used SQL Profiler and Index Tuning advisor to troubleshoot and improve performance problems.

Distributed work evenly amongst 18 Database Administrator both Oracle and SQL Server.

Maintain SQL Server 2000 Database, Application Server and Interface Server allowing transactions to cross.

Installed and configure SQL Server 2005/2008 in development and production set up replication.

Test Develop, and administer database backup and recovery procedures setup log shipping.

Use Enterprise Manager to monitor Database for tuning and backup jobs.

12/2010 – 11/2011, Sr. SQL Server Database Administrator Manhattan Associates

Atlanta, GA, 30303

Administrator 18 Production 12 SQL Servers 5 MySQL instances, 280 Databases managed backup/recovery and disaster recovery.

Create SQL scripts with MySQL to monitor performance and track workload.

Manage database upgrades, performance tuning, multi-master Clustering and replication using MySQL.

Used windows operating system with MySQL to control data files and directories.

Responsible for database backup’s & restores, optimizing various databases, physical database design.

Installation of MySQL databases enforces and maintains database constraints to ensure integrity.

Responsible for securing all MySQL databases using port 3306, allowing access to only authorized users.

Used MySQL Data Modeling to assist Data Warehousing and database design projects.

Created DB objects, including tables, indexes, views, sequences, packages and procedures etc.

Use SQL Profiler to help in troubleshooting performance issues and make improvements to OLTP systems.

Integrated MySQL databases with various applications servers, apache, and PHP to Linux.

Created ETL, SSIS processes, Cubes, manage complete incremental refresh for Data Warehouse projects.

Continued

Page 4

Maintain SQL Server 2000 Database, Application Server and Interface Server allowing transactions to cross.

Installed and configure SQL Server 2005/2008 in development and production set up replication.

Test Develop, and administer database backup and recovery procedures setup log shipping.

Use MySQL Administrator to monitor Database for tuning and backup jobs.

Use MySQL to import export data and create jobs for various activities

04/2009 – 12/2010, Sr. Database Administrators, State of Georgia, 47 Trinity Ave, Atlanta, GA, 30303.

Administrator 4 SQL Servers 120 Databases managed backup/recovery and disaster recovery.

Worked with large 2 TB SQL Server 2005 Databases, created Fact and Dim tables, created and modified SSIS packaged to support and monitor Data Warehousing.

Manage system upgrades, issues, performance tuning, Clustering and replication for SQL Server 2005

Use SSIS/SSRS 2005 SQL Services to import export databases and create jobs, reports to run different activities.

Created ETL, SSIS processes, Cubes, manage complete incremental refresh for Data Warehouse projects.

Create and conduct policy in regards to database administration backup and recovery processes.

Setup multiple servers with MS Server 2003 to run SQL Server 2000 in clustered environment for high availability.

Setup Transaction Replication for speed and reliability to improve SQL queries.

Created scripts for logical and hot Backups, exporting Schema Objects into a dump file.

Maintain SQL Server 2000 Database, Application Server and Interface Server allowing transactions to cross.

Use SQL Server 2005 to manage database files, run backups, and tune the system, leading to improved performance.

Create edit and monitor Backup/Recovery jobs for all SQL Server Databases.

Use SQL Management Studio to monitor Database for tuning and backup jobs.

Use SSIS 2005 SQL Services to import export data and create jobs for various activities.

03/2008 – 04/2009, 40 Hours per Week, Sr. Database Administrator, TRX, 445 Clairmont Rd Atlanta, GA, 30336.

Administrators 40 SQL Server Databases managed backup/recovery, and disaster recovery.

Developed Business Intelligence Applications using SQL Server 2005 Business Intelligence Development Studio, SSRS, Automating Reports, and Data Warehousing.

Manage system upgrades, issues, performance tuning, Clustering and replication for SQL Server 2000-2005

Use SSIS/SSRS 2005 SQL Services to import export databases and create jobs, reports to run different activities.

Created ETL, DTS processes, Cubes, manage complete incremental refresh for Data Warehouse projects.

Administrated 15 Oracle databases version 7 to 10g running on UNIX, HP-UX, Linux, and Solaris.

Create and conduct policy in regards to database administration backup and recovery processes.

Monitored the SGA and tuned the Shared Pool and Rollback Segments.

Page 5

Setup multiple servers with MS Server 2003 to run SQL Server 2000 in clustered environment for high availability.

Setup Transaction Replication for speed and reliability to improve SQL queries.

Created scripts for logical and hot Backups, exporting Schema Objects into a dump file.

Maintain SQL Server 2000 Database, Application Server and Interface Server allowing transactions to cross.

Use SQL Server 2000 to manage database files, run backups, and tune the system, leading to improved performance.

Create edit and monitor RMAN Backup/Recovery jobs for all Oracle Databases.

Use SQL Management Studio to monitor Database for tuning and backup jobs.

Use SSIS 2005 SQL Services to import export databases and create jobs to run different activities...

09/2007 – 03/2008 IBM, DBA-SME (Oracle, SQL Server), Remote Contract work,

Administrated 18 Database Administrators (Dab) 11 SQL Servers and 7 Oracle Dab’s.

Oversee 32 instances 480 Database production databases and disaster recovery site

Work with Development team software developers to design, ERD, and creating stored procedures.

Manage system upgrades, issues, performance tuning, Clustering and replication for SQL Server 2005

Challenged the team to engage in problem solving using new technologies available to them.

Create and conduct policy in regards to database administration backup and recovery processes.

Used SQL Profiler and Index Tuning advisor to troubleshoot and improve performance problems.

Distributed work evenly amongst 18 Database Administrator both Oracle and Sal Server.

Installed and configure Sal Server 2005/2008 in development and production set up replication.

Prioritizes requests and routes assignment to appropriate team member.

Use Grid Control to monitor Database for tuning and backup jobs.

Controlling and monitoring user access to databases

01/2005 – 08/2007, 40 Hours per Week, Team Lead. Database Administrator, Metropolitan Atlanta Rapid Transit Authority, Atlanta, GA, 30324,

Duties

Manage the backup configuration testing and implementation of 62 Oracle/Server 2000 databases.

Supervise three other DBA’s to accomplish the goals and mission set forth by Management.

Create and conduct policy in regards to database administration backup and recovery processes.

Monitored the SGA and tuned the Shared Pool and Rollback Segments.

Setup Oracle 10g Real Application Clusters for high availability on Redhat Linux.

Tuned logical and physical Oracle structures and SQL queries.

Created scripts for logical and hot Backups, exporting Schema Objects into a dump file.

Maintain SQL Server 2000 Database, Application Server and Interface Server allowing transactions to cross.

Use SQL Server 2000 to manage database files, run backups, and tune the system, leading to improved performance.

Page 6

Accomplishments:

- Successfully implemented Oracle e-business suites for accounting and finance software.

Contact this candidate