Database Administrator

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