| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Senior Data Integration Developer Schaumburg, IL Senior Software Developer, Java, Spring Framework, React, Angula Glendale Heights, IL Data Engineer Senior Chicago, IL Senior Full Stack .NET Developer Chicago, IL Senior Data engineer Elmhurst, IL Data Engineer Senior Tinley Park, IL Software Engineer Senior Chicago, IL |
|
Click here or scroll down to respond to this candidate
Venu B Teradata DBA | Control-M| Google Cloud
Teradata Vantage Administration Certified Teradata Vantage 2.3 Associate Certified Google Cloud Certified Associate Cloud Engineer IT Service Management ISO/IEC Street Address Foundation Certified Professional Summary
Nearly 12+ years of total IT experience in Data warehousing background in Teradata Administration, Snowflake, Data Migration to Cloud, Performance monitoring/tuning, Data Warehousing model and concepts.
Working as Teradata DBA Lead Consultant from Tech Mahindra since Feb 2023-July 2024 Worked as Senior Teradata Database Administrator from Wells Fargo Solutions Pvt. Ltd from Nov 2021 to Feb 2023 Worked as Senior Teradata Database Administrator from HSBC software Development India Pvt. Ltd Hyderabad from June 2011 Nov 2021 (Tech-Lead for Offshore Team) Involved in DBA activities such as Migration of Data to Cloud, Creation of Databases Creating/maintaining Roles and Profiles and assigning them to users and Database Space management & Access management (Both Production and Standby Databases) Have good hands-on experience in BAR activities like scheduling the backups and monitoring of those Backup jobs. Used Control-M (version 9) tool extensively to schedule Backup jobs and monitor their scheduled run of backup activity every day. By TRS (Teradata Replication services) assign all the tables in production to appropriate groups and manage them to get replicated on standby databases as part of daily activity. Used Golden gate to maintain TRS groups (Production Tables) and analyzing the reason behind failure of any group as and when needed Performing Health-Checks as part of BAU every day during early business hours and maintain records of the report Reacting to alert system (X-Matters), as and when working as Teradata On-call support. Handling the Change Management and incident management for the production issues using PAR (Privileged Access Request) Approving the change orders and creation of Tables, Views, Batch users in Production, stand-by databases in the time window that agreed in the change requests Data movement across different Teradata servers to support development team. Involved in reviewing the Implementation plans of the new projects that needs to go LIVE. This includes educating the users with the best practices and Teradata recommendations where in need arrives. Using the workload management tool and methodology to manage the system workload to help business team to meet SLA Analyzing sessions with for high spool usage, high CPU usage, high disk usage, and high skew etc when alerts are received. Implemented the new projects/amendments to the existing projects on production machine once it gets clean sheet from the pre-production machine environment. It also includes DML execution, modifying the existing views and mapping new SAS, BI views to the master databases Investigating the occurred discrepancies, through DBQL and communicating to the end users. Did performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics. Increased performance by 35-40% in some situations. Representing in the document review meetings and signing off the impact analysis, study & design documents from a DBA perspective & also Data warehousing solution perspective. Deal with operational elements of the Teradata environment to ensure uninterrupted service to client applications and end users Experienced in dealing with complex Teradata platforms after working with a wide variety of European Teradata clients. Actively involved in all software and hardware Teradata Upgrades. Conducting Teradata Training for New recruitsSkill Set Teradata Studio, SQL Assistant, Golden Gate, Viewpoint, Power BI Scheduling Tools: Control-M 7 Desktop Operating Systems Windows 2000/07/10, Unix Reporting Tools/ Ticketing Tools: GSD, Remedy, My Solution Center Monitoring Tools: BES, Control-M 9 viewpointProfessional Experience (In Reverse Chorological Order)Project6:Duration : From Feb 2023 to July 2024Company : Tech MahindraTechnology : Teradata, Control-M SchedulingTools : Teradata Studio, Viewpoint, SQL Assistant, Control-M Desktop, Service Now Role : Lead Consultant
Bulk loading from the external storage (AWS S3), internal storage to snowflake cloud using the copy command Loading data into snowfall tables from internal storage using snowsql Using Export and import from the internal storage (snowflake) from the external storage (AWS S3) Used SNOW PIPE for continuous data ingestion from S3 Bucket Reviewing the Models of data modelling across the schemas in Database
Moving historical data to Cloud based on the requirement Reviewing the Models of data modelling across the schemas in Database Producing Heat maps and generate report for analysis on the system
Backup and Recovery Activities using DSA
DBA functions (development, test, production) on three platforms in operation
MVC,BLC techniques to perform better utilization
Collecting statistics across the system to reduce skew and better CPU usage
Project5:
Duration : From Nov 2021 to Feb 2023 Company : Wellsfargo Technology : Teradata, Control-M Scheduling Tools : Teradata Viewpoint, Teradata Administrator, SQL Assistant, Control-M Desktop, Service Now, Auto Sys Role : Senior Database EngineerRole Description and Responsibilities: Managed Workload balancing between batch jobs and users using workload Manager from Teradata viewpoint Reviewing the Models prepared by other DAs/Modelers.
Analyzing backup failures and taking appropriate steps. Performance Tuning, system monitoring across all the systems BAR activities using netback up DBA functions (development, test, production) on three platforms in operation
Project 4: HSBC UK BI
Duration : From June 2018 to 2021Company : HSBCTechnology : Teradata, Control-M SchedulingTools : Teradata Viewpoint, Teradata Administrator, SQL Assistant, Control-M Desktop, Golden Gate, GSD R12Role : Senior Database AdministratorRole Description and Responsibilities: Involved in implementing of project (applications) on pre-production machine and advised the users in case of discrepancies, so that they can be avoided while implementing on production box. This implementation needs bunch of tasks to be executed such as creation of new data databases, Views databases, Users, tables, view and other objects as per requirement of the project.
DBA activities that are Implementation of data and table-level security, setting up access rights and space rights for Teradata environment Responsible for maintaining all DBA functions (development, test, production) on three platforms in operation
Using TRS (Teradata Replication services) make sure that all the production tables and are in line with standby databases so that they will be up and running in case of emergency Did performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics.
Managed Workload balancing between batch jobs and users using workload Manager from Teradata viewpoint Analyzing backup failures and taking appropriate steps. Efficiently using DB space by Compression of Tables using ferret utility to make sure Tables are compact in size and release few GB of space on fortnight basis. Acted as a liaison between the offshore and onsite teams.Project 3: HSBC Asia Pacific
Duration : From June 2015 to till 2018Company : HSBCTechnology : Teradata, Control-M SchedulingTools : Viewpoint, Teradata, SQL Assistant, Control-M Desktop, GSD R12Role : Senior Database AdministratorRole Description and Responsibilities: Involved in assignment of space for the new project by cutting down few chunks of space from other unused space applications after having a group call with all the related parties
Provided assistance for the Application team users regarding their roles and how to access to master database using DLWORK tables and views Space and Access management
Created all the Users, Roles, Profiles, Tables and other objects that are necessary
Created backup jobs for the newly created tables and scheduled them using Control-M tool and supported oncall activity for these scheduled backup jobs. Managed to assign newly created production tables TRS groups & make sure backup activity is going on Performing Health Check activity day in day out. Ensure uninterrupted service to client applications and end users worked with development teams to refine, manage and enforce database standards and also ensure adherence to committed SLAsProject 2: HSBC Middle-East
Duration : From June 2014 to 2018Company : HSBCTechnology : Teradata, Control-M SchedulingTools : Teradata Viewpoint, Teradata Administrator, SQL Assistant, Control-M Desktop, Golden Gate, GSD R12Role : Senior Database AdministratorRole Description and Responsibilities: Responsible for maintaining all DBA functions (development, test, production) on three platforms in operation 24x7 (on call support) DBA activities that are Implementation of data and table-level security, setting up access rights and space rights for Teradata environment Managed Workload balancing between batch jobs and users using workload Manager from Teradata viewpoint Creation of Batch users and make sure that main database got accessed by these batch users only
Creation of new groups in TRS for newly created tables in production environment Monitoring the regular system performance and state using Viewpoint.
Reviewing the Models prepared by other DAs/Modelers.
Analyzing backup failures and taking appropriate steps. Working with onshore DBA team and was a major player in making the projects day to day operations run smoothlyProject 1: HSBC One
Duration : From June 2011 to 2016Company : HSBCTechnology : TeradataTools : Teradata Viewpoint, Teradata Administrator, SQL Assistant, Control-M Desktop, Golden Gate, GSD R12Role : Database AdministratorRole Description and Responsibilities: Space and Access management
Created all the Users, Roles, Profiles, Tables and other objects that are necessary
Created backup jobs for the newly created tables and scheduled them using Control-M tool and supported on call activity for these scheduled backup jobs. Performance Tuning , system monitoring across all the systems BAR activities using netback up Participated in responding to viewpoint alerts. Acted as a liaison between the offshore and onsite teams. |
