Daily Archives: March 14, 2005

IT Jobs: Two Database Consultant jobs in Maine

Jobs

Database Production Support Consultant (1 year)

  • At least 4-5 years combined using both MSSQL and Oracle RDBMS
  • Experience with performance tuning and integrity via indexing, normalization/de-normalization, constraints, triggers, etc.
  • Understanding of database security and implementation using views, column level permissioning, and roles.
  • Experience with DTS, creation/maintenance of SQL jobs, and security from server to database (including use of NT Authentication as well as standard SQL login/password security)
  • Excellent debugging and communication (both written and verbal) skills required
  • Excellent organizational skills
  • Windows command line scripting and UNIX shell scripting including Awk
  • Ability to communicate technical issues in an understandable way to non-technical end users, and keep management informed of the status of issues.
  • Database maintenance including backup and recovery, space management, and consistency checks
  • Responsibilities to include monitoring existing production processes, identification of performance improvement opportunities in existing processes, completion of audits (daily through monthly), creation/maintenance of desktop procedures/instruction manuals for existing processes, assisting during testing of new processes, and maintenance of data dictionaries

 

Database Consultant (1 year)

  • At least 4-5 years combined using both MSSQL and Oracle RDBMS
  • Creation and maintenance of large data warehouse databases (up to 1TB)
  • Extensive development of stored procedures (containing complex business logic) and views
  • Experience with performance tuning and integrity via indexing, normalization/de-normalization, constraints, triggers, etc.
  • Understanding of database security and implementation using views, column level permissioning, and roles.
  • Excellent debugging and communication (both written and verbal) skills required
  • Excellent project management and organizational skills
  • Experience creating and updating technical documentation and following development methodology
  • Windows command line scripting and UNIX shell scripting including Awk
  • Experience acting as a liaison between non-technical business users to create appropriate business requirements
  • Data analysis experience helpful
  • Database maintenance including backup and recovery, space management, and consistency checks
  • Responsibilities to include monitoring existing processes to populate data warehouse, improving performance of existing SQL processes, assisting in the development of new processes for data gathering, completing project documentation, and development and maintenance of data dictionaries

 

For immediate consideration, please contact:

Anne Keehan

Partner

Brandywine Technology Partners

Phone: 302.656.6100 x225

Email: akeehan@btpartners.net

http://www.AcehAid.org

Code Camp III windup

Just Rambling

wowee! what a fun fun weekend. Even with a snowstorm there were a good 300 people at code camp on saturday. More on Sunday. There were even speakers who came from afar – Seattle (Rod Paddock who is speaking at Vermont.NET tonight), Chicago (Raj Das), North Carolina (Rob Zelt and Josh Carlisle), NJ (DonXML).

There were a lot of first time speakers and that went great! Dave Burke gave his presentation on Customizing .Text , which I couldn’t attend as I had a talk at the same time, and really enjoyed presenting. Dave got in a very scary accident on his way down and we were all happy to have him there and well.

Sam Gentile had to deal with my low powered laptop to do his .NET 2.0 demos since he had problems with his machine – but at least it worked!

I had fun with my talks. I did the security fundamentals talk again with a look at wse2.0 and love doing that one! I also got to try out two new talks. What’s new in ADO.NET 2.0 and  C# for VB programmers. They were both fun.

I know that during the ADO.NET talk, there was something I said, “hmmm – will have to check that out and blog it, but someone has to remind me” – I need the reminder because, as I expected, I don’t remember what that was – outside of checking the perf differences between using row add to add many rows to a table or using dataset merge and modify row state – as expected – no difference. I tried it with 400 new rows. So I have to find a better scenario for my demo!

The C#/VB talk was a total blast. Although the sessions were a generous 90 minutes, mine was before lunch. So at the point my talk was supposed to end, everyone just went and grabbed their lunch and came back and we played for another 45 minutes. Even though I don’t know the ins and outs of CodeRush too well, I spent about 10 minutes demoing it. I think it is a great tool for people who are used to one language and have to do some coding in the other. We got a little deeper into delegates than I meant to. I believe that delegates are the A#1 biggest hard to grok thing for VB programmers but I have found a way of explaning it that I think works. I think that I will get myself better versed in them and put together a session on delegates and event handling in .NET for VB programmers.

Thom Robbins did an extraordinary job putting this together!



http://www.AcehAid.org