Professional Summary

Three years experience in retail data warehouse environment, including Teradata, Summary HP Neoview, and Netezza as a Database Administrator. Projects have ranged from simple installations to data warehouse construction for multiple data warehouse systems of varying sizes and complexity. Additionally, well versed in Teradata development tools.

Databases: Teradata, HP Neoview, Netezza

Certifications: Teradata Certified Master V2R5

Professional Experience

Database Administrator June 2006 March 2010
Confidential,Bentonville, AR

Responsible for assisting in the control, integrity and accessibility of the database structure of multiple data warehouse databases (Teradata, HP Neoview, Netezza) with many concurrent users. Responsible for implementing the physical data structures to support the application development teams. Provide problem determination and resolution with proper escalation. Assist in designing the distribution and configuration of database resources, tuning database applications for optimum performance, and implementing disaster recovery and contingency plans. Run intra-team projects, apply existing technical knowledge to new projects, and provide project review for team projects. Also provides input to management on vendor proposals and ensures vendors are accountable for daily work and participate in the evaluation of tools to address the business needs. Participate in weekly on call pager rotation.

TeradataTeradata Tools

• SQL Assistant
• BTEQ
• Teradata Administrator
• Priority Scheduler
• Alert Facility
• Index Wizard
• Statistics Wizard
• Visual Explain
• TASM
• Teradata Workload Manger
• Teradata Workload Analyzer
• Teradata Manager

Extensive Experience in the Following Tasks

• Create physical table structures from a logical model with the proper index assignments.
• Create User IDs, Batch IDs, Databases, Profiles, and Roles using Teradata Administrator or SQL Assistant/SQL.
• Manage Access Rights with proper requirements.
• Monitor and manage production activity with Teradata Manager.
• Multi-Value Compression Analysis and implementation.
• Generate script to create macros, tables, views from data model and implement the scripts in production.
• Create Secondary Indexes, Join Indexes, Partitioned Primary Indexes and Collect Statistics on tables.
• Optimize and fix spool space issues.
• Optimize high CPU consumption jobs.
• Copied data from one system to another using an internal developed program.
• Did various types of system maintenance and cleanup.
• Exposure to workload management practices focused on high concurrency and active data warehousing.

HP Neoview Neoview Tools

• DBAdmin
• Neoview Dashboard
• Neoview Scripts
• Genus Loading Tool

Extensive Experience in the Following Tasks

• Create User IDs, Batch IDs, Databases, Role using DBAdmin.
• Create Tables/Views with proper index based on the logical data model.
• Monitor and manage production activity with Neoview Dashboard.

Projects Teradata Active System Management (TASM)
Increase business critical applications’ throughput time

• Turn on DBQL to capture resource utilization of each workload.
• Utilize Workload Analyzer to gather information about captured workload.
• Utilize Workload Manager throttle problematic applications.
• Utilize Workload Manager to adjust resouce distribtion of workload partition.

Multi-Value Compression
Regained database space to prevent purchasing additional hardware to meet business needs

• Perform Multi-Value Compression Analysis to determine which tables can be regained with sufficient amount of space to prevent buying additional hardware.

Application Migration
Migrate an application from one resource intensive production system to a less resource intensive production system in order to improve applications run time.

• Moving tables/views/macros/data from one production system to another.
• Modifying the application’s account strings to have the appropriate priority.

SOX (Sarbanes-Oxley) Compliance
Create individual DBA IDs required by the SOX compliancy
Create automated email report to track generic DBA IDs usage
Password requirements are required to apply to every new and existing IDs

• Implemented profiles to have the necessary password requirements to enforce all the IDs that are in the profile.

Data Mart Implementation
Created a Data Mart for a specific business subject

• Implement database hierarchy
• Create Databases/Tables/Views/Macros
• Physical Optimization
• Creating Seconday Indexes/Join Indexes
• Collecting stats
• Work with application team to optimize the Meta-data layer of the Business Object/Oracle BI Tool.

TTU (Teradata Tools and Utility) 12.0 upgrade
To prepare for future Teradata Database upgrade and improve the capability of Data Warehouse

• Served as the Project Lead to coordinate with teams to successfully implement TTU 12.0 across needed Operating Systems (UNIX, LINUX, Mainframe, Windows).
• Testing and implementing TTU 12.0 to all existing production system with no problem.

Professional Trainings

.NET Windows and Web Programming
Java Programming Essentials with RSA
UNIX Systems Basics
Perl
Teradata Physical Database Design
Teradata Advanced SQL
Teradata Warehouse Administration
Teradata Application Utilities
Project Management 101

Education

B.S. Computer Science (3.31)