website-hero-image2

2739 Database Reliability Engineer

Location: Remote

Description:
Are you a Senior database engineer who has a decent amount of experience working in a Cloud (AWS) environment? We are looking for a Database Reliability Engineer to help us with re-architecting our databases and working closely with our software development team to do so. If you love digging into database code, please keep reading! We are a fun, dynamic, product development company and the manager of this role is a former techie, super funny, and fosters a great working environment. If you’re interested, please send your resume to careers@itmotives.com. We value and encourage diversity in the workplace and women, minorities, and veterans are highly encouraged to apply. Thank you!

Job Type: FTE

Additional Information:
More about this role:
What is a Database Reliability Engineer (DBRE) you ask? DBREs are responsible for keeping database systems (this includes NoSQL technologies) that support all user-facing services and internal production systems running smoothly 24/7/365. Successful DBREs are an interwoven blend of database engineering, administration, and software development that apply sound engineering principles, operational discipline, and mature software development and automation, specializing in databases (PostgreSQL and MSSQL). In that capacity, DBREs are peers to Site Reliability Engineers (SREs) and bring database expertise to the SRE Infrastructure teams as well as our engineering teams.

WHAT YOU'LL DO:
• Database performance and reliability
• Optimize queries, indexes, and overall database structure to improve performance
• Work on observability of relevant database metrics and make sure we reach our database objectives
• Design infrastructure to meet business Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO)
• Provide database expertise to engineering teams (e.g. through reviews of database migrations, queries, and performance optimizations)
• Provide guidance on the right type of datastore, depending on the objectives and workload
• Automation of database infrastructure and help engineering succeed by providing self-service tools
• On-Call support rotation with the team

LOCATION & SCHEDULE:
This position will be full-time remote based in the US. This individual should be willing to work with a team based in the Pacific Time Zone and be able to adjust work hours accordingly. This position requires participation in a rotating 24/7 on-call schedule.

WHAT WE NEED FROM YOU:
• At least six (6) years directly working with relational database environments
• At least six (6) years’ experience with Database Administration for Microsoft SQL Server and PostgreSQL
• At least six (6) years’ experience in troubleshooting and resolving intermediate to complex database problems
• At least six (6) years’ experience in Performance Tuning and Optimization
• Expert level skill with backup, replication, restore and recovery models
• Expert knowledge of High Availability (HA) and Disaster Recovery (DR) options for Microsoft SQL Server
• Expert knowledge of indexes, index management, and statistics
• Expert T-SQL development and knowledge of SQL internals
• Advanced knowledge of SQL development and software development life cycle
• Advanced experience in implementing operational automation using scripts
• Experience with AWS technologies
• Intermediate to advanced knowledge of NoSQL based technologies such as JSON or Columnar Store solutions
• Demonstrated ability to design and build a SQL Server to include capacity planning to meet performance objectives
• Nice to have: Bachelor’s degree in Computer Science or a related degree, or equivalent of business experience

OUR TECH STACK:
Our tech stack is as follows: Java Spring Boot, Node.js, React/Redux, Postgres, Microservices, Containers, Lambda, ElasticSearch, Python, Spark, CI/CD, IaC, AWS