Remote PostgreSQL DBA - Mailing list pgsql-jobs

Job Title : Lead Database Architect
Locations: Remote

Get To Know The Team:
DomaniRx is a newly formed organization focused on shaping the future of 
Pharmacy Benefit Management by delivering a cloud-native, API-driven 
claims adjudication platform.

Our team is made up of engineers with varying levels of professional 
experience and backgrounds, from new graduates to 20-year veterans of 
the healthcare industry. We are looking for creative engineers and 
technologists: relevant industry experience is important, but less so 
than your demonstrated abilities, passion and attitude. We’re always 
improving and looking for individuals that enjoy being challenged and 
have a strong desire to make the engineering experience better for our 
users.

Why You Will Love It Here!
Flexibility: Hybrid Work Model & a Business Casual Dress Code, including 
jeans
Your Future: 401k Matching Program, Professional Development Reimbursement
Work/Life Balance: Flexible Personal/Vacation Time Off, Sick Leave, Paid 
Holidays
Your Wellbeing: Medical, Dental, Vision, Employee Assistance Program, 
Parental Leave
Diversity & Inclusion: Committed to Welcoming, Celebrating and Thriving 
on Diversity
Training: Hands-On, Team-Customized, including SS&C University
Extra Perks: Discounts on fitness clubs, travel and more!
What You Will Get To Do:

     Design and develop Database Architecture to solve business and 
business intelligence problems in alignment with the enterprise 
scalability requirements.
     Architect a strategy for sharding and partitioning Postgres 
Databases to meet the performance and high availability requirements of 
constantly growing databases that may reach over 100TB levels.
     Drive the build out of high availability and sharded database 
infrastructures such as Citus-driven (or similar custom sharding and 
cluster driven technologies) infrastructures using Postgres as DBMS. 
     Develop disaster recovery architecture that will enable a complete 
failover to a data center in a different region.
     Architect database backup strategies
     Analyze infrastructures and develop strategies to harden DBMS 
infrastructure security posture.
     You will perform technical planning, architecture development, and 
specification modification.
     You will develop strategies and specifications for new 
products/services, applications, and service offerings.
     You will assess the compatibility and integration of 
products/services proposed to ensure an integrated architecture across 
interdependent technologies is within standards.
     Lead complex database infrastructure projects that require a broad 
perspective, conceptual thinking, and in-depth analysis to identify 
solutions.
     May also lead a process or function without direct reports.
     Demonstrate a depth and breadth of expertise within a discipline 
and has a deep understanding of the business, financials, 
products/services, or market.
     Develop policies and procedures and recommend best practices.
     Advise and provide direction to other data and dba engineers.

What you will bring:

     Minimally requires a bachelor’s degree and 6 years of related 
experience, or a high school degree and 8 years of related experience.
     5 Years experience working with Postgres Relational Databases
     3-5 Years experience working on Datawarehouse Projects
     5 Years Database Design and Architecture
     Must have Citrus or related Postgres database sharding and scaling 
experience.


Note, sharding experience is more important than citus experience



If interested apply here:

https://wd1.myworkdaysite.com/recruiting/ssctech/SSCTechnologies/job/Remote---Missouri-US/Lead-Data-Architect_R32734