Database Developer - 4481

Who are we: Magnaflow is a leading manufacturer and supplier based in Oceanside, CA of premium products to the automotive aftermarket industry such as catalytic converters, performance exhaust and replacement exhaust. Through the Camburg division in Huntington Beach, CA. Magnaflow also supplies race-inspired performance suspension products and vehicle uplifting services, Magnaflow is focused on future growth through both new business development and new product introduction. Our websites are the employer's site and the employer's site. Salary Range: $130,000-$150,000 USD annually *Final agreed upon compensation will be based on a variety of factors including but not limited to an individual’s related experience, education, certifications, skills, and work location. What you will be doing: The Database Developer is responsible for designing, developing, maintaining, and optimizing the organization's databases, data pipelines, and reporting infrastructure. This role ensures data integrity, availability, security, and performance while supporting business intelligence, analytics, and operational applications. The ideal candidate combines strong database development expertise with modern data engineering practices to transform raw data into reliable, scalable solutions that drive business decisions. Responsibilities: Design, develop, and maintain high-performance database solutions, including complex stored procedures functions, and query optimization across SQL Server and Azure SQL environments Build and manage scalable, fault-tolerant ETL/ELT pipelines using both on-prem and cloud-based tools (e.g., SSIS, Azure Data Factory, Databricks) Develop and support enterprise data warehouse and data mart architectures to enable reporting, analytics, and business intelligence initiatives Collaborate with application developers, analysts, and business stakeholders to translate business requirements into efficient data models and solutions Ensure data quality, integrity, and consistency through validation, monitoring, and implementation of data governance best practices Optimize database and warehouse performance through indexing, partitioning, query tuning, and workload management Implement robust backup, recovery, and disaster recovery strategies to ensure availability and resilience of critical data systems Support integration between enterprise systems (ERP, WMS, etc.) through reliable and scalable data pipelines Troubleshoot and resolve data-related issues, performance bottlenecks, and ETL failures in production environments Support users with analytics tools such as PowerBI Qualifications Requirements:   Bachelor’s degree in Computer Science, Information Systems, or related field, or equivalent hands-on experience 5+ years of experience in database development, data engineering, or related roles Advanced expertise in Microsoft SQL Server and Azure SQL, including query optimization and stored procedure development   What you need: Strong experience with ETL/ELT development using tools such as SSIS, Azure Data Factory, Databricks, or similar platforms Experience designing and supporting data warehouse architectures (star/snowflake schemas, data marts, fact/dimension modeling) Working knowledge of additional database technologies (e.g., Oracle, MySQL, or NoSQL platforms) Experience with scripting and development languages such as Python, PowerShell, or .NET for automation and data processing Familiarity with reporting and analytics tools (SSRS, Power BI, Tableau, or similar) Strong understanding of data integration patterns, data governance, and best practices for data security Excellent problem-solving skills with a focus on performance, scalability, and reliability What’s in it for you? Competitive Salary PTO, Sick Pay, Birthday Holiday, Paid Holidays Medical, Dental, Vision 401k Matching (Up to 5%) Education assistance Company sponsored events Growing department and team   #LI-Onsite