Database Engineer II

Who We Are

OpenEye, the cloud video platform company, provides solutions for video security, business intelligence and loss prevention. For over 20 years, OpenEye has been committed to developing an easy-to-use, comprehensive video management system backed by Heroic Customer Service® and support. Our on-site and cloud-based products can be found protecting schools, hospitals, banks, retail stores, and other facilities around the world. OpenEye’s solutions are available globally through a trusted network of certified service providers. OpenEye is a subsidiary of Alarm.com. Learn more at www.openeye.net.

OpenEye is proud to be one of the 2023 Best Places to Work in the Inland Northwest. Ready to join a casual, fun and creative culture? Join our team!

Job Summary

As a Database Engineer II at OpenEye, you will be at the core of ensuring the reliability, performance, and security of our data backend infrastructure for OpenEye Web Services (OWS). Combining robust technical proficiency, organizational skills, and interpersonal abilities, you will engage with evolving technology to make data-driven decisions.

In this role, you will leverage your technical expertise in database design, optimization, scalability, and security. You will take on the responsibility of leading small-to-medium-sized projects, exhibiting robust leadership skills and a growing level of autonomy.

This role provides a unique opportunity for coders who have a strong affinity for data and databases. If you are a software engineer excited by data manipulation or a database engineer who finds satisfaction in deep-dive coding sessions, this position is your perfect opportunity!

Role and Responsibilities

• Designs and implements scalable, robust database solutions in alignment with business requirements.
• Maintains and optimizes database elements, including performance, security, storage, and access.
• Develops and refines backend and data-centric software, encompassing feature additions, modifications, bug fixes, and unit tests. Collaborates with the Team Leader or Product Owner to resolve arising issues.
• Reviews development requests and makes educated decisions about the most efficient way to proceed.
• Interfaces with various departments to acquire information needed to successfully deliver solutions that meet customer needs.
• Clearly communicates tasks and ideas across developers, management, various departments, and customers.
• Analyzes and interprets diverse input requirements, devising optimal strategies to fulfill each requirement.
• Reviews software code to ensure compliance with company, departmental, and team standards.
• Provides guidance and assistance to other database or software engineers on issues relating to data, databases, queries, and data access patterns.
• Other duties as assigned.

The Tech

• AWS RDS, MySql, CrateDB, PostgreSQL, AWS Kinesis Data Streams, Microsoft SQL, Power BI, Java, Python, Spring, Git, IntelliJ

Qualifications

• Bachelor's Degree in Computer Science or a related field
• 2-5 years of professional experience
• Proficient and practical experience with relational databases such as MySql, AWS RDS, PostgreSQL, or similar, in a production environment
• Experience with BI tools such as PowerBI, Tableau, or similar technology
• Experience in Java, C#, or similar programming language
• Solid understanding of object-oriented programming and development practices
• Excellent understanding of database concepts (indexing, triggers, transactions, constraints, etc.)
• Ability to troubleshoot database locking and performance issues
• Excellent understanding of query execution plans and advanced query structure
• Ability to quickly learn new technologies and practices
• Excellent critical thinking and problem-solving skills
• Strong quality ethic and test-first attitude
• Great communication and teamwork skills

The Perks!  

• Employees are eligible to purchase company stock at a discounted rate
• Collaborative, fun, creative culture where idea sharing is encouraged
• Casual dress (Jeans are welcome!)
• Medical, dental, vision & prescription benefits starting day 1! Generous medical plan subsidy and health savings account option with company contribution helps keep your costs low.
• Up to $5,000 annual company match for 401k
• Company paid short-term/long-term disability, AD&D and life insurance
• Paid maternity and paternity leave
• 15 Days of Paid Vacation accrued per year (increases after year 3)
• 7 Paid Sick/Wellness days per year
• 9 Paid Holidays per year
• This position is eligible for a flexible hybrid work schedule
• Educational Assistance Program covering non-degree support, undergraduate and graduate degrees
• Employee Equipment Program – Free Alarm.com system for your home!

OpenEye is an Equal Opportunity Employer 

In connection with your application, we collect information that identifies, reasonably relates to or describes you (“Personal Information”). The categories of Personal Information that we may collect include your name, government-issued identification number(s), email address, mailing address, other contact information, emergency contact information, employment history, educational history, criminal record, and demographic information.  We collect and use those categories of Personal Information about you for human resources and other business management purposes, including identifying and evaluating you as a candidate for potential or future employment or future positions, recordkeeping in relation to recruiting and hiring, conducting criminal background checks as permitted by law, conducting analytics, and ensuring compliance with applicable legal requirements and Company policies. 

Notice To Third Party Agencies

Alarm.com understands the value of professional recruiting services.  However, we are not accepting resumes from recruiters or employment agencies for this position. In the event we receive a resume or candidate referral for this position from a third-party recruiter or agency without a previously signed agreement, we reserve the right to pursue and hire those candidate(s) without any financial obligation to you. If you are interested in working with Alarm.com, please email your company information and standard agreement to RecruitingPartnerships@Alarm.com.

#LI-RC1

#LI-Hybrid

JR104920