Database Engineer

1 week ago Be among the first 25 applicants

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.
• T-SQL : 3 years (Required)
• Database Server Administration : 3 years (Required)
• SSRS : 1 year (Preferred)
• Data warehouse : 1 year (Preferred)
• 3 years of experience with most of the above.
• Ability to communicate effectively with other departments.

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.

Seniority level

Employment type

Job function

Industries

Referrals increase your chances of interviewing at SSD Alarm by 2x

Santa Ana, CA $100,000 - $115,000 1 month ago

Newport Beach, CA $100,530 - $122,870 2 weeks ago

Los Angeles, CA $180,000 - $220,000 3 weeks ago

Irvine, CA $100,000 - $150,000 3 weeks ago

Los Angeles Angels-Full Time Data Engineer (Baseball Systems Developer)

Anaheim, CA $95,000 - $110,000 1 month ago

Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr