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
Ludhiana05-2018
Bachelors of Computer Science -
Punjab University/ DD Jain College
Ludhiana05-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