Teradata DBA

360 IT Professionals; Pittsburgh (Allegheny County); On-site; Full time

Benefits offered by this job

Group health insurance

Job summary

A prominent IT staffing agency in the United States is seeking a .Net Application Developer to work with a transit agency. The role involves creating and developing database models, supporting application staff, and training developers. Candidates must have at least 3 years of experience in application databases, proficient SQL skills, and be a U.S. citizen. Preferred qualifications include a Bachelor's degree in computer science and experience with Teradata and Linux. The position offers group health insurance and requires passing drug and background screening.

Qualifications

• At least 3 years of related experience in Application Databases.
• Experience with SQL and Teradata utilities.
• U.S. citizenship required.

Responsibilities

• Create and review physical and logical data models.
• Provide support for application and business areas.
• Assist in technology training for application developers.

Skills

Proficient SQL

Troubleshooting skills

Linux system administration

Education

High School Diploma or equivalent

Bachelor’s degree in computer science or related discipline

Tools

Teradata

Hadoop

Job 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

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 a Teradata 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:
• Service Manager.
• 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

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