Cloud Support Engineer (Database Postgres Oracle)

Amazon

Given a graph represented as an adjacency list, write a function to perform a Depth-First Search (DFS) traversal starting from a given node. The function should print each visited node. Also, provide an example graph and demonstrate how your function would traverse it. Explain the time and space complexity of your solution. For example, consider the following graph: { 0: [1, 2], 1: [2], 2: [0, 3], 3: [3] } If we start the DFS traversal from node 2, the expected output would be: 2, 0, 1, 3 (or another valid DFS traversal order). Your function should: Take the graph (adjacency list) and a starting node as input. Implement DFS traversal. Print each visited node. Correctly handle cycles to avoid infinite loops. Analyze and state the time and space complexity of your implementation.

Amazon

Let's dive into a debugging scenario. Imagine you are working on a critical e-commerce platform used by millions of customers. During a peak shopping period (like Black Friday), you receive alerts indicating a significant slowdown in the checkout process. Customers are reporting that it takes an unusually long time to complete their purchases, and some are even experiencing transaction failures. This is directly impacting sales and customer satisfaction. Your team suspects a performance bottleneck somewhere in the system. The architecture involves multiple microservices, including a user authentication service, a product catalog service, an inventory service, a payment processing service, and an order management service. These services communicate with each other via REST APIs and message queues. The database consists of both relational (PostgreSQL) and NoSQL (Redis) databases. You have access to logging, monitoring tools (like Prometheus and Grafana), and distributed tracing (like Jaeger). How would you approach debugging this issue systematically, identify the root cause, and propose a solution? Be specific about the tools and techniques you would use at each stage. For example, walk me through what metrics you'd focus on, how you would narrow down the problematic service, and what steps you'd take to pinpoint the exact code or configuration causing the bottleneck. Provide specific examples of commands or queries you might use to gather data or test hypotheses. Also consider potential causes related to scaling, caching, database performance, and code inefficiencies. How would you ensure minimal disruption to the platform during the debugging process? How do you handle conflicting information or dead ends during debugging?

Amazon

Describe a time when you and a teammate had a fundamental disagreement about a project. What was the disagreement about? How did you approach resolving the disagreement? What was the outcome, and what did you learn from the experience?