Roy Prasad

About

I'm a Teradata Database Administrator providing services to administer, maintain and control the Data Warehouse including the Teradata database, the operating system and tools. Self-motivated individual with good communication skills with a consistent track record of meeting commitments and delivering quality results.

Experience

Infosys

Mar 2019 – Jun 2021

Irving, TX

Teradata DBA

• Provide Database Administration for large (900 TB) Teradata Enterprise Data Warehouse • Monitor CPU/IO and AWT usage. Investigate High CPU/IO usage • View query plans for any tuning opportunity • Respond to viewpoint alerts. • Provide support to the application teams. • Monitor Table Stats Jobs and update as required. • Review and respond to PDCR Reports

TCS

Mar 2016 – Mar 2019

Irving, TX

Teradata DBA

• Monitor Table Stats Jobs and update as required. • Review and respond to PDCR Reports • Administer Security • Adjust TASM Settings and respond to TASM alerts • Backup and Recoveries • Provide application support • Identify and implement table compression • Suggest Primary Index changes for skewed table & PPI suggestions for performance enhancement. • Identify and delete obsolete secondary indexes. • Work with Teradata Utilities

Education

California State University Northridge

Mar 1978 – Mar 1980

Bachelor of Science, Business Information Systems

Skills