| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateContact InformationCandidate's Name
Phone: PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLELocation: Roswell, GA Street Address
Candidate Description30+ 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 ListCode Library and Builds on VM/CMS MainframeCreate JCL and TSO to build products on IBM z/OS platformCreate JCL scripts and using SPUFI to run, or submit from Job logProgramming using REXX to manipulate the rate at which JCL programs runBuild databases on IBM z/OS platform, modify as necessaryDB2 LUW Version and Fix pack UpdatesDB2 LUW Pure Data for Transactions (PDTX) Administration and Certification; using Pure Scale architectureDB2 LUW Pure Scale architecture, upon which DB2 Pure Data for Transactions (PDTX) is basedHands on experience with PDTX hardware repairUNIX Shell scripting (Born, Korn and C shell)Strong UNIX platform skills, including commands and shell script programmingPerl script creation and modificationWindows Power shell scriptingDB2 LUW administration up to v10.5 on Windows/AIX/LinuxDB2 LUW 7, 8.0, 9.5, 9.7,10.1, 10.5, 11.0Hands on experience on Query Tuning and optimizationCA ERWIN data modeling toolDB2 LUW Data Partitioning Facility (DPF)Disaster Planning, Backup and RecoveryDB2 LUW Range and Table PartitioningPerformance tuning on DB2 9.7, 10.1, 10.5Physical Database Design and storage sizingSQL Procedure editingHigh Availability Disaster Recovery (HADR)DB2 LUW SQL ReplicationIBM Data StudioToad SoftwareOracle SQL Developer Data Modeling ToolExperienced in DB2 LUW database design and developmentCertificationsIBM Certified Administrator - IBM Pure Data System for TransactionsIBM Certified Database Administrator - DB2 10.1 for Linux, UNIX, and WindowsIBM Certified Database Administrator DB2 10.5 for Linux, Unix and WindowsParalegal Certification Emory University School of Law December 2021Employment History4C Consulting@Deloitte, remoteDB2 Database AdministratorJune 2021 to March 2024Using JIRA and Confluence to work tickets, share information and set up buildsProvide 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 processesMaintain Inventory control for all DB2 LUW databases across the enterpriseWork 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 programsEmory University Law School, Atlanta. GAStudentJan 2020 to Dec 2021Completed course at Emory University Law School Paralegal Course.Genuent LLC@Fiserv, Alpharetta. GADB2 Database AdministratorOct 2018 to Jan 2020Provide 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 scriptsWrite PowerShell scripts to automate database maintenance and scheduled processesMaintain Inventory control for all DB2 LUW databases across the enterpriseCreated Database Status Check Program using PowerShellInfinite Computer Solutions@IBM, remoteDB2 Database AdmistratorJan 2017 to Feb 2018Provide 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 zLinuxCreate Perl, Shell and SQL scripts to perform necessary functions to support applications and databasesProvide guidance on Linux commands to application users.Advise users on appropriate DB2 Security strategies (groups, roles, users)IBM Infosphere Replication for CDCIBM Data StudioDB2 Upgrades and Fix Pack installs from versions DB2 LUW 10.1 to DB2 LUW 11.1Documentation of processes, instructions, and troubleshootingMonitor disk space usage and request additional disk space as neededUse IBM WebSphere to create DDL and extract existing models in WebSphereIBM AnalyticsRetireeJan 2016 to Jan 2017Retired from IBM on 12/2/2015 to take care of terminally ill mother in Diamondhead MS.IBM Software Group, Atlanta, GADB2 Database AdministratorApril 2014 to Dec 2015Participate in meetings and advise developers in setting up HADR in a Pure Scale Cluster environmentHardware 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 changesDB2 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 PDTXExtensive documentation of PDTx command and processesAssisting Oracle DBAs to learn DB2 LUW and migrate their databases from Oracle to DB2Write SAS v9.2 programs to evaluate data in Oracle databases prior to migration into DB2SunTrust Bank, Atlanta, GADatabase Administrator/SAS programmerSept 2009 to April 2014Write SAS v9.2 programs to evaluate financial data from DB2 LUW databasesResponsible 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 configurationsAs 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 changeSupport 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 terabytesInstall and configure DB2 LUW v9.5, V9.7, V10.5 on Windows and AIX platformsAnalyze queries generated by Cognos for performance improvement opportunitiesCreate database maintenance scripts on AIX platform to perform database backups, runstats, reorgsS1 Corporation, Norcross, GADB2 Database EngineerAug 2008 to June 2009Responsible 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 proceduresdatabase backup and recovery; assisting the data modeler with creating DB2 LUW design; implementing design and keeping up with design changesInstall and configure DB2 LUW v9.5 (and v8.2) on multiple servers with appropriate fix packs to accommodate necessary databasesDecrease CPU and Disk utilization by evaluating and improving database performance through DB2 utilities such as Snapshot Monitor and Event MonitorImprove 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/remoteI/T Specialist and SAS ProgrammerMarch 1987 to Aug 2008Responsible for Code Library and Build on VM/CMS. Write JCLl programs to enable Builds to run fasterDatabase duties on DB2 z/OSSupported 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 changesParticipates in the development and implementation of short and long-term DB2 LUW 9.5 strategies of multi-user, multi-functional systemsDevelops database solutions that meet business objectives that optimize the use and accessibility of dataDevelops strategies for the continued planning, designing and documentation of standards for physical data storage, maintenance, access, and security administration to standardize environments and improve efficiencyDemonstrated knowledge of related database architecture and development methodologiesDemonstrated proficiency in structured analysis and technical design techniquesDevelop Perl and Korn shell scripts to monitor SQL Replication and validate the successful movement of data between DB2 Z/OS and DB2 LUW databasesAutomate the loading of large DB2 LUW databases using Perl and Korn shell scripts, including error handling and notificationDB2 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 nodesPerformance tuning of DB2 LUW databases on AIX platformAIX Administration support tasks for DB2 LUW Warehouses with Data Partitioning Factor, such as determination of space allocation, userid support and file system managementCreate 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 designUtilize ERWIN Data Modeling software to update data warehouse modelConfigure Federated Databases to ensure data integrity across databasesUtilize Brio Enterprise software to build reportsProvide 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 MonitoringWrite database backup scripts to send backup images to IBM Tivoli Storage Manager. Verify that database backup images were successfully processed by IBM Tivoli Storage ManagerEducationGeorgia Institute of Technology; Atlanta, GA M. S. in Operations ResearchGeorgia Institute of Technology; Atlanta, GA 24 graduate hours in Statistics toward M.S. Statistics.Emory University; Atlanta, GA B.S.N. in NursingEmory University School of Law; Atlanta, GA Paralegal Certification |
