Senior Database Platform Engineer

$0 - $0

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 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: [email protected] & 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.