Database Administrator

Clicklease LLC
Draper, United States
2 days ago
Apply on startup.jobs
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Working hours
Regular working hours
Job source

Tech stack

Artificial Intelligence Airflow Amazon Web Services Amazon Elastic Compute Cloud Backup Devices Bash Shell Code Review Databases Information Engineering Data Infrastructure Extract Transform Load (ETL) Data Warehousing
+32 more
Database Analysis Database Servers Linux DevOps Disaster Recovery Failover Monitoring of Systems Python (Programming Language) PostgreSQL Microsoft SQL Server Windows Servers Operational Data Store Operational Databases Performance Tuning Windows PowerShell Query Optimization Runbook Transact-SQL Zabbix Data Processing System Availability Delivery Pipeline Snowflake Grafana Database Performance Change Data Capture Database Migration Gitlab-ci Git Flow Terraform Data Pipelines Automation Anywhere

Job description

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 Our Databases Available & Recoverable

  • 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.

Protect Sensitive Financial Data

  • 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.

Support Engineering & Data Teams

  • 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., * 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.

Requirements

  • 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.

About the 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.

  1. 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.

  2. 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.

  3. 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., 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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on startup.jobs
Prepare application

Good distractions

Loading talks and stories from around this role…