May 11, 2006 at 10:37 pm
In June, I'm leaving my present position as Engineering Applications Developer at an aerospace firm based in southeast Houston, Texas, near I-45 at Beltway 8. To help make the transition as smooth as possible, I'm trying to help the company locate a developer who can take over an application that is currently in Access 2003 (about 60K lines of code), with data in SQL Server 2005.
I am moving the simplest forms to ASP.NET, and in the long term ASP.NET expertise will be invaluable.
In the near term, though, the developer must be able to do complex application development in Access. There are lots of class modules, wide use of OOP techniques, and nearly 250 tables. The developer must be able to support existing code, employing both bound and unbound forms. The developer must accept the notion of building a library of routines and making calls to existing routines wherever possible. Re-inventing the wheel is absolutely unacceptable. Inter-object communication in Access must be second nature to the developer, and the ability to refactor code to add power without breaking existing functions is essential.
In SQL Server we use DRI, stored procedures, and a few triggers. We maintain development, testing, live and training servers. A table of links in the Access MDB front end allows us to set the mode of the application and relink to tables in several different servers, including servers other than our own group listed above.
If you have any doubts whatsoever about being able to do industrial strength development in Access, please don't waste my time replying. If you're not already doing industrial strentgh development in Access, please don't waste my time replying. This is not a trainee position. This is a jump-in-with-both-feet-and-take-it-over-now position.
In case the numbers tell you anything, here's what we have:
329 Forms
47 Modules
891 Queries
80 Reports
64 Tables (local)
188 Tables (SQL Server)
There's some messy code, and there's a lot of really good code, although that's me judging my own code. You can't waste time turning your nose up at compromises made for reasons that someone would have to think a while to justify. The company needs someone who has one goal only: to get the job done.
It's a good setting, around lots of aerospace engineers and the atmosphere is pretty relaxed. They're articulate, and they trust people to know and do their jobs, because they know and do theirs.
Send your resume and introductory remarks to me at r_w_a_n_n_a_l_l_(at)_h_o_t_m_a_i_l_._c_o_m. Just remove the underscores and change (at) to @. I will review resumes and decide which ones I am willing to investigate further. If your resume merits followup, I will expect to see an example of your work before considering your for submission to the company.
There is no fee or commission involved in this. I am trying to get a head start to help the company. They are snowed under and have not started their search yet. I'm doing this because I've been developing in Access for a decade, and I have learned that it is difficult to find developers who can and will do top rate development in Access. I want all the lead time I can get finding a replacement.
Thanks for your attention.
May 15, 2006 at 8:00 am
This was removed by the editor as SPAM
May 15, 2006 at 5:06 pm
i would be the type to re-invent the wheel and migrate it to ASP.Net. I don't have much faith in Access when I can do everything it does, in SQL. Sure, messing with forms and using what's there is good, but dammit, to keep my skills honed, i don't want to be stuck using vba.
now if the requ was to migrate from Access 2003 to SQL Server 2005, you'd see my resume. and prolly everyone elses.
jmo.
May 15, 2006 at 5:13 pm
The careful reader will note that SQL Server is in fact the main repository of the data, and that the move to ASP.NET has begun.
May 17, 2006 at 4:10 pm
I am Microsoft Certified Profession (web applications) in asp.net 1.1, but I have expertise like 1 year on asp.net 2.0 even tough I havent certified yet, I have 3 years of experiencie in sql 200 and 6 months on sql 2005.
I havent programmed in Access but I am very expert on sql,asp.net, .net framework, using controls and so on.
There is a little problem, I live in Colombia, SouthAmerica.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply