OT: Database Programmer

From: Stephen Haywood 
A friend of mine at church is looking to fill a Microsoft database
programmer position. They are migrating from an Access app to web-based SQL
app. If you are interested you can go to
http://www.komatsuamerica.com/careers and look up the jobs for Chattanooga.

Komatsu America Corp. (KAC) is the second-largest, fully-integrated
manufacturer and supplier of construction equipment in North America with a
reputation for reliability that=92s second to none. We have built a network
of manufacturing plants and parts depots with approximately 2000 employees
who manufacture more than 90% of all Komatsu America equipment right here
in the United States.
Our product line ranges from the smallest compact construction size to the
largest mining size and includes hydraulic excavators, wheel loaders,
crawler dozers, off-highway trucks, motor graders, skid steer loaders,
tractor loaders and backhoe loaders.

Develop, modify, and maintain database systems necessary to achieve Supply
Chain Division activities and objectives. Provide technical support in
developing and maintaining database applications. Review, analyze, and
document data and database workflow processes, and prepare documentation of
database applications. Provide user support as necessary.

Job Responsibilities
Database Development and Maintenance Activities

- Develop, maintain, and modify databases to allow departments to operate
as efficiently as possible and to reduce manual effort. Assist in the
design phase of database requirements and functions. Use proper programming
techniques to ensure stable operation of databases.
- Assist management in developing ways to increase departmental efficiency
through automation of tasks. Help research new products, software, etc.
that would improve efficiency.
- Maintain SQL server software interfaces as necessary to support database
applications and maximize database efficiency
- Create test plans, test data sets and automated testing, where possible,
to ensure all components of the applications meet requirements and desired
End Result: Maximize departmental and database efficiency, and ensure
database stability, reliability, and accuracy.

User Support Functions
- Train database users and provide technical support as necessary.
- Document logic and flow of database applications continuously, in the
form of programmer flow charts, as well as user-friendly scripts as
- Monitor and coordinate all change requests to database functionality, in
keeping with management sign off process.
End Result: Ensure that users have access and necessary training to utilize
database applications correctly, as reviewed and approved.

- BS. Degree in Computer Science or related field and at least 3 years
experience developing relational database applications with complex MS SQL
Server and MS Access database software.
- Proficient in Visual Basic programming, for use with MS Excel and MS
- Working knowledge of SAP which must include SAP data extraction skills.
- Microsoft Excel, Word and Access. Must be able to create and maintain
Access databases. Be able to implement user security to the Access
databases. Be able to link to many different data sources and pull data
together to make it useful for Access databases users. Access database
should have the look and feel of purchased software.
- Ability to prepare flow charts and documentation of database developments
using, Microsoft Word, Microsoft PowerPoint, and Visio, as appropriate.
- Able to work well with others, and to work independently to self-manage
assigned tasks.
- MS SQL Server certification preferred.

=============================================================== From: Dave Brockman ------------------------------------------------------ -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 So, I read all that, and I'm still confused. Do they want a DBA, an Access programmer, or NotYet programmer? Regards, dtb -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.17 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk7FifkACgkQABP1RO+tr2S3ZgCfegsxT+/EUgRwYSkXZRb+pVSS 0DYAoLGoQ5YXXV+Kz//Qb3u/3uKlHTtZ =b1/k -----END PGP SIGNATURE-----

=============================================================== From: Stephen Haywood ------------------------------------------------------ My understanding is they have a large Access application that interfaces with SAP. They have outgrown the Access app and want to move to a Web-base SQL app that interfaces with SAP. Whoever they hire will need to know how to do SQL and VBA programming.

=============================================================== From: cynicalgeek@gmail.com ------------------------------------------------------ I don't understand where the confusion manifested itself. Seemed straightfor= ward to me.=20 Sent from my iPhone

=============================================================== From: "Alex Smith (K4RNT)" ------------------------------------------------------ David, for people who can't read database languages yet, I think they're looking for someone to migrate their current Access database application to a web-based SQL database (of a TBD backend) with SAP, and they're looking for someone experienced, and potentially a quote and consult. --=20 " ' With the first link, the chain is forged. The first speech censured, the first thought forbidden, the first freedom denied, chains us all irrevocably.' Those words were uttered by Judge Aaron Satie as wisdom and warning... The first time any man's freedom is trodden on we=E2=80=99re all damaged." - Jean-Luc Picard, quoting Judge Aar= on Satie, Star Trek: TNG episode "The Drumhead" - Alex Smith (K4RNT) - Dulles Technology Corridor (Chantilly/Ashburn/Dulles), Virginia USA

=============================================================== From: Ryan Macy ------------------------------------------------------ Access to SQL server migration is what I understood from the request. Ryan Macy (Sent from my phone.) On Nov 18, 2011, at 9:42 AM, "Alex Smith (K4RNT)" w= rote: ron

=============================================================== From: Dave Brockman ------------------------------------------------------ -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 OK, back to using tags. IME, Most of the people who can program access, can't code hello world in a web app. Most of the people who can program access well, shot themselves a long time ago. And *ALMOST* every windows programmer (those VBA and web types) are the last people in the world you want actually managing a real RDBMS. Most of them can't even figure out how to add their FTP/WEB site to "trusted zones" to download their latest "update". A few members of present company excluded, of course :) Regards, dtb -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.17 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk7GsC4ACgkQABP1RO+tr2THAQCfazOXwffH8y7UbeWNEe4qMliQ un4An1WbDLI/MvABJFfrnf6F/tY75Sl8 =HhIQ -----END PGP SIGNATURE-----

=============================================================== From: Cameron Kilgore ------------------------------------------------------ Please explain to me when it became good form to use Access as a database for a multi-user application in ANY kind of language, let alone .NET. You can get SQL Server for free, practically! --Cameron

=============================================================== From: Dave Brockman ------------------------------------------------------ -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 It was never a good idea, yet MS is determined to prove to the world that JET is a viable db technology... only reason I can think of why Exchange still effing runs on it! Single Processor, 10GB database size, 1 GB RAM, it is free with these limits.... http://www.microsoft.com/sqlserver/en/us/editions/express.aspx Regards, dtb -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.17 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk7GsugACgkQABP1RO+tr2TBgwCcCdg3dw6JAQAGhYPYo5fF4u5f zR4An0EtbQAGkx0FAn5gLd9scYpwpXj5 =6KjD -----END PGP SIGNATURE-----