Innovetive Petcare is a culture-first company that provides resources towards redefining the veterinary lifestyle.
Database Architect
Location
Texas
Posted
15 days ago
Salary
$130K - $150K / year
Seniority
Lead
Job Description
Database Architect
Innovetive Petcare
• Design, build, and maintain a scalable enterprise data platform using Snowflake • Architect ingestion pipelines across clinical, financial, operational, scheduling, and inventory systems • Implement scalable ELT/ETL workflows and data transformation pipelines • Define platform standards for data governance, naming conventions, CI/CD workflows, environment management, testing and deployment strategies • Manage Snowflake architecture, RBAC, security, cost optimization, and performance tuning • Own the dbt ecosystem end-to-end • Build scalable dimensional and canonical data models • Develop reliable marts and semantic layers for analytics consumption • Implement robust testing, lineage, and documentation standards • Create reusable transformation logic and framework standards • Partner with finance, operations, and clinical leaders to deliver trusted Tableau dashboards and reporting layers • Build governed, self-service analytics capabilities • Optimize Tableau performance, row-level security, and published data sources • Translate ambiguous business questions into scalable technical solutions • Implement observability and monitoring solutions for data freshness, schema drift, pipeline failures, and anomaly detection • Establish governance standards for sensitive and healthcare-adjacent data • Improve trust and reliability across enterprise reporting • Serve as a technical standard-bearer for architecture and engineering best practices • Help shape the future structure of the data organization • Mentor future team members as the function grows
Job Requirements
- 10+ years of hands-on experience in Data Architecture and Database Management
- Proven experience building and operating production-grade data platforms
- Experience working with complex, multi-source enterprise datasets
- Background supporting operational, financial, healthcare, or clinical data environments preferred
- Advanced expertise with Snowflake, dbt, Tableau, SQL, Python
- Experience with Snowpipe, Streams & Tasks, Incremental modeling strategies, Data warehouse optimization, Semantic layer design
- Familiarity with orchestration tools such as Airflow, Prefect, Dagster
- Strong understanding of cloud infrastructure (AWS, Azure, or GCP), Git workflows, CI/CD pipelines, Data governance and security best practices
- You are deeply technical and enjoy building systems yourself
- You think architecturally and understand downstream data impacts
- You thrive in high-autonomy, remote-first environments
- You communicate effectively with both technical and non-technical stakeholders
- You balance speed, scalability, reliability, and maintainability.
- Preferred Qualifications: Residing in Austin, Texas with easy access to our home office location.
- Experience in veterinary healthcare, healthcare technology, or other regulated industries
- Exposure to healthcare-adjacent compliance and governance environments
- Experience building enterprise analytics ecosystems from early-stage or greenfield environments.
Benefits
- Competitive base salary
- Comprehensive health benefits
- Paid time off
- Remote work flexibility
- Career growth opportunities
- Collaborative and mission-driven culture
Related Guides
Related Categories
Related Job Pages
More Database Administrator Jobs
• Administration of MySQL and PostgreSQL databases, including creation, configuration, permissions and organization of environments; • Monitoring and performance optimization, including query analysis, indexing, bottleneck identification and database best practices; • Support for backup, recovery, availability and data security routines; • Monitoring and observability of environments using metrics and monitoring tools; • Support in data structuring, modeling and organization, following relational and analytical best practices; • Development and optimization of SQL queries, stored procedures, functions and other advanced database features; • Support for automations and database-related processes using scripts and supporting tools when needed; • Troubleshooting, incident analysis and resolution of issues related to databases; • Technical documentation, team guidance and dissemination of best practices for database usage.
• Install, maintain, and troubleshoot RHEL/OEL OS supporting Oracle databases in physical and virtualized environments. • Provide DBA services to application development, professional services, and support teams, including database design, query validation/execution, and performance tuning. • Troubleshoot database alerts, logs, jobs, disk groups, tablespaces, and resolve performance-related issues. • Automate database tasks and develop scripts to improve efficiency and reduce manual intervention. • Lead the design and implementation of database infrastructure solutions to meet business requirements. • Manage the implementation of technical controls to enforce security policies. • Ensure compliance with SOC2/ISO27001 audits and adhere to all audited controls. • Design, implement, and maintain DR methodologies, ensuring documentation is up to date. • Periodically validate Oracle 19c backup/recovery operations using RMAN. • Assume responsibility for documenting and maintaining disaster recovery plans for each supported system. • Research, evaluate, design, test, and recommend new database software versions and related tools. • Act as a mentor for junior DBAs and provide technical guidance. • Assist development teams in improving database design and PL/SQL best practices. • Provide 24/7 on-call rotational support, including occasional weekend coverage. • Familiarity with monitoring tools like DataDog, Solarwinds, site24/7 or OEM.
Senior Product Manager – Cloud Database, Integrations
DittoReal-time database for mobile, web, IoT, and server apps that can magically sync data with or even without the internet.
• Own the end-to-end product roadmap for Ditto's cloud database • Own the data flow story for Ditto Cloud • Define and maintain customer-facing database SLAs • Own the data migration story • Engage directly with enterprise customers to understand workload patterns • Serve as the go-to voice on the customer data layer inside engineering • Collaborate with GTM and field teams to build enablement assets • Define success metrics for database reliability and drive accountability against them
Role Description We are seeking a highly experienced Senior Oracle Developer & Database Administrator (DBA) to support mission-critical applications and databases. The ideal candidate will possess strong expertise in Oracle database administration, PL/SQL development, production support, performance tuning, database migration, and cloud migration initiatives involving AWS and Red Hat Linux environments. Key Responsibilities - Develop and maintain Oracle PL/SQL packages, procedures, functions, triggers, and database objects. - Provide Level 2/Level 3 production support and resolve critical database issues. - Perform data analysis, troubleshooting, and data correction activities. - Administer Oracle databases including installation, configuration, upgrades, patching, backup, and recovery. - Design, implement, and maintain materialized views and database performance optimization strategies. - Support database migration projects across on-premises, AWS, and Red Hat Linux (RHEL) environments. - Monitor database performance and proactively resolve bottlenecks. - Perform database security, user management, and access control administration. - Execute database deployment, release management, and post-deployment validation. - Collaborate with development, infrastructure, and DevOps teams to ensure system reliability and availability. Qualifications - Strong Oracle Database Administration (DBA) experience. - Advanced PL/SQL development expertise. - Experience with production support and incident management. - Strong SQL performance tuning and query optimization skills. - Experience with materialized views, partitioning, and database performance monitoring. - Hands-on experience with Oracle database migration and upgrade projects. - Experience working with AWS services (RDS, EC2, DMS, S3, CloudWatch). - Experience supporting Oracle databases on Red Hat Enterprise Linux (RHEL). - Knowledge of backup/recovery strategies, RMAN, Data Pump, and disaster recovery. - Strong analytical and troubleshooting skills. Preferred Skills - Oracle RAC and Data Guard. - Shell scripting (Linux/Unix). - DevOps and CI/CD exposure. - Experience in large-scale enterprise production environments. Key Competencies - Oracle DBA - Data Architecture & Engineer - Database Migration - AWS Cloud Migration - Red Hat Linux Administration - Production Support - Data Fixes & Troubleshooting - Materialized Views - Performance Tuning - Backup & Recovery - Root Cause Analysis
