Senior Postgres Database Administrator

For years field service has relied on experience and instinct to keep the world runningbut as teams shrink equipment evolves and expectations rise instinct alone isnt enough. Thats where XOi comes in. As the data intelligence solution built for those who design maintain and depend on critical equipment we turn asset data into uptimeempowering every stakeholder with the visibility and foresight to move from reactive work to proactive planning and predictive maintenance. With unmatched transparency across every stage of the asset lifecycle XOi delivers the right information to the right person at the right timebecause when assets perform at their best so does everything around them.

XOi is expanding our Data Platform team with a Senior Postgres Database Administrator who will own the performance integrity security and architecture of our data platforms. You will set database strategy and standards partner closely with product and application engineers and act as the liaison between Engineering (OLTP/operational systems) and Data/Analytics (Snowflake/OLAP). Your work will directly shape developer experience application performance and the reliability and cost-effectiveness of our data infrastructure supporting a 5000 TPS event-driven architecture.

How our teams collaborate

Youll work daytoday with software engineers data engineers and platform engineers leading design reviews for schema and query changes teaching best practices and continuously improving our data platform. Personality and culture fit mattersa calm curious problemsolver who can recommend pragmatic approaches translate tradeoffs and elevate the whole team.

Why this role matters

• Ensure our transactional Postgres systems deliver low-latency high-throughput experiences for customers and developers.

• Provide clear design boundaries and pipelines between application databases (OLTP) and reporting/analytical workloads (OLAP) to keep each fast and reliable.

• Reduce friction for developers through safe predictable schema change processes excellent observability and clear standards.

What you will own

Partner to Engineering & Developer Experience

• Serve as a trusted partner to application teams helping to translate product and feature needs into resilient data designs.

• Design safe-migration patterns (back/forward compatible; avoid long locks) establish review SLAs templates and linters to keep PRs fast and predictable.

• Coach engineers on query design index selection and data modeling for highperformance applications.

• Document and socialize OLTP vs. OLAP boundaries.

Database Operations & Performance (PostgreSQL)

• Implement comprehensive monitoring/alerting

• Drive query and schema tuning to maintain subsecond p95 and healthy p99s at peak.

• Optimize the sizing and operating parameters of the database for maximum efficiency and speed.

• Establish and apply partitioning strategy to balance write throughput maintenance and query performance.

• Own index lifecycle with guardrails to avoid write amplification and lock contention.

Reliability HA/DR & Incident Leadership

• Lead the DB oncall rotation; act as incident commander for Sev1/Sev2; run blameless postmortems with actionable followups.

• Architect and test HA/DR; define and meet RTO/RPO; maintain runbooks; conduct quarterly DR tests.

• Own SLOs for latency error rate and availability; implement safeguards for long transactions hot partitions and lock storms.

Architecture & Standards Enforcement

• Schema Design Authority: review and approve DB schema changes through PRs; collaborate with Engineers to refactor changes when potential issues are identified; prevent antipatterns (e.g. overnormalized hot paths unbounded transactions crossservice coupling).

• Enforce consistent naming conventions indexing strategies and relational patterns; author ADRs and living standards.

• Work closely with Engineering team to establish standards for database tooling strategy

Development Process & Change Management

• Gate database code via Gitbased PR reviews; implement quality gates (SQLFluff CI checks static analysis); promote rollout patterns (blue/green canary backfills).

• Ensure environment parity and safe deployments (avoid mixing versioned/repeatable migrations; data migrations that scale; zero/nearzero downtime changes).

Analytical Data Flow & Performance

• Maintain clean data contracts and pipelines between OLTP and Snowflake; ensure workload isolation and minimal impact to primaries.

• Leverage Snowflake for data integration from multiple sources and ensuring consumers of the data have performant queries and views.

Stakeholder Communication & Culture

• Act as the liaison between Engineering and Dataalign priorities clarify tradeoffs and communicate impact to Product and Executive stakeholders.

• Elevate team capability via training brownbags and accessible documentation; model calm diplomatic leadership in highpressure moments.

Qualifications (What youve done)

• 58 years production PostgreSQL DBA experience at scale including:

  • Advanced execution plan analysis; SQL tuning; lock/transaction troubleshooting.

  • Index strategy and maintenance (Btree/partial/functional/covering; GIN/GiST when appropriate).

  • Partitioning design and operations (and when not to partition).

  • Connection pooling (pgBouncer) replication (physical/logical) and HA.

  • Security and access control management; audit and compliance awareness.

• Strong understanding of application development and how DB design impacts developer experience (safe migrations backward compatibility featureflagged rollouts testability).

• Proven data modeling skills for highthroughput systems (OLTP) and familiarity with analytical modeling concerns (OLAP) without polluting operational workloads.

• Monitoring/Observability: Comfortable building actionable alerts and dashboards (e.g. Datadog/Prometheus/Grafana) and debugging via pgstat*.

• CI/CD & Migrations: Gitbased workflows; Flyway (in use); quality gates (SQLFluff or similar).

• Cloud & Messaging: Practical AWS (RDS/Aurora or selfmanaged EC2) Lambdas Kinesis SNS/SQS.

• Snowflake: Experience with warehouse sizing workload management performance tuning and cost optimizationor equivalent modern warehouse experience.

• Soft skills/culture: Empathetic partner clear communicator to technical and nontechnical audiences able to build consensus while maintaining technical standards.

Bonus Points

• Multitenant SaaS data patterns; micro-services data architecture (perservice DBs; CDC; outbox pattern).

• Eventdriven highthroughput systems; workload isolation via read replicas/CDC for reporting.

• Experience formalizing data contracts lineage and governance.

XOi Benefits

• XOi offers a comprehensive benefits package that includes medical dental and health with eligibility the 1st of the next month following your date of hire

• XOi offers a 401(k) with eligibility at 90 days

• XOi offers Discretionary Time Off

• All new employees receive a one time $500 New Hire Stipend to support any updates needed for your home office space

• All employees receive a $50/monthly stipend to be used for personal wellness and $50/ monthly stipend towards internet expenses

XOi Technologies is an Equal Opportunity Employer

At XOi we value individuality and the unique qualities we all bring to an organization. We believe we all bring experiences that have an incredible impact on our product and the experience our customers gain from using our products. We do not discriminate against employees based on race color religion sex national origin gender identity or expression age disability pregnancy (including childbirth or other related medical condition) genetic information protected military or veteran status sexual orientation or any other characteristic protected by applicable federal state or local laws.