We provide IT Staff Augmentation Services!

Sr Teradata Architect/big Data Admin Resume

St Louis, MO

OBJECTIVE:

Seeking a challenging role where my leadership and Business Intelligence skills can be fully leveraged to implement effective solutions that enhance both business performance and customer satisfaction.

SUMMARY:

  • Over Fourteen Years of diversified experience in IT in Enterprise Application Architecture, Database Administration, and Project Management. Recently focused on Data Warehouse optimization and business intelligence applications.
  • Over 8 years of working experience in TERADATA Data Warehouse landscape/Administration.
  • Certified DBA Professional with Strong Knowledge of Data warehouse Design Methodology, and Data modeling techniques.
  • Worked on physical/Logical data modeling, implemented using ERWIN.
  • Worked on EDW utilities like BTEQ, MultiLoad, FastExport, Tpump, Visual Explain
  • Experienced in diversified application development in Teradata, Oracle, Peoplesoft, Netezza et al.
  • Good at working with high volume databases of multi terabytes. Trained other team members in Teradata.
  • Good exposure on Hadoop, ASTER Architecture and Administration
  • Involved in Data Migration between Teradata/Oracle, Teradata/Hadoop.
  • Being a Certified SQL Tuning professional reduced execution time significantly for long running tactical queries. Good experience in Oracle (10g, 9i, 8i), ms sql server on OLTP/OLAP environments for large Databases.
  • Extensive experience writing TERADATA Macros, triggers, and views.
  • Proficient in TERADATA DBA activities like creating databases, managing tables, Indexes, User Security, Space/Performance management, System monitoring.
  • Customized and Deployed Confidential portlets for management dashboards reporting.
  • Experience with UNIX Shell Scripting and good coding practices using SQL, PL/SQL.
  • Major Clients worked with; Confidential Bank, Confidential, Confidential, Confidential, Confidential et al.

TECHNICAL EXPERTISE/ENVIRONMENT:

RDBMS: Teradata 14/13/12/v2R6.0/v2R5.x, Oracle 10g/9i/8, DB2, SQL Server 2005/2000

ETL/OLAP/Reporting Tools: Informatica PowerCenter 9.5/8.x/7.x, Business ObjectsXI r2, Xcelsius, FastLoad, MultiLoad, TPump, MicroStrategy 7.1.2, SqlAssistant, DataStage7.5, BTEQ, AtanaSuite Expert, Tableu

Data Modeling/Domains: CA Allfusion ERWin, ER/Studio Data Architect 9.0, Rational S/w Architect, Data Mart Design Conceptual/Logical/Physical Modeling, Metadata Management, Visio, HealthCare, Banking, Retail

Tools: /GUI: Teradata Administrator, TD Performance Monitor, Teradata Manager, Query Analyzer, TOAD, Priority Scheduler/UC4, winDDI, TDWM, ARC, Teradata Confidential

Hardware platforms/Operating systems: TD 6750/5650/5500 , Teradata Enterprise/Appliances, SLES 10/SLES 11, AIX5.3/5.1, Solaris 8/6, HP - UX 11.11, Windows7/2008/2003/NT, Linux AS2.1

Languages: BTEQ, PL/SQL, SQL*PLUS, Unix Shell, C, Java, UML, PeopleCode

PROFESSIONAL EXPERIENCE:

Confidential, St Louis, MO

Sr Teradata Architect/Big Data Admin

Responsibilities:

  • Managed Teradata, Hadoop, Aster Environments
  • SQL Optimization of Reports, Informatica workflows. Explain Plan, AJIs used
  • Capacity Planning for Teradata, Hadoop landscape and forecasting
  • Resolved TD issues, used TSET, DBQL, TDWM dump, CrashDumps, Perflook
  • Data Mover set up, Created jobs to move data across Teradata/Hadoop
  • Executed Performance Benchmarking for SQLs and Backups
  • Monitored, Improved TD systems using Confidential, Resources usage, Alerts. Published performance Metrics. Modified DBS control parameters, Confidential Data Collectors.
  • Implemented PDCR and Upgrade
  • Designed physical data models, Implemented in databases. Implemented PPI, Compression
  • Used best practices for EDW landscape to improve PIs, Stats Collection process, efficient Storage, Backups, Archive & Purge, Security, SOX.
  • Improved TASM settings based on Workloads changes, Jobs priorities/Exceptions, penalty box
  • Lead & mentored junior DBAs, Presented POCs to management for Backups, New Appliances

Environment: Teradata 14.10, Informatica PowerCenter9.5, Tableau, TD2650, TD2750/SLES11, PDCRDATA, BTEQ, Embarcadero, TD Admin, Hadoop, ASTER, TD Confidential, Data Mover

Confidential, Milpitas, CA

Teradata Platform Architect/DBA

Responsibilities:

  • Set up & managed Data Labs for various Groups after interacting with business
  • Performance Tuning of long running queries, Informatica workflows. Used Explain Plan
  • Capacity Planning for Teradata landscape and forecasting
  • Resolved TD issues, used TSET, DBQL, TDWM dump, Perflook, worked with TD support
  • Participated in Upgrade to TD14.10, and H/W upgrade. Executed Performance Benchmarking.
  • Worked on physical data models, Implemented in databases. Implemented PPI, Compression
  • Analyzed TD landscape for gaps, Used best practices to improve PIs, Stats Collection process, efficient Storage, Backups, Archive & Purge, Security, SOX.
  • Implemented TASM settings for Workloads changes, Jobs priorities/Exceptions, penalty box
  • Lead & mentored offshore DBA team for TD DBA tasks

Environment: Teradata 14.10/13.10 , Informatica PowerCenter9.5, BO XI r2, TD6700/SLES10, PDCRDATA, BTEQ, ERWIN, TD Confidential, TD Admin, ARCMAIN, TD Unity Director

Confidential, Plano, TX

Teradata Application Architect/Data Modeler

Responsibilities:

  • Developed Physical Data Models using ERWIN after analyzing Logical data Models and interacting with business
  • Analyzed and translation of data models to Star or Snowflake database schemas.
  • Worked on physical data models, Implemented in databases.
  • Implemented multi value Compression. Reduced storage cost and gained performance
  • Improved Performance optimizing TERADATA SQL statements and various data loading strategies using TERADATA VISUAL EXPLAIN.
  • Enhanced existing processes to run more efficiently by working on PPI, Skew, Joins, AJIs, workload management and Compression.
  • Executed Admin tasks using TD Administrator, Confidential, TD Manager such as workload activity, space utilization, statistics collection, and system performance monitoring.
  • Managed security, space, jobs, tuning of loads, and Change management using HPSM.
  • Performance tuning of queries, and Capacity Planning for TD landscape.

Environment: Teradata 13.10, Ab Initio, BTEQ, BO XI r2, NetVault, Teradata5650, ERWIN, TD

Confidential, Pleasanton, CA

Lead Teradata Application DBA/Architect

Responsibilities:

  • Developed Logical and Physical Data Models using ERWIN after interacting with business
  • Analyzed and translation of data models to Star or Snowflake database schemas.
  • Implemented physical data models, created scripts for Tables, views, Created PIs.
  • Implemented multi value Compression to save storage cost, and gain performance
  • Monitoring system and resolving Performance issues
  • Analysis for Capacity, Workload for different regions, Implemented and enhanced TASM
  • Coordination among regional teams for smoother upgrades, and change management
  • Optimized Performance of long running tactical queries.
  • Revisited Physical Data Models for Performance, Schema Optimization
  • Used best practices for Backups, Statistics Collection, new applications implementations
  • Provided guidance to less experienced team members, and trained them

Environment: Teradata12, Clarity, TARA, WindowsXP, TD Administrator, BTEQ, DBQL, ERWIN, TDWM, Teradata5550/5450, Teradata Manager, Business Objects

Confidential, Milpitas, CA

Lead Performance DBA/Architect

Responsibilities:

  • Long running queries were tuned for Optimal Performance.
  • Enforced proper use of Primary and secondary indices after analysis.
  • Saved CPU by optimizing the collection of Statistics
  • Reduced execution time for jobs by working on the workload management using TASM.
  • Worked on Confidential requirements, and Prepared the Design Document
  • Customized Confidential Portlets to provide better functionality
  • Set up Alerts & Metrics for monitoring purposes by Operations
  • Worked with Architect team to create centralized application to report Performance Metrics and Capacity Utilization.

Environment: Teradata13/12, Informatica PowerCenter 8.6.1, Oracle, NetBackup/TARA, TD Administrator, DBQL, TDWM, Teradata5555/5650, TD Manager, TD Confidential

Confidential, Dallas, Texas

Teradata Performance Analyst/Application DBA

Responsibilities:

  • Data warehouse was running out of capacity.
  • Performed Data analysis to make data types optimization suggestions.
  • Enforced proper use of Primary and secondary indices after analysis.
  • Achieved better performance, and saved CPU by Optimizing the collection of Statistics
  • Developed process to get rid of unused data, and reclaimed huge space by purging unwanted data. Worked on schema optimization.
  • Reduced execution time for jobs by working on the workload management.
  • Analyzed DBQL to find AWTs/CPU usage, long running queries, STATS collection
  • Reviewed Physical Data Models to remove the data redundancy.
  • Conducted interviews with business users to help them understanding the efforts, and to expedite the implementation of recommendations.

Environment: Teradata12/Teradata v2r6, DataStage7.5, DB2, NetVault, WindowsXP, Teradata Administrator, BTEQ,DBQL, ERWIN, PL/SQL, TDWM, Teradata5550, Teradata Manager

Confidential, Brisbane, CA

Lead Teradata DBA/ Architect

Responsibilities:

  • Data Source Mapping to the Retail Logical Data Model
  • Worked on logical and first-cut physical data models using ERWIN
  • Implemented physical data models considering PPIs and Compression for the optimized performance, and reduced storage costs
  • Performed bulk data load from multiple data source like Oracle9i, sql server, flat files to TERADATA EDW. Created scripts using FastLoad, Multi-Load, TPump to load data.
  • Reduced execution time for long running queries using VISUAL EXPLAIN.
  • Gathered reports on spool space, table skews, Index usage and provided recommendations.
  • Developed Unix shell scripts to schedule heavy reports to run during off peak hours
  • Performed Teradata DBA tasks using Teradata Manager such as workload activity, space utilization, statistics collection, and system performance monitoring.
  • Used winDDI for user administration which involved Security, Space, Roles, Profiles.
  • Setup of Statistics Collection process which ensures all tables have current Statistics.
  • Worked on backup/restore processes using ARCMAIN with NetVault

Environment: Teradata v2r6, Business Objects XI r2, Informatica PowerCenter 8.6, PL/SQL, PeopleSoft, Solaris2.8, Oracle 9i, Windows XP, AtanaSuite CompressTool

Confidential, NC

Teradata DBA

Responsibilities:

  • Involved in source/target analysis to implement EDW and ETL architecture
  • FASTLOAD and MULTILOAD jobs to load extracted data into TERADATA databases.
  • Enhanced existing queries and data loads to run more efficiently and faster by query optimization using Teradata Visual explain, Statistics collection, & proper Indexing.
  • Worked on Operational Data Stores (ODS) for specific healthcare requirements
  • Worked on ARCMAIN with NetVault for backup and recovery operations
  • Scheduled, Managed batch jobs using Priority Scheduler and used ENDEVOR for change control.
  • Involved in the archiving of patients data, and making accessible to Teradata
  • Handled DBA tasks like User creation, security, database creation, Primary/Secondary indexes and Scheduling/maintenance of jobs.

Environment: Teradata v2r5.1, QueryMan, BTEQ, FLoad, FastExport, Oracle 8i, UC4, MVS, JCL, SAS, Windows2003, ERWIN, Informatica PowerCenter/PowerMart6.2, Business Objects XI.

Hire Now