OKAYA INFOCOM ยท 1 day ago
Teradata Infrastructure DBA--Seattle, WA, St.Louis , MO, Plano, TX--Full Time
OKAYA INFOCOM is looking for a Teradata Infrastructure DBA to join their team. The role involves managing Teradata database administration, performance tuning, and ensuring data security and compliance while providing support for multiple Teradata systems.
Responsibilities
Installs, configures and upgrades Teradata software and related products
Backup, restore, migrate Teradata data and objects
Establish and maintain backup and recovery policies and procedures
Manages and monitor system performance. proactively monitor the database systems to ensure secure services with minimum downtime
Implements and maintains database security
Sets up and maintains documentation and standards
Supports multiple Teradata Systems including independent marts/ enterprise warehouse
Work with the team to ensure that the associated hardware resources allocated to the databases and to ensure high availability and optimum performance
Responsible for improvement and maintenance of the databases to include rollout and upgrades
Responsible for implementation and release of database changes as submitted by the development team, Working with end customer
Teradata, customer, datacenter, vendor co-ordinations
Forecast data, security audits
User account and access management
Teradata active system management and customer requests and system allocation
Backup and recovery
SOX compliance and audits
DB support from 3rd party vendors
Product evaluations
Oncall support and major incidents
Backup restore, frequency and retention
Disaster recovery
Create long range disaster recovery
Experienced in performance optimization techniques and Structured Query Language (SQL) tuning
Demonstrated knowledge of Performance Data Collection and Reporting (PDCR) and Database Query Logging (DBQL)
Qualification
Required
Infrastructure DBA experience and Backup and Recovery experience
Proven experience with Teradata database administration, performance tuning, and troubleshooting
Strong knowledge of SQL and experience with scripting languages such as Python or Bash
Familiarity with data warehousing concepts and processes
Excellent problem-solving skills and attention to detail
Ability to work independently and as part of a team in a fast-paced, high-pressure environment
Experience with cloud platforms and services
Teradata Platform Maintenance and Support
Teradata latest DSA experience
Managing security policies and compliance
System Monitoring and Maintenance
Performance Tuning
Incident Management and Troubleshooting
Change and Release management
Installs, configures and upgrades Teradata software and related products
Backup, restore, migrate Teradata data and objects
Establish and maintain backup and recovery policies and procedures
Manages and monitor system performance. proactively monitor the database systems to ensure secure services with minimum downtime
Implements and maintains database security
Sets up and maintains documentation and standards
Supports multiple Teradata Systems including independent marts/ enterprise warehouse
Work with the team to ensure that the associated hardware resources allocated to the databases and to ensure high availability and optimum performance
Responsible for improvement and maintenance of the databases to include rollout and upgrades
Responsible for implementation and release of database changes as submitted by the development team, Working with end customer
Teradata, customer, datacenter, vendor co-ordinations
Forecast data, security audits
User account and access management
Teradata active system management and customer requests and system allocation
Backup and recovery
SOX compliance and audits
DB support from 3rd party vendors
Product evaluations
Oncall support and major incidents
Backup restore, frequency and retention
Disaster recovery
Create long range disaster recovery
Experienced in performance optimization techniques and Structured Query Language (SQL) tuning
Demonstrated knowledge of Performance Data Collection and Reporting (PDCR) and Database Query Logging (DBQL)