I hope the day is treating you well.

Kindly go through the below requirement and let me know your thoughts.

*Title: Teradata DBA *

*Location: San Jose, CA  Duration: 6 months with possible extensions*

MUST be Green Card or US Citizens: Do NOT send EAD GC, H1, TN Visa, etc…

Only Candidates.


*Provide consulting to Teradata customers on how to effectively: *

• Develop standards and procedures for the Teradata DBMS environment

• Design the database

• Plan database capacity

• Participate in the design of hardware and software management processes

• Implement/maintain database user roles, security, and permissions

• Implement /maintain database system security and diagnostics

• Maintain distributed database management and control

• Monitor database performance and identification of issues/errors

• Interface with SQL developers for performance and data access

• Interface with Teradata Customer Service support personnel

*Minimum Requirements: *

The consultant must have a Bachelor’s Degree in Computer Science or related
discipline or foreign equivalent with three to five years of progressive
post-baccalaureate work experience. This experience must include
Application DBA experience and responsibilities in a large Teradata
database environment either as a customer or as a consultant. In addition,
the resource must have current certification in Teradata Basics and
Teradata Database Administration or have an equivalent level of experience
in this role. The consultant must be able to work on their own with very
limited expert level support.

*Basic Qualifications: *

*The consultant needs to be able to provide the following technical
capabilities: *

·         Lead in development of DBA standards and guidelines and develop
UDF scripts

·         Work with DDL generators/development tools for handling DDL for
volumes of tables macros and views, ETL data cleansing design and code,
tools for data movement, and maintain change control during development

·         Knowledge of various types of languages and tools such as SQL,
C++, stored procedures, macros, and ETL.

·         Generation and maintenance of reports for Perm space usage trend

·         Design and implementation of reports to monitor system usage and
growth trends

·         Development of system resource and usage reports for management
including capacity calculation spreadsheets (for performance and capacity)

·         Data definition maintenance utilities and administration

·         Development of standard userid, role profile, development of
security access rights, code maintenance macros, code stored procedures for
maintenance of users access rights

·         Understanding of access rights and implications in hierarchy of
roles profiles and rights (Understand the 3 types of access rights and how
they are acquired)

·         PDCR knowledge and how to load various spreadsheet data using OLE
load, or TPT, Macro level performance tuning

·         Good understanding of parallel specific concepts

·         Identification of individual running performance issues:

·         Monitor - Viewpoint, use of TSET, index wizard, other tools for

·         Ability to track running performance issues thru Viewpoint,
identify hot amps, On-the-Fly complex recovery of data via B/R

·         Understand dynamic explains and track through optimizer steps

·         Watch spool space per amp and look for spikes

·         Identify and resolve many to many joins, know different types of
change data capture, temporal issues

·         Work with Teradata Customer Services on Database fixes and

*Preferred Qualifications: *

A Masters degree in computer science is highly desirable as well as current
Teradata Certification in Physical Database design, Teradata SQL and a
Teradata Masters Certification.

*Specific preferred technical expertise includes: *

·         TASM including identification and prioritization of workloads

·         Experience with translating logical models and other schemas to
optimize Teradata physical models

·         Semantic view and table layer development

·         Access Layer development

·         Understand business terms and ability to understand relationships
in the data model

·         Understand of physical table relationships, and ability to
architect for data transformation

·         Experience with Active or Dual Active environments

·         Experience with Data Mover

·         Experience in Host software (MVS, VM, etc.)

·         Unix/Linux OS expertise

·         Experience with other Relational databases such as Oracle, DB2,
and Sybase

·         Experience advising developers and development teams from design
through build phase

·         Willingness to relocate for a long project

*:: Thanks & Regards ::*


*Ravi Prakash | IT Recruiter | Pull Skill Technologies Inc. *

*Desk: 201.497.1010 X 105 | Fax: 201.256.6124*

*New Jersey | Illinois |www.pullskill.com <www.pullskill.com> |
r...@pullskill.com <n...@pullskill.com>    *

You received this message because you are subscribed to the Google Groups 
"Resumes" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to resumes+unsubscr...@googlegroups.com.
To post to this group, send email to resumes@googlegroups.com.
Visit this group at http://groups.google.com/group/resumes.
For more options, visit https://groups.google.com/d/optout.

Reply via email to