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