What are the responsibilities and job description for the Database Engineer position at SSD Alarm?
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.
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.
Salary : $100,000 - $150,000