Senior Database Platform Engineer

EMPLOYER:

Dimensional Funds Advisors LP.

For this position, which is subject to credentials,industry experience, education, training/certifications,and/or geographic differentials, Dimensional reasonablyexpects to pay a salary range of: $0 - $0 This role is alsobonus eligible.

• 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, Solar Winds, and Sentry to ensure documented RPO/RTO compliance and uptime for enterprise applications.
• Develop reusable Terraform modules and Ansible playbooks using Python and Power Shell 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 Power Shell 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.

• 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, Solar Winds, and Sentry to ensure documented RPO/RTO compliance and uptime for enterprise applications; (4) develop reusable Terraform modules and Ansible playbooks using Python and Power Shell 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…