StPetersburgRecruiter Since 2001
the smart solution for St. Petersburg jobs

SQL & PHP Programmer

Company: GA Foods, Exclusive provider of SunMeadow - brand
Location: Saint Petersburg
Posted on: January 8, 2022

Job Description:

Basic Skills
Self-starting professional with working knowledge of MySQL and PHP Programming with incredibly strong eye for data; good written and verbal communication skills with the ability to communicate data clearly to all levels of management.

This is a great opportunity for someone early in their database and development career with a strong knowledge of SQL looking to gain real world experience in using business data effectively. This position reports directly to the Manager, Application Development.

General Purpose of Job
This position is responsible for the management and use of the Company's data that resides in MySQL databases. GA Foods has roughly 700+ employees with multiple food production facilities. This person will provide data in the form of custom built reports in our ERP system, ad-hoc reporting through direct export and manipulation of data via MySQL, and the formatting of data via Microsoft Excel by using Pivot Tables, Charts, and built-in functions like VLOOKUP. GA Foods' primary technology is two-fold: 1) a custom built, non-framework, highly organized LAMP application that currently consists of 480 MySQL tables and 190,000 lines of PHP code, and 2) Microsoft Dynamics NAV which utilizes MsSQL as its database engine. This position is 70/30 SQL to PHP programming. This position begins as a very data-centric position, but as knowledge and experience grows with the code in our custom built LAMP application, there is a lot of opportunity for PHP programming growth.

Essential Duties

Take complex, individualized questions about all aspects of the business and generate data to provide accurate, reliable, and timely answers via MySQL, MsSQL and/or raw data (CSV) sources
Take SQL statements that provide refreshable data for reporting and apply the statements to PHP code for a custom built reporting platform within the Company ERP
Analyze raw data that comes in the form of CSV/Excel documents
Be able to import raw data from CSV/Excel documents into MySQL
Make coding contributions and changes to our custom built LAMP application
Preferred Skills, Degree & Certifications
Bachelor's Degree in Computer Science preferred or 2-3 years of relevant experience
Strong knowledge of Relational Database Management
Strong knowledge of MySQL syntax, including JOIN and built in functions
Strong knowledge of Microsoft Excel, including the use of Pivot Tables and VLOOKUP
Knowledge of PHP programming (or similar)
Knowledge of MsSQL syntax, including JOIN and built in functions
Good communication skills with the ability to communicate to all levels of the organization
Excellent problem solving skills
Ability to take direction but also independent enough to not be micro-managed
Ability to adhere to company Coding Style Guide - both documented and implied
Microsoft Dynamics NAV experience a plus, but not required
Linux (Ubuntu) experience a plus, but not required
Amazon AWS experience a plus, but not required
Experience with version control (git) a plus, but not required

As a condition of employment, you must be able to submit a fully vaccinated COVID vaccination record, provide approved exclusion documentation, or comply with appropriate state regulations within your first 90 days of employment.

Keywords: GA Foods, Exclusive provider of SunMeadow - brand , St. Petersburg , SQL & PHP Programmer, IT / Software / Systems , Saint Petersburg, Florida

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Florida jobs by following @recnetFL on Twitter!

St. Petersburg RSS job feeds