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


How's this for a Job Description


How's this for a Job Description

Author
Message
Brandie Tarvin
Brandie Tarvin
SSC-Dedicated
SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)SSC-Dedicated (37K reputation)

Group: General Forum Members
Points: 37379 Visits: 9268
So I recently got this job description in the mail and at first glance it looks pretty good, but at second glance I wonder if this is another case of "picky employer" asking for the moon. Any thoughts?


1. SQL Server (troubleshooting, debugging, tuning and optimization of SQL queries and stored procedures) 2. Database administration (Replication, design experience with RDBMS. 3.DR: doing quality assurance of the database components released to production.
1. Will need to formulate a conseptual design for this team.
Assist development staff with the debugging, tuning, and optimization of SQL queries and stored
2. Design and implementation of database replication strategies for both internal and DR requirements procedures. Determine, implement, and manage database backup and recovery strategies, with focus on PIT recovery
2. Ongoing database performance tuning and upgrades, including: monitoring and evaluation of all database patches and service packs. Assist setting up clustered SQL Server Environment
3. Quality assurance of the database components released to production. Ticket deployments.
4. Enforce DBA standards to all the stored procedure deployed to production.
5. Provide operational support to the reporting database servers.
6. QA the server and do daily, monthly health check of the server
7. Setup and manage the maintenance and backup plans,
8. Setup jobs, give permissions, perform monitoring and tuning
9. Design and manage database import / export processes used to populate test databases and global data marts. Assist setting up mirroring and log shipping
10. Deploy and support DTS and SSIS packages. Transact SQL and stored procedure development
11. Database modeling and design functions. Create and maintain database ERD diagrams.
12. Research problems and recommend corrective actions. Assit management with resource capacity planning
13. Assist OLAP and Data Warehouse environment when assigned.
14. Implement and enhance database security using proven methodologies.
15. Understand and maintain database replication health for all reporting environments.
16. Manage DR environment for the reporting servers.
19. Mentor DBAs of a small team and provide guidance to all the production issues facing the team.

QUALIFICATIONS:
2. 7 or more years of database administration/design experience with RDBMS.
3. 4-6 years experience with MS SQL Server 7.0, MS SQL Server 2000, MS SQL Server 2005, MS SQL Server 2008/R2.
4. Experience with additional RDBMS.
5. Extensive experience in database and query tuning.
6. Proven experience with SQL Server in VLDB environment.
7. Proven experience using Transact SQL, Stored Procedure and UDF.
8. Experience with MS SQL Server DTS with up to 100 terabytes enviroment.
9. Experience with MS SQL Server backup and recovery techniques in a VLDB environment.
10. Experience with SQL Server replication services. Familiarity with SQL Server clustered environment.
11. Experience with SQL Server mirroring and log shipping.
12. Experience with setting up Disaster Recovery environment.
13. Prefer experience designing and implementing data warehouses, including experience with MS SQL OLAP services.
14. Demonstrated experience in troubleshooting and resolving database problems.
15. Demonstrated experience in tuning database and its objects. Understanding of databases indexes.
16. Understanding of database design practices, including database normalization concepts.
17. Prefer background in Microsoft networking.

Understand and maintain complex SQL Server replication implementation.
Assist management with database and.
Implement and enhance database security using proven methodologies.
Assist development staff with the debugging and optimization of SQL queries and stored procedures.
Ongoing database performance tuning and upgrades, including: monitoring and evaluation of all database patches and service packs.
Design and manage database import / export processes used to populate test databases and global data marts.



6.What conceptual design have you done.
Working with all Development, QA, BA teams that support these applications
Make their jobs run more efficitely due to the systems being up and running according to clients and endusers schedule.
The biggest business challenge they are faced with solving is purely from an operational perspective. They need these DBAs in order to maintain the level of performance that the system requires in order to run smoothly and correctly. They are a 24 x 7 operations and each release needs to meet deadlines that the customer has place on their applications. Each release is different in regards to timelines and there is no standard SLA.
Making sure their group is maintaining the integrity of the production servers in order to maintain optimal performance is their mission critical task. This position was created for a backfill. This backfill will put them at the right amount of head count in order to run their operations effectively.


Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)

Group: General Forum Members
Points: 97441 Visits: 33013
<insert curse words here>

Do I also have to sweep the floors, clean the toilet and maintain the stock portfolio?

That's a rather insane list of requirements. They better be paying well into six figures.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)

Group: General Forum Members
Points: 97441 Visits: 33013
Seriously, how many people on the planet have DTS experience with databases greater than 100tb? I mean, how many DBAs have experience at greater than 100tb, period, full stop? They better be paying really, really, high six figures.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
calvo
calvo
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: 3258 Visits: 4018

1. SQL Server (troubleshooting, debugging, tuning and optimization of SQL queries and stored procedures) 2. Database administration (Replication, design experience with RDBMS. 3.DR: doing quality assurance of the database components released to production.
1. Will need to formulate a conseptual design for this team.
Assist development staff with the debugging, tuning, and optimization of SQL queries and stored
2. Design and implementation of database replication strategies for both internal and DR requirements procedures. Determine, implement, and manage database backup and recovery strategies, with focus on PIT recovery
2. Ongoing database performance tuning and upgrades, including: monitoring and evaluation of all database patches and service packs. Assist setting up clustered SQL Server Environment
3. Quality assurance of the database components released to production. Ticket deployments.
...
QUALIFICATIONS:
2. 7 or more years of database administration/design experience with RDBMS.
3. 4-6 years experience with MS SQL Server 7.0, MS SQL Server 2000, MS SQL Server 2005, MS SQL Server 2008/R2.
...
6.What conceptual design have you done.


I even put it in MS Word to makes sure I Wasn't crazy. It's conceptual!
And one requirement of an employer is that they know how to count.

______________________________________________________________________________________________
Forum posting etiquette. Get your answers faster.
Cadavre
Cadavre
SSCrazy Eights
SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)SSCrazy Eights (8.9K reputation)

Group: General Forum Members
Points: 8922 Visits: 8490
Whoever sent that would go into my "junk" filter for all time.


Forever trying to learn

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better, quicker answers on SQL Server performance related questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/



If you litter your database queries with nolock query hints, are you aware of the side effects?
Try reading a few of these links...

(*) Missing rows with nolock
(*) Allocation order scans with nolock
(*) Consistency issues with nolock
(*) Transient Corruption Errors in SQL Server error log caused by nolock
(*) Dirty reads, read errors, reading rows twice and missing rows with nolock


Craig Wilkinson - Software Engineer
LinkedIn
Scott D. Jacobson
Scott D. Jacobson
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: 1310 Visits: 1020
Requirement 19 confirmed my suspicions. This is a team lead position. You need to understand and be able to do all these things b/c they expect you to delegate but, from time to time, you may have to get your hands dirty. This is a position for someone who wants to switch between management and technical hats quite regularly. I'd suspect it does in fact pay well into 6 figures as others have suggested.

At least, that's my 2 cents Wink
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)SSC Guru (97K reputation)

Group: General Forum Members
Points: 97441 Visits: 33013
Scott D. Jacobson (10/24/2012)
Requirement 19 confirmed my suspicions. This is a team lead position. You need to understand and be able to do all these things b/c they expect you to delegate but, from time to time, you may have to get your hands dirty. This is a position for someone who wants to switch between management and technical hats quite regularly. I'd suspect it does in fact pay well into 6 figures as others have suggested.

At least, that's my 2 cents Wink


Could be. I don't think so though. I think it's a technical lead position. It's what I did at my last company, although I didn't do or know that insane list of topics.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
GSquared
GSquared
SSC Guru
SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)

Group: General Forum Members
Points: 56997 Visits: 9730
Ask them what they really need the most. Judging from the required skills list, they're probably most interested in VLDB administration and DR, and some of the rest of it could be learned on-the-job, if it's even needed. VLDB admin is a rare enough skillset that it's probably the key to the whole thing.

As Grant mentioned, if they really do need one of the (estimated) three people on the planet who actually have all of the skills they are looking for, they better be willing to pay (and perk and benefit) in a big way for all of that. Anyone with all of those skills can pretty much demand whatever they want from an employer, because if you won't pay it, someone else will.

Other than the VLDB requirements, it looks like the usual shopping list. I'm surprised it doesn't seem to mention a degree being required.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
GilaMonster
GilaMonster
SSC Guru
SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)

Group: General Forum Members
Points: 221494 Visits: 46281
Well I certainly don't qualify. Good thing I'm not looking to change jobs....

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Gail Wanabee
Gail Wanabee
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1819 Visits: 1406
I've seen worse. In addition to most of that job description, I've seen additional requirements for concurrent experience and responsibilities for:
1. Cisco router and switch admin
2. VMWare admin
3. Windows Server admin
4. Network admin
5. Security admin
6. Exchange Server admin

...and more, all in the same job description.

These types of jobs are truly 24x7 - for you, the prospective employee. You should plan on giving up sleep or having a life. Even if they pay well, your employer will expect to own you.

I know times are hard and employers are squeezing employees for more productivity but some of the job descriptions seem to be approaching the lunatic fringe.
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