Database Engineer

SSD Alarm • Anaheim, CA

97d • $100,000 - $150,000

About The Position

With over 50 years in the industry, SSD Alarm has grown to become one of the largest and most respected providers of integrated security and fire solutions in the U.S. We own and operate our own UL Central Station and have built a strong reputation in the industry for technical expertise and service. Our company continues to grow by focusing on customer service excellence and leading in technology. We seek top talent in the Security Industry. The Database Engineer position works within the SSD Alarm IT team to develop, design and create database structures, stored procedures, reports and pipelines to support company projects. Responsibilities include ensuring reliability of data pipelines to the data warehouse, creating SQL stored procedures for web developers and vetting products to ensure they integrate with SSD's data strategy. The Database Engineer will ensure databases are replicated, optimized, backed up and well maintained. While the primary platform is Microsoft SQL Server, familiarity with Sybase ASE 15.7 is a plus. Candidates with strong SQL Server backgrounds are encouraged to apply, as those skills will translate well to our Sybase environment.

Requirements

• T-SQL: 3 years (Required)
• Database Server Administration: 3 years (Required)
• Ability to communicate effectively with other departments.

Nice To Haves

• SSRS: 1 year (Preferred)
• Data warehouse: 1 year (Preferred)
• Microsoft Power BI
• REST APIs, JSON

Responsibilities

• Advanced T-SQL programming. Creating complex stored procedures with input/output parameters, error handling, transaction rollbacks, using work tables and nested procedures.
• Database recovery planning, high availability and backups.
• Create high performance SQL queries and be able to optimize existing queries.
• Use ETL/SSIS or equivalent to move/transform data from production to the data warehouse. Must be able to optimize data transfer to move as little as possible as fast as possible.
• Work with SSRS to generate automated and on demand reports. These reports are client facing and for internal use.
• Database performance tuning and maintenance, managing indexes and maintenance plans.
• Managing a data warehouse.
• Work effectively with project leaders and stakeholders.

Benefits

• 401K
• medical insurance
• dental insurance
• vision insurance
• life insurance
• paid company holidays
• paid vacations

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: High school or GED