SUMMARY

• Good understanding and implementation of DBA Concepts like TASM, Performance Tuning, View Point Administration, DSA (Restoration & Archival process), Administration (Space Management, User Management), Data Migration, Performance Monitoring
• Installation of PDCR & Complete setup of Teradata on 2850
• Worked on different POC’s associated with Teradata.
• Understanding the business Source inventory template for Physical implementation of Data Model. (MLDM approach followed in Physical design)
• Performance tuning (Use of Data Dictionary/Directory tables and views to manage the system. DBQL Analysis to get more performance impacted queries.

PROFESSIONAL EXPERIENCE

Confidential

System DBA

Responsibilities:

• New Setup for 2850 as a disaster recovery.
• Analysis on table level redesign & applying Compression using MVC Tool (Teradata proprietary Tools & Nexus)
• Providing technical guidance and solutions for performance issues on production, pre - production databases - Performance Tuning
• Administration, Maintenance and control of the Teradata View Point
• Responsible for Backup/Restoration (Data Copy from one source system to another source system), monitoring.
• Supporting application development timelines by reviewing and assisting in the implementation of designs and/or incremental changes to database definitions.
• Performance capacity planning including allocating system storage and planning future storage requirements (Space Management)
• Creating Teradata Objects like Databases, Users, Profiles, Roles, Tables..etc (User Management)
• Responsible for House Keeping Jobs & Auto Provision Tools.
• Responsible for Centralized Stats Management
• Responsible for testing New tools associate with Teradata
• Automated regular DBA activities

Environment: Teradata 15, Netezza, Vertica, Teradata Viewpoint 15, 6800H, IT Service Now, SLES 11(SUSE Linux Enterprise Server), Windows XP, UNIX, SQL, MS-Office.

Confidential

Responsibilities:

• DSA-Teradata BAR activitiesSupporting application development timelines by reviewing and assisting in the implementation of designs and/or incremental changes to database definitions (Change Management process in IT Service Now(J&J Ticketing tool) )
• Report generation through Shell Scripting
• Creating Teradata Objects like Databases, Users, Profiles, Roles, Tables..etc (User Management)
• Responsible for House Keeping Jobs & Auto Provision Tools.
• Responsible for Centralized Stats Management
• Responsible for Tripwire(Monitoring Unauthorized changes on Node Servers)
• Responsible for Axida (Granting and Revoking access to Teradata CS)
• Analysis on table level redesign & applying Compression using MVC Tool (Teradata proprietary Tools & Atana Suite)
• Responsible for testing New tools associate with Teradata (POC’s on Alteryx, R Tool)
• Automated regular DBA activities

System DBA

Confidential

Responsibilities:

• Performance capacity planning including allocating system storage and planning future storage requirements (Space Management)
• Creating Teradata Objects like Databases, Users, Profiles, Roles, Tables..etc (User Management)
• Providing technical guidance and solutions for performance issues on production, pre-production databases - Performance Tuning
• Administration, Maintenance and control of the Teradata View Point
• Responsible for Backup/Restoration(Data Copy from one source system to another source system), monitoring on NetVault (Bar Activities)
• Administration, Maintenance and control of the Teradata Workload Management policies and rules.
• Supporting application development timelines by reviewing and assisting in the implementation of designs and/or incremental changes to database definitions (Migrating Pre-Production System to Production System)
• Performance Report generation
• Centralized Stats Management
• Data migration & data copy (Small Volumes) using Atana Suite Tools
• Automated Few Regular Activities of DBA Tasks (Shell Scripting. Complete Setup of DB as per process, DDL Migration )

Environment: Teradata 12, Teradata Viewpoint 15, 6650H, IT Service Now, Windows XP, UNIX, SQL, MS-Office.

Confidential

Physical Data Modeler, System DBA

Responsibilities:

• Requirement Gathering
• Understand the BA’s Requirement
• Create Prototype designs against logical data models, and defines data repository requirements and warehousing requirements.
• Get it approved for the MLDM Model created
• Using LDM Creating PDM Model.(Erwin -Reverse Engineering)
• Performance Analysis on Existing Tables to provide the Column usage if any model changes.
• New PI and SI recommendations on a table based on the requirement for resolving skew/space issues.
• Support to Users on DDL Scripts.

Support DBA

Confidential

Responsibilities:

• Creating Teradata Objects like Databases, Users, Profiles, Roles, Tables, etc..
• Reallocation Disk space - Move Space
• Granting a Revoking of Object Rights, System Rights on Databases/Users/Roles
• Responsible for gathering Query, CPU, Disk resource requirements for new applications and extensions to existing systems.
• New PI and SI recommendations on a table based on the requirement for resolving skew/space issues.
• Using Compression techniques to provide required compression values to gain space and for better retrieval performance.
• DBQL Analysis to get more performance impacted queries

Environment: Teradata 12, 5550H, Windows XP, UNIX, SQL, MS-Office

Confidential

Linux Admin

Responsibilities:

• DNS installation:
• Installing RHEL5 on Virtual Machine.
• Installing BIND 9.5.1 rpm’s.
• Configuring named.conf as forwarder.
• Send mail
• SSH, NFS, Veritas Volume Manager

Environment: BIND-9.5.1, Microsoft virtual server 2005, Nessus 3, Red Hat Enterprise Linux 5, Solaris 10.