Paranthaman V
Cloud Engineer - Database
Bangalore
Summary
PROFILE SUMMARY :
- Detail-oriented System and Database Administration including designs, develops and maintains highly scalable, secure and reliable databases. Accustomed to working closely with system architects, software architects and design analysts to understand business or industry requirements to develop comprehensive data models. Proficient at developing database architectural strategies at the modeling, design and implementation stages.
- Responsive expert experienced in monitoring database performance, troubleshooting issues and optimizing database environment. Possesses strong analytical skills, excellent problem-solving abilities, and deep understanding of database technologies and systems. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills.
- Having 9+ years of professional IT experience in System and Database Administration and Data Engineering – Teradata and BigQuery DBA.
- Having good knowledge on Data warehousing concepts, and familiar with GCP cloud architecture -BigQuery, Dataproc, Cloud Composer, Compute Engine, Storage.Logs Explorer,Monitor.
- Expertise on handling the Slots and reservation-based project requirement inside organization. Co-ordinating with Google team for P1 and P2 issues via Cases in the GCP console.
- Monitoring the GCP BigQuery query performance in looker, bqviz and troubleshooting the errors.
- Also performed migration activities as a part of Teradata to BigQuery Migration. Also having brief knowledge on Hadoop and MPP architecture.
- Hands on experience in performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics.
- Good Knowledge on CI/CD pipelines and using Github
- Sound Knowledge on Change management, Problem management and high priority incident handling via ticketing tool like Service now, Jira and maintaining the same on Confluence.
Overview
10
10
years of professional experience
5
5
Certifications
1
1
Language
Work History
Senior Database Administrator/ Technical Consultant
Teradata India Pvt Ltd
Bangalore
Teradata DBA / Senior System Engineer
Cognizant Technology Solutions
Chennai
- Roles and Responsibilities :
- Perform Teradata DBA activities like creation of Users, Databases, Roles, and Profiles
- Perform space monitor regularly on daily bases and manage the space to avoid live failures
- Monitor and control production boxes by performing various activities like Locks checks, Query monitoring using Viewpoint
- Perform Data copy from production to dev & test boxes for testing and development purpose using
- TARA
- To work on access related issues raised by development, testing and Business users
- Perform housekeeping for space management activities
- Perform SQL query performance and tune as in required to reduce the resource consumption
- Perform query optimization and assist developers and users by analyzing DBQL data, explain plan and join strategy and Partitioning large tables to improve performance of queries
- Worked on production incident by analyzing the issue, root cause and solution on daily basis
- Worked on production call during the duration on onshore by 24
- 7 production support for batches
- Having good knowledge about the production batches and can able to solve production Incidents
- Develop ARC scripts to perform backup and restore operations (Archive, Restore & Copy) of all the
- Teradata database objects.
Walmart Inc
11.2020 - Current
- Is an American multinational retail corporation that operates a chain of hypermarkets, discount department stores, and grocery stores from the United States, headquartered in Bentonville
- Arkansas
- Description :
- Day to day DBA activities like managing the databases, users, roles, profiles & access management in both PROD & DEV environments in both Teradata and BigQuery including 24
- 7 DBA Support
- Resolving performance issues like environment slowness, long running queries, Skewness etc
- Hands on experience in performance tuning, including collecting statistics, analyzing explains & determining which tables needed statistics
- Workload Management, slot allocations and setting reservation as per the business requirements & recommendations
- Having good Knowledge in viewpoint setups and monitor production the systems end to end through different viewpoint portlets (Query Monitor, System Health, Workload Monitor, Todays Statics, Space
- Usage, Metrics Analysis, and other use full portlets)
- Space allocations, movement and clean up
- User, Role, Profile, Database objects creation and Administration
- Restricting the User Access by Granting and Revoking Privileges to/from users
- Preparation of Monthly DBA Report and Roadmaps
- Excellent inter-personal and communication skills in collaborative mode with proficiency in grasping new technical concepts quickly and utilize the same in a productive manner
- Worked on ticketing tools like JIRA and Service Now on Severity and Priority basis
- Worked on Tableau dashboard to generate various system and query metrics (CPU/IO/AppId/Growth trend) subscriptions and presented to the customer which provide them a better forecast on the business.
Database Administrator
Air Canada
05.2020 - 11.2020
- Created and updated database designs and data models.
- Created and implemented database designs and data models.
- Designed and developed analytical data structures.
- Modified databases to meet needs and goals determined during planning process.
Teradata DBA / Senior Analyst
HCL Technologies
Chennai
08.2016 - 05.2020
WORKEXPERIENCE Datawarehouse DBA/ System Engineer
Walmart
Bangalore
01.2008 - 01.2012
Education
Bachelor of Engineering - Mechnical Engineering
Skills
Teradata- SQL Assistant, TARA GUI, Viewpoint , BTEQ, Multiload, FASTLOAD
Google- BigQuery, Looker, BqViz, Data Catalog, Logs Explorer, Support, Compute Engine,Dataproc,Cloud Composer,
Incident Management, Change Management,Ticket tool like Service now ,JIRA and ConfluencePassport NoL7369783Certification
GCP-Associate Cloud Engineer Certified, Professional Data Engineer Certified, Gen AI Badged from
Additional Information
- -09-1991 Nationality :
Timeline
- Walmart Inc
11.2020 - Current
Database Administrator - Air Canada
05.2020 - 11.2020
Teradata DBA / Senior Analyst - HCL Technologies
08.2016 - 05.2020
WORKEXPERIENCE
Datawarehouse DBA/ System Engineer - Walmart
01.2008 - 01.2012
Senior Database Administrator/ Technical Consultant - Teradata India Pvt Ltd
Teradata DBA / Senior System Engineer - Cognizant Technology Solutions
Anna University, GGR College of Engineering - Bachelor of Engineering, Mechnical Engineering