Space Management 1 2
Resume:
Mani M Atkuri Sr. Teradata DBA
Phone: 314-***-**** Email: mani.atkuri @gmail.com
PROFESSIONAL SUMMARY
Over 14+ years of IT experience in Analysis, Design, Modeling, Development, Administration, Implementation and Tuning.
Have experience in using Teradata SQL Assistant, Teradata Studio, Teradata Administrator, Viewpoint, DSA, TARA, Querygrid, Datamover and data load/unload utilities like BTEQ, FastLoad, MultiLoad, FastExport, TDAM-Kafka.
Developed procedures and processes to manage user creation, database physical implementation, space management, utility logging report, performance monitoring, and workload analysis.
Extensively worked in Teradata DBA activities like: Archive/Recovery, DBS maintenance,
hardware and software upgrades, TASM setup and monitoring, Creating Teradata Users,
databases, performance tuning queries.
Worked on dual active data Warehouses with database sizes up to petabyte.
SME in setting up datamover DSA, Querygrid configurations.
Enabled Security features like TLS 1.2, retention locks on Backup images.
Provided performance tuning and physical and logical database design support in projects for Teradata systems.
Extensively worked on design and testing Dell RI vantage VMware.
Good Experience on migrating and setting Vantage Cloud enterprise on Azure.
Participated in peer testing Vantage cloud lake enterprise on Azure (beta).
Tested and implemented NOS to write and read data from S3 object store.
TECHNICAL SKILLS
Operating Systems
Unix, Windows XP, Windows 2000, Windows NT 4.0.
Databases
Teradata V17.10, V16.20, V16,V15.10/V15/V14/V13.10/ V12.
Teradata Tools
Query Facilities: Queryman, BTEQ, Teradata Studio.
Load & Export: FastLoad, Mload, FastExport.
Archiving: ARC, DSA, Datamover
Teradata Manager, Visual Explain, Teradata Viewpoint, TASM.
Querygrid, Teradata Vantage, Kafka Access module, Azure blob, NOS
ETL and Other Tools
Datastage, Informatica, SAS, Microstrategy, Cognos, Dremio.
Data Modeling
Erwin.
Microsoft Technologies
C#, VB.Net,VB6.0
Languages
C, C++, SQL, PL/SQL.
Duration : Sept 2021 to Current
Client : Dell technologies, Florida
Role : Senior Teradata DBA
Responsibilities:
Engineering team performed POC on new features and SME support for any issues.
Participate in the design and development of a technical architecture that will be aligned with the client’s business objectives.
Responsible for providing an assisting user to extract data from Teradata to various sources.
Involved in workload balancing through TASM.
Explored new features with V17.10.
Worked on Upgrades like SLES12, TD 17.10.
Extensively worked on enabling NOS feature and worked with engineering teams to resolve network bottlenecks.
Capacity buy back effort reduced 1 million tcore per year.
Worked on enabling Data duplication from primary data domain to secondary Data domain.
Deliver new and complex high-quality solutions to clients in response to varying business requirements and Creating and managing user accounts.
Extensively worked on Hardware expansion (added 5 cabinets) and VMware expansion.
Worked on Teradata VantageAzure cloud enterprise setup and hybrid cloud.
Good understanding with cloud concepts, setting up vnet peering, express route, opening firewall ports and static routing.
Worked on setting up and did performance testing on Dell RI VMware.
SME in configuring LDAP, TLS, DM, DSA, Querygrid, TASM.
Environment: SLES 11, 12 and 15, Veritas Netbackup 8.1, Teradata 16.20,17.10, DSA 17.20, DM 17.12, QG 2.19.
Duration : February 2013 to Sept 2021
Client : United Healthcare/Optum Services, Reston VA
Role : Senior Teradata DBA
Responsibilities:
Worked on TARA and DSA to take the backups.
As Teradata DBA, responsible for maintaining all DBA functions (development, test, production) on three platforms in operation 24x7.
Setup core process required to source new data streams into Teradata data mart
Participate in the design and development of a technical architecture that will be aligned with the client’s business objectives.
Responsible for providing the best Teradata Datastage Loading strategies for ETL processing of getting data into Data mart.
Involved in workload balancing through TASM.
Tested new features of different Compression introduced with V15.10
Performed database health checks and tuned the databases using Teradata Manager.
With the in-depth expertise in the Teradata cost-based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI/USI/NUSI/JI) etc. In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance.
Analyzing sessions with for high spool usage, high CPU usage, high disk usage, and high skew etc., when alerts are received.
Setup DR environment and have used DM DSA/QG to perform data syncup.
Use of all database administration tools to analyze system status/performance.
Analyze explains/statistics/diagnostics to isolate SQL problems.
Teradata SQL, OLAP functions, and Load/Unload utilities
Deliver new and complex high-quality solutions to clients in response to varying business requirements and Creating and managing user accounts.
Installed Teradata drivers for the teradata utilities on Windows/Linux/AIX.
Refreshed the data by using fastexport and fastload utilities.
Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.
Extensively worked on Hardware upgrade, Software upgrade, Backup hardware upgrade from TARA to DSA.
Working as an On-Site Teradata Lead DBA, doing DBA activities that are Implementation of data and table-level security, setting up access rights and space rights for Teradata environment. Performance tuning, Monitoring and reporting Review system utilization by user
Environment: HP Unix 11.11, IBM PC/Windows XP Professional, BRIO, Veritas Netbackup 3.4, Netvault 6.5, Teradata V12/V14/V15/V15.10,16,16.10, TARA, DSA, ERWIN 3.5.2, Informatica powercenter 7.1
Duration : January 2011 to February 2013
Client : United Healthcare/Optum Services, St Louis MO
Role : Teradata DBA
Responsibilities:
As Teradata DBA, responsible for maintaining all DBA functions (development, test, production) on three platforms in operation 24x7. Platforms included 2580, 6 node for production, 2node for development and testing, 6650 2+1 node with TD V14.
Setup core process required to source new data streams into Teradata data mart.
Configured Netback up Technology to take Teradata Database backups.
Participate in the design and development of a technical architecture that will be aligned with the client’s business objectives.
Responsible for providing the best Teradata Data stage Loading strategies for ETL processing of getting data into Data mart.
Involved in workload balancing through TASM.
Worked on new features of different Compression introduced with V13.10. (Multivalve, Algorithmic, Block Level).
Explored New features like Trusted Sessions, Temporal, and Virtual Storage.
Performed query optimization and assisted ETL developers and users by analyzing DBQL data, explain plan and join strategy and Partitioning large tables to improve performance of SQLs.
Performed database health checks and tuned the databases using Teradata Manager.
With the in-depth expertise in the Teradata cost-based query optimizer, identified potential bottlenecks with queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics, physical design considerations (PI/USI/NUSI/JI etc) etc. In-depth knowledge of Teradata Explain and Visual Explain to analyze and improve query performance.
Multiload, BTEQ, created & modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc.
Worked on creating and managing the partitions.
Deliver new and complex high-quality solutions to clients in response to varying business requirements and Creating and managing user accounts.
Installed Teradata drivers for the Teradata utilities.
Analyze explains/statistics/diagnostics to isolate SQL problems.
Teradata SQL, OLAP functions, and Load/Unload utilities
Perform report development, MSTR architecture work, and interaction with business, SMEs and client MSTR team, perform requirements-gathering and translate to technical requirements, document requirements/design.
Did performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations.
Worked on Teradata Viewpoint to monitor queries and space usages issues.
Performed DBA support of multiple Teradata systems using SQL ASSISTANT, TERADATA MANAGER, and PMON.
Performance tuning, Monitoring and reporting Review system utilization by user.
Environment: TD 12/13, Teradata Viewpoint, Teradata Administrator, Teradata SQL Assistant, Teradata Manager, PMON, Teradata Arc main, Informatica 8x, Cognos, UNIX, Viewpoint, MLOAD, TPIMP, FAST LOAD, FAST EXPORT.
Contact this candidate