Teradata Performance Dba

6 months ago

Hyderabad Telangana, India Teradata Full time

What You’ll Do

Manage Production/Development databases performance.

Review Teradata system reports and provide “performance assessment” report with recommendations to optimize system.

Investigate and quantify opportunities from “performance assessment” reports and

Monitor using Viewpoint tool for Teradata system performance using different portlets.

Closely monitor the performance of various work groups on the system and make sure data is available to business as per the SLA requirement.

Optimal index analysis - Review Index usage on tables and recommend adding dropping indexes for optimal data access.

Review uncompressed tables, analyse its usage, and implement compression to save space and reduce IO activity - using various algorithms like MVC/ BLC/ ALC.

Optimize locking statements in views, macros & queries to eliminate blocking contention invest.

Review the Spool Limits for the users and recommend optimal limit for the Ad-hoc users to avoid run away queries over consuming system resources.

Check for Mismatch data types in the system and make them unique to avoid costly translations during query processing.

Review Set tables and check for the options to convert to MultiSet to avoid costly duplicate row checking operation.

Review Large Scan Tables on the system and analyze for using PPI, MLPPI, Compression, Secondary indexes & Join Indexes

Setting up the database hierarchy that includes database creation and management of objects such as users, Roles, Profiles, tables, views.

Maintain profiles, roles, access rights and permissions for Teradata user groups and objects.

Generate periodic performance reports using PDCR and identify bottlenecks with the system performance.

Establish PDCR canary performance baselines. Utilize standard canary queries to identify variance from baseline.

Effective usage of TASM & Priority distribution to penalize the resource intensive queries, Give high priority to business-critical workloads, Throttling of different workloads for optimal throughput and provide performance reports to check workload management health.

Who You’ll Work With

Teradata is growing our Global Consulting team and we’re looking for individuals that exemplify our principle of Customer Obsession through operational excellence, leadership, and a passion to continually be the voice of the customer. If you are interested in working in a dynamic and fast paced environment where you can directly influence the outcomes of consulting services, then this is the place for you. You will actively support and help our customers to meet their SLA’s by making sure of data availability, identify & troubleshoot Performance issues of critical workloads for seamless business operations and provide performance recommendations.

3-12 years of Teradata DBA experience.

Should have worked in Unix platforms.

Excellent oral and written communication skills in the English language.

Must be willing to provide 24x7 on-call support on a rotational basis with the team.

Must be willing to travel - both short-term and long-term

What You’ll Bring

Statistics Management and Optimization

Exposure to DWH Env (Knowledge of ETL/DI/BI Reporting).

Exposure to troubleshoot the FastLoad / Multiload/ FastExport/ BTEQ/ TPump errors, should be good at error handling.

Well conversant with various ticketing system/production change request/ Teradata Incident management.
Should be good at automating various processes.
Ability to write efficient SQL & exposure to query tuning.
Preferably understand Normalization and De-normalization concepts.
Preferable exposure to visualization tools like Tableau, PowerBI.
Preferably have good working knowledge on UNIX shell, Python scripting.

  • Teradata Dba

    3 months ago

    Hyderabad, Telangana, India LTIMindtree Full time

    We are Hiring Teradata DBA Minimum 8 - 12 Years of Exp Chennai, Bangalore, Mumbai ,Pune, Hyderabad Kindly Share your Resume **Job Description**: Key Responsibilities Lead the migration of Teradata onpremises systems to Teradata Vantage in the cloud Design implement and manage Teradata databases in the cloud environment Optimize database performance and...

  • Product Content Designer

    6 months ago

    Hyderabad, Telangana, India Teradata Full time

    What You’ll Do As a Product Content Designer at Teradata, you play an important role in the overall user experience by creating clear and engaging content to help our half a million users perform their jobs efficiently. You collaborate with product designers, product managers, software engineers, and other partners to design user experiences that are...

  • Project Manager

    6 months ago

    Hyderabad, India Teradata Full time

    Project Manager - Japanese Language Expert (JLPT) Multiple Locations: Hyderabad, Telangana, India • Pune, Maharashtra, India Requisition Number: 218142 External Description: What You’ll Do The Customer Services Project Manager is responsible for managing service delivery at assigned customer accounts within APJ (Asia Pacific and Japan) for...

  • Senior Database Software Developer

    4 weeks ago

    Hyderabad, Telangana, India Teradata Full time

    About the Role:As a Senior Database Software Developer at Teradata, you will be part of a team that works on a cloud-based data platform for AI. The role involves designing and developing database technology, including experience in data lake house architecture and SQL engine of cloud ecosystems.Key Responsibilities:Design and develop database technology,...

  • Staff Software Engineer

    6 months ago

    Hyderabad, India Teradata Full time

    Staff Software Engineer Location: Hyderabad, Telangana, India Requisition Number: 218145 External Description: What you will do You will work in Open Table Format project that's aims to provide the ability to read and write Iceberg data sets via Teradata Engine. Who you will work with You will be part of the team that worked to enable Teradata on public...

  • Teradata

    6 months ago

    Hyderabad, India NTT DATA Full time

    **Teradata | 3 - 6 Yrs** Work Mode - Hybrid Location - HYD/BLR Shift Timing - 12 PM to 9 PM Description: Skillset: Teradata, Informatica, UNIX (Hadoop/AWS will be addon) **Job Description**: Lights On development/enhancement role requires associate to work on enhancements in agile model and based on the need, need to involve incident management...

  • Tata Consultancy Services | MS SQL DBA | hyderabad

    2 weeks ago

    hyderabad, India Tata Consultancy Services Full time

    Greetings from TCS!!! **TCS is Hiring for MS SQL DBA** Walkin Interview for MS SQL DBA in Hyderabad Walkin Interview Date: 16th Nov 2024(Saturday) Role: MS SQL DBA Desired Experience: 4- 13Years Job Location: Hyderabad Required Skillsets: SQL, My SQL, Cosmos Job Description: 4+ years of hands on experience in MSSQL database Adminstartion 1....

  • Cloud(Aws) Dba

    6 months ago

    Hyderabad, Telangana, India DAZN Full time

    **Job Title**: - Cloud(AWS) DBA**Location**: - Hyderabad, India**Schedule**: - Full-Time, Permanent**Team**: - 61-166 - Technology Operations - Data Operations**Department**: - A - Dept HM uses to open req**What's your new role about?**: - Senior Cloud DBA (Snowflake + AWS)-6+ years - HYDERABAD, INDIA / - A - DEPT HM USES TO OPEN REQ - 61-166 -...

  • Teradata Database Admin

    6 days ago

    Hyderabad, India Tata Consultancy Services Full time

    Teradata Database Admin5 to 10HyderabadMust-Have** JD /competency for the requirement: 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...

  • Teradata Database Admin

    5 days ago

    Hyderabad, India Tata Consultancy Services Full time

    Teradata Database Admin 5 to 10 Hyderabad Must-Have** JD /competency for the requirement: 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...

  • Tata Consultancy Services | MS SQL DBA | hyderabad

    7 days ago

    Hyderabad, India Tata Consultancy Services Full time

    Greetings from TCS!!!**TCS is Hiring for MS SQL DBA**Walkin Interview for MS SQL DBA in HyderabadWalkin Interview Date: 16th Nov 2024(Saturday)Role: MS SQL DBADesired Experience: 4- 13YearsJob Location: HyderabadRequired Skillsets: SQL, My SQL, CosmosJob Description:4+ years of hands on experience in MSSQL database Adminstartion1. Proficient in writing in...

  • Teradata Database Admin

    1 day ago

    Hyderabad, India Tata Consultancy Services Full time

    JD /competency for the requirement:Installs, configures and upgrades Teradata software and related products.Backup, restore, migrate Teradata data and objectsEstablish and maintain backup and recovery policies and procedures.Manages and monitor system performance. proactively monitor the database systems to ensure secure services with minimum...

  • Teradata database admin

    1 day ago

    Hyderabad, India Tata Consultancy Services Full time

    JD /competency for the requirement: Installs, configures and upgrades Teradata software and related products.Backup, restore, migrate Teradata data and objectsEstablish and maintain backup and recovery policies and procedures.Manages and monitor system performance. proactively monitor the database systems to ensure secure services with minimum...

  • Senior Cloud Engineer

    1 week ago

    Pune/Hyderabad, India Teradata Full time

    Job Description : What You'll Do : - Design, implement, review, test, deploy and maintain innovative software solutions to transform languages across the Teradata Vantage platform (a critical Teradata strategic component). - Collaborate well within a tight- knit team to produce world- class enterprise- grade software. - Deliver quality Java,...

  • Teradata Database Admin

    2 days ago

    Hyderabad, India Tata Consultancy Services Full time

    JD /competency for the requirement:Installs, configures and upgrades Teradata software and related products.Backup, restore, migrate Teradata data and objectsEstablish and maintain backup and recovery policies and procedures.Manages and monitor system performance. proactively monitor the database systems to ensure secure services with minimum...

  • Teradata Database Admin

    5 hours ago

    Hyderabad, India Tata Consultancy Services Full time

    JD /competency for the requirement:Installs, configures and upgrades Teradata software and related products.Backup, restore, migrate Teradata data and objectsEstablish and maintain backup and recovery policies and procedures.Manages and monitor system performance. proactively monitor the database systems to ensure secure services with minimum...

  • Teradata Database Admin

    1 day ago

    Hyderabad, India Tata Consultancy Services Full time

    JD /competency for the requirement: 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...

  • Dba Architect

    4 weeks ago

    Hyderabad, Telangana, India Tata Consultancy Services Full time

    Inviting Applications for DBA Architect Job Title: DBA Architect Experience Required: 4 to 10 Years Location: Hyderabad - Handson experience in Performance Tuning - Exposure of user managementand handling/troubleshooting of operation activities - Proficient in backup andrecovery methods on LUW environment Qualifications :BACHELOR OF ENGINEERING

  • Payroll Analyst

    6 months ago

    Hyderabad, India Teradata Full time

    Payroll Analyst Location: Hyderabad, Telangana, India Requisition Number: 218144 External Description: What You’ll Do: Maintain payroll information by collecting, calculating, and entering data. His/her duties will involve but not restricted to intricate calculations of department specialization payments, car allowances, wage garnishments, retro and...

  • Oracle Dba

    6 months ago

    Hyderabad, Telangana, India Sierra-Cedar Full time

    Position: Oracle DBA Location: Hyderabad Experience: 5-7 Years **Responsibilities**: The Oracle DBA is responsible for handling DBA operations and Projects within Cloud Managed Services to support multiple clients hosted by Cloud Managed Services. The work includes Installing Oracle Software, creating Oracle Databases, performing upgrades of the database...