Database Administrator Operations Research

Contact Information

Suzanne H. Sellers

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

Email: ***********@***.***

Location: Roswell, GA 30075

Candidate Description

30+ years in the I/T industry with Masters in Operations Research and additional credits toward Masters in Statistics from Georgia Institute of Technology. 27 years as DB2 DBA in production environments on LUW platforms. 3 years as DBA on IBM z/OS platform. Skilled in SAS Programming, Shell/Perl programming on Linux/Unix for 20+ years.

Technical Qualifications/Skills List

Code Library and Builds on VM/CMS Mainframe

Create JCL and TSO to build products on IBM z/OS platform

Create JCL scripts and using SPUFI to run, or submit from Job log

Programming using REXX to manipulate the rate at which JCL programs run

Build databases on IBM z/OS platform, modify as necessary

DB2 LUW Version and Fix pack Updates

DB2 LUW Pure Data for Transactions (PDTX) Administration and Certification; using Pure Scale architecture

DB2 LUW Pure Scale architecture, upon which DB2 Pure Data for Transactions (PDTX) is based

Hands on experience with PDTX hardware repair

UNIX Shell scripting (Born, Korn and C shell)

Strong UNIX platform skills, including commands and shell script programming

Perl script creation and modification

Windows Power shell scripting

DB2 LUW administration – up to v10.5 on Windows/AIX/Linux

DB2 LUW 7, 8.0, 9.5, 9.7,10.1, 10.5, 11.0

Hands on experience on Query Tuning and optimization

CA ERWIN data modeling tool

DB2 LUW Data Partitioning Facility (DPF)

Disaster Planning, Backup and Recovery

DB2 LUW Range and Table Partitioning

Performance tuning on DB2 9.7, 10.1, 10.5

Physical Database Design and storage sizing

SQL Procedure editing

High Availability Disaster Recovery (HADR)

DB2 LUW SQL Replication

IBM Data Studio

Toad Software

Oracle SQL Developer Data Modeling Tool

Experienced in DB2 LUW database design and development

Certifications

IBM Certified Administrator - IBM Pure Data System for Transactions

IBM Certified Database Administrator - DB2 10.1 for Linux, UNIX, and Windows

IBM Certified Database Administrator – DB2 10.5 for Linux, Unix and Windows

Paralegal Certification Emory University School of Law December 2021

Employment History

4C Consulting@Deloitte, remote

DB2 Database Administrator

June 2021 to March 2024

Using JIRA and Confluence to work tickets, share information and set up builds

Provide DB2 database support on SUSE Linux for new deployments, database fixes, backups/restores and creating reports for performance of the databases.

Write Shell scripts to automate database maintenance and scheduled processes

Maintain Inventory control for all DB2 LUW databases across the enterprise

Work closely with Build Team to support their efforts to create new versions and fixes.

Support State of Illinois in support of HealthCare, and social Service programs’

Emory University Law School, Atlanta. GA

Student

Jan 2020 to Dec 2021

Completed course at Emory University Law School Paralegal Course.

Genuent LLC@Fiserv, Alpharetta. GA

DB2 Database Administrator

Oct 2018 to Jan 2020

Provide database support to users of DB2 11.1 on Windows Platform using Data Server Manager, scheduled tasks, fix pack installations, Changes to data on a regular basis using SQL scripts

Write PowerShell scripts to automate database maintenance and scheduled processes

Maintain Inventory control for all DB2 LUW databases across the enterprise

Created Database Status Check Program using PowerShell

Infinite Computer Solutions@IBM, remote

DB2 Database Admistrator

Jan 2017 to Feb 2018

Provide database support to users of an internal IBM utility which consists of 8 servers, including one dedicated database server currently running DB2 v10.1 and DB2 v10.5 on Linux Platform. Operating System is zLinux

Create Perl, Shell and SQL scripts to perform necessary functions to support applications and databases

Provide guidance on Linux commands to application users.

Advise users on appropriate DB2 Security strategies (groups, roles, users)

IBM Infosphere Replication for CDC

IBM Data Studio

DB2 Upgrades and Fix Pack installs from versions DB2 LUW 10.1 to DB2 LUW 11.1

Documentation of processes, instructions, and troubleshooting

Monitor disk space usage and request additional disk space as needed

Use IBM WebSphere to create DDL and extract existing models in WebSphere

IBM Analytics

Retiree

Jan 2016 to Jan 2017

Retired from IBM on 12/2/2015 to take care of terminally ill mother in Diamondhead MS.

IBM Software Group, Atlanta, GA

DB2 Database Administrator

April 2014 to Dec 2015

Participate in meetings and advise developers in setting up HADR in a Pure Scale Cluster environment

Hardware support of Pure Data for Transactions chasses.

As a member of the DBA team, supported development, test and production databases in a large payment institution: skills used include configuration; troubleshooting performance tuning, creating and modifying tables, indexes and stored procedures; database backup and recovery; assisting the data modeler with creating DB design; implementing design and keeping up with design changes

DB2 LUW Database Administrator 10.5 for transition from Oracle to DB2.

Administer PureData for Transactions (PDTX) software and hardware configuration and support.

Document and execute system test cases for PDTX

Extensive documentation of PDTx command and processes

Assisting Oracle DBAs to learn DB2 LUW and migrate their databases from Oracle to DB2

Write SAS v9.2 programs to evaluate data in Oracle databases prior to migration into DB2

SunTrust Bank, Atlanta, GA

Database Administrator/SAS programmer

Sept 2009 to April 2014

Write SAS v9.2 programs to evaluate financial data from DB2 LUW databases

Responsible for HADR compliance across all test and production databases: implementing, writing scripts to monitor the status of HADR, creating new HADR configurations and retiring old HADR configurations

As a member of the DBA team, supported development, test and production databases in a large financial institution: skills used include configuration; troubleshooting; performance tuning, creating and modifying tables, indexes and stored procedures; database backup and recovery; assisting the data modeler with creating Database design for DB2 LUW 10.5; implementing design and keeping up with design change

Support users of DB2 LUW 10.5 data warehouses with Data Partitioning Feature (DPF or multi-node) in a financial environment with very large databases up to 100 terabytes

Install and configure DB2 LUW v9.5, V9.7, V10.5 on Windows and AIX platforms

Analyze queries generated by Cognos for performance improvement opportunities

Create database maintenance scripts on AIX platform to perform database backups, runstats, reorgs

S1 Corporation, Norcross, GA

DB2 Database Engineer

Aug 2008 to June 2009

Responsible for High Available Disaster Recovery (HADR) compliance across all test and production databases: implementing, writing scripts to monitor the status of HADR, creating new HADR configurations and retiring old HADR configurations.

Supported transactional DB2 LUW databases for payment applications as member of a team of DBAs: skills used include configuration; troubleshooting; performance tuning, creating and modifying tables, indexes; and stored procedures

database backup and recovery; assisting the data modeler with creating DB2 LUW design; implementing design and keeping up with design changes

Install and configure DB2 LUW v9.5 (and v8.2) on multiple servers with appropriate fix packs to accommodate necessary databases

Decrease CPU and Disk utilization by evaluating and improving database performance through DB2 utilities such as Snapshot Monitor and Event Monitor

Improve overall database reliability and uptime by spearheading effort to incorporate DB2 LUW v9.5 HADR feature.

Open and execute Change Requests on a regular basis to ensure smooth operation of the DB2 LUW databases.

IBM Corporation, Marietta, GA/remote

I/T Specialist and SAS Programmer

March 1987 to Aug 2008

Responsible for Code Library and Build on VM/CMS. Write JCLl programs to enable Builds to run faster

Database duties on DB2 z/OS

Supported Analytic Database and Enterprise Information Warehouse as primary DBA: skills used include configuration; troubleshooting; performance tuning, creating, and modifying tables, indexes and stored procedures; database backup and recovery; assisting the data modeler with creating DB design; implementing design and keeping up with design changes

Participates in the development and implementation of short and long-term DB2 LUW 9.5 strategies of multi-user, multi-functional systems

Develops database solutions that meet business objectives that optimize the use and accessibility of data

Develops strategies for the continued planning, designing and documentation of standards for physical data storage, maintenance, access, and security administration to standardize environments and improve efficiency

Demonstrated knowledge of related database architecture and development methodologies

Demonstrated proficiency in structured analysis and technical design techniques

Develop Perl and Korn shell scripts to monitor SQL Replication and validate the successful movement of data between DB2 Z/OS and DB2 LUW databases

Automate the loading of large DB2 LUW databases using Perl and Korn shell scripts, including error handling and notification

DB2 LUW version 8 and 9 DBA for large Data Warehouse projects on AIX platform (up to 10 terabytes), utilizing the Data Partitioning Feature (DPF) across multiple data nodes

Performance tuning of DB2 LUW databases on AIX platform

AIX Administration support tasks for DB2 LUW Warehouses with Data Partitioning Factor, such as determination of space allocation, userid support and file system management

Create DB2 LUW SQL Replication scenarios to and from DB2 Z/OS and DB2 LUW host systems.

Design DB2 LUW layout using DPF using OLAP and star-schema design

Utilize ERWIN Data Modeling software to update data warehouse model

Configure Federated Databases to ensure data integrity across databases

Utilize Brio Enterprise software to build reports

Provide instructions to IBM Tivoli Monitoring administrator to schedule jobs in support of Production DB2 Database. Correct and re-run any jobs that fail in IBM Tivoli Monitoring

Write database backup scripts to send backup images to IBM Tivoli Storage Manager. Verify that database backup images were successfully processed by IBM Tivoli Storage Manager

Education

Georgia Institute of Technology; Atlanta, GA M. S. in Operations Research

Georgia Institute of Technology; Atlanta, GA 24 graduate hours in Statistics toward M.S. Statistics.

Emory University; Atlanta, GA B.S.N. in Nursing

Emory University School of Law; Atlanta, GA Paralegal Certification

Contact this candidate