Frank Mosley, Jr.

*** ********* ******, *********, ** 37076 · Cell: 615-***-**** · Email: ad05cw@r.postjobfree.com

Professional Website: www.fmosley.com

PROFESSIONAL SUMMARY

Experienced DBA with 20 years as a DBA Consultant, Lead DBA, and DBA Project Manager supporting various database environments.

Azure SQL Database Training

Azure Data Lake Storage Service (Gen1 and Gen2)

Azure Create SQL Database

Azure Query Editor

Query Azure SQL Database using SSMS

Azure Always Encrypted

Migrating SQL Server Database to an Azure SQL Database

Elastic Pools

Virtual Machines and Managed Instances

Backing up the Azure SQL Database

Restoring an Azure SQL Database

Securing an Azure SQL Database

High Availability and Disaster Recovery

Monitoring and Tuning Azure SQL Database

Evaluate and Implement an alert and notification strategy

PROFESSIONAL EXPERIENCE

May 2023 –

September 2023 DB2 DBA Contractor

HCA Corporation, Nashville, Tennessee

Provided database support for the Lawson ERP Payroll system upgrade to V10.

Database support involved the AIX application server and the DB2 V12 z/OS data sharing sysplex environments. Database responsibilities involved the creation of databases, tablespaces, tables, indexes, views, granting security and generating backups.

January 2015 -

March 2023 Remote DBA Contractor

Arkansas Blue Cross Blue Shield, Little Rock, Arkansas

Provided SQL Server 2008 R2/2012/2014/2016 database support for the Enterprise Content Management Imaging Systems.

Utilized Windows Powershell with SQL Server.

Providing DB2 UDB 11.1 AIX and DB2 11.5 Red Hat Linux database support for claims processing. DB2 AIX and RHEL support includes application patch process, backup and restore, DMS to Automatic storage conversion, upgrades, performance tuning and risk management assessment.

Utilized export, import, load, restore database and db2move for application development. Generated weekly reorgs and runstats for production tables and indexes along with reclaimable storage.

Generated DDL for the databases, tablespaces, tables, views, stored procedures, triggers and functions. Issued grants for the roles in development, test and production systems. Created buffer pools, storage groups and large objects.

Utilized Netbackup policies for nightly backups of the DB2 AIX and Linux databases along with point-in-time restore.

For DB2 V11.5, utilized dsmtop utility for database monitoring the db2 instances.

For Capacity management, worked with workload manager for CPU, Memory and thread resources.

Utilized db2expln and db2advis for performance management along with dbm and db configuration parameters for setup and tuning the db2 instances.

Problem solving techniques involved reviewing the db2diag log files along with DB2 LUW technical documentation and working with IBM support regarding critical issues.

Supported data warehouse environments along with data replication and change data capture.

Worked on the migration of DB2 UDB V11.1 from AIX to Red Hat Linux.

January 2011 –

July 2014 Lead Database Administrator

Fruit of the Loom Corporation, Bowling Green, Kentucky

Provided project management, application and database support and strategic direction for various database platforms. The databases are SQL Server 2000/2005/2008/2012, Oracle 10g/11g/12c Grid Control, UDB DB2 and Teradata data warehousing.

SQL Server Database Administration

Installed and upgraded SQL Server on the Windows Server platform

Utilized T-SQL for database development

Created SQL Server databases, tables, indexes, views and stored procedures

Generated backups and recovery processes for SQL Server

Configure SQL Server Alerts

Creating SSIS Packages

Managing I/O Performance for OLTP workloads

Utilized SQL Profiler and Traces along with DMVs

Utilized Idera’s SQL Diagnostic Manager for Performance and Tuning

Database Mirroring Failover with SQL Server

SQL Server Clustering

UDB AIX Database Administration

Created UDB tablespaces, tables, indexes, views for data warehouse support

Managed UDB tablespaces and space utilization with TSM

Provided problem resolution for UDB on AIX as well

Created UDB stored procedures for ETL process

Created backup and recovery of databases for UDB on AIX

Setup UDB AIX interfaces for DB2 z/OS, SQL Server, Oracle and the AS/400 platforms

DB2 z/OS Mainframe Database Administration/Systems Programming

Upgraded DB2 V5 to V8 on z/OS Mainframe

Utilized SMP/E with installation and maintenance

Worked on DB2 data sharing migration process

Setup online reorgs for DB2 z/OS maintenance process

Created databases, tables, indexes, views, stored procs, etc.,

Setup backup and recovery processes for DB2 z/OS

Setup DDF interfaces for client server processing

DB2 log analysis

Provided problem resolution for DB2 z/OS Mainframe

Provided application support for DB2 z/OS Mainframe

Utilized Endevor

Participated in Disaster Recovery for DB2 z/OS Mainframe

IBM Tivoli Decision Support

Utilized File Manager

Utilized Omegamon DB2 for performance tuning

Shadow from Rocket Software

Utilized SQL Performance Analyzer for performance tuning

Sysview for DB2

Provides database assistance to the offshore development team.

November 2009 –

May 2010 DBA Contractor/Project Lead

Windstream Communications, Cleveland, Ohio

Served as the Project Lead for the upgrade of DB2 z/OS Mainframe for the data warehouse system. Developed project plans, managed risk, managed stakeholders, performed integrated change control and managed quality control.

December 1999 –

May 2009 Senior IT Specialist/IBM Consultant

IBM Global Services, Nashville, Tennessee

Responsibilities included DB2 z/OS Mainframe database administration, DB2 systems programming and IT Project Management.

Responsibilities as an IT Project Manager included the migration of PeopleSoft Financials ERP software from DB2 z/OS Mainframe to Oracle on UNIX.

Developed statement of work, project plan, supervised resources, managed risk, maintained budgets, and worked with procurement on client contracts.

Served as the Lead Database Administrator for the implementation of a data warehouse project for General Motors Corporation. The data warehouse was developed on the DB2 z/OS Mainframe platform for Brazil and Argentina.

The warehouse contained vehicle warranty information. Supported the application team during the project life cycle.

Proficient in CLIST, JCL, REXX, backup and recovery, DDL, DML and ISPF

on the DB2 z/OS Mainframe.

EDUCATION and TRAINING

Training

Azure Data Engineering – Azure Storage, Azure Data Factory, Azure Stream Analytics, Azure Databricks, Azure Data Lake, Azure Synapse, Azure Event Hubs

Azure SQL Database Administration – Azure SQL Database Backups, Azure SQL Database Restore, Azure SQL Database Security, Elastic Pools, High Availability and Disaster Recovery, Monitoring and Tuning Azure SQL Database

Snowflake Cloud Data Warehouse

Cosmos DB

Big Data and MapR Hadoop Operations Essentials Overview

MongoDB for DBAs

Master Certificate in IS/IT Project Management

Villanova University

Certificate of Achievement in Mastering Project Management,

Villanova University

Certificate of Achievement in Project Management for IS/IT Professionals,

Villanova University

Education

Master of Science in Computer Science, Jackson State University, Jackson, MS.

Bachelor of Science in Education, Tennessee State University, Nashville, TN.

TECHNICAL SKILLS

Databases: SQL Server 2000/2005/2008, UDB DB2, DB2 z/OS

Operating Systems: AIX, Linux, Windows, z/OS

IMS Database

ERP Applications: PeopleSoft HRMS, PeopleSoft Financials, SAP Manufacturing, Lawson

Modeling Tools: Erwin Data Modeling

Development Tools: Data Studio, DB Visualizer, Data Stage

Microsoft Tools: Word, Excel, PowerPoint, Project, SharePoint

Cloud Computing: Microsoft Outlook

MEMBERSHIPS

Professional Association for SQL Server - PASS

Contact this candidate