Senior Database Platform Engineer

Dimensional Fund Advisors; United States; Remote; USD 125,000 - 185,000; Full time

Benefits offered by this job

Bonus eligible

Remote work option

Job summary

Dimensional Funds Advisors LP seeks a Senior Database Platform Engineer to design, deploy, and manage high-availability database platforms (SQL Server, PostgreSQL, MongoDB, Snowflake) and implement secure authentication frameworks. You will automate deployment with Terraform/Ansible, monitor systems for uptime, and mentor the database team.

Remote/hybrid options may apply from home offices in CA/TX/NC. The role requires extensive experience across multiple DB engines, cloud data solutions, and

Qualifications

• Bachelor’s degree in Electrical Engineering, Computer Science, Computer Engineering, or related field and 7 years of relevant experience.
• Experience engineer and administer high availability for SQL Server, PostgreSQL, MongoDB, and Snowflake.
• Experience with security/authentication frameworks and CIS Benchmark compliance.
• Hands-on with Terraform modules and Ansible playbooks for deployment automation.
• Knowledge of data ingestion, Snowflake external tables, and Apache Iceberg formats is a plus.
• Strong collaboration with cross-functional teams and stakeholder communication.

Responsibilities

• Engineer and administer high availability for SQL Server, PostgreSQL, MongoDB, and Snowflake across multi-region setups.
• Develop security/authentication frameworks (LDAP, OAuth 2.0) and enforce RBAC and CIS benchmarks.
• Manage database maintenance, monitoring (DPA, SolarWinds, Sentry) for uptime and RPO/RTO.
• Build reusable Terraform modules and Ansible playbooks with Python/PowerShell integrations.
• Lead CMS-like inventory and policy-based management for database assets; mentor team.
• Collaborate with business, development, and infra teams; may work from home office in CA/TX/NC.

Skills

SQL Server

PostgreSQL

MongoDB

Snowflake

Terraform

Ansible

Python

PowerShell

OAuth 2.0

LDAP authentication

Monitoring tools

Leadership/mentorship

Education

Bachelor's degree in Electrical Engineering, Computer Science, Computer Engineering, or related field

Master's degree in Electrical Engineering, Computer Science, Computer Engineering, or related field

Tools

Terraform

Ansible

Python

PowerShell

Snowflake

SQL Server

Job description

For this position, which is subject to credentials, industry experience, education, training/certifications, and/or geographic differentials, Dimensional reasonably expects to pay a salary range of:

$0 - $0

This role is also bonus eligible.

Job Description:

EMPLOYER: Dimensional Funds Advisors LP.

POSITION: Senior Database Platform Engineer

WORKSITE: 6300 Bee Cave Road Building One, Austin, TX 78746

DUTIES: Engineer and administer high availability solutions for SQL Server (Always on Availability Groups on multi-subnet failover clusters), PostgreSQL, MongoDB (replica sets and sharded clusters), and Snowflake (multi-region accounts with failover configurations). Engineer security and authentication frameworks for SQL Server (Windows/SQL authentication, CIS Benchmark compliance), MongoDB (LDAP authentication), PostgreSQL (role-based access controls), and Snowflake (OAuth 2.0 client authentication). Database maintenance operations, and monitoring integration with DPA, SolarWinds, and Sentry to ensure documented RPO/RTO compliance and uptime for enterprise applications. Develop reusable Terraform modules and Ansible playbooks using Python and PowerShell integration for baseline standard enforcement, network configuration automation, secure data sharing implementation, and consistent deployment patterns reducing provisioning time across development, staging, and production environments. Engineer Central Management Server (CMS) infrastructure and inventory management systems using Python and PowerShell scripting to automatically discover, register, and track SQL Server instances, PostgreSQL clusters, MongoDB deployments, and multiple Snowflake accounts with enabling centralized policy-based management. Provide technical leadership and mentorship to database team while serving as escalation point of contact for advanced troubleshooting, collaborating verbally with multiple business departments, application development teams, infrastructure groups, and executive stakeholders. May work from a home office where Dimensional has an office in California, Texas, or North Carolina. #LI-DNI

MINIMUM REQUIREMENTS: Bachelor’s degree in Electrical Engineering, Computer Science, Computer Engineering, or related field and 7 years of experience stated herein to involve: (1) engineer and administer high availability solutions for SQL Server (Always on Availability Groups on multi-subnet failover clusters), PostgreSQL, MongoDB (replica sets and sharded clusters), and Snowflake (multi-region accounts with failover configurations); (2) engineer security and authentication frameworks for SQL Server (Windows/SQL authentication, CIS Benchmark compliance), MongoDB (LDAP authentication), PostgreSQL (role-based access controls), and Snowflake (OAuth 2.0 client authentication); (3) database maintenance operations, and monitoring integration with DPA, SolarWinds, and Sentry to ensure documented RPO/RTO compliance and uptime for enterprise applications; (4) develop reusable Terraform modules and Ansible playbooks using Python and PowerShell integration for baseline standard enforcement, network configuration automation, secure data sharing implementation, and consistent deployment patterns reducing provisioning time across development, staging, and production environments; (5) designed and implemented enterprise data ingestion solutions leveraging Snowflake External Tables and Apache Iceberg table formats to consume data from Amazon S3 base data lakes; and (6) configured and Managed Snowflake integrations (Security/Storage) enabling connectivity with PowerBI, Sigma and SailPoint applications. Also, 2 years experience stated herein to involve engineering experience and usage with Kafka. May work from a home office where Dimensional has an office in California, Texas, or North Carolina.

ALTERNATIVE REQUIREMENTS: In lieu of a Bachelor’s degree, employer will accept a Master’s degree in Electrical Engineering, Computer Science, Computer Engineering, or related field and 5 years of experience stated herein to involve: (1) engineer and administer high availability solutions for SQL Server (Always on Availability Groups on multi-subnet failover clusters), PostgreSQL, MongoDB (replica sets and sharded clusters), and Snowflake (multi-region accounts with failover configurations); (2) engineer security and authentication frameworks for SQL Server (Windows/SQL authentication, CIS Benchmark compliance), MongoDB (LDAP authentication), PostgreSQL (role-based access controls), and Snowflake (OAuth 2.0 client authentication); (3) database maintenance operations, and monitoring integration with DPA, SolarWinds, and Sentry to ensure documented RPO/RTO compliance and uptime for enterprise applications; (4) develop reusable Terraform modules and Ansible playbooks using Python and PowerShell integration for baseline standard enforcement, network configuration automation, secure data sharing implementation, and consistent deployment patterns reducing provisioning time across development, staging, and production environments; (5) designed and implemented enterprise data ingestion solutions leveraging Snowflake External Tables and Apache Iceberg tableformats to consume data from Amazon S3 base data lakes; and (6) configured and Managed Snowflake integrations (Security/Storage) enabling connectivity with PowerBI, Sigma and SailPoint applications. Also, 2 years experience stated herein to involve engineering experience and usage with Kafka. May work from a home office where Dimensional has an office in California, Texas, or North Carolina.

Dimensional offers a variety of programs to help take care of you, your family, and your career, including comprehensive benefits, educational initiatives, and special celebrations of our history, culture, and growth.

It is the policy of the Company to provide equal opportunity for all employees and applicants. The Company recruits, hires, trains, promotes, compensates, and administers all personnel actions without regard to actual or perceived race, color, religion, religious practice, creed, sex, sex stereotyping, pregnancy (which includes pregnancy, childbirth, and medical conditions related to pregnancy, childbirth, or breastfeeding), caregiver status, gender, gender identity, gender expression, transgender identity, national origin, age, mental or physical disability, ancestry, medical condition, marital status, familial status, domestic partnership status, military or veteran status or service, unemployment status, citizenship status or alienage, sexual orientation, status as a victim of domestic violence, status as a victim of stalking, status as a victim of sex offenses, genetic information, political activities or recreational activities, arrest or conviction record, salary history, natural hairstyle or any other status protected by applicable law except as otherwise required or permitted by law or regulation applicable to the Company or its affiliates.