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