SQL Developer

SQL Developer Job Title: SQL Developer Location: Southfield, MI Position Type: Full-time, Salaried Company Overview We are a dynamic and fast-growing company specializing in Computerized Maintenance Management Software (CMMS) for hospitals.

With over 40 years of success in a rapidly evolving industry, we are committed to fostering a culture of collaboration and continuous employee development.

Position Overview The SQL Developer is primarily responsible for customer database conversions.

Secondary responsibilities will involve report generation.

The ideal candidate will have experience with technical trouble shooting, debugging, and developing innovative solutions to complex problems.

This position requires an individual with exacting standards and great attention to detail, who also possesses excellent communication skills and has the ability to effectively collaborate with team members.

Knowledge of AIMS or other CMMS software functions and an understanding of Clinical Engineering and Facilities Maintenance processes is a plus.

Key Responsibilities Database & Query Development Writing and optimizing SQL queries for retrieving, updating, and managing CMMS data Developing stored procedures, functions, and triggers to automate tasks Ensuring efficient indexing and query performance tuning Report & Dashboard Development Creating custom reports for maintenance teams, management, and stakeholders Designing SQL queries to extract meaningful insights from CMMS data Integrating SQL queries with Dundas or SSRS Data Analysis & Business Intelligence Analyzing maintenance and asset performance data to support decision-making Developing KPIs and metrics for equipment uptime, work orders, and costs Performing data validation and troubleshooting inconsistencies in CMMS records Data Integrity & Security Assisting with database backups and disaster recovery planning Implementing data validation checks to ensure accuracy and consistency Supporting role-based access control by enforcing security policies through SQL Integration & System Support Assisting with data migrations, imports, and exports between systems Supporting API integrations that require SQL queries for data exchange Troubleshooting database-related issues and working with developers to optimize system performance Required Qualifications and Skills BS in Computer Science or related degree, and 1–3 years related experience or equivalent combination of education and experience.

1–3 years of experience with Microsoft SQL Server (SQL V2008+) writing stored procedures, creating ad-hoc queries, designing and understanding database schemas and analyzing databases of various types and complexities.

Experience with relational database design, analysis and implementation.

Experience with data ETL.

Preferred Skills Proficient with Microsoft Office.

Experience with non-relational database analysis as well as modern relational databases.

Knowledge of various reporting tools (i.e., SSRS, Crystal Reports). Benefits Medical, Dental and Life insurance AD&D insurance 401(k) Plan Paid Time Off (PTO) and Paid Holidays Interested candidates should send their resume along with salary expectations to .

Full Time