SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL Server developer contract in Atlanta
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jls
Starting Member

USA
1 Posts

Posted - 10/29/2003 :  10:25:38  Show Profile  Reply with Quote
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 queries
based on user requirements & / or converting logic from FoxPro & Access
code
No DBA work
No Triggers
No User Defined Functions
No Developer who users SQL Server only as a back end database
No one who uses DTS or Wizards to move data in and out of SQL Server
Good knowledge of SQL Stored procedures for complex logic queries
Good knowledge how to write good, efficient SQL code
Good knowledge how to write complex join queries (Inner Join, Left Join,
Right Join)
Good knowledge of SQL Server index tuning (from a programmers point of
view)
Access VBA a plus (VBA, Forms, Sub Forms & Reports)
Little to no travel
Scripts and code will be stored within SourceSafe
Some documentation will be required (routines & execution steps)
Mandatory Weekly status report (due EOD Friday)
Must be able to work in a team environment


A test will be given to each candidate. A requirements document will be given that
will require SQL Code to be developed to derive the correct results.

Greg Blandford
JLS Technical Staffing
gregb@jlssoftware.com

MakeYourDaddyProud
Posting Yak Master

United Kingdom
184 Posts

Posted - 10/29/2003 :  10:41:37  Show Profile  Reply with Quote
Perhaps the title should be SQL Developer rather than SQL Server 2000 Developer???

Daniel Small MIAP
www.danielsmall.com IT Factoring
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 10/29/2003 :  10:58:59  Show Profile  Reply with Quote
quote:
Originally posted by jls


No DBA work -- What does that mean?
No Triggers -- Really? Why not
No User Defined Functions -- Again
No Developer who users SQL Server only as a back end database -- Sounds like what you want
No one who uses DTS or Wizards to move data in and out of SQL Server -- OK
Good 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 of
view) -- Tuning from an application developers point of view...clarity please
Access VBA a plus (VBA, Forms, Sub Forms & Reports) -- ya think
Little to no travel -- Atlanta's a cool town gotta check out Fado
Scripts and code will be stored within SourceSafe -- good idea
Some 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 team


A test will be given to each candidate. A requirements document will be given that
will 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?





Brett

8-)
Go to Top of Page

MakeYourDaddyProud
Posting Yak Master

United Kingdom
184 Posts

Posted - 10/29/2003 :  11:01:35  Show Profile  Reply with Quote
Remember this guy is a recruitor he's just passing on the requirement!


Daniel Small MIAP
www.danielsmall.com IT Factoring
Go to Top of Page

mohdowais
Sheikh of Yak Knowledge

United Arab Emirates
1456 Posts

Posted - 10/30/2003 :  00:46:24  Show Profile  Visit mohdowais's Homepage  Reply with Quote
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
Go to Top of Page

Amethystium
Aged Yak Warrior

Garden of Sakuntala
701 Posts

Posted - 10/30/2003 :  04:55:18  Show Profile  Visit Amethystium's Homepage  Reply with Quote
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!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000