Senior Datastage Developer

We are seeking a seasoned Datastage developer to join our team. The ideal candidate will have expertise in writing and optimizing Teradata SQL queries, TPT script etc.

• 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
• 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.

• 6-12 years of Teradata Performance DBA experience.
• 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 TPT/ 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.
• Good to have exposure to FSLDM
• Good to have exposure to GCFR framework.