Click here to monitor SSC
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
SQLKnowItAll
SQLKnowItAll
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3311 Visits: 3686
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
SQL Know-It-All

How to post data/code on a forum to get the best help - Jeff Moden
SQLKnowItAll
SQLKnowItAll
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3311 Visits: 3686
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
SQL Know-It-All

How to post data/code on a forum to get the best help - Jeff Moden
Evgeny
 Evgeny
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1318 Visits: 742
Hi,

Will you consider someone who required visa sponsorship?
Lynn Pettis
Lynn Pettis
One Orange Chip
One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)

Group: General Forum Members
Points: 26494 Visits: 38127
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)
SQLKnowItAll
SQLKnowItAll
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3311 Visits: 3686
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
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