Teradata DBA

Location: Pittsburgh, PA, us

Company Description

We are focused on imparting effective business staffing services through high level cost effective solutions. We have a strong foundation built on legacy and emerging technologies, including excellent track record of on-time delivery. We are leaders in providing additional custom IT Services with a proficient approach towards development of emerging mobile-based applications and web based application development. We are emerging as one of the largest private talent sourcing and management firms in the US.

Our client- one of the transit agency seeks an accomplished .Net (Web and Mobile) Application Developer

Job Description

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).

Qualifications

Teradata Database Administration

Additional Information

I would love to talk to you if you think this position suits your interest.

If you are looking for rewarding employment and a company that puts its employees first, we would like to work with you. We also offer group health insurance.

NOTE: “Candidates that are offered a position are required to pass pre-employment drug and background screening”