* *** ***** *****

469-***-****

acrc55@r.postjobfree.com

Professional Summary:

Certified TERADATA DATABASE ADMINISTRATOR, Having of around 10 years of

experience in Teradata technology into various APPLICATION and

OPRERATIONAL Teradata DBA activities includes performance tuning, Netbackup

TARA GUI, Netvault, DSA and ARC utility for Backups/Restores, Good exposure in

using TTU tools and utilities (BTEQ, Fastload, Mload, TPUMP and TPT),

Viewpoint, PMON, Teradata Manager for system monitoring and has experience in

handling Hardware and database Upgrades are also part of my forte. Worked on

Windows, MPRAS-UNIX and Linux platforms.

Good Exposure in Using Oracle Golden Gate for Real-Time Data Integration and

also having experience into Installation of GoldenGate application in Source and

Target systems. Monitoring of replication data and troubleshooting the issues while

copying data from source to target system

Good exposure in complete setup of Golden Gate replications at BI side for various

source systems Oracle, SQL etc.,

Co-ordination with source team to stop the extract file during any server

maintenances to avoid data replication issues.

Having good experience in end-to-end Teradata DBA support which includes daily

routine DBA activities, project code reviews, migration and upgrades of Teradata

hardware & software, backup scheduling & monitoring (Netbackup with TARA

GUI, Netvault and ARC utility), other tools & utilities (TTU13 and 14 utilities,

Teradata Administrator, Teradata Manager, dbscontrol etc), PDCR, DBQL,

Capacity Planning and applying Agile (SCRUM) methodologies for BI projects.

Having TASM exposure in analyzing the existing workloads using T eradata

workload analyzer, designing, adjusting & monitoring the workloads using Workload

Designer and Workload Monitor port lets.

Having good experience in Analyzing and worked on ETL side using Informatica

Powercenter, build the mappings, COGNOS, BO, Tableau and SAS, OBIEE and

Micro strategy reporting tools and functionality.

Good in using Mainframe to analyze the ETL jobs, monitoring/create backup and

restore jobs, creating and casting endeavor packages for ETL teams. Stop and re-

initiate the TDPs during the maintenance window.

Creation and maintenance of conceptual (Semantic Data model) and logical data

model design for enterprise data warehouse using ERWIN suite and ER/studio

Page 1

(Embarcadero Tool) for creation of physical data model

Worked with Fortune Global 500 companies like Bank of America, Barclays, Aviva

and GE HealthCare.

Having mid-level ORACLE DBA experience and was involved in migrating Data

Warehousing Oracle 9i databases to Oracle 10g RAC servers and adding

partitions to the critical Oracle database tables of Healthcare client

Trained in Hadoop Big Data Administration.

Achievements:

Awarded with Operational Excellency Award by GEHC client for excellent team

playing for Teradata DBA work.

Awarded with Associate of the Month and BRAVO awards for continuous

outstanding performance for 2011-2012

GE Healthcare won the EPIC award for Resource Optimization and Sustainable

Business Practices for 2012 part of Teradata Partners conference

Received the GOLD and STAR Of The Month awards from BOA for excellent

performance in automating the tasks

Education

Degree Specialization University Year of passing

Post- M.C.A Osmania University, 2004

graduation/Professional INDIA

courses

Graduation B.SC Osmania University, 2001

COMPUTERS INDIA

Technical Skills

Teradata

2 PRIMARY SKILL CATEGORY

SKILL Oracle, Informatica, Business Objects, OBIEE and

3 SECONDARY

COGNOS, SAS and Golden Gate

CATEGORY 1

Teradata, Oracle, Hadoop Bigdata and Mainframe

4 TRAINED SKILLS

Banking and Financial, HealthCare, Insurance and

5 OPTIONAL DOMAIN SKILLS

Manufacturing and entertainment

English, Hindi and Telugu

6 LINGUISTIC SKILLS

Page 2

Professional Experience

1 Project Details I

Company DirecTV

Role Sr Teradata DBA

Software Used TTU 14.10 and 15

Location Los Angeles, CA

Duration Feb 2015 to Till Date

Team Size Project : 8

Roles and Responsibilities:

Teradata system monitoring through Viewpoint.

Supporting 4 environments, PROD, DR, QA and DEV

Handling of 2 6750 8 node systems

Handling of 2 Appliance systems (2700 and 2750)

Supporting Teradata Aster

Working on Teradata V15.00 and SUSE Linux v11 versions

Expertise in using Teradata Tools and Utilities (SQL Assistant, TD Administrator,

BTEQ, Fast load, Multi-load, TPUMP and TPT etc.).

Data migration/copy between PROD to DEV /Test using Data Mover

User and Database creation, maintaining proper access rights through roles and

profiles.

Space management

DDL Review and deployment into various environments

Implementation of MVC and BLC

Release Management/Deployments

SQL Code Review with BI application teams

Performance tuning for ETL and Reporting queries

Expertise in using PDCR and DBQL data for query analysis.

Support and co-ordination during Hardware and patch upgrades.

TASM & Work load monitoring and changes to the existing and creating new settings

based on the analysis of DBQL and TDWM data.

Using SUSE Linux Enterprise 11 Service Pack 1 and new features of TASM (virtual

partitions)

Expertise in setting up alerts through viewpoint for CPU, IO and disk space related.

BAR operations using Netbackup TARA GUI

Converting existing backups to Data Stream Architecture (DSA) from TARA

Netbackup.

Golden gate expertise in using at BI side for debugging Replicats.

Monitor the replicats and resolve the GG issues

Complete setup of new replicats for new tables setup at target side

Page 3

Coordinated with BI architects, managers and application development teams during

the code reviews and deployments.

Expertise in NTA analysis and work with Teradata CSRs to get the updates

Good in Change and Incident management process

Expertise in scheduling and monitoring jobs through CA Autosys scheduler

Good in understanding and providing details during the SOX and PCI audit calls and

attending internal and external security audits

Expertise in TTU client installations on Solaris and Windows systems

2 Project Details II

Company Bank Of America Corporation

Role Sr Teradata Database Administrator (DBA)

Software Used TTU13.10 and 14.10

Location Plano, TX

Duration May 2013 to Jan 2015

Team Size Project : 30

Teradata DBA Roles and Responsibilities:

Supporting 5 production, 3 DR and 8 DEV/SIT and UAT systems

Working with Retail banking, marketing, Home loans and Insurance, Anti-Money

Laundering DB systems.

Close monitoring of all systems using Viewpoint and addressing the issues with

application teams

Code reviews and deployments through CAB/ RFCs

Attempting the all other (grants/ ad-hoc) requests through Nexus, Maximo and

ITSM tools

Backup scheduling and restores (BAR) and monitoring through Netbackup TARA

GUI and mainframe tools.

Good in using Mainframe to analyze the ETL jobs, monitoring/create backup and

restore jobs, creating and casting endeavor packages for ETL teams. Stop and re-

initiate the TDPs during the maintenance window.

Creation and assign the roles through Mainframe panel.

Exposure in autosys scheduler

Provided solutions in code tuning

Access management

Creation of users and DBs through standard Stored procedures

Data copying to different environments through Data Mover

Environment/Data SQL synchronization using Teradata UNITY

Page 4

Supporting with Mainframe and Teradata system engineers during the Teradata

system maintenance

Worked on reviewing, converting semantic and logical data models to physical

data designs using ERWIN and ER/studio suites and provided better suggestions

and chosen the good index type for good data distribution.

3 Hadoop Admin Roles and Responsibilities:

Setup the new Hadoop users.

Cluster maintenance and creation/adding and removal of nodes using tools like

Ganglia, Nagios, and Cloudera Manager Enterprise.

Manage and review the Hadoop log files.

File system management and monitoring.

Collaborating with application teams to install operating system and Hadoop

updates, patches, version upgrades when required.

Transferred data from Teradata Database to Hadoop (HDFS) by using Sqoop.

Import & Export of tables/file using Sqoop

Performed commissioned and decommissioned of Data nodes based on the

requirement.

Good experience in install and configure cluster using Cloudera Manager.

Monitoring the Cluster using Cloudera Manager.

Hands on experience in analyzing Log files for Hadoop and eco system services and

finding the root cause.

Taking backup for metadata

File system management and monitoring

Cluster Monitoring and Troubleshooting

Installing and configuring Hadoop eco systems like sqoop, pig, flume, hive.

Optimizing performance of Hbase/Hive/Pig jobs

Hands on experience Nagios and Ganglia tool.

4 Project Details III

Project Name 1 GE HealthCare, DBA Support

Client GE HealthCare, WI, USA.

Teradata DBA

Role

Software Used TTU13.10

Location Milwaukee, Wisconsin (WI), USA

Duration June 2011 to March 2013

Team Size Project : 17

Roles and Responsibilities:

Extensive Experience in Teradata T13.10, T13, T12, V2R6 and V2R5.

Page 5

Expertise in Database Administration - Teradata EDW & Appliance

Good knowledge in Teradata Backups using ARC utility, Netbackup, Netvault and

TARA GUI tools.

Good exposure in using Oracle Golden Gate for Real-Time Data Integration

Monitoring the data loading logs and debugging the issues in Golden Gate

application source and target system, am done with Oracle to Teradata systems.

Installation of Golden Gate application

Prepared and executed test cases, using HP Quality Center tool, for database

activities like TD V13 upgrades, node expansion and backup enhancements etc.

Worked on reviewing, converting semantic and logical data models to physical

data designs using ERWIN and ER/studio suites and provided better suggestions

and chosen the good index type for good data distribution.

Closely worked with developers and BI Architects and project management teams for

better understanding of projects and flow of the data and reporting scenarios.

Perfect planning and co-ordination with Teradata support team and GEHC BI Teams,

in executing the pre and post upgrade/NPARC activities. Always ensured to

handover production system within the planned outage time.

Design and process preparation and execution of disaster recovery tests. Proper

planning and co-ordination with all BI Teams made the activity successful for every

quarter.

Involved in excellent planning of BI project review process checklists and provided

continuous feedback to program teams during all project lifecycle milestones which

helped GEHC BI projects to maintain quality, standards and improved performance.

Actively involved in GEHC SOX audits

Preparing implementation strategies for Teradata objects for production

enhancements

Identifying and tuning most resource consuming SQLs

Moving data using Data mover between the environments.

Creating profiles, roles and enabling the Query logging when required.

Profiling the Data for Column level Compression.

Managing the users and running the scripts for maintenance through Teradata

Viewpoint.

Monitoring the regular system performance and state using Viewpoint.

Maintain Teradata database Objects and Indices, Space, Users, Purge Jobs and

alerts associated with the Teradata environment.

Complete Teradata access requests (new users, password resets, password unlocks

and user deletion) as required, following agreed processes.

Security Administration - Maintain Teradata roles and profiles

Configuring and Monitoring of alerts, queries, locking logger, access locks and

database performance.

Apart from above, below is the highlighted work which carried through 7X24 services:

Page 6

Around 25 BI Major Project releases per quarter

Around 30 BI Minor project releases per quarter

Around 30 Performance tuning requests per quarter

Code deployments in different environments

1-2 Patch (TTU and Database) upgrades per year

New DR Setup and executions per year

Automation of scripts using Unix

Requirements gathering/verification during tech reviews, worked with BI Architects

and BI CEO's for the better understanding.

Good exposure in change management and SOX audit processes.

Tech refresh Design and Planning on quarterly basis

5 Project Details IV

1 Barclays Managed Services-DWS

Project Name

(Mahindra Satyam)

Client Barclays, UK

Role Performance Tuning Teradata DBA

Organization Mahindra Satyam, Hyderabad, INDIA

Software Used TTU12

Duration Jan -2010 May-2011

GRCB-T (Global Retail and Commercial Banking Technology), Barclays, UK:

Barclays Bank is one of the largest banks in UK, which currently operates out in many

countries across the globe. The business of Banking being so dynamic (say mergers,

acquisitions etc), the IT division of the organization needs to be always ready to cater for

any requirements. GRCB -T being one of such critical IT teams, which strive to provide the

business, data required for the better decision making.

Performance Tuning:

1) Query tuning:

Tune the long running queries raised by application teams.

Analyze DBQL tables data.

Generate weekly report which contains expensive queries (which are taking more system

Resources), and work on fixing those queries using query tuning techniques.

Prepare reports with tuning gains.

2) TASM settings through view point:

Define concurrency thresholds to load utilities.

Define rules and filters to stop run-away and bad queries.

Analyze TDWM tables to estimate the system capacity.

3) System level tuning:

Analyzing system capacity, and put new applications in weakly loaded window.

Page 7

Compare Q close details with previous Q close details and take necessary alterations.

Prepare reports with tuning gains.

4) Other scheduled performance tuning tasks:

Compressions -Single and Multi value compressions. Trying to implement ALC (Algorithmic

Compressions which has been introduced inV13).

Optimized collect stats process, implementing sample stats wherever feasible.

Implementation of Partitioned Primary Indexes on tables having size more than 30 GB.

Analyze Stored Procedures defined with Cursors in that, and provide corresponding

Recursive query which can replace Cursor usage in most of the cases.

5) Quarter close tuning activities:

AWT shortage: Most dangerous situation which makes the sessions into flow control.

6 Project Details V

Project AVIVA Life Insurance

Name

Client AVIVA / U.K (Norwich Union)

Role 7 Production database DBA

Organization TATA Consultancy Services

Location Offshore: Bangalore, INDIA

Duration May/2009Nov/2009

Team Size 3 Module : 1

Roles and Responsibilities:

Database Administration using Teradata Manager, Administrator, PMON and

Viewpoint.

Teradata Tools and Utilities (SQL Assistant, BTEQ, Fast load, Multi-load etc).

Data migration/copy between servers PROD to Dev/Test using NPARC

User Creation/Maintenance.

Environment Creation.

Database/View refreshes.

Implementation of MVC

Release Management/Deployments

SQL Code Review

Monitoring

Support and co-ordination during Hardware and patch upgrades.

View point Administration

Check Table; Pack Disk; PDCR Maintenance etc.,

TASM & Work load settings

Backup with TARA and Netbackup

Automation's/Tools Implemented using Shell Scripting:

Have automated many reports like Space summary, backup completion etc.

Also designed the Database refresh and view refresh tools (within same box) which

resulted in reduce of manual effort by 95%.

Page 8

Automated the Stale Statistics report/rerun resulting in overall system performance

improvement by doing periodic refreshes.

Setup Alerts mails and job completion mails, other automation for Supported

Application's

Developed Customized Alerts for identification of long running queries and active

sessions in System.

Developed a tool for Multi Value Compression.

8 Developed Alerts Based on the Explain Plan Containing Product Join

9 Project Details VI

Project Name 1 GE HealthCare, DBA Support (Wissen InfoTech)

Client GE HealthCare, WI, USA.

Role Team Member

Software Used TTU13.10

Location Offshore: Hyderabad, Andhra Pradesh, India

Duration June 2005 to May 2009

Team Size Project : 12

Role: Teradata Database Administrator Responsibilities

Extensive Experience in Teradata T13.10, T13, T12, V2R6 and V2R5.

Expertise in Database Administration - Teradata EDW & Appliance

Good knowledge in Teradata Backups using ARC utility, Netbackup, Netvault and

TARA GUI tools.

Prepared and executed test cases, using HP Quality Center tool, for database

activities like TD V13 upgrades, node expansion and backup enhancements etc.

Perfect planning and co-ordination with Teradata support team and GEHC BI Teams,

in executing the pre and post upgrade/NPARC(node expansion) activities. Always

ensured to handover production system within the planned outage time.

Design and process preparation and execution of disaster recovery tests. Proper

planning and co-ordination with all BI Teams made the activity successful for every

quarter.

Involved in excellent planning of BI project review process checklists and provided

continuous feedback to program teams during all project lifecycle milestones which

helped GEHC BI projects to maintain quality, standards and improved performance.

Actively involved in GEHC SOX audits

Preparing implementation strategies for Teradata objects for production

enhancements

Identifying and tuning most resource consuming SQLs

Moving data using Data mover between the environments.

Creating profiles, roles and enabling the Query logging when required.

Profiling the Data for Column level Compression.

Page 9

Managing the users and running the scripts for maintenance through Teradata

Viewpoint.

Monitoring the regular system performance and state using Viewpoint.

Maintain Teradata database Objects and Indices, Space, Users, Purge Jobs and

alerts associated with the Teradata environment.

Complete Teradata access requests (new users, password resets, password unlocks

and user deletion) as required, following agreed processes.

Security Administration - Maintain Teradata roles and profiles

Configuring and Monitoring of alerts, queries, locking logger, access locks and

database performance.

Page 10

Contact this candidate