Teradata DBA/Data Warehouse Solutions Architect

New York, NY 10001

Posted: 06/22/2016 Employment Type: Direct Hire Industry: Other Area(s) Job Number: 129 Pay Rate: 140,000

Job Description


The Data Warehouse Solutions Architect is responsible for all activities related to the database system administration, architecture, data modeling, design and development of the Teradata Data Warehouse environment. This individual will translate complex business requirements into scalable technical solutions, provide comprehensive technical expertise in database technologies, determine project scope, and liaise with hardware vendors, business analysts, system administrators, and BI/application developers. We are seeking a motivated self-starter who must be able to work well both independently and with a project team to coordinate database system and infrastructure development. 

Required Skills

  • Implement and maintain database security, create and maintain users/roles, and assign privileges.
  • Capacity planning for growth to support current and future needs.
  • Identify key thresholds and bottle necks which could impact system performance.
  • Optimize and performance tune queries.
  • Establish and maintain sound backup and disaster recovery policies and procedures.
  • Prepare detailed ETL specifications to design, code and test all SQL/BTEQ scripts and utilities.
  • Database design modeling and implementation to meet business objectives and the needs of BI/application enhancements and other project deliverables.
  • Project planning, estimating, approach definition and implementation planning.
  • Identify and recommend alternative solutions.
  • Maintain awareness of new developments in industry and processes.
  • Establish quality processes and standards to deliver stable and reliable solutions.
  • Participate in after-hours support rotation and perform duties in the data centers to support system upgrades or hardware problem resolutions.
  • Ability to install, configure and upgrade Teradata server hardware, software, and related products.

Required Experience

  • Minimum 5-7 years’ experience as a DBA or similar role working with Teradata databases.
  • Teradata Certified Master certification a plus.
  • UNIX shell scripting, Teradata utilities experience required.
  • System administration for AIX, Linux SuSe, and NCR MPRAS a plus.
  • MS/SQL Server, Oracle database knowledge a plus
  • Windows developer experience a plus.
  • C++, Java, VB, or .NET coding a plus.
  • Experience with MicroStrategy a plus.
  • CRM experience a plus.
  • ETL/ELT tool knowledge required.
  • Control-M job automation tool experience preferred.
  • Experience with retail environment is strongly preferred.
  • Bachelor' s degree in Information Systems, Computer Science or equivalent course work/job experience.

  • Advanced analytical and problem solving skills
  • Strong PC skills
  • Strong organizational, verbal and written communication skills
  • Superior customer service skills
  • Strong interpersonal skills
  • Team player
  • Attention to detail
  • Ability to interface with all levels of staff
  • Multi-tasking skills
  • Must be flexible and able to work in a fast-paced environment
  • Consistent delivery of results
  • Excellent data architect skills
  • Performance tuning of Teradata database systems
  • Perform database loads, backups and recoveries using Fastload, Multiload, ARC, NetVault, and NetBackup
  • Understanding of data modeling and use of modeling tools a plus, i.e. Erwin, Data Modeler


Meet Your Recruiter

Jason Destro

Over 20 years’ of recruiting experience with hands-on recruiting and placement of I.T. professionals (Full Time, Temp 2 Perm, & Contingent) in the NJ/NY/CT/PA marketplace for a wide variety of today's demanding IT skill sets. Focused on delivering exceptional service by understanding client’s objectives and goals.

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

Textbox Section