Job description

Role: Teradata Performance Engineer

Location: Austin, TX/Sunnyvale, CA

Term: Fulltime

Job Description:

• Strong experience in Teradata performance tuning
• Experience with Teradata utilities and Teradata product suite is required.
• Ensure the availability and performance of all databases while providing day-to-day database support
• Design, evaluate and optimize database objects in conjunction with the development team
• Experience with performance tuning within a Teradata environment (SQL, Joins, Indexes, Viewpoint, Explains)
• Perform table Indexing, data compression and statistics collection
• Perform Query tuning and system performance improvements
• Investigate batch performance issues and provide solutions
• Monitor database space availability and perform capacity planning
• Advanced knowledge of handling large size Teradata systems on Linux platform.
• Experience maintaining user profiles and security skills that are related to the databases
• Performance trending and analysis including recommending indexing strategies, partitioning, compression opportunities and statistic collection planning.
• Real time monitoring identifying and tuning poorly performing queries and providing improvement recommendations.
• System administration and capacity planning including review and analysis of usage, capacity, and performance data
• Performance review and trending of prior days workload using DBQL logs.
• Application performance tuning using appropriate database management tool
• Application-level capacity monitoring and planning
• Capacity planning and space management utilizing PDCR, MVC and BLC.
• Revamped Viewpoint systems to streamline real time performance monitoring
• Revamped Viewpoint email alerts to only deliver actionable items (space and blocking)
• Designed and wrote custom scripts to improve DBA productivity
• Expertise in generating Space utilization reports and Users query performance reports
• Expertise in Teradata space estimations for future projects.
• Perform table Indexing, data compression and statistics collection
• Perform Query tuning and system performance improvements
• Investigate batch performance issues and provide solutions
• Monitor database space availability and perform capacity planning
• Expertise in generating server performance reports, space utilization, Server CPU & I/O utilization reports, operation Scorecards, Business reports.
• Knowledge on python and tableau is plus
• experience with performance tuning within a Teradata environment (SQL, Joins, Indexes, Viewpoint, Explains)

Job Type: Full-time

Salary: $105,448.12 - $135,935.01 per year

Schedule:

• 8 hour shift

Work Location: One location

Speak with the employer
+91 7372776777

arclintfl.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, arclintfl.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, arclintfl.com is the ideal place to find your next job.