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 Teradata 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
• (Embarcadero Tool) for creation of physical data model
• Worked with Fortune Global 500 companies like Confidential, Confidential, Confidential and Confidential 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 into Hadoop Big Data Administration.
• Transferred data from Teradata Database to Hadoop (HDFS) by using Sqoop.

TECHNICAL SKILLS

PRIMARY SKILL CATEGORY: Teradata

SECONDARY SKILL CATEGORY: Oracle, Informatica, Business Objects, OBIEE and COGNOS, SAS and Golden Gate

TRAINED SKILLS: Teradata, Oracle, Hadoop Bigdata and Mainframe

OPTIONAL DOMAIN SKILLS: Banking and Financial, HealthCare, Insurance and Manufacturing and entertainment

PROFESSIONAL EXPERIENCE

Confidential

Sr. Teradata Database Administrator (DBA)

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 Replicat’s.
• Monitor the replicats and resolve the GG issues
• Complete setup of new replicats for new tables setup at target side
• Coordinated with BI architects, managers and application development teams during the code reviews and deployments.
• Expertise in NTA analysis and work with Teradata CSR’s 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
• Software UsedTTU 14.10 and 15

Confidential

Sr. Teradata Database Administrator (DBA) / Hadoop Administrator

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/ RFC’s
• 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 auto-sys scheduler
• Provided solutions in code tuning
• Access management
• Creation of users and DB’s through standard Stored procedures
• Data copying to different environments through Data Mover
• Environment/Data SQL synchronization using Teradata UNITY
• 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
• Software UsedTTU13.10 and 14.10
• ER/studio suites and provided better suggestions and chosen the good index type for good data distribution.
• 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.
• Hands on experience Nagios and Ganglia tool.

Confidential

Teradata Database Administrator (DBA)

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.
• 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.
• Software UsedTTU13.10
• Apart from above, below is the highlighted work which carried through 24X7 services:
• 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

Confidential

Teradata Database Administrator (DBA)

Responsibilities:

• Confidential 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:
• 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.
• 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.
• System level tuning:
• Analyzing system capacity, and put new applications in weakly loaded window.
• Compare Q close details with previous Q close details and take necessary alterations.
• Prepare reports with tuning gains.
• Other scheduled performance tuning tasks:
• Compressions -Single and Multi value compressions. Trying to implement ALC (Algorithmic
• Compressions which have 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.
• Quarter close tuning activities:
• AWT shortage: Most dangerous situation which makes the sessions into flow control.

Confidential

Teradata Production Database Administrator (DBA)

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%.
• 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.
• Developed Alerts Based on the Explain Plan Containing Product Join

Confidential

Teradata Database Administrator (DBA)

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.
• 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.