Data Manager

David L. Ledford, Jr.

**** ****** ****** **** ********, NC 27377

ac1k9m@r.postjobfree.com 336-***-**** https://www.linkedin.com/in/dledfordjr

Qualifications Profile

Expertise in database administration, data warehousing, data management, and data analysis.

Extensive experience in design, performance optimization and tuning with multi-terabyte databases.

Experienced with client facing roles and presentation to both internal and external customers.

Adept at meeting new technical or organizational challenges and finding solutions.

Education and Certifications

Master of Science in Information Systems and Technology Management; G.P.A. 3.44 (2010)

The University of North Carolina at Greensboro, Greensboro, North Carolina

Bachelor of Science in Information Systems and Operations Management; G.P.A. 3.78 (1997)

Magna cum laude – Beta Gamma Sigma – Hpsilon Pi Epsilon

Experience

Hun Hunter Technical / CGI --- AT&T Research Triangle Park, NC Sep 2016 – Mar 2017

Atl Atlassian System Administrator / Oracle DBA

Primarily responsible for the installation, maintenance, and modifications to the AT&T GCSBizOps team’s new installations of JIRA. Also, responsible for migration of projects, issues, boards, etc.… from the existing JIRA systems to the new ones.

Systems Administration: Primary point of contact for any technical issues that need to be addressed in Atlassian products (JIRA, plugins, etc….) or Redhat Linux.

Database Administration: Install, monitor, backup and tuning of PostgreSQL databases used for JIRA.

IBM Research Triangle Park, NC Jan 2015 – Aug 2016

Oracle DBA

Senior level database administration for BCRS and global Cloud Services for IBM.

Provide production and development support for over 40 databases.

Responsible for a heterogeneious environment (Oracle, Postgresql, DB2).

Heavy use of shell scripting, Perl, SQL, and Linux utilities.

Work with developers in edititing java code and embedded SQL queries.

Oracle environment is 11G on Linux using RMAN

Itron Raleigh, NC May 2014 – Aug 2014

Senior Systems Engineer

Customer support for enterprise energy billing systems.

Setup Oracle databases in a Linux environment.

Troubleshoot meter-reading software.

BB&T Winston Salem, NC Jul 2013 – May 2014

Financial Systems DBA

Write and review complex SQL for data extraction.

Create and maintain SSIS packages for data loading, extraction, and transformation.

Produce financial reports for executive level management.

Assist developers in troubleshooting SQL queries embedded in java code.

Heavy use of T-SQL and Excel.

Apex Systems -- IBM Research Triangle Park, NC Jul 2011 – Dec 2012

Oracle DBA

Senior level database administration for BCRS and global Cloud Services for IBM.

Provide production and development support for over 40 databases.

Responsible for a heterogeneious environment (Oracle, Postgresql, SQL Anywhere, MS SQL Server, DB2).

Assisted BCRS division with move of datacenter from Raleigh NC to Boulder CO.

Heavy use of shell scripting, Perl, SQL, and Linux utilities. Occassional troubleshooting of java code.

Oracle environment is 11G on Linux, formerly using RMAN currently using NetApp SnapManager.

ITT Technical Institutue High Point, NC Aug 2010 – May 2011

Part Time Adjunct Instructor

Provide in class lab and lecture for technical programs.

Assist students with course work and technical labs.

Guilford Technical Community College Jamestown, NC Jan 2011 – Jun 2011

System Administrator II

System Admin for the main ERP system for the college.

Provide day to day maintenance and backups.

Primary technical lead for:

oDatatel’s Colleague System

oSolaris Linux systems

oIBM’s UDT Database system

Tier1 Technologies -- United States Postal Service Raleigh, NC Jun 2010 – Nov 2010

Database Administrator

Provide on call support for level II escalated Oracle database support calls for USPS.

Part of production support responsible for over 1500 Oracle database instances worldwide.

Assist developers with code issues and change management.

Role demanded a broad exposure to an array of technologies and operating systems:

oRAC, HA, RMAN, Data Pump, SQL Data Modeler, shell scripting, tuning, patching

oSolaris, Aix, Linux, HP Unix, Windows 2000, Zlinux

University of North Carolina at Greensboro, Greensboro, North Carolina May 2008 -- May 2010

Graduate Student

Course work included: Oracle Database Administration, SOA, Web Services, Knowledge Management, Data Warehousing, Data Mining, Project Management, Systems Analysis, XML, Distributed Systems & Architecture, Business Statistics and Data Analysis.

Masters Capstone Project using Oracle 11g (A six month project that was presented in November 2009): “A Comparative Analysis of Morbidity Data in North Carolina.”

Project Included:

oCreation of a data mart on a two node instance of Oracle 11g (using RAC and ASM options) with Red Hat LINUX hosted on VMware.

oAnalysis performed with SQL, Microsoft Excel, SAS Dataminer, Oracle Dataminer, and Oracle Predictive Analysis add in for Excel.

o Analysis was a characterization and clustering of North Carolina morbidity rates by county from 2003 to 2007.

oClustering was based on 1990 and 2000 Census data for demographics and economic indicators.

oStudy purpose was to highlight areas that may have higher rates of certain morbidity causes (Cancer, HIV, Suicide) due to economic distress and / or lack of adequate local health services (physicians, mental health professionals, etc.).

Cegedim Research Triangle Park, NC Jan 1999 – Dec 2007

Database Administrator / Senior Data Manager

Senior level data management for Longitudinal Prescription Level databases for pharmaceutical analysis.

Assisted clients in identifying legacy source systems needed for data collection.

Designed and created data marts and databases from client specifications of logical models.

Created SQL scripts, PL/SQL procedures, and functions to automate data extraction, transformation, and loading. Created custom functions to cleanse data fields from multiple vendor sources to target fact and dimension tables. Created custom procedures as needed for row and column level data transformations.

Documented data mappings and transformations for source vendors to target warehouse tables.

Senior level database administration experience with Oracle ver. 7.0, 8.0, 8i, 9i, 10g with emphasis on large databases (180G to 15TB) in a data warehousing environment.

Extensive use of advanced SQL in manipulating large datasets in a data warehouse setting.

Heavy use of SQL Loader, SQL Plus, PL/SQL procedures and functions, OEM Manager tools, Import / Export, and LINUX utilities.

Familiar with Oracle features relating to data warehousing environments such as transportable tablespaces, partitioning, bit-mapped indexes, parallelism, and no logging options.

Decreased project time for major client from 3 weeks to 72 hours.

Contact this candidate