Database Administrator bei XOi Technologies
XOi Technologies · Nashville, Vereinigte Staaten Von Amerika · Hybrid
- Professional
- Optionales Büro in Nashville
XOi Technologies is a data intelligence solution that helps field service teams connect people and equipment in ways that make everyday work more transparent and efficient. Our platform gives technicians tools to capture and access critical job-site information, get remote support when needed, and share clear records of the work they perform through photos and videos. As an AI-driven platform, we are building intelligent capabilities directly into the workflow. From something as simple as entering a dataplate, like model, serial number, and manufacturer, our solution can automatically provide specifications, features, and performance details that technicians and managers can act on immediately.
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 XOi's 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 XOi's 5,000+ 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.