Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.
 
  • Post
  • Reply
ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

Notorious b.s.d. posted:

wow some p. deece 6.5 figgies itt

no joke, I have fig envy; I need to up my fig game soon, maybe this year.

Adbot
ADBOT LOVES YOU

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

Emacs Headroom posted:

A lot of it is really just bay area money. A friend of mine just did a pretty thorough search and got a spread of offers from 1.25M over 4 years to 2M over 4 years (some had significany amounys in ISO form which depends on liquidity events and performance though)

I didn't talk to Netflix but my understanding is that they're aggressive also with offers, but comp entirely with base, so like a $400k salary and that's it.

I live in Seattle though. I think I could probably make a dece 6.5 if I shopped around, but I like the people I work with and I'm the tech lead of a pretty important team doing some cool green field cloud stuff. If it wasn't for those two things I'd be hitting the books for interviews

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

Congrats on dem figs and on a job you really enjoy. I really need to check out Chicago, it seems like a really cool place and its basically the only big city in america thats still affordable

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

Gazpacho posted:

"I hear you're looking to sell a house"
"That's right"
"So could you tell me what you paid for it?"

Not a great analogy since that information is public

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

Pollyanna posted:

how much stock should i put in glassdoor reviews e.g. https://www.glassdoor.com/Reviews/athenahealth-Reviews-E18207.htm it seems like theyre biased towards people unhappy with the company? but then again they have good information in them like that one review where the company called african american employees "AMFAMs" which is kinda weird

The only useful reviews on glassdoor are the negative ones, unless you really care what the HR plants have to say in their 5 star reviews (negatives? Sometimes we move TOO QUICK)


edit: for reference the lovely contracting company I used to work for had a higher review than this, 3.2 is pretty bad...

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

Pollyanna posted:

which still annoys me because a company should have loyalty to its workers over its profits

ahahaha

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

Penisface posted:

I wrote my resume in Google Docs, converted it to PDF and put the link to the PDF as a QR code on my business card. Not sure if this life hack gained me any offers, though.

A neat idea but you could just put your Linkedin URL since thats all Linkedin is

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

Penisface posted:

That would require a Linkedin account which I consider a sort of scrub thing to be honest.

¯\_(ツ)_/¯ Its a good way to accumulate recruiter spam and keep track of former co workers. I try and respond politely to people with interesting opportunities that I'm not ready for at the moment, and will probably go back to them and hit them up when its time to move on. Better than applying through someone's website.

I don't know why anyone would post articles or read those posted articles, but I find it odd if someone doesn't have an account and have used it to get more information about a candidate than would fit on a single resume page (please don't give me a resume with more than one page)

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

We might be hiring but I don't know much about the android team

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

FMguru posted:

there is only one thing you need to know about the android team

it is this:

lol

Well we have plenty of that so

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

Pollyanna posted:

never expect a company to give you a pay raise, theyd rather pull their own teeth out with pliers

They'll give you a raise it just probably won't match what you could get by jumping around. Especially if you're in a competitive market and they know you can do just that.

On the other hand, if you're looking for a promotion, it might be easier to find it at your current job where they know the kind of work you do.

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

TimWinter posted:

A friend shared this video with me and "That's what the money is for" has become a regular response to "well, X is a good idea but obviously so-and-so won't want to do it" at my workplace since then.

What I'm trying to ask is should I watch the rest of Mad Men or is being aware of this exchange enough

Season 1 was good but I was mainly into it for the setting

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

HoboMan posted:

what's a good bs answer for "what does your dream job look like?", all my dreams are long dead

hope they're a bunch of dorks and recognize this https://xkcd.com/1346/

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

Notorious b.s.d. posted:

job postings are an adverse selection problem just like job candidates -- the worst jobs go unfilled the longest

  • a dude who wants to pay someone $10/hour to work on wordpress is gonna have an opening for a looooooong time.

  • windows shops are universally horrible. every single one of them. in every way. low pay, bad management, insipid livestock for coworkers

edit: additionally, if you don't live in a "hot" area for software, most of the software jobs are gonna be pretty horrible. that's normal. don't get too depressed about it. there are probably good jobs hiding, you just gotta be persistent.

Can confirm; microsoft shops are garbage tier poo poo for idiots

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

It probably means nothing. Just like lovely real estate listings use meaningless unverifiable adjectives ("cute", "stunning"), boring companies that have nothing to offer need SOMETHING to talk about in their job ads

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

dragon enthusiast posted:

how acceptable of an answer is "I'm looking for a new job because my current job is in a backwater shithole and I want to move to civilization"

very if you phrase it differently.

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

qhat posted:

Not knowing about joins for a position that involves SQL, junior or not, is unacceptable. That's like admitting you don't know what inheritance is for a programming position.

just know the difference between left and inner and you'll be fine.

I've used cross join maybe a few times in my career, and basically never use anything else.

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

Symbolic Butt posted:

oh that's a good interview question, I have no idea :thumbsup:

Is it though? The whole point of a declarative language like SQL is that I don't give a gently caress how the tables are joined, I just want them joined like this. Some dorks in the 70s figured out the best way to do it, and as a sex-having brogrammer I benefit from their effort.

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

Sapozhnik posted:

well, if you have a seemingly-simple query that's taking forever to run then you're gonna end up looking at a query plan to figure out (a) what the root cause is and (b) what to do about the root cause

and you're going to need to understand how those types of join work in order to do something about it

lol if you think you're ever going to have a DBA who will actually help you with this sort of thing as opposed to impeding poo poo

Honestly the extent of my debugging slow queries is "Does the thing I'm joining on have an index? Should it?". I've looked at query planner output before but mainly just to look for sequential scans.

I wouldn't disqualify someone for not knowing exactly how databases work, given that they're designed for you to not need to know that. Unless they're a DBA or someone claiming expert-level knowledge of databases specifically.

Not to mention SQL is pretty common outside of the relational database world at this point: Bigquery, Spanner, Spark SQL, Hive. Just because someone claims they're good at SQL doesn't mean they know much about databases.

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

30k is insanely low, start shopping around.

1 year of experience isn't ideal to start looking but otoh if you can demonstrate that you've learned all the new-programmer basics (using source control, working with a team, some kind of process i.e scrum, etc) then thats the big concern most companies have: "we don't have time to train them"

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

Edgar Allan Pwned posted:

yes im in america.

Unfortunately the company I work for currently does not have a standardized process, or source control for work. I suppose I could try implementing something myself, just to show that I can. Ive used git before.

Additionally, I dont know if it matters but my actual title isn't programmer. It's "Discovery Technician". I work in e-discovery. But i often have to write programs or tools for the company. Tools that are actively being used. I've updated legacy python code to Powershell, written an auto updating tool, written ruby and python scripts to cull legal data. I guess my point is, i know my title isnt programmer but its a significant portion of my job.

Thats fair, then in interviews (and maybe cover letters) you should emphasize the amount of programming you do. Definently try and introduce source control and some kind of process (scrum, kanbahn, whatever). Both because that will look good to companies you interview with, and also because they're just good things.

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

Some dumb email spam posted:

Nerd Ninjas is looking for a Server Engineer to join our team! If tracking new ground in the gaming world excites you, this is the company for you! You’ll get to work on a project with novel mechanics targeting millions of concurrent users with a massive marketing budget that the world will know about when it launches. You don’t get opportunities like this every day.

We’re looking for a self-guided ninja who has a passion for video games and can spend the majority of the time working in their own dojo. We offer a signing bonus, competitive salary, benefits packages, bonuses, & other incentives as well.

If you’re interested in contributing to a ground breaking project out of our Bellevue office, let’s schedule some time to talk!

What a cute way of saying you're looking for people who work all the time! Haha sounds like such a fun place to work!!!

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

yeah just start doing it while you're looking for a new job. Preferably a real software shop instead of being the "computer guy" for some other office.

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

qhat posted:

double lol at one meeting room between 450 people.

Its cool, teams will just have meetings in their work area.

The office is no doubt open so other teams will get to listen in, this increases collaboration.

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

Shaman Linavi posted:

ive showed up to interviews in purple or rainbow shirts and got the stink eye
i think i need to go buy some white shirts since i don't have any that fit anymore

whats the name of that technique in fabric where its mostly one color but with little flecks of a different color like that? I've always liked the way it looks

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

Is there a tech scene in Chicago? It seems like a cool town but idk what the opportunities are like for a city of its size.

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

Relational databases definitely still have a place in the world, but work best as a view of the data, not the source of truth.

Sure you can shard things out almost indefinitely; but when you want to run analytics on your entire dataset, or subsets of that dataset; you're stuck stitching together partial results from thousands of databases.

The better approach (depending on your usecase of course) is to try and have a single event stream that can put data in multiple places, the database being one of them. A snappy UI can be driven off a SQL database while larger analytics can come from BigQuery/Redshift/Spark Jobs/Beam Jobs etc etc. Important changes made in the UI can be broadcast to that event stream (as well as the local database its using in some sort of "unofficial" change, to make the change seem immediate).

Using a single (or multiple) relational databases might be ok for awhile, but it doesn't take "Google" levels of data for this to be a problem. I work at a medium sized company trying to transition to this model, away from thousands of postgres instances across about 100 physical servers (with really beefy specs). The Postgres servers are fine (well, ok, not really) at delivering reports over relatively short time periods, but we constantly get requests from customers for reports across DB boundaries, or for long periods of time, and that really interferes with our transactional load.

Googling for Whatapp's architecture diagram reveals they do this: data gets put in a relational database but also in riak and probably in a bunch of other places they don't list on the public documents.

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

tk posted:

Do this it makes GDPR compliance real fun.

Yeah this is the wrench that gets thrown into the model. Its fun to talk about everything as an event and the ability to recreate the exact same state by re-streaming all events from the beginning of time. But what happens when a customer leaves? Or they have a retention policy?

We're working on cleanup jobs that just go through all the views and remove the relevant data; basically you have to violate the "immutable" part of the events. In an ideal world there would be "delete" events that would remove records from the views... but you still need to remove them from any copy of the event stream itself, so what can you do.

I guess the main point of the post was that saying "only google cares about this" is not true; its not hard to get too much data for a cluster of databases to no longer be the best solution. I don't even think its wrong for startups to design things from the onset this way. Maybe its a little resume-driven-development, but in their eyes they either grow to that scale or die anyway, so might as well plan to succeed.

I'm gonna be interviewing with a satellite imaging company next week. They produce about 5-10TB of imagery a day and deal with even more serious "big data" problems, so thats pretty exciting.

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

I think we're saying the same thing? Their main strength is OLTP but of course you can get away with running analytics on them as well, especially when the data is small. When our company was building this out, it was the mid aughts and it was a team of people who thought the database could solve everything (I've only been here for 2 years so this is second hand). So we have OLTP, OLAP and even a nightmarish web of triggers to create business objects as events are inserted into the database. Its a real triple threat and now machines are falling over.

As for how beefy the servers are, not that beefy by those standards. Ram on the order of dozens of gigabytes, no idea about the number of cores. As I understand it most of them were acquired several years ago and are getting on in age, leaving the company with a decision: Buy a new round of hardware, or move most of the data to cloud services.

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

please don't server shame

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

Notorious b.s.d. posted:

yeah this is not a fundamental problem in sql databases

this is a problem at your company. y'all should... stop doing that.

Yes... I know... we are in the process of stopping.

Its not a fundamental problem with relational databases, but it is a fundamental problem when you say "Relational databases can be used for anything so long as you shard them and use indexes". Which is how we started talking about this.

Notorious b.s.d. posted:

i think my smallest server at work has 768 gb. they are 1U boxes that we use for dumb cloud-type poo poo

you should definitely buy a new round of hardware, first, to buy you time for the multi-year transition to cloud services. that ain't exactly like flipping a switch or something

We're about a year into the transition, and even if we weren't its not up to me, I'm only on the software side of things.

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

jony neuemonic posted:

current job refuses to accept this idea or the reality of their situation. they’re absolutely certain they can just dump two decades of legacy crap into aws if they just try harder.

Because they realize once the immediate fire is put out the organization will go right back to creating a bunch of small new fires

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

Had a really strange "technical" interview today, with a satellite imaging company I really want to work for. I already had my preliminary chat with the HR recruiter, talked about my interests and background which are big data pipelines and geospatial systems (exactly what they need for the role), additionally I used to work at one of the companies that this company ultimately bought, so I was already familiar with some of their stuff.

Anyway, I get the call, and the connection quality is pretty bad and he has a slight accent, so off the bat I'm having a hard time understanding him. He tells me about the role again and asks about the project I'm working on. For awhile I think we're clicking, though he isn't saying much. I feel like I was able to answer every question he had about the project and my background, we're using a lot of the same technologies (we both use google cloud stuff), etc. He asks me if I have any questions, and honestly I don't really... I'd like to eventually get to some of the questions listed on the first page, but I'd rather do that in person, ideally with members of the team I'll be on. I've already chatted with a friend that works there, so I've got a pretty good idea about how things run.

Anyway, after that, the interview sort of just... ends. He says he'll pass along his feedback to HR, and that it was great talking to me (but in one of those canned ways)... It was scheduled to take 45 minutes but we get through it in 20, and I guess I get nervous when something goes really short because it could be a bad sign (or maybe they scheduled it longer to give me plenty of time for questions)

So I hope I get next steps or a "no" tomorrow.... I'm gonna be really bummed if they pass on me without even an in person interview... I honestly don't know what else I could have done. Phone interviews are the worst :(

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

Programming and Information Systems Services and Solutions(sssss)

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

Seconding (or whatever) the opinion that remote work sucks. Don't under estimate the importance of getting lunch with the team, after work beers, etc. Not only is it good to make personal relationships with your peers and possibly higher-ups, but these outings inevitably talk about work, and its a good time to shine especially if you're more junior (maybe you're not invited to the big design meeting, but you can always bring up ideas informally)

Also theres just the quality of life... I worked remote for about a year and found it incredibly isolating. Just getting out of the house and talking to people is important, even if you have a big network of family and friends. A lot of my friends and former coworkers that are still working remote have similar opinions: they never leave their house anymore.

Maybe you don't mind that, but I hated it.

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

MononcQc posted:

That definitely depends on personality, I find. I also think it's kinda bullshit if you have to hang out with people after work to talk about work in order to be good about work. I'd just get out of there and go for a place where coworkers can talk about something else than work when away from there.

Don't hate the player, hate the game. Happy hour isn't all about work, but being that work is the only thing everyone is guaranteed to have in common, it comes up.

I do agree that things can be different if the team is fully remote, thats a good point.

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

MononcQc posted:

the trick is to start with them on-site or in an expensive area, and then move out to a cheap place and work remote. many employers won't have the guts to cut your salary, they'll just keep it flat for years instead, but still higher than if you had a CoL-adjusted salary to begin with and then got many promotions

A lot of my friends did this when they moved back to new orleans. Can confirm pro strat

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

qhat posted:

Col adjustments lol. I thought being able to pull in the figures while living wherever was why people worked remote, practically the whole point in fact.

You can still pull in dece figgies it just might not be what your peers in a really expensive city make.

To put semi realistic numbers on it, say you have some employees making 120k in a place like New Orleans, while the same employee makes 160k in SF. 120k is enough to buy a really nice house in New Orleans and live a pretty good life, its also at the upper end of the salary spectrum, which means the employee is gonna be pretty loyal. Meanwhile, 160k isn't poo poo in SF and you'll never be able to buy a house.

At the end of the day they know they just have to pay you at the upper end of the tech salaries in the area. Maybe its not fair but you're not gonna do anything about it.

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

FamDav posted:

here's the buffer calculator if you wanted to find out how much of a haircut you'd have to take to live in the same place

https://buffer.com/salary/director-of-engineering-systems/high

i appreciate the honesty in telling me I'd get paid 70% less. that takes courage

Those salaries seem pretty low across the board...

Adbot
ADBOT LOVES YOU

ADINSX
Sep 9, 2003

Wanna run with my crew huh? Rule cyberspace and crunch numbers like I do?

FamDav posted:

both of them are targeting median salary in SF for the position.

I was looking at the software/senior software developer salaries. Idk what directors usually make

  • 1
  • 2
  • 3
  • 4
  • 5
  • Post
  • Reply