Summary
Overview
Work History
Education
Skills
Websites
Languages
Certification
Accomplishments
Timeline
Generic
RICHA ARORA

RICHA ARORA

Gurgaon

Summary

Cloud Database Engineer specializing in troubleshooting complex data issues and optimizing cloud data warehousing solutions. Collaborates with data engineers and analysts to enhance customer experiences by delivering tailored solutions that ensure efficient cloud deployments and data integrity.

Overview

8
8
years of professional experience
4
4
Certifications

Work History

Cloud Support Engineer

Amazon Web Services Pvt. Ltd
05.2022 - Current
  • Provided expert technical support to clients using data warehousing solutions in cloud environments, such as Amazon Redshift, and utilized Quicksight to build customized dashboards that enhance data insights.
  • Resolving complex technical issues related to cloud infrastructure, networking, security using other AWS services like IAM, EC2, Athena, Glue, VPC, S3, Cloudtrail etc
  • Working on monitoring services like AWS Cloudwatch, AWS Grafana and AWS Prometheus
  • Assisting in the design and implementation of cloud-based solutions for customers, ensuring scalability and reliability
  • Assisting in data migration and integration projects, ensuring smooth transitions to the cloud-based data warehousing solutions
  • Troubleshooting and resolving complex data-related issues, including data ingestion, transformation, and analytics processes
  • Monitored and optimized data warehouse performance by identifying bottlenecks and implementing recommended improvements to enhance overall system efficiency.
  • Collaborated with customers to assess data warehousing requirements and delivered tailored solutions that effectively addressed their specific needs.
  • Conducting proactive health checks and periodic assessments to ensure data integrity, security, and compliance
  • Collaborating with data engineers, analysts, and data scientists to deliver comprehensive data solutions for customers
  • Responded to customer inquiries and incidents through tickets, emails, and live chat/calls.
  • Participating in on-call rotations and incident management to ensure uninterrupted cloud support operations.
  • Utilized Quicksuite to automate various tasks and workflows.
  • Developing and maintaining documentation and knowledge base articles for data warehousing best practices and issue resolutions

Teradata Database Administrator

NCR Corporation Pvt. Ltd
07.2018 - 05.2022
  • Conducted performance monitoring and tuning, optimizing complex SQL queries to enhance overall database efficiency
  • Created and modified users, databases, tables, roles, and profiles to support secure and efficient database management
  • Granted and revoked privileges for users and roles on database objects to ensure secure access.
  • Managed statistics for database tables, columns, and indexes to enhance query performance.
  • Database capacity management (space management PERM, SPOOL, TEMP)
  • Proactively monitored database sessions to ensure optimal performance and resource utilization.
  • Monitored system for resource-intensive queries, coordinated with cross-functional teams for timely corrective actions
  • Work with developers promoting their code and solving day to day issues
  • Gained experience using Teradata tools such as Viewpoint and SQL Assistant for database management.
  • Backup and Restore Activities –BAR activities using ARCMAIN scripts and BARDSA –Netbackup)
  • Monitoring and troubleshooting scheduled Teradata Utility jobs failures

Education

Masters of Science - Information Technology

Punjab University/ S.C.D. College
Ludhiana
05-2018

Bachelors of Computer Science -

Punjab University/ DD Jain College
Ludhiana
05-2016

Skills

  • AWS architecture
  • AWS Cloud and Cloudtrail
  • AWS Redshift
  • S3 and Athena
  • VPC and EC2
  • IAM
  • SQL
  • Teradata
  • Data warehousing
  • SQL optimization
  • Performance tuning
  • Serverless computing
  • Cloud infrastructure
  • Disaster recovery planning
  • Cost optimization
  • Customer collaboration
  • Microsoft 365
  • QuickSight/ Quicksuite

Languages

English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Punjabi
Proficient (C2)
C2

Certification

AWS Certified Solutions Architect - Associate

Accomplishments

AWS Customer Obsession Award

Timeline

Cloud Support Engineer

Amazon Web Services Pvt. Ltd
05.2022 - Current

Teradata Database Administrator

NCR Corporation Pvt. Ltd
07.2018 - 05.2022

Masters of Science - Information Technology

Punjab University/ S.C.D. College

Bachelors of Computer Science -

Punjab University/ DD Jain College
RICHA ARORA