Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Got called to interview for a PostgreSQL DBA job... Expand / Collapse
Author
Message
Posted Friday, December 6, 2013 1:10 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 4:53 PM
Points: 488, Visits: 1,983
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
Post #1520724
Posted Wednesday, January 8, 2014 8:29 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 8:09 AM
Points: 507, Visits: 1,867
Just wondering how this had gone, if you're still around?
Post #1528914
Posted Wednesday, January 8, 2014 9:20 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 4:53 PM
Points: 488, Visits: 1,983
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

Post #1528948
Posted Wednesday, January 8, 2014 11:00 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 8:09 AM
Points: 507, Visits: 1,867
Wow, congratulations! Good luck on Monday. It sounds like a good challenge.
Post #1529005
Posted Friday, January 10, 2014 7:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, January 25, 2014 5:49 PM
Points: 3, Visits: 15
Congrats on your new job!
Post #1529799
Posted Friday, January 10, 2014 8:49 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 4:53 PM
Points: 488, Visits: 1,983
Thanks. Just deleted 6gb of email. I feel like I lost 20lbs.
Post #1529850
Posted Friday, January 10, 2014 10:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, January 25, 2014 5:49 PM
Points: 3, Visits: 15
lol...I can relate to that feeling.
Post #1529887
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse