Database Administrator

  • location: Charlotte, NC
  • type: Contract
  • salary: $55 - $65 per hour
easy apply

job description

Database Administrator

job summary:
Summary:

  • Data Base Administrator V supporting Teradata system
  • Senior Teradata Application DBA with 8 - 10 yearsexperience, including Teradata TD16 version or higher:
 
location: Charlotte, North Carolina
job type: Contract
salary: $55 - 65 per hour
work hours: 9am to 5pm
education: Bachelors
 
responsibilities:
Responsibilities:

  • Support multiple Teradata systems including independent marts, development/UAT, disaster recovery, security and the enterprise warehouse systems and business applications.
  • 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.
  • Implement and administer access policies including non-public data masking/encryption policies in conjunction with corporate standards.
  • Support some Mainframe administrative functions including archive processing and job scheduling.
  • Manage, design, support, and consult on practices of storage management, data movement, archive, restore, and disaster recovery.
  • Work closely with Application projects teams on implementation of database changes to support large project initiatives and BAU work.
  • Design, code, test, and implement stored procedures and scripts which will automate selected DBA tasks.
  • Work independently with minimal supervision, with general guidance from more seasoned DBA team members or managers.
 
qualifications:
Qualifications:

Required Skills

  • 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.
  • 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.
 
skills: Skills:

Desired 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, DBS Control 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.

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

easy apply

get jobs in your inbox.

sign up
{{returnMsg}}

related jobs


    Oracle DBA

  • location: Charlotte, NC
  • job type: Contract
  • salary: $46 - $56 per hour
  • date posted: 10/22/2020

    SQL Architect

  • location: Charlotte, NC
  • job type: Contract
  • salary: $60 - $70 per hour
  • date posted: 10/27/2020