Database Engineer

Job Description

Job Description:\n\nMost companies treat their database as plumbing — invisible until it bursts. We treat ours as the single source of truth that hundreds of fleets rely on to keep their vehicles, and their people, safe and moving.\n\nDo you think in schemas and see the elegant data model hiding inside a messy one? Do you get a little thrill from turning a query that took 40 seconds into one that takes 40 milliseconds? And have you already made AI a real part of how you work — not a buzzword on your resume, but a tool you reach for daily to design faster, debug smarter, and ship better? If so, read on…\n\nI'm the Manager of Infrastructure, Cloud Operations and SRE at RTA, and I'm looking for a Database Engineer to own the design, performance, and reliability of the data layer that powers our platform. We run a fleet of SQL Server databases across our customer base, increasingly on AWS, and the data they hold is the heartbeat of the product. But we're also growing — and we know that the data infrastructure we need tomorrow may look very different from what we have today. \n\nThis is a high-ownership, high-impact role: you won't just tune indexes and respond to tickets — you'll help us understand what we need before we've figured it out ourselves, set the data architecture standard, drive migrations and modernization, and bring a modern, AI-augmented way of working to the whole team. If this sounds like you, you could be the peanut butter to our jelly. Read on and apply.\n\nThis role is not for everyone. If you prefer clearly scoped tasks, minimal ambiguity, and steady incremental work, we'd still love to have you — just not in this seat. This role is for engineers who see an undefined data problem and feel a pull toward it, not away from it.\n\nWhat We're Looking For\n\n In general, someone who:\n Is a force multiplier. When you touch the data layer, the whole product gets faster, safer, and easier to build on. You raise the bar just by being in the room.\n Is passionate about serving others.\n Takes pride in their craft, finding fulfillment in data systems that are clean, fast, and trustworthy — and in never being the reason something broke.\n Has genuinely adopted AI into how they work. You use AI tools as part of your daily practice and have a real point of view on where they help, where they don't, and how to use them responsibly.\n Has strong opinions, loosely held. You'll push back when a design is wrong, but you update your views when shown better information. You're not the smartest person in the room — you just want to find the right answer.\n Is comfortable being part of a team that thrives on healthy conflict. People with thin skin need not apply. No, seriously.\n Passionately cares about our clients, who are fleet managers, parts clerks, and automotive technicians maintaining everything from squad cars to school buses — so everyone comes home safely at the end of the day.\n Thinks of themselves less, while not thinking less of themselves. You're other-centric, compassionate, and self-assured.\n Takes ownership and initiative — spotting the slow query, the missing backup, or the schema that's about to become a problem, and fixing it without waiting for a ticket.\n Loves to read, learn, grow, and stretch themselves. Bonus points for each book they've read by Patrick Lencioni!\n\nSpecifically for This Job, Someone Who:\n\n Has 5–7+ years working hands-on with relational databases in production, with real depth in Microsoft SQL Server (T-SQL, query plans, indexing, partitioning). Experience with PostgreSQL is a strong plus.\n Knows relational and non-relational databases not just as concepts, but as tools — and has the judgment to know which belongs where. You can articulate why a relational model (SQL Server, PostgreSQL, Aurora) is the right choice for transactional, integrity-driven workloads, and equally why a document store (MongoDB, DynamoDB), a wide-column store (Cassandra, DynamoDB), a graph database (Neptune), or a key-value cache (Redis, ElastiCache) is the better fit for a different class of problem. You've made those calls in real systems, not just in theory, and you've lived with the consequences of getting it right — and wrong.\n Has meaningful hands-on experience with AWS database and data platform services, including but not limited to:\n Relational: Amazon RDS (SQL Server, PostgreSQL, MySQL), Amazon Aurora\n Non-relational / NoSQL: Amazon DynamoDB, Cassandra, Amazon ElastiCache (Redis/Memcached), Amazon Neptune\n Data warehousing: Amazon Redshift, and familiarity with alternatives like Snowflake or Databricks\n Data lake technologies: Amazon S3 as a data lake foundation, AWS Glue (ETL and data catalog), Amazon Athena (serverless query), AWS Lake Formation\n Data pipelines: AWS Glue, Amazon Kinesis (streaming), AWS Data Pipeline, and/or third-party tooling such as dbt, Apache Airflow, or Fivetran\n Data quality: Experience implementing and enforcing data quality frameworks — validation, lineage, anomaly detection, and governance tooling such as AWS Glue Data Quality, Great Expectations, or similar\n Uses AI in their daily work and isn't shy about it. You're fluent with modern AI tooling — coding assistants, LLM-based query and schema helpers, agentic workflows — and you actively apply them to design, optimization, documentation, and troubleshooting. You can also reason about the data layer behind AI features: vector storage, retrieval/RAG, and how operational data feeds analytics and ML.\n Designs data models, not just tables. You're fluent in normalization and when to denormalize, and you can defend those tradeoffs under pressure. Comfort with data modeling tools (ERwin, dbdiagram, Lucidchart, or similar) is expected.\n Lives and breathes performance tuning — execution plans, indexing strategy, query optimization, statistics, locking/blocking, and establishing performance baselines before there's a fire.\n Owns high availability and disaster recovery — backup/restore strategy, replication, Always On availability groups, failover, RPO/RTO targets, and the discipline to actually test recovery.\n Treats data security as non-negotiable — authentication, authorization, least privilege, encryption at rest and in transit, and an awareness of compliance obligations.\n Automates the boring stuff — maintenance, monitoring, and routine operations — using scripting (T-SQL, PowerShell, Python, or Bash) and infrastructure-as-code where it fits.\n Treats observability as a first-class concern, using tools like New Relic, Datadog, or native AWS monitoring to catch degradation before clients feel it.\n Communicates with precision. You can walk a senior engineer through a thorny migration plan and explain to a product manager why a schema change matters — without losing either of them.\n Has led before — bonus, not required. Time as a team lead, tech lead, or people manager is a real plus; we'd love someone ready to mentor and set standards, whether or not they want the management title back.\n\nKey Responsibilities\n\n Architect & Own the Data Layer: Design scalable, secure, well-documented database schemas and data architecture that the rest of engineering builds on with confidence. You set the direction, not just implement it — and you help us see around corners we haven't looked around yet.\n Guide Technology Selection: When a problem walks through the door, you know whether it needs a relational database, a document store, a graph, a cache, a warehouse, or a lake — and you can make that case clearly to engineers and non-engineers alike.\n Work AI-First: Bring AI into the team's daily workflow — using it to accelerate schema design, query optimization, documentation, and troubleshooting — and help establish what responsible, effective AI-assisted database work looks like at RTA.\n Build and Evolve Our Data Platform: Lead the design and implementation of data pipelines, data quality frameworks, and data lake or warehouse capabilities on AWS as our analytics and reporting needs grow.\n Performance & Scalability: Proactively find and fix bottlenecks — at the query, index, schema, and configuration level — so our systems stay fast as we grow.\n High Availability & Recovery: Design and maintain backup, replication, and disaster-recovery strategies, and prove they work through regular testing.\n Migrations & Modernization: Plan and execute database upgrades, consolidations, and cloud migrations with minimal disruption to clients.\n Security & Compliance: Partner with Security to enforce secure configurations, access controls, and encryption across every database.\n Standards & Mentorship: Set the data standards for the org, review schema and query changes, and level up engineers on writing data access that scales.\n Observability: Build the monitoring, alerting, and baselining that let us catch problems before clients do.\n Continuous Improvement: Don't maintain the status quo — find the inefficiencies, propose the fix, and drive it through to done.\n Collaboration: Work closely with engineering, product, SRE, and support to plan releases, define environment needs, and resolve data issues quickly.\n\nKey Results Areas (aka the Job Outcomes)\n\n Reliable, Recoverable Data: Databases stay available under load, backups are verified, and recovery objectives are met — not just documented.\n Fast by Design: Queries and schemas perform well at scale, with regressions caught early through baselines and monitoring.\n Right Tool, Right Job: When we face a new data challenge — operational, analytical, or somewhere in between — we have someone who already knows the answer and can build toward it before it becomes a problem.\n AI-Accelerated Team: The team works measurably faster and smarter because you brought modern AI practices to how we design, document, and troubleshoot our data systems.\n Technical Bar Raised: Our data architecture, tooling, and the team's data fluency are meaningfully better because you were here.\n Smooth Migrations: Upgrades and cloud moves land on time, with minimal client impact and no nasty surprises.\n Secure & Compliant: Client data is protected by sound access controls and encryption, with no avoidable exposure.\n Data Platform Ready: When the business is ready to do more with its data — analytics, reporting, ML, AI — the foundational infrastructure is already in place because you laid the groundwork.\n\nQualifications\nOK, the "boring" HR part that's necessary:\n\n 5–7+ years of hands-on database engineering/administration experience, with demonstrated depth — not just tenure.\n Strong proficiency with Microsoft SQL Server and T-SQL; familiarity with MongoDB and/or other non-relational systems is a plus.\n Working knowledge of non-relational database paradigms — document, key-value, wide-column, graph — and a track record of knowing which fits which problem. Hands-on experience with one or more of DynamoDB, MongoDB, Redis, Cassandra, or Neptune is a plus.\n Familiarity with AWS data platform services across relational (RDS, Aurora), non-relational (DynamoDB, ElastiCache, Neptune), warehousing (Redshift), data lake (S3, Glue, Athena, Lake Formation), and pipeline tooling (Kinesis, Glue ETL, or equivalent).\n Experience with data quality practices and tooling — validation, lineage, governance, and anomaly detection.\n Demonstrated, hands-on use of AI tools in day-to-day technical work — and ideally an understanding of the data infrastructure behind AI features (vector databases, RAG, embeddings).\n Experience with data modeling, query optimization, indexing/partitioning, high availability, and backup/disaster recovery.\n Familiarity with scripting (PowerShell, Python, or Bash) and monitoring/observability tooling.\n Prior lead or management experience is a meaningful bonus.\n Bachelor's Degree not required but preferred, especially in computer science or a related field. Relevant certifications (e.g., Microsoft SQL Server, AWS Database Specialty, AWS Data Analytics Specialty) are a plus.\n\nThe Bottom Line\nYou've made it this far — congratulations! We're looking for a rare combination: the technical depth to design serious data systems across relational, non-relational, and cloud-native platforms, a modern AI-augmented way of working, and the humility to serve others well. We don't fully know where our data future is heading — and that's exactly why we need someone who does. If you're the kind of engineer who leaves every schema, query, and data platform measurably better than you found it — and who's already figured out how to make AI a daily multiplier — this is your seat.\nTotal compensation for the role is between $155k - $165k a year. This is a full-time remote role, working side by side with the executive, engineering, and product teams. If all of this is checking off the items on your list, we'd love to hear from you!\n\nWhy Top Talent Chooses RTA \nWe invest in our people — period. \n\n 401(k) with 6% Safe Harbor match (100% vested day one) \n Flexible PTO model built on trust and manager-approved time off \n Cigna PPO and HSA medical plan options with company contributions ($780–$1,950 annually) \n Garner Health HRA program: up to $1,000 individual / $2,000 family reimbursement opportunity \n Wellness rewards up to $350 annually \n Virtual care and mental health support resources \n Company-sponsored benefits including dental, vision, EAP, life, STD, LTD, legal plan, and identity theft protection options \n Additional employee perks, wellness initiatives, and discount programs \n\nThe Part We're Most Proud Of \n\n 99% of employees say RTA is a Great Place to Work® (Certified 3 years running) \n 30% ARR growth — two years straight \n We are an AI-forward company building for the future \n Big growth. Real benefits. Strong culture. A team that delivers. \n\nAbout Us \nRTA has been established since 1979 and has the reputation of providing the best customer service in the market. Our purpose is to help fleets succeed. We pride ourselves on creating a caring, family-oriented atmosphere for both staff and clients, and love that our work makes a positive impact on all the lives we touch. \n\nOur clients carry kids in school buses, first responders in emergency vehicles, patients in ambulances, food and medical supplies in trucks, and people just taking the bus or train to work. We do meaningful work, and we want our clients to have the best tools available to them. \n\nOur office spaces are open, spacious, and colorful, with an abundance of natural light. We come together often as a company to enjoy freshly baked desserts or awesome lunches, and genuinely enjoy each other's company. We offer some pretty unique perks and benefits, as well as all the standard ones. We're happy to talk through all the options. \n\nPhysical & Travel Requirements \nThis role has the following physical and travel requirements: \n\n Ability to sit or stand for extended periods \n Ability to work at a computer for prolonged periods \n Ability to travel up to 60% based on business needs \n Ability to transport trainin