girl looking into her desktop
Back to search results

Database Administrator , Core Technology Infrastructure

Charlotte, North Carolina

Job Description:

Position Summary

The resource request is for supporting the Teradata Data Warehouse systems. The team plans on consolidating an appliance class platform into a larger enterprise class platform. The position is for a Teradata Systems DBA which is critical to the ongoing work and rolling out of the new Teradata transformation project/ architecture which may include the opportunity to acquire Hadoop and Cloud strategy knowledge. In addition the candidate would be responsible for managing Teradata databases, Teradata Managed server tools, Data Movement DSA Data Streaming Architecture, BAR Backup and Recovery technology, and Cloud NAS Object Storage.

Support multiple Teradata systems including independent marts, development/uat, disaster recovery, security and the enterprise warehouse systems and business applications.

Building and Installing new Teradata systems including setting access control security layer, DR setup, Manage/Monitor Teradata system performance, including workload management, query performance and tuning, physical node behavior, and amp distribution. Consult on physical database implementations, PPI, skew analysis, join methods, and data access paths. Work with Teradata GSO in resolving RDBMS related incidents.

  • Implement and administer access policies in conjunction with corporate standards.

  • Support Mainframe administrative functions Teradata Datamover tool support with Unity experience

  • Support Unix level process, scripts, and tools for system management and data movement.

  • Manage, design, support, development and consult on practices of storage management, archive, restore, and disaster recovery.

  • Familiar with Incident and change management process using tools like Remedy.

  • Familiar with Cloud computing, Cloud Storage like Native Object Storage, Machine Learning etc.

Primary Skill

  • Teradata

Secondary Skill

  • Disaster Recovery

Tertiary Skill

  • RDMS

Required Skills

  • Advanced working knowledge of Teradata RDBMS at both physical and logical levels.

  • Advanced working knowledge of Teradata suite of tools; DataMover,BAR, TASM, TTU Tools, TPT, DBQL, PDCR, Viewpoint, Datamover, Unity.

  • Familiar with Teradata Systems setup, GDO, DBSControl etc.

  • Working knowledge of Mainframe interfaces and execution; TDP, JCL, TSO,ISPF, ESCON,FICON, NDM.

  • Experience with Linux / Unix operating systems.

  • Automation scripting experience using BASH / Python is a must have for this role.

  • Teradata security , SSO and Active directory integration.

Desired Skills

  • Familiar with Incident and change management process using tools like Remedy

Core Technology Infrastructure Organization:

  • Strives to bring new thoughts and ideas to teams in order to drive innovation and unique solutions

  • Excels in working among diverse viewpoints to determine the best path forward

  • Experience in connecting with a diverse set of clients to understand future business needs – is a continuous learner

  • Commitment to challenging the status quo and promoting positive change

  • Participate in and drive collaborative efforts to advance tools, technology, and ways of working to better serve an evolving client base

  • Believes in value of diversity so we can reflect, connect and meet the diverse needs of our clients and employees around the world

Participates in design, development and implementation of complex databases, often using new technologies. Viewed as the subject matter expert for the team. Manages multiple, moderately complex projects and direct activities of a team related to special initiatives or operations. Routine accountability is for technical knowledge and capabilities as a team member or as an individual contributor. Works under minimal supervision, with general guidance from more seasoned consultants or managers. Works on complex problems where analysis of situations or data requires an in-depth evaluation of various factors. Exercises judgment within broadly defined practices and policies in selecting methods, techniques, and evaluation criterion for obtaining results. Work leadership may be provided by assigning work and resolving problems. Computer Science degree preferred or substantially equivalent experience. Typically 7-10 years of IT experience.

Job Band:

H5

Shift: 

1st shift (United States of America)

Hours Per Week:

40

Weekly Schedule:

Referral Bonus Amount:

0

Job Description:

Position Summary

The resource request is for supporting the Teradata Data Warehouse systems. The team plans on consolidating an appliance class platform into a larger enterprise class platform. The position is for a Teradata Systems DBA which is critical to the ongoing work and rolling out of the new Teradata transformation project/ architecture which may include the opportunity to acquire Hadoop and Cloud strategy knowledge. In addition the candidate would be responsible for managing Teradata databases, Teradata Managed server tools, Data Movement DSA Data Streaming Architecture, BAR Backup and Recovery technology, and Cloud NAS Object Storage.

Support multiple Teradata systems including independent marts, development/uat, disaster recovery, security and the enterprise warehouse systems and business applications.

Building and Installing new Teradata systems including setting access control security layer, DR setup, Manage/Monitor Teradata system performance, including workload management, query performance and tuning, physical node behavior, and amp distribution. Consult on physical database implementations, PPI, skew analysis, join methods, and data access paths. Work with Teradata GSO in resolving RDBMS related incidents.

  • Implement and administer access policies in conjunction with corporate standards.

  • Support Mainframe administrative functions Teradata Datamover tool support with Unity experience

  • Support Unix level process, scripts, and tools for system management and data movement.

  • Manage, design, support, development and consult on practices of storage management, archive, restore, and disaster recovery.

  • Familiar with Incident and change management process using tools like Remedy.

  • Familiar with Cloud computing, Cloud Storage like Native Object Storage, Machine Learning etc.

Primary Skill

  • Teradata

Secondary Skill

  • Disaster Recovery

Tertiary Skill

  • RDMS

Required Skills

  • Advanced working knowledge of Teradata RDBMS at both physical and logical levels.

  • Advanced working knowledge of Teradata suite of tools; DataMover,BAR, TASM, TTU Tools, TPT, DBQL, PDCR, Viewpoint, Datamover, Unity.

  • Familiar with Teradata Systems setup, GDO, DBSControl etc.

  • Working knowledge of Mainframe interfaces and execution; TDP, JCL, TSO,ISPF, ESCON,FICON, NDM.

  • Experience with Linux / Unix operating systems.

  • Automation scripting experience using BASH / Python is a must have for this role.

  • Teradata security , SSO and Active directory integration.

Desired Skills

  • Familiar with Incident and change management process using tools like Remedy

Core Technology Infrastructure Organization:

  • Strives to bring new thoughts and ideas to teams in order to drive innovation and unique solutions

  • Excels in working among diverse viewpoints to determine the best path forward

  • Experience in connecting with a diverse set of clients to understand future business needs – is a continuous learner

  • Commitment to challenging the status quo and promoting positive change

  • Participate in and drive collaborative efforts to advance tools, technology, and ways of working to better serve an evolving client base

  • Believes in value of diversity so we can reflect, connect and meet the diverse needs of our clients and employees around the world

Participates in design, development and implementation of complex databases, often using new technologies. Viewed as the subject matter expert for the team. Manages multiple, moderately complex projects and direct activities of a team related to special initiatives or operations. Routine accountability is for technical knowledge and capabilities as a team member or as an individual contributor. Works under minimal supervision, with general guidance from more seasoned consultants or managers. Works on complex problems where analysis of situations or data requires an in-depth evaluation of various factors. Exercises judgment within broadly defined practices and policies in selecting methods, techniques, and evaluation criterion for obtaining results. Work leadership may be provided by assigning work and resolving problems. Computer Science degree preferred or substantially equivalent experience. Typically 7-10 years of IT experience.

Shift:

1st shift (United States of America)

Hours Per Week: 

40

Learn more about this role

Full time

JR-21070172

Band: H5

Manages People: No

Travel: No

Manager:

Talent Acquisition Contact:

Taimour Khan

Referral Bonus:

0

Street Address

Primary Location:
901 W Trade St, NC, Charlotte, 28255