SUMMARY:

• Confidential has over 7 years of experience in IT industry. Confidential specializes in Teradata Database Administration. As a Teradata Administrator Confidential has involved in multiple DBA activities including implementing the changes in various systems like Production and UAT systems by RFC requests, Involved in system outages and BAR activities.
• Confidential is proficient in Teradata DBA activities and functions like database creation and setup, user management, system performance, resource monitoring, database backup using archive and restore.
• Confidential has expertise in Teradata database administration, Teradata system maintenance, performance tuning, TARA GUI, ARC utility for Backups/Restores, good exposure in using TTU tools and utilities, Viewpoint, Datamover, Unity, PMON and Teradata Manager for system monitoring and handling Teradata Databases.
• Confidential is well versed in Data validation process from Teradata to Hadoop. As part of replacing the Teradata disaster server wif Hadoop systems, performed data movement from Teradata to Hadoop using Sqoop. Post Data Move (Teradata to Hadoop) successfully performed data validation for each record. Extensively worked wif Teradata SQL and HIVE SQL, embedded in UNIX shell scripts to perform data validations.
• Certified on Teradata Application Development V2R5.Teradata DBA hands - on summary:
• Teradata Tools and Utilities: including DBA Tools like Teradata Administrator/Teradata viewpoint/ARCMAIN/SQL Assistant/Performance Data Collection & Reporting (PDCR) & DBQL for Performance Monitoring. Very good noledge in Data mover, Teradata Unity, Load/Unload Utilities like Multiload, FastLoad, Fast Export, TPUMP and TPT.
• User Management: Creating users, granting permissions. Creating spool space, Moving space from one database to other. Assigning roles based on security layers in a controlled access environment.
• Query Tuning and Optimization: Remediate slow running queries by using various query optimization techniques (primary index/stats/joins/skew elimination, etc) and tools (viewpont and Visual Explain).
• Database Setup/Backup and Day to Day Maintenance: Table implementations, maintenance and backup using Arcmain and TARA GUI. Creating sandbox environment for application users. Creating/modifying db creation scripts in Unix/Linux shell scripts using VI Editor. Creating/replacing teradata databases, users,tables, rights, views, stored procedures, join indexes, macros. Providing on call 24X7 support on rotational basis every other week. Run periodic database health checks for spool, monitoring dbc.accessrights. Keeping abreast of TD updates from Teradata At your Service(T@Ys) and alerts which impact current Teradata systems.
• Determining database perm, spool and temp space. Allocating and moving space between teradata databases/users using Teradata Administrator. Creating roles, granting/revoking permissions using Teradata Administrator/Teradata SQL Assistant.
• Maintaining all DBA functions (development, test, production) in all three platforms in operation 24x7.
• Managing database space, allocating new space to database, moving space between databases as needbasis.
• Addressing day to day users issues such as resetting passwords, unlocking used ID's, working on permission issues.
• Very good noledge in Data mover, Teradata Unity, Load/Unload Utilities like Multiload, FastLoad, Fast Export, TPUMP and TPT.
• Having good working noledge of TASM, Viewpoint, teradata console utilities,.
• Monitoring bad queries, aborting bad queries using View point Query monitor, looking for blocked sessions and working wif development teams to resolve blocked sessions.
• Analyzing sessions wif for high spool usage, high CPU usage, high disk usage, and high skew etc when alerts are received.
• Tuning bad queries by analyzing explain plans, visual explain to understand optimizer plans, created various NUSI index as needed bases
• Extensively worked wif DBQL data to identify high usage tables and columns.
• Monitoring of all systems using Viewpoint and addressing the issues wif application teams
• Code reviews and deployments through CAB/ RFC’s
• Attempting the all other (grants/ ad-hoc) requests through Nexus, Maximo and Remedy tools
• Data movements to different environments through Data Mover
• Environment/Data SQL synchronization using Teradata UNITY
• Participated in DBA on call rotation to support production system during off hours.

TECHNICAL SKILLS:

Teradata tools & Utilities Query facilities: SQL Assistant, Teradata Administaror,BTEQ, PMON, View point, Data mover, Unity & TARA GUI

Database: Teradata 13.0/14.0,Oracle(9i/10g),SQL Server,DB2 and Hadoop

ETL / SAS: Informatica 8.0, SAS 9.3, Base SAS,SAS/Macros, SAS/SQL & SAS EG, Hyperion Essbase, Microstarategy

Load & Export: FastLoad, MultiLoad, Fast Export, BTEQ, Tpump, TPT, ARC

Scheduler: AutoSys

Version Control: Apache SVN

Operating Systems: Windows XP, 2000,UNIX/Linux, Mainframes (MVS)

Scripting languages: UNIX Shell, JCL

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Teradata Systems Admin & Support

Responsibilities:

• Maintaining all DBA functions (development, test, production) in all three platforms in operation 24x7.
• Managing database space, allocating new space to database, moving space between databases as need basis.
• Creating roles and profiles as needed basis. Granting privileges to roles, adding users to roles based on requirements.
• Addressing day to day users issues such as resetting passwords, unlocking used ID's, working on permission issues.
• Very good noledge in Data mover, Teradata Unity, Load/Unload Utilities like Multiload, FastLoad, Fast Export, TPUMP and TPT.
• Having good working noledge of TASM, Viewpoint, Teradata utilities,.
• Monitoring bad queries, aborting bad queries using View point Query monitor, looking for blocked sessions and working wif development teams to resolve blocked sessions.
• Analyzing sessions wif for high spool usage, high CPU usage, high disk usage, and high skew etc when alerts are received.
• Tuning bad queries by analyzing explain plans, visual explain to understand optimizer plans, created various
• Extensively worked wif DBQL data to identify high usage tables and columns.
• Monitoring of all systems using Viewpoint and addressing the issues wif application teams
• Code reviews and deployments through CAB/ RFC’s
• Attempting the all other (grants/ ad-hoc) requests through Nexus, Maximo and Remedy tools
• Backup scheduling and restores (BAR) and monitoring through Net backup TARA GUI and mainframe tools.
• Data copying to different environments through Data Mover
• Environment/Data SQL synchronization using Teradata UNITY
• Participated in DBA on call rotation to support production system during off hours.

Environment: Teradata 13.0, Teradata SQL, Unix, SAS Base, Hyperion Essbase, Microstarategy, DB2, Oracle, SQL server, BTEQ, Fast load, Tpump, Multiload, TPT, View point,Unity, Data mover, Mainframes, Autosys, and JAMS.

Confidential

DBA

Responsibilities:

• Use of Data Dictionary tables and views to manage the system.
• Creating and managing user accounts wif appropriate security.
• Prepared shell scripts for monitoring the system.
• Automated the Netbackup and NetVault for tables and database.
• Refreshed the data by using fast export, multiload, fastload and ARC utilities.
• Assisting developers/users to tune queries.
• Overseeing daily and weekly back-ups.
• Performance monitoring, investigating long running queries and Tuning queries wif the analysis of Business objects.
• Automated the stats collection process using shell scripts.
• Analyzing data and implementing the multi-value compression for optimal usage of space.
• Granted & Revoked Object Rights, System Rights on Databases/ Users/ Roles.
• Reviewing the projects in all the phases and Migrating the database objects.
• Defined a backup process for DB wif ARC utility.
• Active participation in Teradata maintenance activities.
• Worked wif BI Production Supporting team for production database issues.

Environment: Teradata 12.0, JCL, Teradata SQL, UNIX, DB2, BTEQ, Fast load, Tpump, Multiload, ARCMAIN and MVS

Confidential

DBA

Responsibilities:

• Production DBA support.
• User administration by creating and managing privileges of user
• Creating and managing databases.
• Move data across different environments using ARCMAIN, Fastexport/Fastload,Multiload methods.
• Managing Backups/Recovery by ARCMAIN
• Code Reviews and Migrations across different environments.
• Resolving Spool space issues.
• Roles and Profiles Management
• Working on a NEXUS ticket request process.

Environment: Teradata 12.0, JCL, Teradata SQL, Oracle, DB2, BTEQ, Fast load, Tpump, Multiload, PMON and MVS