SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Got called to interview for a PostgreSQL DBA job...


Got called to interview for a PostgreSQL DBA job...

Author
Message
sqldriver
sqldriver
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2156 Visits: 2536
Not by a recruiter, by one of the research heads at the company. Had a phone interview today.

My background for the last three years has been MS SQL querying and light DBA tasks, guided primarily by people asking me things and me asking Google and then fixing them. Prior to that, I've done quite a bit of help desk and general IT work. I got thrown at SQL because I had "Access dB" on my resume from 2003.

I've literally done nothing with PostgreSQL, but they want to see me for a live interview next week. They say they're fine with someone learning it on the job if they can demonstrate a certain level of technical ability beforehand. I just downloaded and installed a copy of PostgreSQL to play with, and I'll dive into the documentation tonight.

I'm not uninterested, and I realize it's premature to lose any sleep over switching dB flavors, but I was sort of curious if anyone here has any thoughts on the PostgreSQL world, any major differences between it and MS, etc. Prior to today I hadn't given it much thought.

Thanks
Beatrix Kiddo
Beatrix Kiddo
SSCertifiable
SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)

Group: General Forum Members
Points: 6837 Visits: 4830
Just wondering how this had gone, if you're still around?
sqldriver
sqldriver
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2156 Visits: 2536
Hi,

It apparently went well enough for them to offer me the job. I start on Monday.

I've been delving into some PG over the last few weeks, and I've found the basic stuff comparable to MS SQL (especially querying).

There's a lot I dislike about the way PG functions are written, and not having a native way to work with the file system (there's no xp_cmdshell equivalent, which probably makes some of you happy). Those things would have to be written with another language within a PG function.

Also, I haven't found any forums or how-to websites as vibrant and informative as this, and other MS SQL oriented ones.

I'm a little concerned about leaving the MS SQL ecosystem, but it's still a huge step forward from my current job. I'll be working on a massive data warehouse/reporting system for NYC public and charter schools.

Regards,
Erik
Beatrix Kiddo
Beatrix Kiddo
SSCertifiable
SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)

Group: General Forum Members
Points: 6837 Visits: 4830
Wow, congratulations! Good luck on Monday. It sounds like a good challenge.
Shey
Shey
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 15
Congrats on your new job!
sqldriver
sqldriver
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2156 Visits: 2536
Thanks. Just deleted 6gb of email. I feel like I lost 20lbs.
Shey
Shey
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 15
lol...I can relate to that feeling.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search