Ajay Vyas

• Working with business to gather new/enhanced requirements and provide solution designs.
• Develop and deploy the data pipelines using GCP services like Templates, Apache Beam, Dataflow, Cloud function, Cloud Scheduler,Cloud Composer, Cloud Storage and Apache Airflow for customer transactional data and product data.
• Object creation using the concept of partitioning, clustering, temporary table and materialized views.

• Handling the data related issues via Service Now like missing data, incorrect data, data redundancy etc in the Big Query and fixing them.
• GCP administration activities related to the file getting stuck in the cloud storage bucket, failure of the Dataflow jobs, cloud function issues, airflow jobs failure, DAG failures, data fusion not working, cloud storage issues and composer issues and fixing them
• Using gcloud CLI commands like gsutil, gcloud dataflow and other commands to simplify the process and using it for automation, if required
• Netezza DBA activities: Performance tuning using proper Distribution Keys, Zonemaps, Cluster Based Tables and Materialized views.
• Data migration using nzmigrate and CTAS mechanism.
• Data backup and restore activities.
• Data maintenance activities like grooming of the tables, data backup and updating the table statistics.
• Maintaining Workload Management using GRA, SQB and PQE mechanism.

• Handling the Netezza system effectively to avoid data blockage to the upstream systems.
• This role involved activities like data storing, data maintenance, data transfer, data loading, object creation and workload management which was fulfilled using Netezza utilities like usage of distribution keys while creating the table, Zonemaps, Statistics, grooming of the tables, commands like nzmigrate, nzrestore, nzbackup command, performance tuning, Workload Management using GRA, SQB and PQE mechanism along with Unix shell scripting to create automation.

Project: Shire Pharmaceuticals

• In this project, we were using Netezza Twinfin 6 to handle the patient's data coming through the ETL tool Informatica and processing it as per the user's requirements
• Netezza DBA activities: Migration of data using nzmigrate command and CTAS mechanism
• Data loading via external tables using nzload and nzmigrate command
• DDL and DML executions as per the request
• Data backup and restore using nzbackup and nzrestore command
• Performing regular maintenance activities like grooming and updating the statistics for all the tables in all the databases along
• Unix shell scripting for automation scripts.