Data Base Analyst (DBA)

Location: Union, NJ
Date Posted: 09-12-2018
DBA - Terradata

We have an opening for a Terradata DBA to work at our client site in Union, N.J.  This is a full time salaried position (hourly contractors will be considered).  For salaried employees, benefits include paid vacation, paid holidays, personal/sick time, health insurance allowance.  Compensation is dependent upon experience.

This position is responsible for primarily supporting Teradata environment that will include configuration, administration and maintenance of non-production and production environments. This position must have advanced working knowledge of Teradata RDBMS at both physical and logical levels. This role works closely with BI Analytics, Data Modelers, QA, ETL and other groups. Typically this role supports multiple, technically complex, mission-critical, and/or high-profile Projects. This individual must possess strong Administration Skills including the ability to make sound Database recommendations. 

Essential Job Functions:
  • Manage/Monitor system performance, including workload management 
  • Manage/Monitor Query performance and tuning, physical node behavior, and amp distribution
  • Support multiple Teradata systems including Data marts, development, and the enterprise warehouse systems and business applications.
  • Responsible for implementation and release of database changes as submitted by the development team. 
  • Provide weekend /off hour Support as Required 
  • Take care of production deployments.
  • Consult on physical database implementations, PPI, skew analysis, join methods, and data access paths. 
  • Support Unix level process, scripts, and tools for system management and data movement
  • Support development and consult on practices of storage management, archive, restore, and disaster recovery
  • Work with Teradata GSC in resolving RDBMS related incidents.
  • Responsible for improvement and maintenance of the databases to include rollout and upgrades
  • Install, configure and upgrade Teradata software and related products.
  • Proactively monitor the database systems to ensure secure services with minimum downtime
  • Implement and administer access policies in conjunction with corporate standards. 
  • Help ETL Developers to fine tune the SQL’s
  • Manage DBMS configuration changes.
  • Take care of Pack Disk, Scan Disk 
  • Backup, restore, migrate Teradata data and objects from Production to dev
  • Excellent communication (written and verbal). Full life cycle experience in Data Warehousing Data Integration, and Data Management.

Job Requirements:
  • 10+ years - Overall IT experience.
  • 10 years - DBA experience; must be proficient in both logical physical database designs. 
  • 8 Years – Teradata DBA Experience.( Teradata V15 & Higher)
  • 3 years – Advance Shell scripting.
  • Proficient in Teradata Tools and client utilities including Tara Gui
  • Other RDBMS database experience is a plus ( Netezza, Kognitio, SQL server)
  • Qualifications:
  • BS/MS degree, applicable certifications or equivalent experience required. 
  • High-level problem solving and technical experience.
  • Advanced knowledge of Teradata Architecture and system internals
  • Extensive experience in administering large databases
  • Advance Teradata Certification 
  • Expert understanding of business application 
  • Expert Database Physical, Logical design/SQL skills
this job portal is powered by CATS