TERADATA DBA Resume Cleveland, Ohio - Hire IT People

PROFESSIONAL SUMMARY:

I have around 15.5 years of work experience in the IT industry.
Designing, development, DBA activities involving Teradata and designing, developing and supporting end - to-end features in Teradata Database Administration namely -
Database Securities (Via roles, LDAP, Default)
Expert in Query Tuning related to Spool space error, simplifying long running queries and many others.
My strength is Performance Tuning of system and queries.
Teradata AWT and VPROC analysis.
Teradata integration with Protegrity for data protection.
Database Failover/Failback (Entire planning and execution)
Installations of Database patches and TTUs, Troubleshooting.
Database Object backup and recovery using Teradata DSA.
Performance Tuning of database using Viewpoint portlets.
Automated Release management with Teradata using DevOps.
Troubleshooting database issues and resolving alongside TAYS.
Database Object, space management.
Object Compression using MVC and other compression methods.
Data mart setup within Database.
Experience in Teradata Datalabs.
Expertise in Teradata Datamover.
DevOps (uDeploy) integration with Teradata.
One of my area of strength is Performance Tuning of Teradata queries, improving overall batch processing, tuning around job scheduling.
Performance Tuning involved PDCR data analysis, Viewpoint data analysis, batch job scheduling analysis and sometime rewriting queries along with statistics modification.
Have good experience in Teradata DBA activities like database maintenance activities
Performance Tuning, Teradata user and database creations.
Analyzing and tuning complex queries.
Full scale database objects management.
Creating and managing user accounts.
Prepared scripts for monitoring the system.
Installed Teradata drivers for the Teradata utilities. Refreshed the data by using fast export and fastload utilities.
Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.
Good understanding and hands on knowledge of Teradata Data Mover, Teradata Wallet
Good knowledge on installing, supporting and problem solving of various Teradata utilities on WINDOWS and Linux platforms.
Extensively worked in Teradata DBA activities like: Teradata migration from other databases, I have worked along very closely with Enterprise ETL team, Data Scientist group, Data Analysts and solving various performance, connectivity and installation related issue.
Hands on expertise on DBS installation / upgrading / maintenance, Creating Teradata Users, Teradata Database capacity planning.
Lead the teams in the usage of mostly all the Teradata Utilities like Fastload, Multiload, Tpump, BTEQ, FastExport. Teradata monitoring using Teradata Viewpoint.
Worked extensively in C, C++, Shell Scripting, Unix Internals, Teradata and well versed with other RDBMS like Oracle.
Strong in developing tools and system applications using Unix Internals. Worked on Windows NT, 95, CE, SUSE Linux.
Worked extensively in Teradata Manager, PDCR, BTEQ, TDADMIN, VIEWPOINT, DATA MOVER, TERADATA STATS MANAGER, Teradata RDBMS, SQL, Teradata Data Modeling, Teradata Client on SUSE Linux.

SKILL:

TERADATA VIEWPOINT, STUDIO, ADMINISTRATOR, ATANA SUITE
FASTLOAD, MULTILOAD, TPUMP, TERADATA PL/SQL, BTEQ
UDeploy/GIT
Unity Data Mover
Informatica
Oracle
SUSE Linux

WORK EXPERIENCE:

TERADATA DBA

Confidential, Cleveland, Ohio

Responsibilities:

Teradata Performance Improvement for queries and database
Database securities
Teradata VIEWPOINT
Teradata Workload Management
Automated release management in Teradata
ATANA Suite
Database backup and recovery.
Teradata Unity Data Mover.
In depth knowledge of Teradata PDCR/DBC metadata to analyze query performance
Teradata shell scripting.

Tools: Teradata Viewpoint, Teradata Studio, Teradata Administrator, ATANA SUITE, Automated Release management tool, Unity Data Mover, Teradata Statistics manager.

Data Analyst

Confidential

Responsibilities:

As a data analyst I performed the following activities -
Participated in building an inhouse tool to validate data lineage across the enterprise.
Data analysis and report preparation of Banking data.
BASEL analyst.

Tools: Inhouse tool, Oracle Toad

Informatica Development and Support

Confidential, Cleveland, Ohio

Tools: Informatica/Linux/Oracle/Appfluent support, Informatica, Oracle, Linux.

Informatica, Mainframe Development

Confidential

Tools: Informatica, Mainframe, Oracle

Mainframe, AS/400 Development

Confidential

Tools: Mainframe, AS/400, DB2, COBOL, JCL

We provide IT Staff Augmentation Services!

Teradata Dba Resume

Cleveland, OhiO

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship