Teradata Infrastructure DBA

Tata Consultancy Services Ltd

Seattle, WA

JOB DETAILS
SALARY
$110,000–$130,000 Per Year
SKILLS
Bash Scripting, Cloud Computing, Customer/Client Research, Data Collection, Data Migration, Data Recovery, Data Warehousing, Database Administration, Database Technology, Database Triggers, Detail Oriented, Disaster Recovery, Documentation Standards, Forecasting, High Availability, Identify Issues, Incident Management, Information/Data Security (InfoSec), Legal, Loan Funding, Maintain Compliance, Market Surveys, NCR Teradata, Network Operations Center, On Call, Performance Analysis, Performance Tuning/Optimization, Problem Solving Skills, Product Testing, Python Programming/Scripting Language, Release Management/Engineering, Resource Management, SQL (Structured Query Language), Sarbanes-Oxley Act (SOX), Scripting (Scripting Languages), Security Auditing, Security Monitoring, Software Upgrades, Stored Procedures, Student Loans, Systems Administration/Management, Systems Maintenance, Team Player, User Account Administration, Warehousing, Writing Skills
LOCATION
Seattle, WA
POSTED
30+ days ago

Must Have Technical/Functional Skills

  • 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's latest DSA experience
  • Managing security policies and compliance
  • System Monitoring and Maintenance
  • Performance Tuning
  • Incident Management and Troubleshooting
  • Change and Release management

Role and 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
  • Customer feedback survey
  • 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)
  • Ability to write complex Teradata SQL queries, stored procedures, triggers, functions

Practical experience in managing the internal and external Teradata database security

Base Salary Range : $110,000 to $130,000 Per Annum

TCS Employee Benefits Summary:

Discretionary Annual Incentive.

Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.

Family Support: Maternal & Parental Leaves.

Insurance Options: Auto & Home Insurance, Identity Theft Protection.

Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.

Time Off: Vacation, Time Off, Sick Leave & Holidays.

Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

#LI-SV2

#LI-KUMARAN

About the Company

T

Tata Consultancy Services Ltd