Big Data Engineer/Admin

• Feb 2022 - Present

Platform / Data Engineer

• May 2016 - Feb 2022

Lead Teradata DBA

• Apr 2015 - Mar 2016

• Identifying and Tuning poorly performing queries both ETL Batches and Users which • Deciding and applying hard-cap CPU Limits and Penalty profile enhancement to the business verticals to limit the CPU usage. • Reducing DBA workload and automating most of the Daily stuff that comes to DBA by creating procedures and Unix scripts. Like stats collection,access grants ,password reset etc. • Look for possible Design level modifications that can help Improve system performance and also help in maintaing DR system. • Work along with GSC on any P1 system impacting issues. • Implement MVC and identify candidates for BLC based on whether its HOT or COLD data. • Solely manage PDCR data and scripts and modify if reqired. • Manage Archive and Restore, and try to reduce the Backup window. • Creating and Managing Viewpoint alerts • Managing TASM setting and make changes to further enhance the System performance. • Managing SHC and oher SOX Audits. • Managing and Defining various queries that will be used for publishing System reports. • Automating Purging and other scripts. • Interact with client and address any System related Issues Show less

Associate Technical Associate

• Apr 2013 - Mar 2015

1. Hosting weekly DBA meeting to track, resolve and escalate outstanding issues and open tickets. Hosting weekly Service Mgmt. meeting to make the customer relationship strong and effective. Creating Incidents with Teradata and interacting with GSC/DBS engineer to remove the system error. 2.Tuning poorly performing queries of worse Batches and Users which affects the system badly. Analyzing Explain Plan, DBQL and PDCR information for providing them the tuning solutions, recommendations & technical guidance to increase the query performance (High Parallel Efficiency & Low skew). Applying hard-cap and Penalty profile enhancement to the business verticals to limit the CPU usage. 3. Maintaining the production STATS job (Daily/Weekly/Monthly) to keep the STATS updated. Collecting/Dropping Statistics based on the requirement. 4. SQL Code review and planning the Deployment & Rebuild. Has done PPI revision and MVC implementation successfully as year ending activity every year. 5. User mgmt. such as creating users and granting access/privileges based on requirement without impacting the Security policies. 6. Roles & Profile mgmt. creating roles and profiles according to the user groups. 7. Monitoring batch jobs/SQL’s triggered by Business End Users, CPU utilization, blocking, aborting queries when deadlock occurs through VIEWPOINT. 8. Providing CPU Utilization, Database Space and Database Performance information. 9. Coordinating with Backup Administration Team for taking regular Full backup based on the requirement. 10. Catering to Ad-hoc requests (e.g. Creation of Database Objects, Granting privileges to a user/role, Resetting the password /Releasing the password lock for a user etc.) 11. Housekeeping activities (Purging of DB objects according to the company policies). Show less

Teradata DBA

• Oct 2010 - Mar 2013

As DBA, the responsibilities were to deliver new and complex, high quality solutions to clients in response to varying business requirements. Some of them being • Implementation of the New Database, including Creating users, Database Objects etc • Compression analysis and implementation. Did Multi value compression on many tables. • Space Management: Current Space usage analysis, and recommendation regarding the utilization of space. • Creating users and User rights management. • Profile and Role management of database users • Creating of physical database objects (tables, views, indexes, Macros, Procedures) • Preparation of backup and restoration scripts and monitoring (Veritas Net backup and TARA GUI), • Performance Monitoring: Identified potential bottlenecks with user queries from the aspects of query writing, skewed redistributions, join order, optimizer statistics etc. Usage of Teradata Explain and Visual Explain to analyze and improve query performance. User sessions analysis, resource usage analysis and implementation of the required Workloads. • Tuning of the Scripts for better performance. • Analysis, selection and implementation of the system wide object demographic Statistics. • Advice structural changes and gives STATS collection recommendations wherever required. • Recreating the tables with new PI for resolving skew/space issues. • Setting the rules and throttles in the TDWM. • Archiving and Purging of Tables for space Maintenance. Show less