Grishma Parmar

http://in.linkedin.com/in/grishmparmar/

973-***-**** © aczgvh@r.postjobfree.com

SUMMARY

Grishma has over 7 years of experience in Teradata, Hadoop & Aster Database Administration, Performance Tuning, User/DB Management and Installation & Configuration of PDCR, Linux. I possess strong abilities in administration of large data clusters in big data environments and am extremely analytical with excellent problem-solving. I possess a Bachelor's Degree in Information Technology over and above Cloudera Hadoop Administrator certification.

AREA OF EXPERTISE

Expert Skillset consisting of sound knowledge and certifications in Hadoop, Teradata as well as Aster Data.

Experience in Performance Optimization and Production DBA support using Teradata SQL, BTEQ & Teradata Viewpoint Utilities.

Upgradation of Teradata Database from 12 to 13.10, 13.10 to 14.10 & 14.10 to 15.10.

Experienced in installation of PDCR on Teradata 12

Experience in large scale multi-terabyte system backup and recovery using TARA, TIVOLI, NETVAULT & Mainframe

Experienced in Hadoop Cluster Building as well as Maintenance, Teradata Database Administration, Aster Data Administration

Upgradation of Cloudera Hadoop cluster from CDH 5.5 to 5.7 & corresponding CM versions.

Upgradation of Aster Database from 5.10 to 6.00

Experience in implementing High Availability (HA) of Hadoop Name Node and various services like HDFS, HBASE, etc.

Implementing and Configuring Kerberos Security Authentication on Hadoop Clusters.

Experience in Monitoring the Hadoop Cluster via Cloudera Manager, Ganglia & Nagios.

Experience in monitoring Aster via Aster Management Console, Ganglia & Nagios.

SKILL SET

TERADATA – Tools & Utilities

BTEQ, Fastload, Multiload, Fast Export, SQL Assistant, TD Administrator, TD Manager, Viewpoint, ARCMAIN, TARA, Tivoli, NetVault, MainFrame.

HADOOP – Tools & Utilities

Cloudera Hadoop, Cloudera Manager, HDFS, YARN, MapReduce, Impala, Hive, Sqoop, HBASE, Ambari, Pig, Spark, Zookeeper, Scala, Python.

ASTERDATA – Tools & Utilities

ACT, Monitoring via AMC, Monitoring via Ganglia, nCluster_export, nCluster_import, BAR, TD STUDIO, Nagios.

RDBMS

AsterData 5.10, 5.0, Teradata TD 15.10, TD 14.10, TD 14.0, TD 13.10, TD12, Oracle9i.

Operating Systems

Windows, Linux, UNIX.

Certifications

Cloudera Certified Administrator for Apache Hadoop (CCA - 500)

Hortonworks Certified Apache Hadoop Administrator

Oracle Certified Java 6 Developer

Teradata 12 Physical Design and Implementation

Teradata 12 SQL

Teradata 12 Basic

Oracle 9i OCP

Lean Competency

WORK EXPERIENCE

Barclays – USA & UK March 2015 – Feb 2017

Data Warehouse DBA (Hadoop / Teradata)

Project Synopsis: Barclays has multiple Hadoop Clusters dedicated for individual business verticals. It also has a large Teradata Warehouse which is used by various teams to store important data including customer details, client details, account details, etc. There are connectors used to ensure smooth flow of data to & from the Teradata and Hadoop systems.

Responsibilities: Teradata

Performing Code Review (analyzing the scripts provided by developers and providing corrections)

Performance Tuning.

Working closely with the L3 and upper management for upcoming Upgrade.

Work closely with Teradata GSC team for issue resolution and Incident Management.

Monitoring the system for resource intensive queries, blocking and coordinating with different teams across the client for corrective actions.

Proactive resolution and Analysis of job blockings/Long running jobs in Development, Test, and Production environments and advising support team about long term fix.

Addressing the performance issues related to CPU, I/O, Data skew.

Creating Teradata objects like Databases, Users, Profiles, Roles, Tables, etc. as per application requirement.

Proficient in using Viewpoint, Teradata Manager & Teradata Administrator tools.

Troubleshooting & administering the Teradata Databases.

Providing support to the ETL and other developers.

Creating & Managing Databases/Users, Roles/Profiles.

Space Management.

Providing on-call support after business hours & over the weekend.

Defining and scheduling statistics collection and monitoring the stats collection process.

Dropping Databases / Users with proper approvals verifying the dependency before dropping.

Granting & Revoking of Object Rights, System Rights on Databases / Users / Roles.

Responsibilities: Hadoop

Installing, Configuring and Setting up Hadoop Clusters. (Dev, Test, Non-Prod, Prod)

Performing Hadoop Version Upgrades (from 5.5.2 to 5.5.7 starting with Non-Prod moving to Prod)

Implementing High Availability of Name Node and Hadoop Cluster capacity planning to add and remove the nodes.

Implementing & Configuring Kerberos Authentication.

Managing, Monitoring & Maintaining the Hadoop systems.

Worked with the client team for performing analysis using Spark & Scala.

Implementing and Configuring SQOOP connectivity between Hadoop and Teradata.

User Management and user activity management with Navigator API for security compliance.

Configuration of HA for various Hadoop services like HDFS, HBASE, YARN, ZOOKEEPER.

Resolving issues related HIVE, IMPALA, SQOOP and other Hadoop services.

Installation of RHadoop packages.

Executing R jobs on Hadoop clusters.

Developed Hive queries for the analysts.

Coordinating with different teams and Vendor Partners for delivering effective & efficient deadlines.

Environment: Teradata 15.10, Teradata 14.10, NetVault, Mainframe, CyberArk and Cloudera Hadoop.

Teradata Corporation Jan 2010 – Feb 2015

Associate Technical Consultant

Chubb Group of Insurance Companies, Warren, NJ Jan 2014 – Feb 2015

Team Lead

Project Synopsis: This project was related to AsterData technology. Client used this technology in order to perform predictive analysis on their data and achieve their goals.

Creating, maintaining, and supporting AsterData Environment.

System monitoring through Aster Management Console.

Incorporated the new physical database structures.

Created and monitored backup jobs using AsterData Backup Server.

Handling & Resolving BAR issues.

User & Access Management.

Documented BAR related issues with solutions.

Co-ordination with GSC team for resolving issues.

Active member during the Aster Database Upgrades to 5.10.00.01, 5.10.00.03 & 6.00.01.

Implementation and Scheduling of Audit Scripts.

Performing Vacuum & Analyze on System Catalog Tables.

Value adds:

Automation of Daily Logical level backups.

Downloading and Installation of some SQL-MR functions.

Configuring and debugging AnyDatabase2Aster SQL-MR function.

Environment: AsterData 6.00.01, Aster Management Console (AMC), Ganglia, nCluster_import.

AEG Worldwide, San Francisco, CA Nov 2012 – Dec 2013

Team Lead

Project Synopsis: Client used to load its data from flat files into the Teradata Data Mart and use it for promotions and marketing their products and offers to attract potential customers and increase its revenue.

Team Lead for the Operational Team.

Played an active role in upgrade from Windows based TD 12 to SLES based TD 14. Was involved in all stages right from planning to post upgrade regression testing to final handover.

Creating and driving Weekly IRA Calls.

Creating, analyzing and driving Monthly Report calls with client.

Worked on user, database, roles creation requests, along with ETL monitoring and error solving.

System monitoring through Viewpoint.

Providing on-call support after business hours & over the weekend.

Value Adds:

Performance Tuning for long running queries.

Environment: Teradata 14.0, Teradata 12.0, Viewpoint, Teradata Manager, Teradata Administrator.

Meredith Corporation, Des Moines, Iowa July 2012 – Jan 2014

Team Lead

Project Synopsis: Client used the Teradata Data-Mart to load data from their spreadsheets and flat files and use it to generate important reports.

Worked on user, database, roles & profile creation request.

System monitoring through Viewpoint.

Handling user request for tuning queries, space management etc.

Creating and driving Weekly IRA Calls.

Creating, analyzing and driving the Monthly Reports Calls.

UDF installation and debugging.

Designing and Implementing Backup Strategy using TARA and NetBackup.

Creating, analyzing and driving the Quarterly Reports Calls.

Addressing the performance issues related to CPU, I/O, Data skew.

Value Adds:

Performance Tuning for long running queries.

Environment: Teradata 13.10, Teradata Administrator, Teradata Manager, Teradata SQL Assistant.

Accenture Analytics Subscription Environment (AASE) Oct 2011 – July 2012

Project Synopsis: Client had purchased this Teradata system and provided it to their clients on resource sharing basis. This was a multi-tenant system and its resources were shared between multiple third party clients.

Monitoring the system for resource intensive queries, blocking and coordinating with different teams across the client for corrective actions.

Creating Teradata objects like Databases, Users, Profiles, Roles, Tables, etc. as per application requirement.

Performing Code Review.

Handling Planned and Unplanned Outage communication and co-ordination with different teams across client for the duration of downtime and following up with Teradata GSC for rot cause analysis.

Generating reports using PMCP/PDCR for capacity planning and for reactive actions for any performance impact.

Defining and scheduling statistics collection and monitoring the stats collection process.

Dropping Databases / Users with proper approvals verifying the dependency before dropping.

Granting & Revoking of Object Rights, System Rights on Databases / Users / Roles.

Proactive resolution and Analysis of job blockings/Long running jobs in Development, Test, and Production environments and advising support team about long term fix.

Performing the restore operations whenever requested.

Work closely with Teradata GSC team for issue resolution and Incident Management.

Proficient in using Viewpoint, Teradata Manager & Teradata Administrator tools.

Perm/Spool Space Management

Access rights/Roles/Profile maintenance.

Active Member for the Downgrade of a Node.

Environment: Teradata 12, Teradata Manager, Teradata Administrator, Teradata SQL Assistant.

CVS Caremark, Dallas, TX Dec 2010 – Sept 2011

Project Synopsis: Client used this Teradata system as its only enterprise data warehouse. They used to load data into the system and used it for various purposes including end-users.

Working on 24*7 Support Environment managed by strict Service Level Agreements with time limits for ticket acknowledging, ticket resolution/Escalation.

Data refreshed across different Teradata production and non-production environment by using Teradata Arcmain scripts.

Dropping Databases / Users with proper approvals verifying the dependency before dropping.

Granting & Revoking of Object Rights, System Rights on Databases / Users / Roles.

Monitoring resource, CPU usage and Users activity using DBQL data.

Monitoring and resolving session blocking.

Creation of databases, determining logical and physical Databases as per business requirement reviewing for any performance impact.

Creation of users and mapping appropriate roles as per application requirements following standard firm policies

Active member for the Node Addition and Upgrade from TD 12 to TD 13.10

Coordinating changes to databases environment and oversee that upgrades have been carried out and being in part of different Teradata software upgrades and hardware node level expansions.

Environment: Teradata 12.0, Teradata 13.10, Teradata Manager, Teradata Administrator, NetBackup.

CVS, Providence, RI March 2010 – Nov 2010

Technology: Teradata 12, Teradata 13.10

Project Synopsis: Client used this Teradata system as its only enterprise data warehouse. They used to load data into the system and used it for various purposes including end-users.

Working on 24*7 Support Environment managed by strict Service Level Agreements with time limits for ticket acknowledging, ticket resolution/Escalation.

Data refreshed across different Teradata production and non-production environment by using Teradata Arcmain scripts.

Dropping Databases / Users with proper approvals verifying the dependency before dropping.

Granting & Revoking of Object Rights, System Rights on Databases / Users / Roles.

Monitoring of databases/sessions using Performance Monitor.

Active member for the Node Addition and Upgrade from TD 12 to TD 13.10

Environment: Teradata 12, Teradata Manager, Teradata Administrator, Fast Load, Multi Load, Arcmain, Tara, Tivoli.

EDUCATION

Bachelor of Science - Information Technology S.I.E.S College of Commerce & Economics, Mumbai

Trainings:

At Barclays –

Cloudera Hadoop Administrator

At Teradata -

Hortonworks Hadoop Developer & Administrator

Teradata Mixed Workload Design

Teradata Mixed Workload Optimization

Teradata Database and Architecture

Teradata Performance Tuning training

Teradata tools and utilities BTEQ, Teradata Manager, Teradata Administrator, Viewpoint etc.

ACHIEVEMENTS

Awarded with Teradata Employee of the Quarter Q1-2014 for exceptional performance for a client.

Contact this candidate