Database Administrator

Clicklease•Draper, UT

10d

About The Position

As a member of the Data Engineering team, the Database Administrator is the technical owner of the databases powering the lending platform, risk and decisioning systems, and customer-facing services. The role works alongside DBAs and Data Engineers and partners closely with DevOps, which owns cloud infrastructure, to keep production databases fast, secure, available, and reliable. The databases are self-hosted on AWS EC2 and include Microsoft SQL Server with a failover replica, PostgreSQL in a primary/replica configuration, and Snowflake as the data warehouse. The role requires deep expertise in either SQL Server or PostgreSQL and strong hands-on experience with the other. The administrator will shape how the data platform is built, deployed, and operated, including moving database tooling and AWS DMS resources under infrastructure-as-code. The role spans availability and disaster recovery, performance and capacity management, production monitoring and incident response, protection of sensitive financial data, safe database deployments, automation, and support for engineering and data teams. It also includes using AI tools to improve analysis and operations, maintaining documentation and runbooks, and collaborating with DevOps on database infrastructure.

Requirements

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

Nice To Haves

Designing database architectures that scale with a business, including partitioning, read scaling, and capacity planning.
Windows Server administration supporting SQL Server and its services.
Monitoring and observability experience with tools such as Zabbix and Grafana.
Experience building or improving CI/CD pipelines for database changes.
Terraform experience, especially bringing existing resources under infrastructure-as-code.
Experience with AWS DMS or other change-data-capture and replication tools.
Experience with data warehouses such as Snowflake, ETL/ELT pipelines, or workflow orchestration tools such as Prefect or Airflow.
Experience supporting SOC 2 or similar compliance audits.
Experience in fintech, lending, payments, banking, or another highly regulated environment.

Responsibilities

Maintain stable and resilient production databases, including failover, replication, and disaster-recovery plans.
Own backup and recovery strategy and automate regular restore and failover testing.
Refresh non-production environments from production data safely and repeatably.
Monitor, troubleshoot, and tune database performance, including queries, indexes, servers, and instance configuration.
Partner with engineers on schema design, query optimization, and efficient data processing.
Plan database capacity and growth proactively.
Build and maintain monitoring, dashboards, and alerting that surface issues early.
Participate in an on-call rotation, resolve database incidents, and follow up with changes that prevent recurrence.
Install, configure, patch, and upgrade self-hosted database servers on EC2 using scripted, repeatable processes.
Manage access according to least-privilege principles and regularly audit roles and permissions.
Implement encryption, secure connections, and auditing to protect sensitive financial and personal data.
Review and deploy database changes and maintain and enforce database deployment best practices.
Improve GitLab CI/CD pipelines for database changes to make releases safer, faster, more automated, and SOC 2 compliant.
Write and review production data fixes carefully.
Automate routine tasks using Python and scripting, and keep runbooks and documentation current.
Provision databases for new services.
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 modern AI tools and agents to accelerate performance analysis, troubleshooting, scripting, and documentation.
Identify opportunities for AI to improve database operations and reliability, and share effective AI workflows with the team.
Bring AWS DMS resources, including replication instances, endpoints, and tasks, under infrastructure-as-code with Terraform.
Collaborate with DevOps on EC2 instances, storage, and networking for databases.
Build repeatable, automated processes for database provisioning, patching, and failover.