We provide IT Staff Augmentation Services!

Teradata Dba Resume

4.00 Rating

Keene, NH

CAREER OBJECTIVE:

Exploring opportunities to apply extensive experience in Teradata in a challenging environment where good communication, administrative and problem solving skills can be effectively utilized.

SUMMARY:

  • About two and half years of IT experience in various phases of the application development life cycle, database analysis, design, support and implementation in Business environment.
  • Create, maintain and support Teradata on production and development environment
  • Experience in physical database design, performance monitoring and user Workload management.
  • Worked with Teradata tools such as Teradata Manager, Teradata administrator, SQL Assistant.
  • Experience in all phases of the system development life cycle including requirement analysis, design, coding, testing and documentation
  • Excellent team player, quick learner with analytical and interpersonal skills.

KEY SKILLS AND KNOWLEDGE:

Teradata Load Utilities

FastLoad

MultiLoad

TPump

BTEQ

FastExport

Teradata Tools

Teradata Manager

Teradata Administrator

Teradata SQL Assistant

PMON

Priority Scheduler

TASM

NetVault

NetBackup Administrator

NetBackup Client

ARCMAIN

Teradata V2R6/12/13

Oracle 9i/10g

SQL Server 2000

MySQL

MS Access

Languages

Teradata SQL

T - SQL

PL/SQL

Operating Systems

NCR MP-RAS

Unix

Linux

Windows 2000/XP/NT

ETL Tools

DataStage 8.1/8.5

Informatica 7.0

PROFESSIONAL EXPERIENCE:

Confidential, Keene, NH

Teradata DBA

Responsibilities:

  • Create, modify and drop Databases, Profiles, Roles, Tables, Views, Indexes (Primary, Secondary, partitioned etc.), Triggers, Macros and stored procedures.
  • Responsible for database space for present and future considerations and assigning and revoking space on the analysis basis.
  • Performance Database Monitoring using TERADATA MANAGER, PMON, VIEWPOINT tools.
  • Worked with various system interfaces to gather requirements for migration, implementation and prepare the estimates for database related activities.
  • Troubleshoot problems by checking sessions and error logs and performance issues, tuning of ETL Load process.
  • Strong working knowledge on Teradata native ETL utilities(Multiload,TPump Fastload, FastExport) and Teradata SQL
  • Performed table recovery from the daily, monthly and weekly archived through arc main utility on VERITAS NetBackup, NetVault platform.
  • Create and Maintain users for Production/Development Teradata Systems
  • Analyze the long running SQL queries using Explain Plans, and indexes and fine-tuned to run successfully in production
  • Provide 24/7 on call DBA support.

Environment: Teradata 12/13, NCR MP-RAS, Linux, 5400H, 5450H, 5600H IBM PC/Windows XP Professional/Windows 7, NetVault 8.5, TARA GUI, TTU 8.2/ 12/13.0.0.1 /13.0.0.10 , Teradata Manager 12/13.0.0.1 , IBM Info Sphere DataStage 8.5, Microstrategy 8.1, TASM.

Confidential

Teradata DBA

Responsibilities:

  • Create, modify and drop Databases, Roles, Tables, Profiles, Views, Indexes (Primary, Secondary, partitioned etc.), Triggers, Macros and stored procedures.
  • Performance tuning of ETL Load process and long running SQL.
  • Support the ETL team with Teradata Load utilities (Multiload, TPump, Fastload, and FastExport) and Teradata SQL issues.
  • Database space maintenance.
  • Performance and Workload Management using TERADATA MANAGER and PMON tools.
  • Worked with various business teams to gather the requirements and prepare the estimation for database related activities.
  • Performed table recovery from the daily, monthly and weekly archived through arc main utility on VERITAS NetBackup platform.
  • Create and Maintain users for Production/Development Teradata Systems.

Environment: Teradata V2R6, NCR Windows 2000 Servers 5500H, IBM PC/Windows XP Professional, VERITAS NetBackup 6.5, TARA GUI, Visual SourceSafe 6.0,TTU 8.2, TDWM, TQS 6.2,Teradata Manager 7.02.05, BO 6.5.1, Informatica 7.0,Microstrategy 8.0, Sybase Power Designer.

We'd love your feedback!