SUMMARY:

• Having 11+ years of experience in Administering Teradata databases. Testing, Upgrading patches in Dev, QA and production databases, Having Excellent knowledge of automation scripts implementation on UNIX and windows servers .
• Extensive knowledge in Teradata utilities like TSET, Mload, Fload and Fexp, have good command on SQL and Explain Plan Analyzing.
• Extensive knowledge in Teradata Performance Tuning, involve with program teams and Architect team to find and resolve query issues / DB Design issues
• Good experience in utilizing the Teradata tools.
• Extensive knowledge in writing BTEQ, FastLoad, FastExport and MultiLoad scripts. I have also designed and implemented a production Change Control policy and procedures.
• Proactively monitoring the production system and acting accordingly for prod issue
• Exposure on oracle 9i concepts
• Knowledge on ETL tools like Informatica for session monitoring and understanding session logs to resolve DB specific failures, proving recommendations by Query rewriting for better performance.
• Supported Physical Data Model of project initiatives to maximize system performance through primary index selection and data compression
• Knowledge of Installation & basic administration of Oracle 9i. Knowledge in monitoring Alert Log File.
• Very organized, versatile, self - motivated team player with strong analytical and relationship management with effective written and oral communication skills.
• Quest learning new technologies and striving for excellence motivates.
• Good Communication abilities in collaborative approach & team building skills with proficiency in grasping new technical concepts quickly and utilize the same in a productive manner.

TECHNICAL SKILLS:

Operating Systems: Linux,Unix, Windows NT

Languages: Unix Shell Script, PL/SQL

Databases: Teradata, Oracle

Tools: & Utilities: Teradata Manager,Teradata Administrator, Teradata Index wizard,TeradataStatisticswizard,TeradataSQL Assistance,TDWM,TASM,TSET,Bteq, Fastexport, Fastload, Mload, Arc and Confidential, Toad.Nexus Compression Tool.

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

Teradata Operational DBA

Responsibilities:

• Responsible for all System Architecture and Database Administration on Teradata. BAR implementation and management for NetBackup.
• Maintain Protegrity services and tasks
• Monitoring Confidential .
• Performance Tuning, Query Optimization and SQL
• Reporting and Capacity management.
• Wroked Confidential Migrations, System merge, Version Upgradations,TTU installations on LINUX,UNIX,WINDOWS and Solaris systems.
• Coordination with Confidential GSC on various tasks (upgrades, patches, system work and troubleshooting on major SW issues).
• Block Level TBBLC compression
• TASM Efforts
• Experience on Wherescape RED tools
• Responsible for hardware and software platform upgrades(DB, Confidential, Linux,Solaries,Unix and Windows systems) and configuration.

Environment: Teradata V 14.10.04.11 (9 node system, with 6Active and 3HSNs),Cluster Confidential (V14.10), NETBACKUP,TARAGUI,Weherescape RED, Teradata Administrator, Service-Now and IDM tools for user requestsTeradata Index wizard, Teradata SQL Assistance, Teradata system Emulation Tool (TSET), TASM and Teradata utilities like Bteq, Fastexport, Fastload, Mload, Arc etc.

Confidential, Phoenix, AZ

Teradata System DBA

Responsibilities:

• Experience in supporting hardware/software installation and upgrades for the Teradata environment
• Experience with Teradata Database Administration including experience of managing large systems
• Experience in monitoring and tuning a database to provide a high availability service
• Experience in Supporting and coordination during hardware upgrades
• Notifying the status to ETL staff regarding jobs if there is any issue while monitoring system using Confidential and PMON on daily basis.
• Creating databases and setting up Environment for Development, Testing and UAT and moving the code and History data to production by following the implementation process
• Must have a broad knowledge of diverse data administration
• Implement multi-value compression using Nexus smart compression tool on weekly basis.
• Storing the SQL logs in separate database.
• This will be based on Business User and Power User Requirement.
• Drive planning and execution of hardware/software upgrades and expansion.
• Space allocation requests.
• Monitor database and periodic performance tuning.
• Copying/refreshing the data between two systems using netbackup or arcmain utililtes.
• Taking necessary action to avail the Database resource like spool space efficiently and ensure the Database High availability for Business and Batch Jobs.
• Maintaining the Teradata Space efficiently for Business and batch jobs by ensuring the Data currency is up to date.
• Regular Housekeeping of DBC to manage the DBC space by cleaning the DBC objects
• Tuning the database so as to provide the expected performance
• Collecting the status in frequent intervals as far as possible. Enhanced the stats process with sample stats logic for the large tables.
• Involved in TTU, DBS version and OS patch upgradations and Node merger activities and other client tools upgradations whenever needed.
• Providing the No of Online, Batch and Power User information reports as per the requirements
• Performing maintenance Activities like (COLLECT STATS) at the time of backup so that it will not impact business availability windows.
• Monitor technical alerts though Confidential .
• Confidential protlet configuration and Confidential services restart when needed.
• Involving in to generadte year ending audit reports
• Providing Spool space, Perm space Jobs wise and User wise usage report
• Providing the Performance related job info with Regular intervals.
• Providng CPU backlog and Overall system CPU demand reports on weekly baises.
• Creation of reports using PDCR tool kit and PDCR database tables.
• Montiring and Miantaing the daily and weekly production backups.
• Creating, scheduling/automating, and modifying the backup jobs on netbackup console and Tara GUI.
• Troubleshooting the backup issues
• Maintaing the services of Netbackup, Taraclient and Taraserver whenever needed (both windows and Linux systems).
• Configured Netbackup Vaulting jobs to duplicate the backup job images between different data centers.
• TASM maintaining activities like, creation, copying/cloning, backing up of TASM ruleset, activation and deactivation of ruleset.
• Involved define and modification of TASM workloads,throttles andfilers as per client requirement
• Work expireince on EMC EDL consle to maintain the netbackup tapes.

Confidential

Application DBA

Responsibilities:

• Design, creating and tuning physical database objects (tables, views, indexes) to support normalized and dimensional models. Maintain the referential integrity of the database.
• Monitoring the system using Teradata Confidential and PMON.
• Involving in weekly, monthly and quarterly reports generation by using PDCR tool kit.
• User,database,object creation upon the remedy tickets.
• Reviewing the SQL code and object code to fix the performance issues.
• Providing the data purge recommendations for large tables for monthly wise.
• Involving in weekly oncall rotation.
• Provide ongoing support of the environment by developing processes and executing object migrations, security and access privilege setup, and performance monitoring.
• Must have a broad knowledge of diverse data administration methodologies, and tools.- Runtime optimization, planning, scheduling, and execution of maintenance utilities.
• Design, build and maintain the physical Teradata data structures to support business requirements
• Review the database interaction of each application interacting with Teradata
• Coordinate activities with the Database Administration Area Set best practices for the Teradata environment Provide input to physical modeling.
• Knowledge of database recovery and restart procedures is desirable.
• Identifying the Power users and providing the space for analyzing and Business Study specific to them without impacting the Batch jobs and loads.
• Knowledge transfer to Dev team to optimize code before moving to production and following the checklist.
• Perform initial problem isolation/identification/documentation
• Schedule change implementation activity.
• Raising the priority for loads based on the requirement.
• Worked on DDL code review and generating the executable DDL script from ERWIN tool.
• Doing object,databases and user installations.
• Appling the table compression using Nexus tool
• Checkout the system/root passwords using EPAR tool
• Involved in NODE merger and Confidential upgrade activities.
• Providing Application Wise Growth to date and projections for future growth and evaluating the same considering Management views and concerns.
• Proactively providing information about the outage timings to client DW team and the Business team so as to plan their activities accordingly.
• Assist with technical specifications as required and Plans at an operational level and manages the effective use of resources to implement a medium sized or multiple smaller assigned projects.
• Transforms business specifications into cost-effective information systems applications through resource plans and prioritizes work within established budget objectives.
• Provides the project manager/supervisor with timely and accurate information regarding the performance of the assigned projects(s)
• Builds and leverages effective alliances across the technical and business community ensuring the best utilization of resources
• User Creation/Modify
• Granting Roles and Profiles for users
• Database Audit related stuff.
• Manage user access and implements/ensures security requirements are met.

Environment: Teradata V 13.10.04.04 , Confidential (V14), NETBACKUP,TARAGUI,NEXUS tool for table compression, Teradata Administrator, Teradata Index wizard, Teradata SQL Assistance, Teradata system Emulation Tool (TSET), TASM and Teradata utilities like Bteq, Fastexport, Fastload, Mload, Arc etc.

Confidential, Tampa, FL

Teradata Database Administrator

Responsibilities:

• Done Query optimization explain plans, collect statistics, Primary and Secondary indexes.
• Worked on loading several tables using Fastload, and Multiload.
• Created scripts using FastLoad, Multi-Load to load data into the Teradata data warehouse.
• Managed Teradata databases and space issues (MAXPERM, MAXSPOOL etc) created user accounts and fixed performance issues and used tools like Teradata Administrator, Teradata Manager, PMON, cnsrun, Dbscontrol.
• Performed DBA activities like creating databases, users, tables, views, macros, secondary indexes, partitioning table, monitor and tune tables/queries, used Teradata Visual Explain utility. involved in Validating Data from different Data Source which involved creating of a number of Temporary Tables.
• Used BTEQ for Batch Processing Job to automate daily reports for transactions with multiple access level.
• Releasing Utility Locks of Fastload / Multiload.
• Dropping Multiload related tables for the aborted jobs.
• Investigating Space Usage & Monitoring the growth of the databases.
• Responsible for optimizing space management for Production, Pre-Production and Test Teradata systems.
• Conversion of a data from oracle to a Teradata V2R6 EDW
• Daily Load monitoring and maintaing.
• Implemented Teradata Collect Statistics Processes
• Data Load Script Design and Testing

Environment: Oracle DBA on SUN Solaris, Windows 2000/NT 4.0 and Oracle 8i/9i environment Teradata V2R6, Teradata V12 Teradata Manager, NET

Confidential, WI

Teradata Database Administrator

Responsibilities:

• Use of Data Dictionary/Directory tables and views to manage the system
• Teradata Administrator - graphical Windows tool to assist in administration
• Worked as Application Teradata dba on BI development projects like SWB,SRC,INV,AP,AR..etc in both EDW and ODS.
• Focuses on database design and the ongoing support and administration of databases for a specific applications
• Suggesting the table redesign, query rewrite,Index creations(PI,SI and JI), macros and stored procedures at database level.
• Doing the Analasys on Informatica loading design Jobs and giving the suggestions about the mappings and workflows of BI project teams.
• Writing and debugging complex SQL and understands the best ways to in corporate database requests into application programs.
• User scripts and 3rd party applications
• Creating and managing user accounts and databases with 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.
• Supported Physical Data Model of project initiatives to maximize system performance through primary index selection and data compression
• 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
• Maintenance activities like Check Table,Scandisk,Packdisk using Ferret Utilities
• Installed new software db mon on Teradata nodes to monitor the system.
• Installed Teradata utilities 8.1 and upgraded to 8.2 and Teradata utilities 8.2 is upgraded to 12 versions.
• Used Teradata Index Wizard to identify the good SI for a query and workload.
• Used Teradata Statistics wizard to identify the missing and extra stats.
• Used TDWM for defining the work loads for ETL’s and Reporting.
• Used TSET for copying the stats and other system information to analyze the issue.
• Automated the stats collection process using shell scripts.
• 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 upgrades activities in different releases.
• Have Knowledge in Compression techniques.
• Worked with BI Production Supporting team for production database issues.
• Teradata Query/Performance Tuning:
• Worked as Teradata Performance Tuning/ Query tuning DBA since last one year. The task is to reduce the Teradata system resource consumption.
• Worked on Long Running Informatica Queries, Business Object Queries and Cognos reporting queries.
• Tuned the Load and reporting queries by considering the below things
• Queries that take more CPU( Total CPU Time)
• Queries that take more HOTAMPCPU
• Queries that take more spool usage
• Queries that take more CPU skew due to bad data and bad query design
• Queries that have take more PJI
• Tuned the reporting queries(ie COGNOS, WEB and BO Queries) that are used to aborted by TDWM rule violations
• Given the suggestions for the bad running queries to the respective program teams by creating the problem ticket or clarify case.
• Fixed the tables skew factor by suggesting the PI changes and data changes
• Tuned the long running BTEQ load scripts by using GT(Global Temporary) and VT(volatile Temporary) tables.
• Reduced the runtime and rows limit for the queries by collecting the single and multi column statistics.
• Tuned the queries by creating the Secondary Indexes and by modifying the joins and by adding the filter conditions.

Environment: Teradata V2R6 (Teradata V12 upgradation is under staging area), Teradata Manager 12.0.0.6, NET Confidential, Teradata Administrator, Teradata Index wizard, Teradata SQL Assistance, Teradata system Emulation Tool (TSET) and Teradata utilities like Bteq, Fastexport, Fastload, Mload, Arc etc.

Confidential

Oracle and Teradata Database Administrator

Responsibilities:

• Installed, Upgraded and Configured Oracle 9i/8i.
• Creating Database, Tablespaces, Rollback Segments etc.
• Creating users & roles and granting roles and privileges to users.
• Capacity Planning, Estimating Database Size and SGA size.
• Designing and developing backup and recovery strategies.
• Control and monitor user access to the database.
• Table and Index fragmentation.
• Refresh Object level, schema level and full database level from production to non-production databases.
• Adding partitions to the tables on quarterly basis.
• Generate the database growth report by monthly wise.
• Done Query optimization explain plans, collect statistics, Primary and Secondary indexes.
• Worked on loading several tables using Fastload, and Multiload.
• Created scripts using FastLoad, Multi-Load to load data into the Teradata data warehouse.
• Managed Teradata databases and space issues (MAXPERM, MAXSPOOL etc) created user accounts and fixed performance issues and used tools like Teradata Administrator, Teradata Manager, PMON, cnsrun, Dbscontrol.
• Performed DBA activities like creating databases, users, tables, views, macros, secondary indexes, partitioning table, monitor and tune tables/queries, used Teradata Visual Explain utility.
• Involved in Validating Data from different Data Source which involved creating of a number of Temporary Tables.
• Used BTEQ for Batch Processing Job to automate daily reports for transactions with multiple access level.
• Releasing Utility Locks of Fastload / Multiload.
• Dropping Multiload related tables for the aborted jobs.
• Investigating Space Usage & Monitoring the growth of the databases.
• Responsible for optimizing space management for Production, Pre-Production and Test Teradata systems.
• Conversion of a data from oracle to a Teradata V2R6 EDW
• Daily Load monitoring and maintaing.
• Implemented Teradata Collect Statistics Processes
• Data Load Script Design and Testing

Environment: Oracle DBA on SUN Solaris, Windows 2000/NT 4.0 and Oracle 8i/9i environmentTeradata V2R6, Teradata Manager, NET Confidential, Teradata Administrator, Teradata Index wizard, Teradata Statistics wizard, Teradata System Emulation Tool (TSET),Teradata SQL Assistance(Query Man), Teradata utilities like Bteq, Fastexport, Fastload, Mload etc.,