We provide IT Staff Augmentation Services!

Teradata Sql Assistant Resume

SUMMARY

  • More than 10 years of experience in Teradata Database Systems on UNIX, Windows and Mainframe environment
  • Involved in Design, Development and DBA activities with various Enterprise Data Warehouse in Banking, Retail, Logistics, Manufacturing and Life sciences
  • Extensively worked on designing Data management, logical data modeling and physical database configurations for large - scale data warehouse
  • Worked extensively with Teradata utilities like Multi Load, Fast Load, Fast Export, BTEQ and TPT (Teradata Parallel Transporter)
  • Experienced with Teradata Tools like SQL Assistant, Viewpoint and Administrator
  • Experienced in Teradata Backup/Restore/Copy using Arc main and Netvalut
  • Experienced in Performance tuning and analysis by using DBQL queries
  • Experienced in Teradata Database Upgrade version from 15.10 to 16.20
  • Experience in Data migration from Hadoop to Azure Databricks
  • Good knowledge on Cloud based systems such as Snowflake and AWS Redshift

PROFESSIONAL EXPERIENCE

Confidential

Teradata SQL Assistant

Responsibilities:

  • Responsible for Teradata Platform Architect for Teradata Appliance severs
  • Working with System Manager, Teradata Vendor and Director for solving high priority incidents
  • Working with Application Managers to implement best practices in the development
  • Responsible for application enhancement designs for efficiency with a focus on performance
  • Responsible for Teradata database Upgrade version from 15.20 to 16.20
  • Implementation of Teradata integrated workload management
  • Building strategy for backups and system maintenance activities
  • Implemented best practices to improve system response time for various a business generating queries and web application using Teradata database
  • Analyzing project requirements and develop detailed specifications for new and existing data warehouse database related requirements
  • Evaluating products and upgrades for appropriateness and lead the implementation and upgrade strategies
  • Supporting Teradata patch and upgrades collaborating with Teradata team and interfacing with the application sub-vendors
  • Reviewing and resolving Teradata alerts and communicate any risk/issues or impact on the management, team, and business users through appropriate communication strategy
  • Creating Teradata incident on issues, tracking using TAYS, setting necessary priorities, monitoring and controlling, and work with Teradata to resolve the issues promptly
  • Involved in analyzing Explain text for debugging optimizer related issues
  • Responsible for gathering Query, CPU, Disk resource requirements for new applications and extensions to existing systems.
  • Providing required solutions to Business End users with appropriate query re-enhancing and any other techniques.
  • New PI, PPI, SI and JI recommendations on a table based on the requirement for resolving skew/space issues.
  • Using Compression techniques to provide required compression values to gain space and for better retrieval performance.
  • Responsible for Backup/Restoration (Data Copy from one source system to another source system), monitoring on Net Vault (Bar Activities)
  • Administration, Maintenance and control of the Teradata Workload Management policies and rules.
  • Responsible for testing new tools associated with Teradata (POC’s on Alteryx, Spark, Metricinsights Tool)
  • Data migration and compression analysis on Teradata tables through Atana suite & MVC.
  • Assisting DBA’s, Developers and support teams for solving technical issues
  • Responsible for Data migration from Hadoop to Azure Databricks
  • Responsible for Databricks database, tables creations
  • Responsible for load files in azure datalake file storage container
  • Responsible to identify and automate the process by using shell script

Confidential

Teradata SQL Assistant

Responsibilities:

  • Leading Offshore and onsite team for Deliverables
  • Responsible for various DBA activities such as setting up access rights and space rights for Teradata environment
  • Performance tuning, Monitoring and reporting Review
  • Analyzing the bottlenecks & ensuring the smooth execution of reports within the SLA for the Tactical P1 Applications
  • Query optimization and assisted ETL developers and users by analyzing DBQL data explain plan and join strategy and Partitioning large tables to improve the performance of sqls
  • Involved in setting up and maintaining Workload Management using TASM
  • Setting up and maintaining Data Labs
  • Involved in Capacity Planning & Trend Projection/Monitoring system growth
  • Interact with user and BA to analyze the business requirements and discuss with Architect for the solutions
  • Responsible for maintaining the Data integrity across the Confidential system
  • Review the code from the development team before the SIT and Regression
  • Co-ordinate with source system to resolve data integrity issues
  • Providing suggestions for improving the process and systems performances
  • Responsible for suggesting a workaround for problematic SQL
  • Involved in analyzing Explain text for debugging optimizer related issues
  • Meeting and discussions within the team and also with onsite counterpart and providing solutions

Confidential

Teradata SQL Assistant

Responsibilities:

  • Database Administration like creating databases, user, Roles, Profile, user Permission as per Confidential standard
  • Daily Monitoring the ETL for Confidential like overall disk utilization for databases, Users and spool space, Database locks, Monitoring of resource utilization and performance
  • Day-to-day and on-call support of the in-house developed ETL and Data Warehouse applications, SLA for the support via BMC Remedy Tool
  • Tools utilized in the implementation such as Teradata Viewpoint, Administrator, TARA GUI, ARCMAIN
  • Handled space management issues, by allocating spaces to different users/databases
  • Creation of backup/copy/restore jobs via TARA GUI utility
  • Involved in analyzing Explain text for debugging optimizer related issues
  • Responsible for writing simplified queries for the complex SQL
  • Publishing System health Report daily, weekly and monthly for analyzing the system utilizations
  • Identifying problematic queries on the system or application level and tuning the queries to reduce resource utilization
  • Modifying throttle settings as part of system-level performance tuning to reduce concurrent sessions
  • Identifying skewed modeled tables and providing suggestions with good Primary Index to improve the performance of the queries accessing those tables
  • Adding Partitioned Primary Index to the candidate tables to reduce the query run time and system resource usage
  • Generating a monthly report of resource-intensive queries on application-wise and optimizing those queries to reduce the resource consumption to improve system performance
  • Finding the unwanted secondary usage on the tables and providing suggestion to avoid them to free up additional disk space on the system
  • Applying Multi-Value Compression in the regular interval on the candidate columns to free up additional disk space on the system

Confidential

Teradata SQL Assistant

Responsibilities:

  • Creating users, roles and profiles
  • Allocation of Space Management and User Management
  • Design physical database objects (tables, views, indexes)
  • Code review to ensure standard in coding defined by Teradata.
  • Identifying the bottlenecks in the query and implementing the changes to eliminate those
  • Query tuning and suggestions for improvement
  • Execution of Adhoc queries
  • Creation of deployment groups in Informatica and deployment
  • Involving into the design, develop, and test processes for initial loading data and cyclical data into a data warehouse
  • Participate in integration and system testing
  • Validate the results of unit, component integration, system acceptance and deployment readiness to ensure conformance to business
  • Defect management logged by using HPALM

Hire Now