SQL Programmer / Database Programmer

Plum Market•Farmington Hills, MI

1d•Onsite

About The Position

We are seeking a detail-oriented Programmer to design, develop, maintain, and optimize SQL-based database solutions that support business operations and reporting needs. This role will work closely with IT, data, and business stakeholders to ensure data accuracy, performance, and availability across systems.

Requirements

Strong proficiency in SQL (T-SQL, PL/SQL, or equivalent)
Experience with relational databases (e.g., SQL Server, MySQL, PostgreSQL, Oracle)
Solid understanding of: Database design and normalization, Indexes, keys, constraints, and relationships, Query optimization and performance tuning
Ability to analyze large datasets and identify trends or issues
Experience writing and maintaining stored procedures and functions
Strong problem-solving and analytical skills
Clear documentation and communication skills
Experience with reporting tools (SSRS, Power BI, Tableau, etc.)
Bachelor’s degree in Computer Science, Information Systems, or related field or equivalent work experience
2+ years of hands-on SQL development experience

Nice To Haves

Familiarity with ETL tools or data integration processes
Experience supporting business-critical systems (POS (LOC SMS), ERP, CRM, etc.)
Basic scripting or programming experience (Python, PowerShell, C#, etc.)
Knowledge of data security and compliance best practices

Responsibilities

Design, write, and maintain complex SQL queries, views, functions, and stored procedures
Develop and optimize database performance, including indexing and query tuning
Maintain data integrity and ensure consistency across databases
Create and support reports, dashboards, and extracts for business users using SSRS reports and Power BI
Troubleshoot and resolve SQL-related issues and data discrepancies
Participate in database design, schema changes, and data modeling
Support data imports, exports, and ETL processes
Collaborate with developers, analysts, and business teams to understand data requirements
Document database objects, processes, and standards
Follow best practices for security, backups, and change management
Make and Maintain API connections for third parties