Jobs in Islamabad

Teradata Jobs Performance DBA



Teradata Jobs Performance DBA:

Organization: Teradata

Position: Teradata Performance DBA

Location Islamabad, Pakistan

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.
  • Apply best practices in each of the areas.
  • Monitor using Viewpoint tool for Teradata system performance using different portlets.
  • Review poor performing queries generated from BI/ETL tools and provide best practice recommendations on how to simplify and restructure views, apply PPI or other index changes.
  • 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
  • Analyze various applications and understand the space requirements and segregate the disk space under the categories of perm, spool, and temp space.
  • 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.

What Makes You a Qualified Candidate

  • 10+ years of Teradata DBA experience specifically specializing in performance optimization.
  • Experience with Unix platforms.
  • Excellent oral and written communication skills in the English language.
  • Prior consulting and/or Managed Services experience.
  • Must be willing to provide 24ร—7 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

  • Experience in review of poor performing queries and provide best practice recommendations on how to simplify and restructure views, apply PPI or other index changes.
  • 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.
  • Experience in fine tuning various application parameters/number of sessions to ensure optimal functioning of the application.
  • 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. Apply

Teradata Jobs Performance DBA

Register & Apply Online



Instagram Follow Facebook Like PageLinkedIn Follow


Jobs By Cities

Jobs By Field


Jobs By Organization


Recent Jobs

Punjab Public Service Commission PPSC Jobs April 2025
University of Engineering & Technology UET Lahore Jobs April 2025
Federal Directorate of Education Govt of Pakistan Jobs April 2025
Specialized Healthcare & Medical Education Dept Punjab Jobs April 2025
LOLC Microfinance Bank Jobs April 2025
OPPO Mobile Pakistan Jobs April 2025
Alkhidmat Foundation Pakistan Jobs April 2025
Gas & Oil Pakistan Ltd Jobs April 2025
Overseas Pakistanis Foundation OPF Jobs April 2025
Ministry of National Health Services Regulations & Coordination Jobs April 2025
Women Development Department Punjab Jobs April 2025
University of Balochistan Jobs April 2025
Pakistan International Airlines PIA Jobs Cabin Crew
Pakistan Minerals Pvt Ltd PMPL Jobs April 2025
Dalda Foods Pvt Ltd Jobs Shift Officer QA
MCB Funds Jobs Assistant Manager Quality Assurance
Outfitters Stores Pvt Ltd Jobs Retail Associate
Punjab Human Capital Investment Project PHCIP Jobs Financial Management Specialist
Ministry of Inter-Provincial Coordination Jobs Chief Executive Officer CEO
Ignite Jobs Chief Executive Officer CEO
Uniworth Shop Jobs Call Center Agent
OLP Financial Services Pakistan Limited Jobs Manager Information Security
FonGrow Pvt Ltd Jobs Sales & Purchase Executives
Soorty Enterprises Pvt Ltd Jobs Electronics Technician
Hilal Foods Pvt Ltd Jobs Sr Executive Account Receivables
Izhar Engineering Pvt Ltd Jobs HR Officer Sites
Diners Pakistan Jobs Merchandiser Formal Pants
Shams Textile Mills Limited Jobs Marketing Officer
TPL Properties Jobs Head of Electrical
Artistic Milliners Pvt Ltd Jobs Textile Marketer
whatsappgroup