Database Administrator
Database Administrator
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Beyond day-to-day use in the field XOi also functions as a central system of record for service organizations helping them make decisions in real-time while maintaining a clear view of their entire asset portfolio. By simplifying communication supporting skills development and turning operational data into practical insights we are making it easier for our customers to access the right information they need to improve revenue reduce costs and keep equipment running longer.
XOi is expanding our Data Platform team and looking for a Database Administrator (DBA). In this role you will be responsible for the performance integrity security and architectural oversight of XOis database systems including PostgreSQL databases a Snowflake data warehouse and associated data platforms. This role involves proactive database management enforcing data architecture standards and serving as the technical authority for all database-related decisions. The DBA will work closely with Engineering Product and Data Science.
Core Responsibilities:
Database Operations & Performance
Proactive Monitoring: Implement comprehensive monitoring for PostgreSQL and Snowflake environments identifying performance issues before they impact users
Performance Optimization: Conduct regular query performance analysis index optimization and database tuning to maintain sub-second response times
Capacity Planning: Monitor database growth patterns and plan for scaling needs across development staging and production environments
Incident Response: Serve as primary on-call resource for database emergencies with authority to make immediate decisions to restore service
Architecture & Standards Enforcement
Schema Design Authority: Review and approve all database schema changes through PR process requiring refactoring when necessary to meet standards
Data Modeling Standards: Enforce consistent naming conventions indexing strategies and relational design patterns across all database objects
Migration Management: Oversee Flyway deployment processes and evaluate tools like Atlas for future migration improvements
Technical Debt Prevention: Identify and prevent anti-patterns that lead to performance degradation or maintenance issues
Development Process Integration
Required PR Reviews: All database-related pull requests must receive DBA approval before merging to production
Code Quality Gates: Implement automated tools (SQLFluff etc.) and manual reviews to maintain SQL code quality
Deployment Oversight: Ensure proper deployment practices and prevent issues like mixing versioned/repeatable migrations
Cross-Team Collaboration
Engineering Partnership: Work diplomatically with development teams building trust through demonstrated value
Best Practices Training: Provide guidance and training to developers on database best practices query optimization and data modeling
Documentation: Maintain comprehensive documentation of database standards procedures and architectural decisions
Stakeholder Communication: Translate technical database concepts for Product and Executive stakeholders
XOi-Specific Requirements
Real-time Data Processing: Optimize database performance for XOis 5000 TPS event-driven architecture
Reporting Integration: Ensure smooth data flow between operational databases and Snowflake analytics platform
Multi-environment Management: Manage database consistency across development integration QA and production environments
Qualifications:
3 years PostgreSQL DBA experience with demonstrated expertise in:
Advanced query optimization and execution plan analysis
Index strategy and maintenance (B-tree partial expression etc.)
Connection pooling replication and high availability setup
Database security and access control management
Familiarity with the AWS ecosystem including Lambdas Kinesis Streams SNS & SQS
SQL Expertise: Advanced SQL skills with ability to optimize complex queries and create efficient data models
Version Control & CI/CD: Experience with Git database migration tools (Flyway in use presently)
Monitoring Tools: Experience with database monitoring platforms and alerting systems
Process and Collaboration Skills:
Authority in Technical Environments: Proven ability to enforce technical standards in collaborative environments
Diplomatic Leadership: Skill in building consensus while maintaining technical authority
Cross-functional Communication: Ability to explain technical concepts to non-technical stakeholders and influence architectural decisions
Problem-Solving Under Pressure: Experience managing database crises while maintaining professional relationships
Bonus Points!
Micro-services Architecture: Understanding of database patterns in micro-services environments
Event-Driven Systems: Experience with databases supporting high-throughput event processing
SaaS Multi-Tenancy: Knowledge of database design patterns for multi-tenant SaaS applications
Snowflake experience including: Warehouse sizing and cost optimization; Data pipeline integration and monitoring; Performance tuning for analytical workloads
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.
Required Experience:
Unclear Seniority
Employment Type
Full-Time
