Teradata DBA

Role: Teradata DBA
Location: Pittsburgh, PA
Duration: 6 months Contract-To-Hire

ESSENTIAL RESPONSIBILITIES:

• Create, develop, and review the physical model created from the logical model, ensuring that the detailed physical design of data structures and databases complies with standards, guidelines, and procedures recommended for all aspects of data modeling, database design, and maintenance. Provide support for application staff and business areas regarding database implementations, which could include a customized in-house database and/or a third party application package. Establish automated monitoring mechanism for space and database availability conditions. Establish best practices for database and application high availability through the use of third-party technologies and through the exploitation of various database features.

• Assist in identifying, developing, and providing technology training to the application developers of the organization (formal and informal). Participate in staff training opportunities (formal and informal) relative to rules, procedures, and standards for the access and maintenance of shared data resources.

MINIMUM QUALIFICATIONS:

·High School Diploma or equivalent.

·Must possess at least 3 years of related, progressive experience in Application Databases

·Experience using proficient SQL

·Incumbent who fills this position must be a US citizen, and must also pass a background check.

PREFERRED QUALIFICATIONS:

·Bachelor’s degree in computer science or a related discipline.

·Three (3) years’ experience as aTeradata DBA.

·Design and definition of database objects.

·Experience with the implementation of an application backup/recovery plan.

·General understanding of Database Query Log and Performance Data Capture Repository.

·Experience in Linux system administration tasks and shell scripting.

·Knowledge of Hadoop.

·Strong troubleshooting and problem determination skills.

·Experience with more than one database environment and one or more of the following qualifications:

o Service Manager.

o Unix/Linux scripting.

o CA/Erwin data modelling software.

·Experience designing Databases with high availability, high volume and high performance requirements considered a plus.

·General understanding of Teradata Utilities including (BTEQ, FastExport, FastLoad, Multiload, Teradata Parallel Transporter, and Teradata Wallet).