Teradata DBA

Ktek Resourcing LLC; Phoenix (AZ); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading data solutions company in Phoenix, Arizona, seeks an experienced Database Administrator proficient in Teradata. Responsibilities include maintaining databases, monitoring performance, and supporting application teams. The ideal candidate will have 7-9 years of experience, particularly with large databases and a solid understanding of database lifecycle management. Strong communication and leadership skills are required. This role offers the chance to handle critical database administration tasks in a dynamic environment.

Qualifications

• 7-9 years of hands-on experience with Teradata database administration.
• Experience in partitioning, indexing, and data models.
• Solid skills in managing database lifecycle, builds, and recovery.

Responsibilities

• Maintain and support required databases/instances.
• Monitor incident ticket queue and resolve issues within SLAs.
• Provide daily development support for application teams.

Skills

Teradata database administration

Database lifecycle management

Linux (Redhat or SUSE)

Strong communication skills

Job description

• Key Responsibilities include, but are not limited to:

• Maintain and support databases/instances required by application
• Monitor incident ticket queue and resolve database incidents within SLAs
• Monitor backup results and resolve/troubleshoot failed database backups
• Provide daily development support to application teams including database connectivity, configuration (index creation, database layout, schema changes) and Data migration
• Monitor database and server performance and identify current and potential bottlenecks
• Provide performance monitoring during all phases of the Application’s development lifecycle
• Responsible for troubleshooting Database issues including collecting information through traces and other logging facilities
• Provide database and SQL Tuning expertise through recommendation to application developers, vendors and other core Application teams
• Provide Database configuration for optimal performance including Database Partitioning
• Review and support installations of database maintenance and security patches and upgrade to supported release levels

Qualifications

Qualifications:

• 7-9 Years of hands‑on experience with Teradata database administration experience handling big size databases, providing support to EDW applications and databases
• Experience in the use of Partitioning and indexing and Data models
• Solid and proven skills in managing database lifecycle – builds, patching, backup and recovery
• Experience with Linux (Redhat or SUSE), Solaris and Unix AIX is desired
• Demonstrated use of scripting, Stored Procedures, Triggers, Cursors, Logins and Views
• Results oriented, willing to take responsibility and accept accountability for action
• Strong communication and leadership skills with the demonstrated ability to lead and influence technical professionals across the enterprise
• Comfortable with ambiguity as needs change on a regular basis with a high degree of initiative and sense of urgency
• Excellent oral and written skills with the ability to interact with senior management, technical subject matter experts, and business customers are essential in this role
• Ability to work on multiple initiatives and projects simultaneously
• Ability to operate in a support role, assuming on call responsibilities