Exploring opportunities to apply extensive experience in Teradata in a challenging environment where good communication, administrative and problem solving skills can be effectively utilized.
- 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
Teradata SQL Assistant
SQL Server 2000
T - SQL
Confidential, Keene, NH
- 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/126.96.36.199 /188.8.131.52 , Teradata Manager 12/184.108.40.206 , IBM Info Sphere DataStage 8.5, Microstrategy 8.1, TASM.
- 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.
- .NET Developers/Architects Resumes
- Java Developers/Architects Resumes
- Informatica Developers/Architects Resumes
- Business Analyst (BA) Resumes
- Quality Assurance (QA) Resumes
- Network and Systems Administrators Resumes
- Help Desk and Support specialists Resumes
- Oracle Developers Resumes
- SAP Resumes
- Web Developer Resumes
- Datawarehousing, ETL, Informatica Resumes
- Business Intelligence, Business Object Resumes
- MainFrame Resumes
- Network Admin Resumes
- Oracle Resumes
- ORACLE DBA Resumes
- Other Resumes
- Peoplesoft Resumes
- Project Manager Resumes
- Quality Assurance Resumes
- Recruiter Resumes
- SAS Resumes
- Sharepoint Resumes
- SQL Developers Resumes
- Technical Writers Resumes
- WebSphere Resumes
- Hot Resumes