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