SSD Alarm ยท 3 months ago
Database Engineer
SSD Alarm is one of the largest and most respected providers of integrated security and fire solutions in the U.S., focusing on customer service excellence and leading technology. The Database Engineer position is responsible for developing, designing, and creating database structures, ensuring the reliability of data pipelines, and maintaining databases to support company projects.
Security & Investigations
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 stake holders
Qualification
Required
T-SQL: 3 years (Required)
Database Server Administration: 3 years (Required)
Ability to communicate effectively with other departments
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
Preferred
SSRS: 1 year (Preferred)
Data warehouse: 1 year (Preferred)
Microsoft Power BI
REST APIs, JSON
Benefits
401K
Medical, dental & vision insurance
Life insurance
Paid company holidays
Paid vacations
Company
SSD Alarm
SSD Alarm was founded in 1968 with the mission of providing advanced system solutions and superior customer service.
H1B Sponsorship
SSD Alarm has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2022 (1)
Funding
Current Stage
Growth StageCompany data provided by crunchbase