PROFESSIONAL SUMMARY:

• Working for IT industries for 8.7 years, excellent field of experience as Teradata, Vertica Database administrator (DBA) and Oracle admin.
• Involved in DWH Analysis, Design, and Implementation, Coding and Reporting.
• Wide experience in Teradata from version 12.0 through 16.20, Vertica 7.1.
• Extensive practical hands - on experience as DBA in Setting up the Structure, Database, User, role, profiles, Space as per Teradata & Vertica Best Practices.
• Setting up Teradata DB, Vertica Cluster and supporting of the Enterprise Hadoop data lake environment for big data analytics platform.
• Responsible for aligning Data warehousing technology solutions with business requirements also responsible for the creation and execution of the data strategy and architecture such that it meets the needs for various business functions across its transactional, operational & analytical data warehouse application.
• Hands on experience of CPPT & PDCR (Performance data collection and reporting) installation, migration, configuration, troubleshooting and reporting.
• Participated in Teradata DBS Version, Power, Floor sweep and Disk Merge Upgrades, database cloning, Disaster Recovery, Workload management, DOWN AMP recovery.
• Administer, maintain and utilize policies and procedures for ensuring the security and integrity of the databases.
• Preparing weekly, monthly & quarterly production health reports and presenting those reports to the customer.
• Performance assessment on a new project, which was to scan performance metrics for project to uncover any potential issues that could jeopardize overall system performance.
• Gained hands-on experience on Utilities like Showspace, Showlocks, and Packdisk, Checktable, Scandisk, TSTSQL, Vprocmanager, Config, etc.
• Worked on Netvault, Netbackup, Datamover, Datadomain, DSA BAR Utilities, VBR.py and responsible for design and correct functioning of BAR and DR solutions.
• Hands-on experience in Data copy using Datamover, NAMEDPIPE, FE-ML mechanism.
• Perform security audits, which includes designing and implementing roles, profiles, accounts and IP-Filtering, Gateway security. Ensure compliance in related tasks with company and regulatory policies and procedures.
• Working closely with customer and resolving different type of day to day customer’s issue and Provide suggestion and recommendation as per Teradata best practices.
• Very good understanding of Teradata & Vertica Architecture, its components and their functionality and Extensive experience on Query performance tuning on analyzing and understanding the Explain plan and based on the optimizer plan tuning the SQL, check the Primary Index or projections, Data distribution, data access paths, skew analysis, defining Partition Primary Index (PPI) to avoid full table scans on large tables, Implemented Secondary Index, Join Index, Aggregate Join Index, Collecting statistics, Compression, SQL change (re-writes) recommendations to use Volatile table to further improve the performance of the SQLs.
• Excellent working experience on Querygrid & Presto connectors. Worked on Teradata and Hadoop connectivity using Teradata presto. This connector help DB user to access data-lake files/tables seamlessly from DB.
• Good knowledge on Change Management, Incident Management, Problem Management.
• Perform capacity planning and forecasting. Evaluate and implement new initiatives on technology and process improvement. Perform short and long term system/database
• Managed Teradata Viewpoint Alert setup and configurations.
• Maintain workload management (TASM) to appropriately match the current requirement and making changes to workload based on new requirement for the better management of the system.
• Define and modify workload management standards (workload groups, throttles, priorities etc.) Based on the needs of the day in production and explain the changes effectively to the team.
• Analyzes transactions and data volumes, designs and develops complex databases and applications, assists in developing system requirements, participates in large-scale software development initiatives including product selection and implementation.
• Generating TSET report for day to day Teradata incidents and also importing data demographics/Stats using TSET.
• Proactively monitoring the Vertica environments using VSQL, Management Console and DB Visualizer.
• Monitoring hadoop cluster health and long running Jobs and communicate to users or application teams.
• Fine tuning Vertica and Hadoop cluster parameters to yield better performance.
• Good knowledge on DBS control parameters.
• Working on multi value compression for the qualified tables using Atana-Suite which will help in saving disk Space and reduced the I/O.
• Worked on automation of DR sync process, User de-activation, Hut-lock release, Default value creation, Space alerts, CPU alerts, Packdisk, Scandisk, Checktable, etc.
• Gained hands-on experience on Teradata utilities like BTEQ, Mload, Fload.
• Working with Teradata Customer support executive for any Production/Development database issue and interact with client accordingly.
• Planning, analysis and implementation of DB related features and enhancements.
• Creating and managing Data LABS & deploying UDF’s (SHA, Oracle, java) on user request.
• Lead efforts to evaluate new vendor software or existing system and make recommendations
• Ability to translate technical concepts into business level language and effectively communicate ideas and direction with all levels of business management and staff
• Participate as Subject Matter Expert (SME) as required for design reviews and technology and tool selection
• Keep current on database systems and features, 3rd party tools, and industry standards.
• Hands-on SYSYINIT, TDPUT, DIP, TVS (Teradata virtual storage) & TIM (HeatMap Udf), SWS.

TECHNICAL SKILLS & EXPERIENCE:

Database Technology: Teradata12,13,13.10&14.00,14.10,15.0, 15.10.16.10 , 16.20 & Oracle10g, Vertica 7.1,Hive

Programming Languages/Scripting: PL/SQL, SQL, Shell & Python

Framework: Hadoop

Tools: & Utilities: Teradata Manager, Viewpoint, Teradata Administrator, Teradata SQL Assistant, SWS, TDWM, PMON, TSET, BTEQ, FastLoad, Mload, Management console, DBvisualizer Sql*loader, Toad, putty, Tectia

Operating Systems: Windows, UNIX, Linux, MPRAS-UNIX, AIX.

Backup tools: Netvault, Netbackup(DSA,DATADOMAIN,TARA), VBR.py

WORK EXPERIENCE:

Confidential

Tools: Teradata 15.0,15.10,16.10, Hadoop, Viewpoint, datalab’s, Teradata Administrator, Teradata SQL Assistant,Hive, Phython, BTEQ, NetBackup (TARA,DSA,DATADOMAIN), Tectia, Query Grid, Presto

Sr.Teradata DBA

Responsibilities:

• Manage Database, User creation process along with implementing any new changes required, which will reduce the overall duration of database creation process.
• Develop and implement database performance monitoring process and analyse monitoring data for performance optimization opportunities.
• Maintain reports which to help customer management represent the usage of Teradata system accurately in any high-level meetings and helping the management team in making better business decisions related to Teradata infrastructure.
• Resolve database performance issues, database capacity issues, replication, and other distributed data issues.
• Monitoring hadoop cluster and long running Jobs and communicate to users or application teams.
• Supporting Jobs which Translate and load unrelated data sets in various formats and sources like JSON, text files, Kafka queues, and log data.
• Coordinating with Users and helping them to understand the current environment and what would best suit their business requirement, which helps in delivering solutions with in their SLA.
• As a principal advisor was responsible for establishing standards best practices in data warehouse/architecture, data management, analytics, and business intelligence.
• Understanding, documenting and articulating the customer’s current data warehouse/data mart architecture. This includes a complete inventory of the customer’s data warehouses and datamarts as well as their respective business functions.
• Fine tuning applications and systems for high performance and higher volume throughput by advising optimization techniques in using big data tools.
• Assisting in trouble shooting integration and database connectivity issue in Python Jobs.
• Monitoring stats collection and proactively optimizing them as needed to help the queries to run efficient on system.
• Constantly research to improve the performance of the system by sharing any new changes/features available in the Teradata system, with the development team.
• Coordinating with Teradata vendor and customer development teams for major/minor upgrades and System changes.
• Conducting operational meetings every week and presenting the generated reports to the stake holders.
• Designed & Automated Data-Sync process between PROD & DR, Hut-locks release, BAR reports, etc.
• Work with developers and share automated process to easily identify and clean-up unused objects, which will reduce the space usage and improves the performance.
• Managing and maintain all Teradata production and non-production database systems.
• Perform production implementations and work with application developers to tune their SQL for standard coding practices and creating DBA policies, procedures and standards.
• Set Teradata standards w.r. Confidential database design, physical data storage, maintenance, access and security administration. Design and implement standards for monitoring; ensure database environment are running effectively, including backups and disaster recovery.
• Responsible for backup and recovery on DBMS.
• Provide mentoring and, along with technical guidance and direction to the teams.

Confidential

Tools: Teradata 13.10 & 14.0, 14.10, Confidential -VERTICA, Management Console, Viewpoint and datalab’s, Teradata Administrator, Teradata SQL Assistant, DB-Visualizer, DBD, TSET, BTEQ, NetBackup ( Confidential ), Putty, JIRA…

Sr Teradata DBA & Vertica DBA

Responsibilities:

• Setting up the Structure, Database, User, role, profiles, Space as per the Teradata & Vertica Best Practices.
• Database Version Upgrades, PDCR installations and migrations.
• Performance tuning &optimizing projections.
• Monitor Database growth & provide Database capacity planning for applications expansion.
• Automation of default value creation for DEVELOPMENT teams.
• DOWN AMP recovery and handling critical system failures.
• Active participation in Disk merge and power upgrades and floor sweep.
• Data copy using NAMEDPIPE, FE-ML mechanism.
• Hands on experience in Vertica SQL Analytics & Hands on experience on giant PRODUCTION / Development cluster.
• Running the PDCR Reports each and analysing them for better performance.
• Down node recovery, node addition for VERTICA cluster.
• Setting up system health reports, Node down alerts using shell script for Vertica cluster.
• Performing projection refresh, stats collection & Audit's.
• Preparing weekly, monthly & Quarterly production health report & presenting those reports to the customer.
• Support application development timelines by reviewing and assisting in the implementation of designs and/or incremental changes to database definitions.
• Assist with data models & data volumes to determine best possible Business solution.
• Review Multiload, Fastload, Tpt, Fastexport, BTEQ scripts.
• Actively monitoring the production system and identifying the poor performing queries and send to the application team and also analyse them if there is any tuning opportunity.
• Working on Automation of System Level Utilities like showspace, showlocks, and packdisk.
• Monitor Database growth & provide Database capacity planning for applications expansion.
• Participated in Teradata version upgrade (13 to 13.10, 1 & 14 to 14 to 14.10).
• Actively performing Teradata Quarterly maintenance and send notification to the business users.
• Proactively monitoring the production systems and acting accordingly for production issues.
• Work collaboratively within the database team and with vendors to resolve incidents and mitigate risks.
• Worked on PDCR migration (13 to 14 & 14.10).
• Proficient in creating Process Flows using Visio

Confidential

Tools: Teradata 13.10 & 14.0, 14.10, Viewpoint and datalab’s, Teradata Administrator, Teradata SQL Assistant, TSET, BTEQ, Netbackup ( Confidential ), Remedy.

Teradata DBA

Responsibilities:

• Designed and Implemented Disaster Recovery system.
• Automation of STATS collection, Deploying java UDF’s (custom) and Oracle UDF’s.
• Automation of User de-activation, Space alerts, CPU alerts, etc…
• Database refresh Activities between Teradata production and Non-Production Systems.
• Define Teradata database architectures and strategies to meet application availability, scalability and performance requirements.
• Setting up the green channel, which is higher priority workload in workload management to ensure that the most business critical finance reports run through this lane and meet the daily SLA.
• Working on Change Management, Incident Management, and Problem Management.
• Gathering query, CPU & disk resource requirements for new applications and extensions to existing systems.
• Working on compression (MVC) for qualified tables which will help in saving disk Space.
• Generating & analysing the PDCR Reports & planning appropriate action plan.
• Cleanup the unnecessary secondary index which are never been used in the system to improve the performance and minimize the ETL load time.
• Assisting TDCS during database upgrades by disabling Resusage, DBQL logging, Etc.
• Preparing weekly, monthly & Quarterly production health report & presenting those reports to the customer.
• Collaborate with other data architects, application development team members and/or DBAs to resolve issues.
• Communicate data design strategy, guidelines, principles and standards to the development teams.
• Actively monitoring the production system and identifying the bad performing queries and send them to the application teams and also analyse them if there is any tuning opportunity.
• Working on Automation of System Level Utilities like showspace, showlocks, and packdisk.
• Work with Teradata GSC in resolving RDBMS related incidents.
• Monitor Database growth & provide Database capacity planning for applications expansion.
• Participated in Teradata version upgrade (1 ) and also PDCR migrations.
• Researches and recommends optimal design criteria and best utilization of resources
• Collaborate with the DBA and System Administrator to ensure the data warehouse and BI systems adhere to Customer IT security best practices, protocols and standards.
• Participate in all phases of the SDLC including requirements gathering, design, development, testing, deployment and maintenance.
• Actively performing Teradata Quarterly maintenance and send notification to the business users.
• Ensuring all project team members have the tools and necessary to perform effectively.

Confidential

Tools: Teradata 13.10,Teradata manager, PMON, Viewpoint, Teradata Administrator, Teradata SQL Assistant, TSET, BTEQ, Netvault (Backbone), Clarify(AMDOC’s).

Teradata DBA

Responsibilities:

• Primary responsible of all prod and non-prod systems backup and restore activities.
• Manage, design, support, and consult on practices of storage management, archive, restore, and disaster recovery.
• Validating and monitoring Backups and performing recovery on request.
• Setting up the Structure, Database, User, role, profiles, Space as per the Teradata Best Practices.
• Responsible for constructing and/or optimizing physical database designs tailored for the Teradata information warehousing database environment in support of various strategic application development initiatives.
• Performance monitoring, investigating long running queries (query-spotlight) and tuning queries with the analysis of Business objects.
• Working on Change Management, Incident Management, and Problem Management.
• Running the PDCR Reports each and analysing them for better planning/tuning opportunities.
• Manage/Monitor system performance, including workload management and throttling in TASM, query performance and tuning, physical node behaviour, and amp distribution.
• Reviewing the projects in all the phases and migrating the database objects.
• Working closely with customer & Resolving different type of day to day customer’s issue & Provide suggestion and recommendation as per Teradata best practices.
• Extensive use of Viewpoint to monitoring the System health and using various portlets of Viewpoint for various task like data labs, Auto stats, Data Mover, query monitor, remove console (DBS Control, Ferret, Lock Display, Show locks, etc.).
• Preparing weekly, monthly & Quarterly production health report & presenting those reports to the customer.
• Overseeing the overall Data warehouse performance staring data sourcing, staging, journaling, schematic, Reporting and Extraction also ETL tuning and Report performance tuning.
• Provide timely, accurate administration & reporting & Handling SARS request/Pre-prod and PROD RFC implementation.
• Monitor Database growth & provide Database capacity planning for applications expansion.
• Co-ordinated in Teradata upgrades (disk-merge and power upgrade).
• Actively performing Teradata Quarterly housekeeping activities (packdisk, checktable).
• Working with Batch Supporting team for production database issues.
• Used TSET for copying the stats and other information and analyze the issue.
• Worked with BI Production Supporting team for production database issues.
• Performing regular BAR health checks (Netvault health check).
• Creating Teradata incident (P1, P2 and P3) for any database/hardware/system issues like AMP down, Node down, BAR issues, etc.