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


Knowledgeable Mid-Level DBA - Westchester, IL


Knowledgeable Mid-Level DBA - Westchester, IL

Author
Message
Jared Karney
Jared Karney
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14344 Visits: 3697
We are looking for a very knowledgeable mid-level DBA for a company in Westchester, IL. Knowledgeable means strong t-sql, knowledge of DMVs, Extended Events, and knowledge of Systems (Kerberos, Active Directory, Clustering, and Virtualization as it all pertains to SQL).

We do not use the GUI, we rely on scripts so that we have more control. On day 1, if someone asks if there is blocking going on and what the cause is, we expect you to have your own scripts to determine if there is blocking, what process is blocking, why it is blocking, and the ability to see if there is a way to reduce it.

A large library of scripts is expected so that if we ask you to restore databases from one server to another, you will not have to prepare and type a whole new script to restore the database and move the files.

The difference here between this position and a senior level is your experience and your ability to lead people. We expect the knowledge to be equal.

Message me with any questions. Competitive salary, 401k, benefits, telecommute for a full week once every 6-7 weeks. Expected to be on-call 24x7 during that week for emergencies while still maintaining a 40-hour work schedule.

Thanks,
Jared
PFE - Microsoft
SQL Know-It-All
How to post data/code on a forum to get the best help - Jeff Moden
Jared Karney
Jared Karney
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14344 Visits: 3697
I wanted to add that I am not a recruiter, I am a part of the team and part of the decision making process. That is why my job description is real. I don't expect this candidate to know MDX, BI, VB script, etc. I also don't want someone with 15 yrs. experience who doesn't know the difference between simple and full recovery. This is a DBA position, not a Developer, BI, report writer, data mining, or project management position. This is to administer database servers and make sure that the code deployed on them is good.

Thanks,
Jared
PFE - Microsoft
SQL Know-It-All
How to post data/code on a forum to get the best help - Jeff Moden
Evgeny
 Evgeny
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1593 Visits: 785
Hi,

Will you consider someone who required visa sponsorship?
Lynn Pettis
Lynn Pettis
SSC Guru
SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)

Group: General Forum Members
Points: 98886 Visits: 38997
SQLKnowItAll (2/18/2014)
We are looking for a very knowledgeable mid-level DBA for a company in Westchester, IL. Knowledgeable means strong t-sql, knowledge of DMVs, Extended Events, and knowledge of Systems (Kerberos, Active Directory, Clustering, and Virtualization as it all pertains to SQL).

We do not use the GUI, we rely on scripts so that we have more control. On day 1, if someone asks if there is blocking going on and what the cause is, we expect you to have your own scripts to determine if there is blocking, what process is blocking, why it is blocking, and the ability to see if there is a way to reduce it.

A large library of scripts is expected so that if we ask you to restore databases from one server to another, you will not have to prepare and type a whole new script to restore the database and move the files.

The difference here between this position and a senior level is your experience and your ability to lead people. We expect the knowledge to be equal.

Message me with any questions. Competitive salary, 401k, benefits, telecommute for a full week once every 6-7 weeks. Expected to be on-call 24x7 during that week for emergencies while still maintaining a 40-hour work schedule.


Just a thought, but if you already rely on scripts for most work I'd expect you to have already established a library of such scripts to be used by the team such that each member doesn't have to maintain (write and provide) their own set but use the same set of scripts everyone on the team is using. perhaps even having these saved in a central DBA database that is maintained using a version of source control.

Sounds like an interesting position, too bad I am in Afghanistan until February 2015 (or at least that is the plan).

Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Jared Karney
Jared Karney
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14344 Visits: 3697
Lynn Pettis (4/30/2014)
SQLKnowItAll (2/18/2014)
We are looking for a very knowledgeable mid-level DBA for a company in Westchester, IL. Knowledgeable means strong t-sql, knowledge of DMVs, Extended Events, and knowledge of Systems (Kerberos, Active Directory, Clustering, and Virtualization as it all pertains to SQL).

We do not use the GUI, we rely on scripts so that we have more control. On day 1, if someone asks if there is blocking going on and what the cause is, we expect you to have your own scripts to determine if there is blocking, what process is blocking, why it is blocking, and the ability to see if there is a way to reduce it.

A large library of scripts is expected so that if we ask you to restore databases from one server to another, you will not have to prepare and type a whole new script to restore the database and move the files.

The difference here between this position and a senior level is your experience and your ability to lead people. We expect the knowledge to be equal.

Message me with any questions. Competitive salary, 401k, benefits, telecommute for a full week once every 6-7 weeks. Expected to be on-call 24x7 during that week for emergencies while still maintaining a 40-hour work schedule.


Just a thought, but if you already rely on scripts for most work I'd expect you to have already established a library of such scripts to be used by the team such that each member doesn't have to maintain (write and provide) their own set but use the same set of scripts everyone on the team is using. perhaps even having these saved in a central DBA database that is maintained using a version of source control.

Sounds like an interesting position, too bad I am in Afghanistan until February 2015 (or at least that is the plan).
:-) We do have a library of scripts, but we all also have our own. This is the first place that I have been that keeps this as a company, and we just started it. Plus, I will always have my scripts with me (Google Drive) no matter what, or at least know which sites to go to to get what I need.

It IS an interesting position, but you are probably a it more advanced than what we are looking for. Cool

Be safe over there!

Thanks,
Jared
PFE - Microsoft
SQL Know-It-All
How to post data/code on a forum to get the best help - Jeff Moden
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