高级数据库平台工程师
Senior Database Platform Engineer
对于该职位，根据资质、行业经验、教育背景、培训/认证和/或地理位置的不同，Dimensional 合理预期的薪资范围为：
$0 - $0 此职位也符合奖金资格。
职位描述：
雇主：Dimensional Funds Advisors LP
职位：高级数据库平台工程师
工作地点：6300 Bee Cave Road Building One, Austin, TX 78746
职责：为 SQL Server（多子网故障转移集群上的 Always on 可用性组）、PostgreSQL、MongoDB（副本集和分片集群）和 Snowflake（多区域账户和故障转移配置）设计和管理高可用解决方案。为 SQL Server（Windows/SQL 身份验证、CIS 基准合规）、MongoDB（LDAP 身份验证）、PostgreSQL（基于角色的访问控制）和 Snowflake（OAuth 2.0 客户端身份验证）设计安全和身份验证框架。执行数据库维护操作，并与 DPA、SolarWinds 和 Sentry 集成监控，以确保企业应用程序的文档化 RPO/RTO 合规性和正常运行时间。使用 Python 和 PowerShell 集成开发可重用的 Terraform 模块和 Ansible playbook，用于基线标准执行、网络配置自动化、安全数据共享实现和一致的部署模式，以减少开发、测试和生产环境中的配置时间。使用 Python 和 PowerShell 脚本设计中央管理服务器（CMS）基础设施和库存管理系统，以自动发现、注册和跟踪 SQL Server 实例、PostgreSQL 集群、MongoDB 部署和多个 Snowflake 账户，并启用集中式基于策略的管理。为数据库团队提供技术领导和指导，作为高级故障排除的联系人，口头与多个业务部门、应用开发团队、基础设施组和高管利益相关者协作。可在 Dimensional 在加利福尼亚州、德克萨斯州或北卡罗来纳州设有办公室的居家办公。
最低要求：电气工程、计算机科学、计算机工程或相关领域的学士学位，并有 7 年相关经验，包括：(1) 为 SQL Server（多子网故障转移集群上的 Always on 可用性组）、PostgreSQL、MongoDB（副本集和分片集群）和 Snowflake（多区域账户）设计和管理高可用解决方案；
查看英文原文
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 - $0This 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.
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 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.
Application Instructions: Email: & reference Job ID# DFLP-ATX25-VRDO in the subject line. EOE
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.
Originally posted on Himalayas