Data Engineer

Company: Brivo
Location: Bethesda
Posted on: November 13, 2021

Job Description:

About the RoleAre you a Database Engineer looking to help build amazing features for the next ten million users on our security-oriented IoT platform? Your mission will be to maintain and optimize the core datasets and pipelines driving the vision of Brivo.In this role you will also be expected to:+ 24/7 support for production database environments to ensure the highest standards of availability, resilience, integrity, security and performance required by our business systems.+ Manage, maintain and monitor database backups and disaster recovery processes and procedures.+ Manage, maintain and monitor database security controls in accordance with company security policies.+ Proactively monitor, tune and report on the performance of both the databases and the systems on which they run.+ Manage and maintain ETL pipelines across multiple environments+ Work with both Development and QA teams to support and assist in the development, testing and tuning of database applications.+ Write scripts (both at the OS and Database levels) to automate repetitive or complex tasks.+ Design, develop and maintain appropriate levels of documentation for the database environment, processes and procedures.About You+ Bachelor's degree or equivalent experience required.+ 4+ years of Database Administration experience with RDBMS like Postgres, MySQL or SQL Server.+ 1-2 years of experience using, managing, and deploying Aurora and/or RDS environments within AWS+ Must be familiar with NoSQL databases such as DynamoDB or Cassandra.+ Working knowledge of data streaming solutions such as Kafka or Kinesis+ 2+ years of working knowledge of data warehouse technologies such as Snowflake or Amazon Redshift. + Must be familiar with how to leverage the core building blocks within AWS to properly secure SaaS applications (ex. Security Groups, S3, IAM, etc.)+ Experience with common database administration tasks including backup and recovery, monitoring, security and data-related maintenance (PostgreSQL preferred)+ In depth knowledge of concepts and experience writing SQL and query optimization.+ Familiarity with Big Data concepts and tooling such as Hadoop, Hive, Spark, EMR+ Ability to analyze, diagnose and tune database and query performance at all associated layers (database, network, server, disk).+ Working experience managing Database schema versioning with automated tools like MyBatis, Flyway or Liquibase.+ 2+ years experience writing, maintaining and documenting automation scripts in shell, Python, or other scripting languages+ If you read this far, add the word milk to your resume when you submit+ Working knowledge of programming languages (esp. Java, Javascript, Python, or PHP) and their associated ORM engines (ex. Hibernate, SQLAlchemy, mongoose)+ Demonstrated ability to work with development teams in an Agile environment+ Working knowledge of logging and monitoring tools such as Datadog, ELK, Splunk, New Relic, Prometheus, Grafana, CloudWatch, etc.+ Experience working in on-call rotationAbout UsBrivo is the global leader in mobile, cloud-based access control for commercial real estate, multifamily residential, and large distributed enterprises. Our comprehensive product ecosystem and open API provide businesses with powerful digital tools to increase security automation, elevate employee and tenant experience, and improve the safety of all people and assets in the built environment. Having created the category over twenty years ago, our building access platform is now the digital foundation for the largest collection of customer facilities in the world, trusted by more than 25 million users occupying over 300M square feet of secured space in 42 countries.Our dedication to simply better security means providing the best technology and support to property owners, managers, and tenants as they look for more from buildings where they live, work, and play. Our comprehensive product suite includes access control, smart readers, touchless mobile credentials, visitor management, occupancy monitoring, health and safety features, and integrated video surveillance, smart locks, and intercoms. Valued for its simple installation, high-reliability backbone, and rich API partner network, Brivo also has the longest track record of cybersecurity audits and privacy protections in the industry.Brivo is privately held and headquartered in Bethesda, Maryland. Learn more at www.Brivo.comBrivo is an Equal Opportunity/Affirmative Action EmployerPowered by JazzHR

Keywords: Brivo, Bethesda , Data Engineer, Engineering , Bethesda, Maryland