SQL Developer

SQL DeveloperJob Title: SQL DeveloperLocation: Southfield, MIPosition 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 OverviewThe 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 ResponsibilitiesDatabase & Query DevelopmentWriting and optimizing SQL queries for retrieving, updating, and managing CMMS dataDeveloping stored procedures, functions, and triggers to automate tasksEnsuring efficient indexing and query performance tuningReport & Dashboard DevelopmentCreating custom reports for maintenance teams, management, and stakeholdersDesigning SQL queries to extract meaningful insights from CMMS dataIntegrating SQL queries with Dundas or SSRSData Analysis & Business IntelligenceAnalyzing maintenance and asset performance data to support decision-makingDeveloping KPIs and metrics for equipment uptime, work orders, and costsPerforming data validation and troubleshooting inconsistencies in CMMS recordsData Integrity & SecurityAssisting with database backups and disaster recovery planningImplementing data validation checks to ensure accuracy and consistencySupporting role-based access control by enforcing security policies through SQLIntegration & System SupportAssisting with data migrations, imports, and exports between systemsSupporting API integrations that require SQL queries for data exchangeTroubleshooting database-related issues and working with developers to optimize system performanceRequired Qualifications and SkillsBS in Computer Science or related degree, and 13 years related experience or equivalent combination of education and experience.13 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 SkillsProficient 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).BenefitsMedical, Dental and Life insuranceAD&D insurance401(k) PlanPaid Time Off (PTO) and Paid Holidays Interested candidates should send their resume along with salary expectations to .

Required

Preferred

Job Industries

Other