OBJECTIVE:

• A career position as a Teradata Database Administrator (DBA) utilizing my experience of over 15 years of working with the Teradata R - DBMS (Relational Database Management System), Enterprise Data Warehousing (EDW), Big Data Analytics, and related business solutions.

WORK EXPERIENCE:

Confidential, Bellevue, WA

Teradata Database Administrator

Responsibilities:

• Member of a 2-person DBA Team (one onshore, one offshore)
• Manage a 10-node, 440 AMP, 704 Terabyte Teradata production system which holds a copy of some of the 1400-node Hadoop Data Lake for quicker response times, higher availability, and Teradata Geo-Spatial capabilities.
• User Creation via Teradata Administrator
• User onboarding via “Welcome Wagon” materials
• Architecture Overview: QUANTUM Big Data Analytics, Hadoop Teradata
• Teradata Tools and Utilities (TTU) connectivity and guidance
• SQL Assistant and the Database Explorer
• Teradata Studio Express
• Alteryx
• Tableau
• Space Management - Developed a space report via SQL showing largest databases with max perm, current perm, and percent full which was put in “pie chart” form for upper management
• Space Usage - Kept largest databases under 80% full by adding from FREESPACE database or by purging older data.
• Access rights management via roles
• COLLECT STATISTICS on all but the largest 10 tables (biggest single table is 76 Terabytes )
• COLLECT STATS USING SAMPLE 2 PERCENT column… (For big tables - faster & almost as good as 100%) (See example at bottom)
• Monitoring ETL & other Load jobs via Control-M
• Backfilling missing data from Hadoop via
• WinSCP & Unix Shell Scripting
• Control-M
• Performance monitoring and tuning - able to improve response times 10-fold on some queries by collecting stats
• Viewpoint system monitoring, Heat Map, blockers, users, sessions,
• DBQL (Database Query Log) - developed SQL request to find the longest running, most resource-intensive queries for the past week (Elapsed time). Tuned them by COLLECTing STATISTICS, adding secondary indexes, adding temp tables, etc.
• DBQL (Database Query Log) - also developed SQL requests to get top users for the month including Spool Space Usage, AMP CPU Usage, I/O usage, etc, - and published the results to the user community in a Power Point slide deck.
• Extensive use of SQL Assistant, Teradata Administrator, Viewpoint, etc.

Confidential, Raleigh-Durham, NC

Teradata Database Administrator

Responsibilities:

• Member of the Fujitsu Teradata DBA team serving Confidential of North Carolina (BCBSNC) with 11 members located onsite and offshore in India. First as contractor, then as an employee.
• Served as pool DBA for many projects including EDW Enhancements, IMS Medvantage Versisk-Versand, Sleep Study, Value Based Programs (VBP), Preferred Provider Organization (PPO), Facets Network, BHI, HealthNAV, Care Radius, Integration of E-HR (Electronic Health Records), FEP PPA Clinical History, Consolidated Health Care Expend for Groups (CHEG), Specialty Care Shopper (SCS), Project Control for Shared Customer ID, HEQ, Pulse8, Blue Rewards, HCR 3R, Customer Onboarding (RR Donnelly and Pitney Bowes data), Healthcare Effectiveness Data and Information Set (HEDIS), NCTIO Topaz, EDW Maturity, Customer HUB…
• Represented my DBA team on the BCBSNC Production Change Control CAB (IM Release Tech Content Review) lead by Mary Wilkerson at which all EDW application change tickets were reviewed in depth from the IBM RTC (Rational) “Jazz” system for AGILE development.
• AGILE SDLC (Software Development Life Cycle) - Acted as the embedded DBA for the Blue Cross EDW team which held bi-weekly SPRINT meetings in order to choose goals for delivery within the next 2 weeks - which usually consisted of about a dozen Service Requests (SR) with varying degrees of difficulty (both recent and backlogged). The SRs were then distributed amongst the 3 competing development teams after being ascribed STORY POINTS which are estimated degrees of effort. Short rugby-style SCRUM gatherings, which are akin to football huddles, were held daily just before lunch in order to report on progress and to identify and work on mitigating any BLOCKERS. The mid-day SCRUM encouraged lunchtime socialization of issues, team building, as well as goal and task alignment. At the end of the day, the work continued with a handoff to the closely-aligned Indian offshore teams. At the end of the SPRINT, the team recounted the successes, failures, trials, tribulations, and lessons learned. Finally, the team compared the estimated STORY POINTS to the actual effort expended. DBA inclusion in the AGILE process ensured client satisfaction via effi Confidential ous delivery of voluminous changes to tables, columns, indexes, and views into test, then UAT, and finally prod.
• MICROSOFT AZURE 214x CLOUD Fundamentals - 5-day course including: 1) INTRO: New Azure PORTAL, data centers, services, subscriptions, Resource Manager, RESTful APIs, SDKs, PowerShell, CLI… 2) Azure VIRTUAL MACHINES, Availability; Scalability, creating VMs using Azure Portal, Templates, or Linux… 3) Azure NETWORKING, Virtual Networks (V-nets), VMs in a V-net, NICs (Network Interface Cards) in VMs, V-net to V-net connectivity, site-to-site VPN, Azure ExpressRoute… 4) Azure STORAGE: PowerShell, Storage Explorer, AZCopy CLI, VM disks, File Storage, Azure Portal, File Shares, Blob management, Page Blobs used in Azure VMs… 5) Azure IDENTITY & ACTIVE DIRECTORY, Domains, Users, Groups, Tenants, Multi-Factor Authentication (MFA), AD & SaaS; AD Fed Srv & WAP (Web App Proxy), AD B2C… 6) Azure PaaS (Platform as a Service) plans & services, Portal Dashboard, Kudu, FTP, Visual Studio, SQL Server, NoSQL, Redis Cache, Data Factory, Data Lake; IaaS vs PaaS, Azure SQL vs SQL Server on VM; SQL on Hadoop, HDInsight clusters.
• Attended online session regarding Big Data and Hadoop. Researched the partnership between Teradata and Hadoop.
• Attended and contributed tips to the Teradata SQL Tuning “Lunch and Learn” session with Bill McClernan including those below.
• Created a distribution list of 500+ people working on the BCBSNC Teradata EDW and published the following Teradata Tech Tips:
• “The Paradox (Trade off) of Teradata Primary Index Selection: Beware of Multi-Column PI since more columns = more even distribution (less skew) among the AMPs but also degrade the index’s efficacy regarding single-AMP WHERE Clause SELECTs and AMP-local, low spool PI = PI joins.
• “Top Ten SQL Tuning Tips: What to do if you get, "No More Spool Space..." (examine theEXPLAIN, apply statistics, revisit primary indexes, consider Partitioned Primary Indexes (PPI), add secondary indexes, join indexes, temp tables, remove nested views, etc.)
• “Using Teradata Temporary Tables (Derived, Global, and Volatile) for Building & Tuning Queries, Views, and Macros”
• “Never use “SELECT * with CREATE TABLE…” because the system may choose the first column as the primary index which can cause the table to be badly skewed.
• “Never use a SET table with a NUPI (Non-Unique Primary Index)” since it causes the dreaded DRC (Duplicate Row Checks) overhead (diametrically opposed ideas)
• Other BCBSNC duties include:
• Receiving DDL (Data Definition Language) from the data modelers using ERWIN. Executing scripts first in Development / QA (Quality Assurance), then in UAT (User Acceptance Testing, and then finally into production.
• Creating databases, tables, indexes, views, macros, procedures, triggers, etc. in line with DBA checklist and standards. Recommending / enforcing the standards.
• Extensive use of Viewpoint for system monitoring; also SQL Assistant, Administrator, and other tools. Also manage role access rights, COLLECT STATISTICS.
• Extensive use of Netbackup and Bakbone Netvault BAR Software (Backup. Archive, and Recovery). Instrumental in reducing run time via multi-threading to run backups and restores in parallel.
• Achieved high customer satisfaction ratings via the effi Confidential ous execution of the DDL (Data Definition Language) during Agile SPRINTs and SCRUMs.
• Preserved existing data in tables by using CREATE TABLE statements to make a backup and then using INSERT/SELECT statements to repopulate the tables.

Confidential, Raleigh-Durham, NC

Teradata Database Administrator

Responsibilities:

• Object creation (tables, views, macros, etc)
• Access rights management via roles
• Performance monitoring and tuning
• Viewpoint system monitoring
• Extensive use of SQL Assistant, Teradata Administrator, etc.
• Change management
• Backup Archive and Recovery (BAR) via Bakbone Netvault using multistream to reduce run times

Confidential, Charlotte, NC

Teradata DBA in Home Lending Business Intelligence

Responsibilities:

• Data Management and Data Sourcing to READR from Production sandbox and MIDE
• Change Control Coordinator for team
• Worked with data modelers who use Power Designer and ERWin (Entity-Relationship for Windows) in an iterative manner to generate optimized DDL, to execute it in order to create objects, and then to monitor for performance.
• Track changes through Development, UAT, and Production.
• System monitoring using Viewpoint
• Extensive use of SQL Assistant, Teradata Administrator, etc.
• SQL performance tuning, COLLECT STATISTICS, Indexing, etc.
• Worked on the Home Mortgage Capacity Planning application which includes
• Business Requirements Documentation (BRD) review
• Seats and Staffing optimization (for both sales & fulfillment/processing);
• Loan application volume, history, forecasting & future scenarios;
• Loan pull through & fallout metrics;
• The application tracked the MILESTONES in the life of a loan (application, credit receipt/approval, registration, property ID, Map Receipt (fulfillment/processor, initial underwriter decision, funding, and clear-to-close;
• Turn times between milestones;
• Productivity metrics (such as fundings per underwriter)

Confidential, Charlotte, NC

Teradata DBA

Responsibilities:

• Member of a DBA team with 18 members located across the USA and in Hyderbad, India. Performed rotating production on-call duties lasting an entire week. Duties include executing both production, and development work orders (creating databases, tables, indexes, views, macros, procedures, triggers, etc. in line with DBA checklist and standards).
• Duties include extensive use of Viewpoint for system monitoring, SQL Assistant, Administrator, and other tools. Also manage role access rights, COLLECT STATISTICS, and Bakbone Netvault Backup. Archive, and Recovery (BAR).
• Represent the entire DBA group on weekly Change Control meetings and achieved high compliance ratings insuring customer satisfaction via timely work order and problem ticket review, acceptance, and execution
• Assisted with Teradata Tools and Utilities (TTU 13.10) installations - also opened, tracked and resolved Teradata @ Your Service (T@YS) incidents with the Teradata vendor as needed for TTU troubleshooting
• Main DBA in charge of maintaining and executing DDL scripts for the Capital Markets Operational Data Store (CMODS).
• CMODS scripting involves taking requests from the modeler and creating DDL scripts and promoting them through the various lanes including Dev, Test, UAT, and Prod
• CMODS scripting also involves preserving the data in a lane via CREATE TABLE AS statements, DROP TABLE statements, and INSERT/SELECT statements.
• Extensive use of Atanasoft Delta Tool at Confidential to sync up various development, test, UAT, and production lanes and bring them up to specified level. Atanasoft preserves the data in a lane by automatically identifying table differences and then generating the CREATE TABLE and INSERT/SELECT statements.
• Atanasoft was used to sync up DDL in dev, UAT, and Prod lanes and bring them up to specified level (for instance a lane can be brought up to 1) current production version; 2) current development version or 3) future development version
• Atanasoft is very useful as it preserves the data in a lane by automatically identifying table differences (add a column, drop a column, change data types) and then generating the CREATE TABLE AS... DROP TABLE, and INSERT/SELECT statements.
• After using Atanasoft to sync lanes, various SQL scripts were used to compare table, view, and trigger structures to be sure lanes are at the correct level. Also to spot discrepancies before delivering to the users / customer / applications.

Confidential, Portsmouth, NH

Data Analyst

Responsibilities:

• Completed 2 week course regarding Liberty Mutual's star schema EDW including Claims, Coverages, Occurrences, Employees, Dates, Claim Coverages, Financial Transactions, Litigation Defense, Claim Coverage Monthly summary, etc. Included financial snapshot of monthly inventory, subqueries, current claims as well as "point in time"
• Microstrategy report creation and comparison of results with EDW data.
• Extensive use of excel spreadsheets and VLOOKUP function to compare lists of claims to evaluate which was more correct (create date vs. initial loss cost estimate in the coverage table).
• Automobile insurance metrics include Comprehensive, Collision, Bodily Injury, No Fault/Medpay, Physical Damage Liability, Glass, Rent, and Towing.
• Home Owner metrics include Property Damage and Home Owner Liability.

Confidential, New York, NY

Teradata DBA

Responsibilities:

• Developed Unix shell script with BTEQ to dynamically generate SQL script and run it in order to DROP the oldest range on Partitioned Primary the Index tables.
• Added ranges to Partitioned Primary Index tables that were about to expire.
• Successfully researched how to add PPI sub-ranges - you must first drop an equal number of sub-ranges
• Tuned various queries by COLLECTING STATISTICS on columns in the WHERE and JOIN expressions
• Tuned various queries by adding Secondary indexes
• Created and distributed a Powerpoint presentation outlining the Teradata Version 12 Database Design Course and the Teradata Version 12 Database Tuning Course

Confidential, New York, NY

Teradata SME

Responsibilities:

• Worked closely with Teradata vendor to implement Teradata Active Systems Management (TASM) on QA UAT and Production in March, 2010 - including assigning all profiles to an account string, all users to a profile, and all profiles to a Workload. Began DBQL logging by account string to track performance.
• Helped set up and administer Viewpoint
• Manage two 12-node Teradata 5550 Systems on Version 12 (Production & QA UAT) as well as an 8-node DevTest 2550 Appliance.
• Created daily email reports with key systems performance criteria
• Maintain, update, and enforce standards and procedures
• Encourage Best Practices and Lessons Learned
• Interface with Confidential integrators and application developers migrating the Sales and Marketing application from Oracle to Teradata
• Interface with the Confidential . Systems integrators and application developers migrating the Finance and Procurement application from Oracle to Teradata.
• Investigated a query consuming excess spool and discovered nested aggregate views were the culprit causing unnecessary resource consumption.

Confidential, New York, NY

Teradata Database Administration (DBA)

Responsibilities:

• General administrative duties such as maintaining database objects (tables, views, macros, stored procedures, etc.), security and access privileges (roles and profiles), software installation and configuration (TTU 8.1 and V12 client Software on Unix AIX and Wintel).
• Vendor Interface: Scheduling hardware and software changes. Coordinated V2R6 and V12 server upgrades with vendor and multiple data centers including a hardware upgrade from . Also open/track trouble tickets/incidents with vendor via Teradata@YourService. Apply efixes/DRs as needed. Provided TSET (Teradata System Emulation Tool) output as needed. Examples: Query gets stuck on a product join using V12 that ran fine on V2R6. Another example: FastLoads hanging on open named pipes while using Informatica.
• Data Movement: Move data between various systems (Test, Development, Production) using appropriate tools such as FastExport, FastLoad, ARCMAIN, BakBone NetVault, BTEQ Import/Export, SQL Assistant Import/Export, etc. Some Multiload. Familiar with Tpump. Support ETL Group as needed.
• Backup, Archive, and Recovery (BAR): Design, implement, maintain and automate the appropriate jobs (both cluster and single-stream) as required using Bakbone Netvault with ARCMAIN.
• Trouble shoot and respond to TeamTrack change control incidents to resolve technical and business issues. Shepard changes from Test to Development to Production via Serena’s TeamTrack Change Control System.
• Represented entire database team on weekly Company-wide Change Control meetings utilizing Serena’s TeamTrack.
• Optimize performance on database and applications using EXPLAIN, collect statistics, index selection, workload balancing, increase sessions, etc.
• Capacity planning: properly identify required hardware, software, database configuration / architecture necessary to support application need / growth.
• Oncall Support: 24x7 database support off-site & on-site. (Rotating oncall weekly). Access from home via VPN netmeeting.
• Client Tools / Executables: Intimately familiar with SQL Assistant, Performance Monitor (PMON), Teradata Administrator (Tables: show table definition, columns, statistics, row count, AMP space skew; Objects: create, clone, modify users, databases, tables, show rights held by/on; Move space, Grant/revoke rights, Administer Roles & profiles), Teradata Manager (Database Console: ShowLocks, Query Session, Query Configuration, etc.) (Monitor: Sessions, nodes, vprocs, etc.) Also Total space usage report via Teradata Manager (Investigate, Space Usage).

Confidential, Hartford, CT

Teradata DBA

Responsibilities:

• Responsible for the optimal availability and response time of both Prod and Test.
• Oncall DBA 24/7 with pager for one week every 6 weeks).
• Take part in design reviews enforcing DBA naming standards.
• Perform bi-monthly releases by moving views, tables, and data from test to prod. Translate tables from Oracle to Teradata.
• Redesigned a table with 12 million records by partitioning it by year and month using Partitioned Primary Index (PPI) and then reloading.
• Performed benchmarking and artifact collection to document performance gains on a critical process to add various small business risk factors (driving records, liability claims, restaurant types, SIC codes, employee and vehicle counts, etc.) - achieved by adding the Primary Index (PI) of one table as a secondary index column in another table (thereby eliminating product joins).
• Also responsible for NCR vendor interface involving opening problem tickets and discussing them on weekly conference calls.

Confidential, Los Angeles, CA

Teradata DBA

Responsibilities:

• Member of a 10-person DBA group including rotating on-call duties.
• Primary DBA support for Northwest region (secondary for CO, MA, and HI).
• Responsible for the optimal avaiability and response time of a $15 million Teradata installation (32 nodes, 16 nodes and 4 nodes).
• Unix vi Editor, shell scripting, and Crontab job scheduling.
• Use Teradata Manager / PMON and Canary Queries to monitor performance.
• Gather info on problem queries (especially large product joins) and lower their priority while securing abort approval. Tune said queries using EXPLAIN, diagnostic Helpstats, Indexes, etc. Also database, table, space, user management.
• Represented entire database team on weekly Company-wide Change Control meetings utilizing HP Openview and Remedy.
• Vendor and Kaiser Data Center coordination.
• Backup, Archive and Recovery using Tivoli Storage Manager (TSM) and ARCMAIN on Wintel. Remote access via VPN Dialer / Microsoft Netmeeting.

Confidential, Richmond, VA

Responsibilities:

• Create, maintain, and support Teradata architectural environment; Physical database design; Administration of production objects in change control environment (HP OpenView Service Desk); Development of pro-active processes for monitoring capacity and performance; Perform system level and application level tuning; Support the application development teams for database needs and guidance; Perform backup and recovery operations; Support of production processes; Support of end user queries; Database security administration, etc.

Confidential, Dallas/Ft. Worth, TX

Senior Teradata Database Administrator for the Decision Technology Department

Responsibilities:

• Provided primary support on a multi-application Teradata system. Major DSS applications included AAdvantage Frequent Flyers, Purchasing, Baggage, Flight Analysis, SMARTS (Sales & Marketing). Also rotating on-call support for 6 other systems on weekends. Created and distributed detailed monthly reports covering all performance aspects including resource usage, response time, peak hours, top users, database growth patterns, skewed processing/data distribution, capacity planning, etc. Developed, implemented, and automated an inter-departmental AMR Quality procedure. Implemented a response time monitor (simple "canary" query launched every few minutes to identify system slowdowns) - then correlated times to heavy resource users.
• Recommended solutions to slowdowns such as query optimization, job rescheduling, releasing / preventing locks. Implemented a program to delete and drop old user IDs and to clean up unnecessary rows in the access rights table thereby improving performance. Performed major studies resulting in application redistribution according to type -- and an aging Teradata system was replaced. Recommended machine expansions / upgrades only when all other significant tuning avenues were exhausted.