October 24, 2012 at 4:27 am
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.
October 24, 2012 at 5:48 am
<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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 24, 2012 at 5:51 am
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 24, 2012 at 6:56 am
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.
October 24, 2012 at 7:00 am
Whoever sent that would go into my "junk" filter for all time.
October 24, 2012 at 7:32 am
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 😉
October 24, 2012 at 7:36 am
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 24, 2012 at 7:46 am
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
October 24, 2012 at 10:25 am
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
October 25, 2012 at 9:58 am
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.
October 26, 2012 at 2:00 am
I saw an advert for a contract here in the UK only last week and the agency stated
Must have 5+ years experience on SQL Server 2008 R2
Now, remind me, what was the release date for SQL Server 2008 R2? 😉
The problem is, the agencies nowadays don't have a clue about the positions they are recruiting for and throw in as many "buzz" words as possible. In fact, I would look at the Brandie's advert and feel for sure that it isn't a real job, same as the one i spotted, they're fishing for CVs so they can go contact your former employers touting for work 😎
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2012 at 4:59 am
Perry Whittle (10/26/2012)
I saw an advert for a contract here in the UK only last week and the agency statedMust have 5+ years experience on SQL Server 2008 R2
Now, remind me, what was the release date for SQL Server 2008 R2? 😉
That happened when SQL 2000 was released. And when 2005 was released. And there were a lot of "paper certs" applying for those jobs who claimed to have 10+ years in a software that was only 2 years old.
October 26, 2012 at 5:13 am
Perry Whittle (10/26/2012)
I saw an advert for a contract here in the UK only last week and the agency statedMust have 5+ years experience on SQL Server 2008 R2
Now, remind me, what was the release date for SQL Server 2008 R2? 😉
The problem is, the agencies nowadays don't have a clue about the positions they are recruiting for and throw in as many "buzz" words as possible. In fact, I would look at the Brandie's advert and feel for sure that it isn't a real job, same as the one i spotted, they're fishing for CVs so they can go contact your former employers touting for work 😎
still closer than
Solid knowledge of MSSQL Server 2003
:w00t:
__________________________
Allzu viel ist ungesund...
October 26, 2012 at 5:19 am
Seriously? You saw that one?
October 26, 2012 at 6:32 am
I saw a job advert a few months ago demending experience with PowerView. That piece of software was just released a few weeks on the market. So they probably wanted someone from the development team or an MVP 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 15 posts - 1 through 15 (of 60 total)
You must be logged in to reply to this topic. Login to reply