Database Engineer at SSD Alarm

Fullerton, California, United States -

Full Time

Start Date

Immediate

Expiry Date

05 Apr, 26

Salary

150000.0

Posted On

05 Jan, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

T-SQL, Database Server Administration, SSRS, Data Warehouse, ETL, SSIS, SQL, Database Performance Tuning, High Availability, Backups, Data Recovery Planning, Microsoft SQL Server, Sybase ASE, REST APIs, JSON, Communication

Industry

Security and Investigations

Description

Job Details 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. Job Qualifications 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: Microsoft Power BI REST APIs, JSON 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.

Responsibilities

The Database Engineer will develop, design, and create database structures, stored procedures, reports, and pipelines to support company projects. Responsibilities include ensuring the reliability of data pipelines and maintaining databases.