SUMMARY

• Around 8 Years of experience in IT working extensively in multiple roles dat includes Database Administrator (DBA), Database Support & Maintenance, Backup & Recovery, Reporting & Database performance Tuning and Mainframes operations.
• Teradata DBA wif 5+ years of experience.
• Hadoop Trained & Cloudera Certified Developer for Apache Hadoop (CCDH).
• Extensive noledge on Setting up teh Structure, Database, User, Roles, Profiles, Space as per teh Teradata Best Practices.
• Extensive noledge on Workload management configuration & setup and creating of different types of rules for batch and reporting users to meet their job wifin SLA.
• Extensive noledge in Teradata Performance Tuning, successfully tuned many long running queries.
• Extensive noledge on preparing weekly, monthly & quarterly production health report and presenting those reports to teh customer.
• Working on identifying teh unnecessary secondary index which is never been used in teh system and clean up those unnecessary secondary indexes to improve teh performance and minimize teh ETL load time.
• Working closing wif customer and resolving different type of day to day customer’s issue and Provide suggestion and recommendation as per Teradata best practices.
• Extensive noledge on Change Management, Incident Management, Problem Management.
• Extensive noledge in Teradata utilities like BTEQ, Mload, Fload having good command on SQL and Explain Plan Analyzing.
• Good experience in utilizing teh Teradata tools and Console Utilities.
• Proactively monitoring teh production system and acting accordingly for production issue.
• Extensive noledge on Teradata View point Alert setup and configurations.
• Knowledge on generating TSET report.
• Monitor Database growth & provide Database capacity planning for applications expansion.
• Extensive noledge on DBS control parameters.
• Working Compression on all teh qualified tables which will halp in saving disk Space and reduced teh IO.
• Identifying teh High Partitioned count table and sending recommendation to teh client to revisit teh partitions.
• Extensive noledge on Access Rights scripts & Stats collection process.
• Working wif Teradata Customer supports executive for any Production/Development database issue and interact wif client accordingly.
• Experience in Teradata quarterly maintenance.
• Good communication, Leadership quality, client interaction, presentation skills and comfortable wif 24/7 working days.
• Good Knowledge of UNIX/LINUX and Shell Scripting.
• Extensive noledge on Teradata new server setup and database configuration.
• Experience on Data Mover.
• POC on Hadoop Development & Administration.

TECHNICAL SKILLS

Databases: Teradata 12, 13 & 14, Mainframe DB2.

Tools: & Utilities: Teradata Administrator, Teradata SQL Assistant, TASM, View Point, Teradata Manager, GlodenGate, TSET, PMON.

Teradata Utilities: BTEQ, Fast load, Multi load

Operating Systems: Windows NT/Advanced Server 2000/2003, UNIX, Linux

Backup tool: TARAGUI

PROFESSIONAL EXPERIENCE

Confidential - RICHARDSON, TEXAS

Teradata DBA

Responsibilities:

• Understand requirements and Scope of Project.
• Synch Activity between two Teradata productions System.
• Setting up teh Structure, Database, User, role, profiles, Space as per teh Teradata Best Practices.
• Creating of high level workload management setting to ensure dat each job gets proper priority as per business requirements and each job get completed wifin SLA.
• Setting up data lab and providing end to end support.
• Working compression on all teh qualified tables which will halp in saving disk Space.
• Running teh PDCR Reports each and analysing them for better performance.
• Identifying teh business objects long running queries and analyse them if there is any tuning opportunity.
• Working on tuning teh query which is having high CPU consumption.
• Cleanup teh unnecessary secondary index which are never been used in teh system to improve teh performance and minimize teh ETL load time.
• Working closely wif customer & Resolving different type of day to day customer’s issue & Provide suggestion and recommendation as per Teradata best practices.
• Preparing weekly, monthly & Quarterly production health report & presenting those reports to teh customer.
• Generating daily performance matrix report and send it to teh customer.
• Actively monitoring teh production system to ensure teh each job meet SLA.
• Identifying teh worst performance query and send to teh application team.
• Closely working wif development team to provide teh better suggestion.
• Releasing teh HUT lock, Fastload and Mload lock if any.
• Monitor Database growth & provide Database capacity planning for applications expansion.
• Actively performing Teradata Quarterly maintenance and send notification to teh business users.

Confidential - RHODEISLAND, MASSACHUSETTS

Teradata DBA

Responsibilities:

• Understand requirements and Scope of Project.
• Synch Activity between two Teradata productions System.
• Setting up teh Structure, Database, User, role, profiles, Space as per teh Teradata Best Practices.
• Creating of high level workload management setting to ensure dat each job gets proper priority as per business requirements and each job get completed wifin SLA.
• Setting up data lab and providing end to end support.
• Working compression on all teh qualified tables which will halp in saving disk Space.
• Running teh PDCR Reports each and analysing them for better performance.
• Identifying teh business objects long running queries and analyse them if there is any tuning opportunity.
• Working on tuning teh query which is having high CPU consumption.
• Cleanup teh unnecessary secondary index which are never been used in teh system to improve teh performance and minimize teh ETL load time.
• Working closely wif customer & Resolving different type of day to day customer’s issue & Provide suggestion and recommendation as per Teradata best practices.
• Preparing weekly, monthly & Quarterly production health report & presenting those reports to teh customer.
• Generating daily performance matrix report and send it to teh customer.
• Actively monitoring teh production system to ensure teh each job meet SLA.
• Identifying teh worst performance query and send to teh application team.
• Closely working wif development team to provide teh better suggestion.
• Releasing teh HUT lock, Fastload and Mload lock if any.
• Monitor Database growth & provide Database capacity planning for applications expansion.
• Actively performing Teradata Quarterly maintenance and send notification to teh business users.

Confidential, Nashville, TENNESSE

Teradata DBA

Responsibilities:

• Production DBA support.
• Creating user, database and database objects like table, views, macro etc.
• Extracting objects DDL (Definitions, Comments, Stats) from VAL and promoting it to PROD.
• Creating Roles, Profiles and Account String and providing different access as per teh requirement.
• Data synchronization between Dev and Prod Systems.
• Teradata Replication Services Using GlodenGate to synchronizes business-critical data by capturing row changes made to tables in one database and applying those changes to teh same tables in other databases in near-real time.
• Resolving Spool Space Issues.
• Data Transformation between Dev and Prod Systems.
• Worked on Access Rights scripts.
• Worked on Stats collection process during Dev and Prod Systems Up gradation.
• Worked on DBA procedures.
• Monitoring/Scheduling teh backup process using teh TARAGUI / Netbackup Adminsitrator.
• Prepare teh weekly reports (CPU, IO, Space and) and sending to teh client.
• Performance monitoring, investigating long running queries and Tuning queries.
• Resolving teh user request using Remedy ticket system.
• Monitoring Database growth & provide Database capacity planning for applications expansion.
• Monitoring teh hung/Blocked session and lock and taking teh action accordingly.
• Releasing teh HUT lock, Fastload and Mload lock.

Confidential, Bentonville, ARKANSIS

Teradata DBA

Responsibilities:

• Production DBA support.
• Creating user, database and database objects like table, views, macro etc.
• Creating Roles, Profile and Account String and providing different access as per teh requirement.
• Managing Databases spaces.
• Resolving Spool Space Issues.
• View point/Teradata Manager Alert setup for Prod systems.
• Worked on Access Rights scripts.
• Worked on Stats collection process.
• Worked on DBA procedures.
• Modifying teh DBS control parameter setting as per requirement.
• Prepare teh weekly reports (CPU, IO, Space) and sending to teh client.
• Performance monitoring, investigating long running queries and Tuning queries wif teh analysis of Business objects.
• Resolving teh user request.
• Generating TSET report and sending it to teh GSC.
• Monitoring Database growth & providing Database capacity planning for applications expansion.
• Monitoring teh hung/Block session and lock and taking teh action accordingly.
• Releasing teh HUT lock, Fastload and Mload lock.
• Creating Teradata incident (P1, P2 and P3) for any database/hardware/system issues like AMP down, Node down etc.
• Working wif Teradata Customer supports executive for any Production/Development database issues and interact to teh client accordingly.

Confidential, Chicago, IL

Teradata DBA

Responsibilities:

• 24*7 DBA Production support
• Creation of user, database, roles, profiles, giving access rights.
• Monitoring teh system through VIEW-POINT & responding teh alerts.
• Granted & Revoked Object Rights, System Rights on Databases/ Users/ Roles.
• Take Database backups by TARAGUI.
• Good understanding in analysis of locks, indexing.
• Doing teh refresh from production to QA and Dev as per requirement.
• Fixing any errors in Macros, Stored Procedures
• Checking and providing teh spaces in teh production databases.
• Setting up teh Structure, Database, User, role, profiles, Space as per teh Teradata Best Practices.
• Performing teh Performance review, analyzing reports, Monthly PPT’s and Daily Reports.
• Performing QUERY TUNING.
• Performing Backup, Restore and Copy. Writing scripts for teh same as per requirement
• USER, DATABASE & ACCESS RIGHTS Management.
• SPACE Management (Space allocation, monitoring etc.)
• OBJECT Management (Table/View/Macros/Procedure creation, Data Replication etc.)
• Resolution of ETL Job failure and Session handling.

Confidential

Mainframes Operations

Responsibilities:

• Scheduling teh Production/Development/Test jobs into teh current plan.
• Amending (Overriding/Editing) teh JCLs for failed jobs.
• Restarting/ Force completing/ Holding/ Nopping/ Un-nopping teh operations in OPC.
• Performing adhoc requests as instructed by application team.
• Taking action on teh failed jobs as per application team’s instructions.
• Deleting Operations/ Applications in CP/ LTP of OPC.
• Holding teh jobs as per application team’s request.