Logo
OpenEye

Database Engineer II

OpenEye, Liberty Lake, Washington, United States, 99019

Save Job

Overview 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

OpenEye is an Equal Opportunity Employer

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!

#J-18808-Ljbffr