Database Engineer

Mid-Level Database Engineer

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 seeking a Database Engineer to join our growing team.  If you thrive in an innovative, collaborative, and casual atmosphere, apply today!

Job Summary

As a Mid-Level Database Engineer, you will be responsible for the development and maintenance of the data backend infrastructure for OWS using a combination of technical proficiencies, organizational aptitude and interpersonal skills, as well as learning and progressing with the evolving technology. You will play a key role in ensuring the reliability, performance, and security of our data.

In this role, you will also use your critical thinking and problem-solving skills to turn complex data into actionable information that will help OpenEye to make data-driven decisions.

Role and Responsibilities

• Design and implement database systems and solutions that meet business requirements
• Maintain and optimize database performance
• Monitor database security and enforce security policies
• Collaborate with development teams to ensure data integration and consistency
• Troubleshoot and resolve database and data access issues
• Participate in the design and implementation of new features and functions
• Reviews development requests and makes educated decisions about the most efficient way to proceed.
• Assists other database engineers or software engineers as needed when they have questions about data, databases, queries, or other data-access patterns.
• Effectively communicates tasks and ideas to fellow engineers, management, various departments, and customers.
• Analyzes input requirements from various sources and determine the best way to meet each requirement.
• Reviews software and database code written by others to determine if the code meets company, departmental and team standards.
• Administers and manages database, clustering and replication infrastructure (MySql, CrateDB, MS SQL Server) in development, QA, pre-production & production environments.
• Interfaces with various departments to acquire information needed to successfully deliver solutions that meets customer needs.
• Interfaces with various departments and customers to help solve support issues they are facing using the solutions.

The Tech

• AWS RDS, MySql, CrateDB, PostgreSQL, AWS Kinesis Data Streams, Microsoft SQL, Power BI

Qualifications

• Bachelor's Degree in Computer Science or related field
• 2-5 years professional experience
• Experience in MySql or similar relational database in a production environment
• Experience in PowerBI, Tableau, or similar reporting technology
• Excellent understanding of query execution plans, advanced query formation, and index and performance tuning
• Solid understanding of object-oriented programming and development practices
• Ability to quickly learn new technologies and practices
• Excellent critical thinking and problem-solving skills
• Strong quality ethic and test-first attitude
• Some experience with programming languages such as Java
• Great communication and teamwork skills

The Perks! 

• The pay range for this opportunity is $90,000 - $130,000 annually. In addition, this position is eligible for an annual discretionary bonus. 
• 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.

JR103344

#LI-HYBRID

#LI-RC1

Salary : $90,000 - $130,000