Suggestions for tackling scaling issues

I have 4 years of experience and I feel I am pretty good at what I do but how do I scale up from here, how do I learn new things? Please suggest and help me out

Hi all, Wanted to know the size of database in your respective orgs and choice of db. Also pls mention any challanges faced while scaling it Mine Main db around 3 terra bytes ( no sharding so on a single node with replication) Choice of db maria db

Just how do you scale? Do you use AWS auto-scaler for that?

Am I being overpaid? I am a backend engineer with 7 years of experience. I've been rejected by multiple organizations during salary discussions. They mentioned they can't provide such a high salary. Are my expectations inaccurate? Current CTC: 45 LPA Expected CTC: 54 LPA Designation: Team Lead, Backend

Today, I took a test for the role of Business Analyst at Meesho. The test consisted of three questions, with the first two being moderate in difficulty compared to the third. The first two questions were multiple-choice, requiring me to find bugs in the code. However, the third question was significantly more challenging, as it required writing an advanced SQL query, which was something I had never encountered before. I understand that it's common for startups to set challenging test papers, but I'm looking for advice on how to tackle advanced SQL queries and how to practice them effectively

Ask me anything except my company name, or things that can reveal my identity. I may respectfully choose not to respond to your question based on my own judgement. Here’s a brief intro about me: I’ve worked as both software engineering manager & software technical architect over the last 18+ years on various tech stacks managing backend, frontend and a little bit of cloud. I have seen ups and downs in the software industry. Currently I’m working as a senior architect in one of the product based companies in India.

Interesting thread from previous post on If candidate be asked un realistic problems in the interview How do handle 100k RPS/s scale? I believe such questions just to test if candidate can think and apply certain software engineering design principles at hand. Understand approach how do they handle corner cases ( if they can identify) technical depth, also good way to test fundamentals. For eg https://www.morling.dev/blog/one-billion-row-challenge/ https://github.com/gunnarmorling/1brc Such problems really pushes candidates to thier limits. I love to go deep in OS & database, distributed systems. Would love to see, discuss what interesting tough engineering problems you folks ask in interviews? #tech #softwareengineering

I work for a growing startup in Bangalore. The data team size is very small with no data lead. Not a single query we hit the DB gives any result. Owing to cost cutting my firm has cut down the instance size and they're planning to downgrade the DB too. We data analysts are relying on the data engineering team to fetch us results for our queries which takes a long time to get a single table. This is highly inefficient. The data size is growing at a massive scale however the analytics efforts are trickling down due to poor infrastructure. Is this happening in your data team too? How can I solve this problem given there are no experienced data leaders in our firm to voice out.