Teradata Dba Resume
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.