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 12345»»»

How's this for a Job Description Expand / Collapse
Author
Message
Posted Wednesday, October 24, 2012 4:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 7:28 AM
Points: 5,584, Visits: 6,380
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 Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1376401
Posted Wednesday, October 24, 2012 5:48 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:53 AM
Points: 13,890, Visits: 28,285
<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
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1376416
Posted Wednesday, October 24, 2012 5:51 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:53 AM
Points: 13,890, Visits: 28,285
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
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1376417
Posted Wednesday, October 24, 2012 6:56 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 5:24 AM
Points: 1,265, Visits: 3,598

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.
Post #1376448
Posted Wednesday, October 24, 2012 7:00 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:49 AM
Points: 2,380, Visits: 7,589
Whoever sent that would go into my "junk" filter for all time.


Not a DBA, just 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


LinkedIn | Blog coming soon (for sufficiently large values of "soon" )!
Post #1376449
Posted Wednesday, October 24, 2012 7:32 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 5:41 PM
Points: 356, Visits: 918
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 ;)
Post #1376469
Posted Wednesday, October 24, 2012 7:36 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:53 AM
Points: 13,890, Visits: 28,285
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 ;)


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
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1376472
Posted Wednesday, October 24, 2012 7:46 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 13,872, Visits: 9,596
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
Post #1376483
Posted Wednesday, October 24, 2012 10:25 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:19 AM
Points: 40,208, Visits: 36,617
Well I certainly don't qualify. Good thing I'm not looking to change jobs....


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1376582
Posted Thursday, October 25, 2012 9:58 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, October 16, 2014 8:24 AM
Points: 258, Visits: 1,099
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.
Post #1377100
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse