SUMMARY

• Working for IT industries for 10 years, Excellent field of experience as Database administrator (DBA) as well as Database Support Consultant in Teradata, Vertica for high volume of data. Wide experience in Teradata from version 12.0 through 16.10 & Vertica 7.1.
• Extensive practical hands - on experienceas DBA in Setting up the Structure, Database, User, role, profiles, Space as per Teradata Best Practices.
• Hands on experience of CPPT & PDCR (Performance data collection and reporting) installation, migration, configuration, troubleshooting and reporting.
• Participated in 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 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. 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.
• 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
• ManagedTeradata View point 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.
• Generating TSET report for day to day Teradata incidents and also importing data demographics/Stats using TSET.
• 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.
• Provide mentoring and education, along with technical guidance and direction to the teams
• Hands-on SYSYINIT,TDPUT,TVS(Teradata virtual storage) & TIM(HeatMap Udf).
• Good communication, Leadership quality, client interaction, presentation skills and comfortable with 24/7 working days.

TECHNICAL SKILLS

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

Programming Languages: PL/SQL, SQL

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

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

Backup tools: Netvault, Netbackup(DSA,DATADOMAIN,TARA)

PROFESSIONAL EXPERIENCE

Confidential

Lead 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 analyze 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.
• 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.
• 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 cleanup 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.t 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 routine Tier 2 on-call support.

Confidential

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.
• Perform space capacity planning, forecasting & analysing the Memory and I/O Confidential Resource pool level in Vertica.
• Support application development timelines by reviewing and assisting in the implementation of designs and/or incremental changes to database definitions.
• 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).
• Proactively monitoring the production systems and acting accordingly for production issues & managing the verica licenses.
• Work collaboratively within the database team and with vendors to resolve incidents and mitigate risks.
• Worked on PDCR migration (13 to 14 & 14.10).

Confidential

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.
• Actively performing Teradata Quarterly maintenance and send notification to the business users.

Confidential

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.
• Preparing weekly, monthly & Quarterly production health report & presenting those reports to the customer.
• Handling SARS request/Pre-prod and PROD RFC implementation.
• Releasing the HUT lock, Fastload and Mload lock if any.
• 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.

Confidential

Junior Oracle & Teradata DBA

Responsibilities:

• Creating the database, tables, data objects, setting privileges, indexes, user logins, passwords (security).
• Monitoring System for performance issues (long running SQL, Product joins, etc…) and balancing the load on production server.
• Responsible to resolve problems assigned per help desk queues.
• Monitoring and creating backup and restore Netvault jobs.
• Setting up of automated Jobs for system maintenance tasks.
• Fixing the drive or media issues of Netvault tool and performing BAR health check.
• Releasing user locks and resetting their passwords.
• Supported the all types of testing activities of the application before moving to the production Box for batch jobs and critical user queries.
• Monitor Database growth & provide Database capacity planning for applications expansion.
• Written shell scripts to get automatic notifications for DB space (perm crossed 70%), DB restart, Top 20 space consuming tables, Top 10 Big databases, etc…
• Allocate and modify Teradata database space as required.
• Performing housekeeping activities like CheckTable, Scandisk, Packdisk using Ferret Utilities.
• Worked on PDCR installation (13).
• Monitoring the hung/Blocked sessions and taking the action accordingly.
• Releasing the Fastload and Mload lock if any.
• Proving 24/7 on-call support based on requirement.