SQL PROGRAMMER

Romph & Pou Agency

SQL PROGRAMMER

Shreveport, LA
Full Time
Paid
  • Responsibilities

    Summary:

    We are seeking an intermediate-level SQL developer to join our team. Candidate will working in a cloud-based Azure/SQL Server environment. Team members work in cohesion to enhance our SCORPIO proprietary database tool, which consists of maintenance, improvements and streamlining of all data intakes, data storage, stored procedures and automation, data manipulations and calculations and tool output/client deliverables.

    Skills & Responsibilities:

    Programming complex views, stored procedures and functions

    Developing Report Server reports (Builder or Visual Studio) and accompanying queries/datasets

    Creating database triggers for automation, e.g., Agent jobs, automatic email notifications, etc.

    Writing queries to fulfill user requests (data extraction/importation, etc.)

    Administrative Skill Required:

    Creating Integration System packages (Excel file upload/download, etc.) for data automation

    Writing queries for and assisting integration of third party applications (Power BI, Tableau, etc.)

    Creating table indexes to improve database performance

    Reviewing query performance and optimizing code

    Data modeling to visualize database structure

    Designing and creating tables to store user requests & application data

    Keeping detailed documentation of all created items

    Other:

    Secondary programming languages a plus, especially Python, .NET and VBA

    Benefits:

    Medical Coverage

    Dental Coverage

    Vision Coverage

    401K

    Life Insurance (both Automatic and Supplemental up to $100,000)

    Paid Vacation Days/Personal Days/Sick Days

    11 Weeks of Short-Term Disability Coverage

    Rewards Program for Length of Service

    Perks:

    Free Sodas and Coffee

    Monthly Employee Work Anniversaries and Birthdays Celebrations

    Christmas Party in December

    Employee Crawfish Boil

    Halloween Potluck Lunch

    New Hire Breakfast Meet and Greets

    Business Casual Dress Code

    Community Involvement