Level Experienced Job Location Anaheim Branch - Anaheim, CA 92801 Position Type Full Time Education Level High School Salary Range $100,000.00 - $150,000.00 Salary/year Job Shift Day Job Category Information Technology
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.
What you will be doing:
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 stake holders.
Pluses:
Must qualify for a State of California Alarm Company Employee Permit. This will include a criminal history review by the California Bureau of Investigative Services.
Benefits
We recognize people as our most valuable asset. Our competitive salary and benefits package includes 401K, medical, dental & vision insurance, life insurance, paid company holidays, and paid vacations.
*SSD Alarm is an Equal Opportunity Employer. Employment contingent upon successful completion of post-offer background screening and drug testing.
SSD Alarm was founded in 1968 with the mission of providing advanced system solutions and superior customer service. We are one of the largest family-owned security and fire alarm companies in the nation serving commercial, retail, corporate, government and residential clients. Because monitoring your alarm is an important part of protecting your home or business, we proudly staff and operate our own U.L. Listed monitoring centers around the clock.
At SSD Alarm, our focus is on preventing loss and protecting people. We take pride in creating lasting partnerships, and we attribute our growing success to the strong relationships we build with our clients.
We strive for excellence in everything we do. We offer industry best products and services backed by a dedicated team of professionals. All of our team members are individually selected and verified through background checks and drug screening. Recognizing the importance of education, we support and provide factory training, licensing, and continued education for all of our employees. From our products and services to the quality of our team members, we are committed to exceeding expectations and building lasting relationships with our clients.
