Senior Database Architect - PostgreSQL & Cloud

Adaptiva; Seattle (WA); On-site; USD 110,000 - 120,000; Full time

Benefits offered by this job

100% company-paid health insurance

Performance-based bonuses

401(k) retirement plan

Stock options

Job summary

Adaptiva is seeking a Senior Database Administrator to lead design, development, and optimization of mission-critical databases powering enterprise products. Based in Kirkland, WA, this role focuses on high-scale PostgreSQL/SQL Server environments across development, staging, and production.

You will optimize performance, ensure availability, security, and collaborate with cross-functional teams to resolve complex data challenges in a fast-paced setting.

Qualifications

• Bachelor's or Master's degree in Computer Science, Information Technology, or related technical discipline.
• Expertise in PostgreSQL; MSSQL is a plus.
• Expertise in complex SQL development, schema design, indexing, and query optimization.
• Experience with managing Postgres replication.
• Experience diagnosing and improving performance in large-scale systems.
• Hands-on DB performance improvement techniques including indexing, partitioning, and SQL tuning.
• Proficiency with PL/pgSQL and T-SQL and scripting (Bash) for automation.
• Strong data modeling and ERD skills; experience with data warehousing concepts.
• Knowledge of ETL/ELT processes and loading techniques.

Responsibilities

• Monitor database health, availability, and performance across on-premises and cloud environments.
• Plan capacity and infrastructure requirements for large-scale deployments.
• Troubleshoot and optimize complex SQL queries to improve scalability.
• Maintain and optimize PostgreSQL and SQL Server databases; support replication and clustering.
• Participate in design, development, and optimization of database solutions for enterprise products.
• Collaborate with QA, support, and engineering teams to identify root causes of issues.
• Engage with customers to diagnose DB bottlenecks and resolve data-related pain points.

Skills

PostgreSQL

MSSQL

SQL development

PL/pgSQL

T-SQL

Bash scripting

ERD/data modeling

Data warehousing (DW)

Kubernetes

Cloud Native Postgres

Postgres replication

Query optimization

ETL/ELT

Schema design

Education

Bachelor's or Master's in CS/IT

Tools

Elasticsearch

Loki

GitOps

Kubernetes Operator

Job description

Adaptiva is seeking a Senior Database Administrator to lead design, development, and optimization of mission-critical databases powering enterprise products. Based in Kirkland, WA, this role focuses on high-scale PostgreSQL/SQL Server environments across development, staging, and production.

You will optimize performance, ensure availability, security, and collaborate with cross-functional teams to resolve complex data challenges in a fast-paced setting.