Database Reliability Engineer

ClickLease; Draper (UT); In loco; USD 110.000 - 160.000; Tempo pieno

Descrizione del lavoro

Clicklease is seeking an experienced Data Engineer to own and operate our on-prem/AWS hosted databases (SQL Server, PostgreSQL, Snowflake) powering our lending platform. You’ll work with the DBA, Data Engineers, and DevOps to keep production databases fast, secure, and reliable.

You will drive backups, migrations, and automation of deployments, while advancing IaC and monitoring. This fintech environment emphasizes high availability, disaster recovery, and scalable data operations.

Competenze

• 3+ years administering SQL Server or PostgreSQL in production.
• High availability, disaster recovery, and backup/restore, including failover replicas.
• Running self-hosted databases on AWS EC2 and Linux, in partnership with DevOps.
• Performance tuning and query optimization, plus strong SQL skills, including stored procedures.

Mansioni

• Keep production databases stable with failover, replication, and disaster-recovery plans.
• Own backup and recovery strategy and automate restores and failover tests.
• Refresh non-production environments safely from production data.
• Monitor, troubleshoot, and tune performance (queries, indexes, configs).
• Partner with engineers on schema design and data processing efficiency.
• Build and maintain monitoring, dashboards, and alerting; participate in on-call rotation.
• Automate database deployments and CI/CD pipelines; apply IaC practices.

Conoscenze

SQL Server

PostgreSQL

Python

PowerShell

Bash

Terraform

Git workflows

CI/CD

AWS EC2

Snowflake

Data warehousing

Runbooks

On-call

Security

Strumenti

Snowflake

Grafana

Descrizione del lavoro

Established in 2018, Clicklease is dedicated to empowering small business owners frequently overlooked by traditional lenders. Our headquarters are located in the vibrant city of Draper, UT, with operations extending to Radial, Alajuela, Costa Rica. We've cultivated a dynamic environment where equipment financing goes beyond being a mere service; it acts as the gateway to realizing entrepreneurial dreams.

Our Core Values:

1. We Are A Happy Company:
At Clicklease, happiness is not just a byproduct; it's a fundamental value. Join a workplace where positivity and joy are cultivated, creating an environment where you can bring your best self to work every day.

2. We Celebrate Collective Intelligence:
We thrive on the brilliance of collaboration. Clicklease is a space where diverse minds come together, combining their intelligence to create solutions that matter. Your ideas are not just heard; they're celebrated.

3. We Practice Empathy:
Empathy isn't just a word in our dictionary; it's a daily practice. Join a team that values understanding and compassion. At Clicklease, we recognize the human side of business and foster a culture where empathy is a guiding principle.

4. We Listen & Learn:
Growth is a continuous journey at Clicklease. We believe in listening and learning from one another. Your insights and experiences contribute to our collective knowledge, making us stronger as a team.

Our Mission:

At Clicklease, we have a clear purpose - to fulfill the capital needs of underserved entrepreneurs and their Main Street Businesses. We achieve this mission through simple, fast, and innovative equipment leasing solutions. This is not just a statement; it's the driving force behind everything we do.

As a member of our Data Engineering team, you’ll be a technical owner of the databases that power our lending platform, risk and decisioning systems, and customer-facing services. You’ll work alongside our DBA and Data Engineers, in close partnership with our DevOps team, who own our cloud infrastructure, to keep production databases fast, secure, and reliable.

Our databases are self-hosted on AWS EC2: Microsoft SQL Server with a failover replica, and PostgreSQL in a primary/replica configuration, alongside Snowflake as our data warehouse. We’re looking for someone with deep expertise in SQL Server or PostgreSQL and strong hands-on experience with the other.

You won’t just keep the lights on. You’ll help shape how we build, deploy, and operate our data platform, including bringing our database tooling under infrastructure-as-code.

What You’ll Be Doing

• Keep production databases stable and resilient, with reliable failover, replication, and disaster-recovery plans.
• Own backup and recovery strategy and automate regular testing of restores and failover.
• Refresh non-production environments from production data safely and repeatably.

Drive Performance & Scalability

• Monitor, troubleshoot, and tune database performance, from queries and indexes to server and instance configuration.
• Partner with engineers on schema design, query optimization, and efficient data processing.
• Plan for capacity and growth before they become problems.

Operate & Monitor Production

• Build and maintain monitoring, dashboards and alerting that surface issues early.
• Participate in an on-call rotation, responding to and resolving database incidents, then following up with fixes that prevent repeats.
• Install, configure, patch, and upgrade self-hosted database servers on EC2, using scripted, repeatable processes.
• Manage access using least-privilege principles, and audit roles and permissions regularly.
• Implement encryption, secure connections, and auditing to protect sensitive financial and personal data.

Improve How We Ship Database Changes

• Review and deploy database changes and maintain and enforce best practices for database deployments.
• Improve our GitLab CI/CD pipelines for database changes, making releases safer, faster, more automated, and SOC 2 compliant.
• Write and review production data fixes with care.
• Automate routine tasks with Python and scripting and keep runbooks and documentation current.
• Provision new databases as new services come online.
• Support data engineering pipelines, including AWS DMS replication and orchestration, that move operational data into Snowflake.
• Help developers with database access, troubleshooting, and best practices.

Use AI to Work Better & Faster

• Use modern AI tools and agents to accelerate performance analysis, troubleshooting, scripting, and documentation.
• Identify opportunities where AI can improve database operations and reliability.
• Share effective AI workflows and techniques with the team.

Improve How We Ship Database Changes

• Bring our AWS Database Migration Service (DMS) resources, including replication instances, endpoints, and tasks, under infrastructure-as-code with Terraform.
• Collaborate with DevOps on the EC2 instances, storage, and networking for our databases.
• Build repeatable, automated processes for database provisioning, patching, and failover.

What We’re Looking For

Required Qualifications

• 3+ years of administering SQL Server or PostgreSQL in production, with strong hands-on skills in the other.
• High availability, disaster recovery, and backup/restore, including failover replicas, streaming replication, and point-in-time recovery.
• Running self-hosted databases on AWS EC2 and Linux, in partnership with DevOps.
• Performance tuning and query optimization, plus strong T-SQL and SQL, including stored procedures and functions.
• Instance configuration, security, roles, and routine maintenance across both engines.
• Automation with Python and working knowledge of PowerShell and Bash, using Git-based workflows with code review and staged deployments.
• Strong troubleshooting skills and a calm approach to production incidents.
• Strong written communication for runbooks, documentation, and tickets.
• Using AI-assisted tools for database analysis and operations.

What Will Make You Stand Out

• Designing database architecture that scales with the business, such as partitioning, read scaling, and capacity planning.
• Windows Server administration in support of SQL Server and its services.
• Monitoring and observability with tools like Zabbix and Grafana.
• Building or improving CI/CD pipelines for database changes.
• Terraform, especially bringing existing resources under infrastructure-as-code.
• AWS DMS or other change-data-capture and replication tools.
• Data warehouses (e.g., Snowflake), ETL/ELT pipelines, or workflow orchestration tools (e.g., Prefect, Airflow).
• Supporting SOC 2 or similar compliance audits.
• Fintech, lending, payments, banking, or another highly regulated environment.

What Success Looks Like

You’ll Be Successful When

• Our databases are stable, fast, and recover predictably when something goes wrong.
• Performance problems are caught early and fixed at the root.
• Database changes ship safely and routinely through automated pipelines.
• Database infrastructure is defined in code, and changes are repeatable and reviewable.
• Access to sensitive data is controlled and auditable.
• Engineers trust the data platform and know where to go for help.
• Database knowledge is documented and shared rather than concentrated with a few individuals.

The Person We’re Looking For

You are an owner first.

You enjoy digging into execution plans and wait stats, but you also understand that the goal is reliable systems for the business.

You think about what happens when a server fails, a restore is needed, or a deployment goes wrong, not just when everything works.

You’d rather automate a task than do it twice.

Most importantly, you want the systems you run to keep performing reliably and scale as Clicklease grows.