Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
jls
Starting Member
1 Post |
Posted - 2003-10-29 : 10:25:38
|
We are looking for a strong SQL Server 2000 Developer contractor with SQL Server application programming experience. The project is converting a FoxPro Database to Access / SQL Server 2000. Excellent SQL knowledge (SQL Scripting) developing many ad-hoc queriesbased on user requirements & / or converting logic from FoxPro & AccesscodeNo DBA workNo TriggersNo User Defined FunctionsNo Developer who users SQL Server only as a back end databaseNo one who uses DTS or Wizards to move data in and out of SQL ServerGood knowledge of SQL Stored procedures for complex logic queriesGood knowledge how to write good, efficient SQL codeGood knowledge how to write complex join queries (Inner Join, Left Join,Right Join)Good knowledge of SQL Server index tuning (from a programmers point ofview)Access VBA a plus (VBA, Forms, Sub Forms & Reports)Little to no travelScripts and code will be stored within SourceSafeSome documentation will be required (routines & execution steps)Mandatory Weekly status report (due EOD Friday)Must be able to work in a team environmentA test will be given to each candidate. A requirements document will be given thatwill require SQL Code to be developed to derive the correct results.Greg BlandfordJLS Technical Staffinggregb@jlssoftware.com |
|
MakeYourDaddyProud
184 Posts |
Posted - 2003-10-29 : 10:41:37
|
Perhaps the title should be SQL Developer rather than SQL Server 2000 Developer???Daniel Small MIAPwww.danielsmall.com IT Factoring |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-10-29 : 10:58:59
|
quote: Originally posted by jls No DBA work -- What does that mean?No Triggers -- Really? Why notNo User Defined Functions -- AgainNo Developer who users SQL Server only as a back end database -- Sounds like what you wantNo one who uses DTS or Wizards to move data in and out of SQL Server -- OKGood knowledge of SQL Stored procedures for complex logic queries -- Does that include cursors? Good knowledge how to write good, efficient SQL code -- What do you mean by effcient?Good knowledge how to write complex join queries (Inner Join, Left Join,Right Join) -- What no sub queries, derived tables, SELECT FROM (SELECT?Good knowledge of SQL Server index tuning (from a programmers point ofview) -- Tuning from an application developers point of view...clarity pleaseAccess VBA a plus (VBA, Forms, Sub Forms & Reports) -- ya thinkLittle to no travel -- Atlanta's a cool town gotta check out FadoScripts and code will be stored within SourceSafe -- good ideaSome documentation will be required (routines & execution steps) -- What no tech writer?Mandatory Weekly status report (due EOD Friday) -- No poject manager?Must be able to work in a team environment -- How many people on this teamA test will be given to each candidate. A requirements document will be given thatwill require SQL Code to be developed to derive the correct results.-- Is there only 1 answer?-- Didn't mention how long the gig is for...-- I'm assuming development must be done on sight-- relocation package?-- Why Access?
Brett8-) |
|
|
MakeYourDaddyProud
184 Posts |
Posted - 2003-10-29 : 11:01:35
|
Remember this guy is a recruitor he's just passing on the requirement!Daniel Small MIAPwww.danielsmall.com IT Factoring |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-10-30 : 00:46:24
|
But why no user-defined functions??!! Now how do I do cool stuff like parsing a CSV? Owais Make it idiot proof and someone will make a better idiot |
|
|
Amethystium
Aged Yak Warrior
701 Posts |
Posted - 2003-10-30 : 04:55:18
|
Wow... talk about jobs knocking on your door. I wish I could go for this. Would love to try out the United States for a few years.But never mind, the company I'm contracting for has offered me a permanent position so I'm going to do the sensible thing and opt for stability.Hope you find a suitable candidate soon! __________________Make love not war! |
|
|
|
|
|
|
|