Support Manager
Resume:
ARINDAM PAIN
Contact: ***-813-***-**** ~ E-Mail: ***********@*****.***
Teradata DBA ASSIGNMENTS
DBA Project Management IT Management * Software Development
ABRIDGEMENT
A seasoned IT professional with over 20 years of commendable success as a Teradata Production DBA Support, Teradata Application DBA Support, Aster Production DBA Support, Solution Architect, Application Development, Implementation & Project Management.
Currently associated with Bank of America, USA as Senior Database Administrator.
Well versed with Teradata Database Administration, Aster Database Administration, DBA Automation Processes, Performance Tuning Workload Management, QueryGrid, Foreign Servers, Datamover and various Teradata Load and Unload Utilities.
Lead Datacenter Migration, Relocation and Reconsolidation Projects.
Data warehousing concepts, Backup Tools such as DSA Netbackup, NETVAULT, ARCMAIN, TIVOLLI using Tara-Gui
Worked on Teradata Querygrid with setup from T2T, T2A, T2H.
Successfully migrated data across databases from different platforms.
Migration experience of databases from Oracle to Teradata.
Develop ETL (Extract, Transform, Load) processes and tools needed to migrate for data migration.
Created Foreign Servers, Worked on Importing Data, Exporting Data, Joining Hadoop Tables with Teradata Tables.
Used the procedures HCTAS, HDROP. Used UseNativequalification feature.
Worked on ECA Performance and Tuning consideration for proper Workload Management.
Providing the required access and doing the necessary security configuration for the proper functioning of Querygrid.
A keen strategist, planner and implementer with expertise in devising strategies aimed at enhancing overall organizational growth, sustained profitability of operations and improved business performance.
Possess credibility & personal integrity that leaves lasting impression with corporate decision makers, motivates employees and generates loyalty.
In-depth expertise in all aspects of the SDLC including requirement analysis, design, development, testing, troubleshooting and debugging.
Strong collaboration, team building, interpersonal, communication skills with proficiency at grasping new technical concepts quickly & utilizing the same in a productive manner.
CAREER MILESTONES
A Teradata and Aster DBA Professional who has worked for the leading Banking Giants like Bank of America, Telecom Giants like AT&T, Verizon and Verizon Wireless and Retail Giants like Walmart Headquarters and Tesco.
Gained extensive exposure for several support issues related to Data warehouses worldwide (was trained in Teradata and Linux OS, at NCR San Diego office) at NCR Teradata offshore unit, for some of the very well-known global clients like SBC, Dell, Bank of America, etc.
Provided Teradata DBA Support for the World’s Largest Retail Datawarehouse Installation of Walmart Stores, Inc., Bentonville, Arkansas.
Recognized as Teradata DBA with about 14+ years of experience in Teradata DBA support activities while working as a Senior Database Administrator for Verizon Wireless and Senior Manager-DBA for the prestigious WALMART (World’s largest retail database) project of DBA support.
Played a pivotal role Project Manager – Teradata DBA in TESCO (2nd Largest retail in UK) and Level 3 support personnel along with Front-Line activities at NCR and Teradata Corporation.
Teradata Certified professional and has experience on Teradata and Aster RDBMS; extensively used Teradata Client Utilities, Teradata Foreign Servers along with Teradata Viewpoint and Workload management by using TASM.
EXPERIENCE CHRONOLOGY
Since Aug’18 with Bank of America as Senior Database Administrator
Oct’17-Aug’18 with Charter Communications as Senior Database Administrator
Jan’17-Sep’17 with AT&T as Senior Database Administrator
Jun’14-Dec’16 with Verizon Wireless as Senior Database Administrator
Jul’12-Jun’14 with Verizon as Senior Database Administrator
Jul’09-Jul’12 with Walmart as Senior Database Administrator
May’08-Jul’09 with Tesco as Project Manager
Apr’04-Apr’08 with Teradata Engineering & Services, Hyderabad as Software Engineer
Apr’03-Apr’04 with Data Access (I) Pvt. Ltd., New Delhi as Database Administrator
Mar’02-Apr’03 with CES (I) Pvt. Ltd., Lucknow as Developer
Jul’98-Mar’02 with Pentasoft Technologies Limited, Kolkata as Assistant Consultant
Oct’97-Jul’98 with LCC, Kolkata as Developer cum Faculty
KEY RESULT AREAS
* Project Management * Database Administration *Application Programming
* Relationship Management * Maintenance * Team Management
* SDLC * Software Analysis * Client Relationship Management
Project Management
Interacting with customer & team for requirement gathering, risk assessment, finalization of technical specifications.
Developing plans & schedules, resource allocations as per budgets, manpower deployment and team meetings for individual projects.
Interacting with team members to ensure smooth progress of project work.
SDLC
Interfacing with clients for business gathering, conducting system analysis and finalizing technical / functional specifications and high level design documents for the project.
Participating in design and coding of Software Applications; mapping requirements; participating in the finalization of product specifications and selection of appropriate techniques.
Conducting system study and coordinating with team members for system design & integration, application maintenance, etc.; contributing to the design, development, testing, troubleshooting and debugging of the software.
Database Administration
Create, maintain, and support Database architectural environment.
Devise strategy for Backups, recovery & fine-tuning.
Workload Management, Capacity Planning, user maintenance, database security imposition; performance analysis of application and database.
Relationship Management
Meet deadlines without compromising quality norms and adhering to SLA. Delivery Management & Post Implementation support.
Understand & co-ordinate client’s needs / enhancements, customization, software-related issues, provide solutions in adherence to delivery schedules.
Achieve customer satisfaction by ensuring service quality norms and building the brand image by exceeding the customer expectations.
NOTEWORTHY ACCOMPLISHMENTS
Lead a team of over 40 members.
Dexterously handling Teradata and Aster DBA activities for Verizon Wireless and Verizon.
Recognized for providing Teradata DBA Support for Walmart, as well as the visibility to the Management for all the DBA Towers (Consisting of 40+ Members) in the areas of Resource Position for all DBA Towers, Onsite and Offshore – situation / key issues / challenges, Billing Details for the week, Kudos / Evaluation of Kudos, Value Addition, Admin / IT issues, Weekly Report in the specified format, Nomination of DBA’s from various towers for Rewards & Recognition, Handling of operational issues, Driving the Governance Team for ITIL/20k Certification, etc.
Received Values Awards at Tesco.
Attained the Excellence Award for Exceptional Performance and Valuable Contribution at Collabera, Bangalore.
Awards / Appreciation Letters received:
Cash Reward under Special Skill Bonus from Collabera for handling complexities involved with highest degree of accountability.
Cash Reward under Key Associates Retention Scheme from Satyam for customer delight in meeting stakeholder obligation and achieving high performance levels.
SCHOLASTICS
B.Sc. from S.U., Rourkela in 1994.
PGDIM from CMC, Kolkata in 1997.
CIC from IGNOU, Kolkata IN 1998.
TECHNICAL SKILLS
Databases: Teradata, Aster
Other Databases: Oracle
Tools & Utilities: Teradata Viewpoint, TASM, QueryGrid, Foreign Servers, Datamover, Data Labs, Teradata Administrator, SQL Assistant, BTEQ, TDWallet, Fast Load, Mload, TPump, TPT, PDCR, TSET, Visual Explain, Autostats, Console, Ferret, LocksDisplay, DBS Control, CTL, Cnstool, DBS Control, Checktable, Query Session, Recovery Manager, Vproc Manager, Gateway Global.
Languages: SQL, PL/SQL, Unix/Linux Shell Scripting.
Backup Tools: DSA Netbackup, Netvault, Tivolli, Taragui, Arcmain, HP Openview, Legato
Replication: VDT, CDC.
ETL Tool: Informatica.
Operating System: UNIX (MP-RAS, Linux, Solaris, HP-UX), Windows
Hardware: NCR WorldMark 5250/5350/5450/5400/5500/6700/6800 Servers,
Teradata Appliance
Front-End Tools: PB, Developer2000/6.
Data Modelling Tools: S-Designer, Erwin, Designer2000
Technology: Datawarehousing
Business: Telecom, Retail
Additional Trainings: Received Training in Querygrid/SQL-H for Big Data Hadoop.
CERTIFICATIONS
Teradata Certified Professional from NCR University in 2004.
Custom-Unix to Linux/SLES10 – Teradata from Novell, USA in 2007.
Data Backup Practices and HP Storage Data Protector and Legato from ACE Data in 2003.
Training on Storage Device from EMC in 2003.
CIC (Certificate in Computing) from IGNOU, India in 1998.
Web Programming using JAVA from SSI in 2001.
Advanced Java and Web Technologies from SSI in 2001.
Job Oriented Certificate Course on Steel Making from BE College, Shibpur (Deemed University), Howrah, National Institute of Secondary Steel Technology, Sponsored by Department of Steel, Govt. of India in 1996.
PERSONAL DOSSIER
Address: Allen, TX.
Languages Known: English, Hindi, Bengali and Oriya
Passport & Visa Details
Passport No.: Z2292176
Visa: H1B Valid
ANNEXURE
Project Summary: -
Organization Bank of America
Title: Sr. Teradata DBA
Client: Bank of America
Location: Plano, TX.
Role: Senior Teradata Database Administrator
Period: Since Aug’18
Team Size: 12 members
Environment: Working on following Databases and Client tools:
Databases: Teradata 16.
Tools: Teradata Tools & Utilities, Teradata Viewpoint, TASM, PDCR,
Datamover
BAR: DSA Netbackup
Replication: VDT
O/s: Linux, Solaris, Windows
Hardware: Teradata Servers.
Description: Bank of America is one of the world's largest financial institutions, serving individual consumers, small- and middle-market businesses and large corporations with a full range of banking, investing, asset management and other financial and risk management products and services.
There are 4 Teradata Production Servers, 1 Teradata DR Server 1 Teradata Development Server, 1 Teradata UAT Server. As a Teradata DBA, numerous application databases are supported and automated.
Role: Accountable for DBA activities in Bank of America Datawarehouse Environment:
Be main contact for issue resolutions and be an efficient Teradata DBA.
Database Availability Monitoring and Health check.
Creation of DBA Automation Scripts and processes and Scheduling in Autosys Environment.
Creation of DBA Automation Stored Procedures.
Enhancement of Post Move Process which automatically collects stats, creates views, advances run date.
Deployment of Data mover job creation via Bitbucket.
Running system resource utilization reports
Resolve any Teradata Database related issues raised by business users and application teams via Nexus Ticketing System.
Workload Monitoring.
Live Monitoring of Teradata Servers by using Viewpoint.
Support the Developers and Business Users for database needs and guidance
Recommendation of PI changes to reduce skew factor of tables.
Recommendation of additional Stats, Indexes for better query performance.
Implementation of Profiles.
Disk space saving by implementation of MVC and BLC.
Creation of Backup and Restore/Copy Strategies.
Creation of new Service ID’s for Application/Batch after reviewing/optimizing Sql’s.
Setup access rights and space allocation for Teradata environment
Creation/Granting/Revoking of Roles, Privileges to Normal and Secured Databases.
Working with Access Category Entitlement, Privacy Protection of highly secured Banking Environment.
Create, maintain, and support Teradata architectural environment.
Setting up of Querygrid for access to Teradata and Hadoop.
Deployment of production processes through Remedy tickets.
Proactive Maintenance & Productivity improvement.
Sending of TSET info to Teradata GSC support via incidents for their in-house problem re-creation.
Interacting with GSC/GTS via T@YS to resolve issues.
Coordinating with TD CSR team, TD GSC team & internal prod-support teams to resolve issues.
Respond to change requests to create, change, or delete database objects (tables, views, indexes, DDL, DML, etc.) per client specifications.
Highlights: Developed DBA Automation Applications and Processes.
Organization Charter Communications
Title: Sr. Teradata DBA
Client: Charter Communications
Location: Charlotte, NC.
Role: Senior Database Administrator – Teradata
Period: Oct’17 – Aug’18
Team Size: 5 members
Environment: Working on following Databases and Client tools:
Databases: Teradata 14/15.
Tools: Teradata Tools & Utilities, Teradata Viewpoint, TASM, PDCR,
Data Labs., Datamover
BAR: DSA Netbackup
Replication: VDT
O/s: Linux, Solaris, Windows
Hardware: Teradata Servers.
Description: Charter Communications is an American telecommunications company, which offers its services to consumers and businesses under the branding of Spectrum. Providing services to over 25 million customers in 41 states, it is the second-largest cable operator in the United States by subscribers, just behind Comcast, and third largest pay TV operator behind Comcast and AT&T U-verse/DirecTV. It is the fifth largest telephone provider based upon residential subscriber line count.
Charter acquired Time Warner Cable and Bright House Networks for a combined $71.4 billion, making it the third-largest pay television service in the United States.
There are 6 Teradata Production Servers, 4 Teradata Development Server, 3 Teradata UAT Server. As a Teradata DBA numerous application databases was supported and automated.
Role: Accountable for DBA activities in Charter Communications Datawarehousing Environment:
Key Stakeholder Management
Provide visibility to support managers and concerned stakeholders
Present Project review report from time to time.
Migration, Reconsolidation and Relocation of Datacenters.
Be main contact for issue resolutions and be an efficient Lead DBA
Database Availability Monitoring and Health check.
Creation of DBA scripts, processes and automated reports for Housekeeping Tasks.
Resolve any Teradata Database related issues raised by business users and application teams.
Tweaking of TASM settings from time to time for optimum utilization of Teradata Servers.
Workload Monitoring.
Setting up of alerts, canary queries, etc.
Live Monitoring of Teradata Servers by using Viewpoint.
Support the Developers and Business Users for database needs and guidance
Resolution of various data load errors.
Recommendation of PI changes to reduce skew factor of tables.
Recommendation of additional Stats, Indexes for better query performance.
Implementation of Profiles.
Disk space saving by implementation of MVC and BLC.
Creation of Backup and Restore/Copy Strategies.
Creation of new Functional ID’s for Application/Batch after reviewing/optimizing Sql’s.
Creation/Granting/Revoking of Roles, Privileges to Normal and Secured Databases.
Be the main contact for issue resolutions and be an efficient Teradata DBA.
Installation/Upgradation of Aster on Commodity Servers.
Create, maintain, and support Teradata architectural environment.
Setting up of Querygrid for access to Teradata and Hadoop.
Support of production processes through Service-Now tickets.
Proactive Maintenance & Productivity improvement.
Sending of TSET info to Teradata GSC support via incidents for their in-house problem re-creation.
Respond to change requests to create, change, or delete database objects (tables, views, indexes, DDL, DML, etc.) per client specifications.
Highlights: Reconsolidation, Migration and Relocation of Datacenters.
Organization AT&T
Title: Teradata/Aster DBA
Client: AT&T
Location: Richardson, Tx.
Role: Senior Database Administrator – Teradata/Aster
Period: Jan’17 – Sep’17
Team Size: 6 members
Environment: Working on following Databases and Client tools:
Databases: Teradata 14/15, Aster 6.20
Tools: Teradata Tools & Utilities, Teradata Viewpoint, AMC,
BAR: Taragui, Netbackup
O/s: Linux, Solaris, Windows
Hardware: Teradata AEDW 6690/6800/5650/5500/2700 Servers,
Teradata Aster running on Commodity Hardware, Hadoop.
Description: At&t is a global leader in Communications, IT solutions, Information and Entertainment Services. There are 10 Teradata Production Servers, 2 Teradata Development Server, 1 Aster Production Server, 1 Aster Development Server and Hadoop. As a Teradata/Aster DBA numerous application databases was supported and automated.
Role: Accountable for DBA activities in AT&T Datawarehousing Environment:
Creation of DBA scripts, processes and automated reports for Housekeeping Tasks.
Resolve any Teradata/Aster Database related issues raised by business users and application teams.
Tweaking of TASM settings from time to time for optimum utilization of Teradata Servers.
Setting up of alerts, canary queries, etc.
Live Monitoring of Teradata/Aster Servers by using Viewpoint and AMC.
Support the Developers and Business Users for database needs and guidance
Resolution of various data load errors.
Recommendation of PI changes to reduce skew factor of tables.
Recommendation of additional Stats, Indexes for better query performance.
Implementation of Profiles.
Disk space saving by implementation of MVC and BLC.
Creation of Backup and Restore/Copy Strategies.
Creation of new Functional ID’s for Application/Batch after reviewing/optimizing Sql’s.
Creation/Granting/Revoking of Roles, Privileges to Normal and Secured Databases.
Be the main contact for issue resolutions and be an efficient Teradata/Aster DBA.
Installation/Upgradation of Aster on Commodity Servers.
Create, maintain, and support Teradata architectural environment.
Setting up of Querygrid for access to Teradata, Aster and Hadoop.
Support of production processes through tickets
Sending of TSET info to Teradata GSC support via incidents for their in-house problem re-creation.
Respond to change requests to create, change, or delete database objects (tables, views, indexes, DDL, DML, etc.) per client specifications.
Received Training on Teradata Unity.
Highlights: Creation of numerous DBA Scripts, Processes and Useful Reports.
Organization Verizon Wireless
Title: Teradata/Aster DBA
Client: Verizon Wireless
Location: Temple Terrace, FL
Role: Senior Database Administrator – Teradata/Aster
Period: Jun’14 – Dec’16
Team Size: 8 members
Environment: Working on following Databases and Client tools:
Databases: Teradata 13/14/15, Aster 6
Tools: Teradata Tools & Utilities, Teradata Viewpoint, QueryGrid, Foreign
Servers, TDWallet, TASM, MLOAD, FastLoad, TPT, Datamover, BTEQ,
Teradata Administrator, SQL Assistant, Teradata Viewpoint, TASM,
PDCR, Autostats, MVC and BLC.
BAR: Tivoli, Taragui
ETL: Informatica Powercenter
O/s: Unix, Solaris, Windows
Hardware: Teradata EDW 6800 Servers, Teradata Appliances,
Teradata Aster Big Analytics Appliances, Hadoop.
Description: Verizon is a global leader in Communications, IT solutions, Information and Entertainment Services. There are 7 Teradata Production Servers, 2 Teradata Development Server, 2 Aster Production Servers, 1 Aster Development Server and Hadoop. As a Teradata DBA numerous application databases was supported and automated.
Role: Accountable for DBA activities in Verizon Wireless Data warehouse Environment:
Creation of DBA scripts, processes and automated reports for Housekeeping Tasks.
Resolve any Teradata/Aster Database related issues raised by business users and application teams.
Tweaking of TASM settings from time to time for optimum utilization of Teradata Servers.
Implementation of QueryGrid and Foreign Servers.
Implementation of TDWallet.
Setting up of alerts, canary queries, etc.
Live Monitoring of Teradata Servers by using Viewpoint.
Support the Developers and Business Users for database needs and guidance
Resolution of various data load errors.
Recommendation of PI changes to reduce skew factor of tables.
Recommendation of additional Stats, Indexes for better query performance.
Implementation of Profiles.
Disk space saving by implementation of MVC and BLC.
Creation of Backup and Restore/Copy Strategies.
Creation of new Functional ID’s for Application/Batch after reviewing/optimizing Sql’s.
Creation/Granting/Revoking of Roles, Privileges to Normal and Secured Databases.
Be the main contact for issue resolutions and be an efficient Teradata/Aster DBA.
Create, maintain, and support Teradata architectural environment.
Setting up of Querygrid for access to Teradata, Aster and Hadoop.
Support of production processes through tickets
Sending of TSET info to Teradata GSC support via incidents for their in-house problem re-creation.
Respond to change requests to create, change, or delete database objects (tables, views, indexes, DDL, DML, etc.) per client specifications.
Highlights: Creation of numerous DBA Scripts, Processes and Useful Reports. Implementation of Foreign Servers, TDWallet. Provided performance tuning and process improvement recommendations from time to time. Significant Space savings by using MVC in production environment and block compression in non-production environment.
Organization Verizon
Title: Teradata/Aster DBA
Client: Verizon
Location: Temple Terrace, FL
Role: Senior Database Administrator – Teradata DBA
Period: Jul’12 – Jun’14
Team Size: 8 members
Environment: Working on following Databases and Client tools:
Databases: Teradata, Aster,
Other Databases: Oracle
Tools: Teradata Tools & Utilities, Teradata Viewpoint, PDCR,
TASM, MLOAD, FastLoad, TOAD, TOAD Data Modeller,
Embarcado.
BAR: Netvault
ETL: Informatica Powercenter 9.5.1
Replication/Data Sync:
IBM CDC Tool
O/s: Unix, Solaris, Windows
Hardware: NCR WorldMark 6700 Servers, Teradata Appliance,
Teradata Aster Big Analytics Appliances.
Description: Verizon is a global leader in Communications, IT solutions, Information and Entertainment Services. It has 2 Production Systems and 2 Development Systems. Verizon has migrated their Datawarehousing applications from various databases like Oracle and DB2 to Teradata to have a single version of truth. As a Teradata DBA Numerous application databases were migrated from Oracle which simultaneously had to be fine tuned and supported.
Role: Accountable for DBA activities in Verizon Data warehouse Environment:
Migration of various application databases from Oracle to Teradata.
Develop ETL (Extract, Transform, Load) processes and tools needed to migrate this data
Creation of data extraction scripts for Oracle.
Creation of Teradata Mload and FastLoad and Bteq scripts for Data Migration
Creation of Informatica Interfaces and mapping for Data Transfers.
Resolution of various data load errors.
Recommendation of PI changes to reduce skewing factor of tables.
Recommendation of additional Stats, Indexes for better query performance.
Implementation of Profiles.
Disk space saving by implementation of MVC and Block Compression restores.
Creation of Backup and Restore/Copy Strategies.
Creation of new Functional ID’s for Application/Batch after reviewing/optimizing Sql’s.
Creation/Granting/Revoking of Roles, Privileges to Normal and Secured Databases.
Be the main contact for issue resolutions and be an efficient Teradata DBA.
Create, maintain, and support Teradata architectural environment.
Setting up of alerts, canary queries, etc.
Creation of Macros; Space Management; Database Up-gradation and Migration Activities.
Upgradation and usage of PDCR.
Resolve any Teradata related issues raised by business users and application teams.
Support the application development teams for database needs and guidance
Support of production processes through tickets
Sending of TSET info to Teradata GSC support via incidents for their in-house problem re-creation.
Respond to change requests to create, change, or delete database objects (tables, views, indexes, DDL, DML, etc.) per client specifications.
Upgradation of servers and Patch Installation.
Received Training in SQL-H of Big Data Hadoop and Aster.
Highlights: Continuous Migration of Datawarehouse Application related databases from Oracle to Teradata within Fixed Time Frame apart along with Teradata DBA related activities. Provided performance tuning and process improvement recommendations from time to time. Significant Space savings by using MVC in production environment and block compression in non-production environment.
Organization Walmart
Title: Teradata DBA
Client: Walmart
Location: Bentonville, Arkansas/Bangalore, India
Role: Senior Manager – Teradata DBA
Period: Jul’09 – Jul’12
Team Size: 11 members
Environment: Working on following Database and Client tools:
Database: Teradata
Tools: Teradata Tools & Utilities, Teradata Viewpoint, TASM
BAR: Netvault
O/s: Linux, MP-RAS, Windows
Hardware: NCR WorldMark Servers
Description: Walmart has the world’s largest retail database whose size has crossed Petabyte. It has 8 Production Systems and 2 Development Systems.
Role: Accountable for DBA activities in Wal-Mart Data warehouse Environment:
Be the main contact for issue resolutions and be an efficient Lead DBA.
Create, maintain, and support Teradata architectural environment.
Migration of various application databases across servers for load balancing.
Query Tuning which resulted in significant CPU savings which goes as quarterly reports to upper management equated as Dollar Savings.
Creation of new DBC ID’s for Application/Batch after reviewing/optimizing Sql’s
Grant/Revoke of Additional Roles, Privileges to Normal and Secured Databases.
Monitoring and maintenance through Teradata Viewpoint.
Using Teradata Manager to set alerts, canary queries, etc.
Creation of Macros; Space Management; Database Up-gradation and Migration Activities.
Resolve any Teradata related issues raised by business users and application teams.
Support the application development teams for database needs and guidance
Support of production processes through Remedy tickets
Respond to change requests to create, change, or delete database objects (tables, views, indexes, DDL, DML, etc.) per client specifications.
On-call support
Provide Level 2 & 3 support
Highlights: Performed Query Tuning resulting in significant CPU cycles and spool space savings. Provided TASM recommendations from time to time for efficient workload management. Identified and rectified incorrect database permissions provided to a large number of users. Planned, prepared and executed Change Controls. Successfully upgraded to v13 and also migrated various applications related to various countries across different Teradata Systems.
Organization TESCO
Title: Teradata DBA
Client: TESCO HSC
Location: Bangalore, India.
Role: Project Manager - Teradata Lead DBA
Period: May’08—Jul’09
Team Size: 4 members
Environment: Working on following Database and Client tools:
Database: Teradata
Tools: Teradata Client Tools & Utilities, Teradata Manager, TASM
BAR: Netvault
O/s: Linux, MP-RAS, Windows
Hardware: NCR WorldMark 5250/5350/5450/5400/5500 Servers.
Description: Tesco has 4 Production Systems and 1 Development box and has implemented Netvault Backup with SL8500 Tape Library. Master box comprises 12*5500 nodes at SDC (Master DW for source data loading, analytic and ad hoc queries), Cheshunt box comprises of 28 * 5400 nodes at CDC(Cheshunt Box is used for Group countries application), Reporting box comprises of 12 nodes in which 6*5250 and 6*5350 nodes(Reporting applications use aggregate data derived from a master. New Master Box comprises of 16 nodes which separates the fixed report queries (DW Reporting) from the variable ad-hoc queries (DW Master) has proved to be the best way to guarantee on-line performance for report users). Development Box consists of 12 Nodes.
Role: Played a vital role as Project Manager - Teradata Lead DBA in Tesco:
Key Stakeholder Management
Provide visibility to support managers and concerned stakeholders
Suggest and Implement Service Improvement Plans from time to time
Present Project review report from time to time
Be main contact for issue resolutions and be an efficient Lead DBA
Create, maintain, and support Teradata architectural environment
Administration of production objects in change control environment
Development of pro-active processes for monitoring capacity and performance
Frequent MVC analysis for space saving.
Using Teradata Manager to set alerts, canary queries, etc.
Support of production processes such as P1,P2,P3 tickets
Space administration. Ensuring that the disk space is effectively utilized.
Database security administration.
Database Backup, Archival & Restore using Netvault.
Coordinating with Teradata GSC for upgrades, patch installation, etc.
Weekly meetings with the Client and the dedicated GSC personnel.
Running utilities like checktable, scandisk, etc
On-call support
Provide Level 2 & 3 support
Highlights: Implementation of TASM and DBA Best Practices. Implemented many useful Teradata alerts, MVC, Capacity Planning Reports, Automatic Stats Collection Procedure, etc. Planned and executed successfully Migration and Up-gradation Activities. Implemented Incremental, Clustered and Partitioned Backup strategy apart from normal Database backup by using Netvault. Successfully migrated from L700 to SL8500 Tape Library. Successfully Upgraded and Migrated to Teradata Higher Versions.
Organization Teradata India Pvt. Ltd.
Title: NCR Teradata Global Support Centre
Client: Teradata Global Customers.
Location: San Diego, CA / Hyderabad, India
Role:
Contact this candidate