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