SUMMARY:

• Having 7 years of experience in IT industry. He specializes in Teradata Database Administration.
• Proficient in Teradata DBA activities like DBA functions like database creation and setup, user management, system performance, resource monitoring, database backup using archive and restore.
• He has experience in Teradata DBA into different activities includes performance tuning, TARA GUI, ARC utility for Backups/Restores, Good exposure in using TTU tools and utilities, Viewpoint, PMON, Teradata Manager for system monitoring and have an experience in handling Teradata database . experience on Teradata database Administration into different activities includes Teradata system Maintence,performance tuning, TARA GUI, ARC utility for Backups/Restores, Good exposure in using TTU tools and utilities, Viewpoint,Datamover,Unity,PMON,Teradata Manager for system monitoring and have an experience in handling Teradata database(12,13.10,14.1 versions).
• Experience in Teradata Data mover scripts, Unity and view point.
• Experience in mainframe systems with JCL.
• Experience on ETL tools like IBM datastage and analytical tools like SAS, BASE SAS.
• Expertise in writing UNIX shell scripts, Perl scripts for the automation process.
• Experience with TASM and advance performance management and sql tuning.
• Experience in usage of PDCR and DBC tables.
• Experience in installing Teradata applying patches, level 3 troubleshooting
• Experience in change implementation and release management process.
• Experience usage of HADOOP frame work for the replacement of traditional tapes.
• Conducted hadoop trainings to various teams in the organization.
• Experience in usage of Rainstor for the data de - duplication on hadoop.
• Experience in data import process from Teradata to hadoop using sqoop.
• Expertise in installing and Configuring of HADOOP cluster.
• Expertise in working with HADOOP echo systems like HIVE, PIG, HBASE and HDFS file system.
• Good Architecture knowledge on parallel processing with hadoop.
• Experience in Data validation process from Teradata to Hadoop.
• As part of replacing the Teradata disaster server with Hadoop systems, we have done data movement from Teradata to Hadoop using Sqoop .Once Data moved from Teradata to Hadoop we have done data validation for each record.Datavalidation process done using the Teradata SQL and HIVE SQL, which are embedded in Unix shell scripts.
• For the past 7 years he has successfully performed as a Teradata Administrator. Experience in program management activities like participating in implemenations,Coordinating with users for implementations and smooth releases, experience in change management life cycles and release management activities like RFC's. Assisting users and development teams to resolve the issues.Particiapted in Teradata migration initiatives.
• As a Teradata Administrator he 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.
• 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 knowledge in Data mover, Teradata Unity, Load/Unload Utilities like Multiload, FastLoad, Fast Export, TPUMP and TPT.
• System Performance tuning and capacity planning experience, including production and interpretation of PMCP Reports.
• Experience with translating logical models to optimal physical models.
• 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 (viewpoint 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.
• Experience in installing Patches/Level 3 troubleshooting support.
• Experience Netvault backup system.
• 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 need basis.
• Addressing day to day users issues such as resetting passwords, unlocking used ID's, working on permission issues.
• Very good knowledge in Data mover, Teradata Unity, Load/Unload Utilities like Multiload, FastLoad, Fast Export, TPUMP and TPT.
• Having good working knowledge of TASM, Viewpoint, teradata console utilities,.
• Monitoring bad queries, aborting bad queries using View point Query monitor, looking for blocked sessions and working with development teams to resolve blocked sessions.
• Analyzing sessions with 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 with DBQL data to identify high usage tables and columns.
• Monitoring of all systems using Viewpoint and addressing the issues with 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.
• He has over 3 years of experience on ETL development using IBM datstsage.
• Used Datastage as ETL tool to load & unload data to /from Teradata/Sql Server databases
• Extensive knowledge of usingDatastage with various processing stages.
• Experienced in UNIX shell scripts/JCL Programs to write wrapper scripts to call ETL Jobs.
• Having experience in 3NF, dimensional modeling (BI/ Data Warehouse).
• Knowledge of different Schemas (Star and Snow Flake) to fit reporting, Query and business analysis requirements.
• Good understanding of Financial Services logical Data Model Teradata (FSLDM).

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

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 DBA

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.
• Experience in Teradata Datamover scripts.

Confidential

Sr.Sys 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.
• Experience in Teradata Datamover scripts.
• Experience in installing Patches/Level 3 troubleshooting support.
• Experience Netvault backup system.
• Very good knowledge in Data mover, Teradata Unity, Load/Unload Utilities like Multiload, FastLoad, Fast Export, TPUMP and TPT.
• Having good working knowledge of TASM, Viewpoint, Teradata utilities,.
• Monitoring bad queries, aborting bad queries using View point Query monitor, looking for blocked sessions and working with development teams to resolve blocked sessions.
• Analyzing sessions with 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 with DBQL data to identify high usage tables and columns.
• Monitoring of all systems using Viewpoint and addressing the issues with 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 with appropriate security.
• Prepared shell scripts for monitoring the system.
• Experience in installing Patches/Level 3 troubleshooting support.
• Experience Netvault backup system.
• 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 with 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 with ARC utility
• Active participation in Teradata maintenance activities
• Worked with 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