NOTE MUST HAVE 3+ YEARS ACCESS DATABASE PROGRAMMING EXPERIENCE.

American Products, Inc. (API) is a leading architectural metals manufacturer and construction company. We are seeking a very experienced Access Database Developer / Architect to join our team. We are located in Oldsmar, Florida very close to Westchase, Citrus Park, Tampa, etc.

Please note that this is an in-office position (this is not a remote position).

Job Duties for Access Database Developer / Architect:

First and foremost, must have 7+ Years Extensive Access and SQL Database Experience, both designing and maintaining Microsoft Access databases versions 2013 - 365
Create and manage databases and tables, both standalone and linked
Perform queries of all types, as needed
Create and manage forms with many sub-forms with coding
Reporting – creating very complex, custom reports which will involve macros /temporary tables, coding, etc.
Reporting - creating reports that email table designs as reports within emails.
Reporting - creating and sending very detailed, complex reports to staff from access databases, etc.
Manage 25+ databases
Create SQL views and links to databases
Security setups in both Access development and in Exchange Active directory.
Continuously enhance user experience by making necessary changes to Access databases.

Job Requirements for the Access Database Developer / Architect:

Strong access database development absolutely required
Strong skills in VBA, and HTML required to perform required duties
SQL backend exp. required for various databases
Strong access database development absolutely required
Macros and modules exp. a must
Must be comfortable assisting users daily and multi-tasking on a daily basis
Must be very comfortable working with different types of databases and hardware
Microsoft Certification a plus
Crystal reports writing experience a plus
Experience working with accounting software and integrating data between access and accounting software (including Sage 100, Sage 50, Quickbooks, etc.) a plus
Experience with Microsoft Exchange and setup of user emails and distribution groups a plus
Experience with Goldmine, Quotewerks, a plus as well

Technical IT Experience Preferred but not Required as well, to include:

Set up user emails and distribution groups
Coordinate software installation or upgrades and monitor implementation process
Setup computers for new hires
Software installation, printer installation, etc.
Assisting all staff as various IT needs arise
Inventory computers and tracking of software licensing
Support 3CX phone system maintenance

Excellent Benefits Package Offered

Benefits package to include health, dental, vision, 401K with company match, paid vacations and paid holidays, etc. We also offer a casual dress work environment, a great location, and most of all, a great team!

American Products, Inc. (API) jobs

Access Database Developer / Architect