About Opeeka

Opeeka is an innovative technology company, committed to boosting the health and well-being of people from all walks of life. Opeeka is the nation’s leader in care collaboration and “person-centered” outcomes measurement. We provide a robust Software as a Service (SaaS) solution to Healthcare Providers, Healthcare Insurance Companies, Government Agencies, and Community Based Organizations that serve people in need. Opeeka’s success and impact has been recognized in the healthcare industry and we are poised to significant growth and continued impact. Learn more at www.opeeka.com/news

Person-Centered Intelligence Solution (P-CIS), Opeeka’s principal technology, is a patient outcomes platform that connects to care organizations’ existing technology to extend its capability to support value-based care. Payers, states, counties, and care providers use P-CIS to unify the continuum of care, reduce burden on staff, and improve patient outcomes. There is no other technology on the market like P-CIS. It is the only platform to symbiotically work within the ecosystem of care technology to improve workflow, outcomes, care coordination, and overall care system performance.

Opeeka is searching for individuals to join our team who are comfortable working in a fast paced environment and are interested in leveraging their proven skills to help Opeeka capitalize on the significant growth opportunities ahead. If you are someone who is looking for an exciting opportunity with an early stage technology leader, keep reading.

Company Benefits

Opeeka offers a full range of competitive Company benefits to eligible employees.

Vacation

Full-time employees are eligible to earn and accrue vacation upon the first day of work. All full-time employees are eligible to accrue at least 80 hours of paid vacation time annually, and annual vacation time increases based on tenure.

Sick Time

All employees will be granted 5 days (40 hours) of paid sick leave in a lump sum at the time of hire and subsequently, at the beginning of each year on January 1st. Employees may begin to use paid sick leave on their 90th day of employment (or sooner, if applicable law requires). Employees can use up to 5 days (40 hours) of paid sick leave per year.

Holiday Pay

Upon hire, all employees will receive holiday pay for the Company observed holidays, which includes most Federal Holidays and the day after Thanksgiving, and the week between Christmas Day and New Year's Day.

Medical Insurance Benefits

Opeeka provides the option of a comprehensive medical insurance plan for eligible full-time employees and their dependents. Employees are eligible to enroll in the medical program on the first of the month following 30 days of continuous employment. The Company will pay a portion of the medical insurance premium, up to $800 per employee and up to $600 for covered dependent(s). Medical insurance benefits are available to employees, the employee’s spouse or registered domestic partner, and the employee’s legal dependents.

Dental and Vision Benefits

Eligible full-time employees may also enroll in an employee only, an employee plus children or a family contract on the first of the month following 30 days of employment. For eligible full-time employees, the Company will contribute 100% of the Dental plan cost for the Employee. Employee is responsible for 100% of the cost for covered dependent(s). Employees are responsible for 100% of the cost of Vision coverage.

Retirement Plan

Opeeka provides eligible full-time employees with a Safe Harbor 401k plan. The Company will match an employee’s elective contributions on a dollar-for-dollar basis, up to 4% of your annual compensation. Full-time employees are eligible to enroll in the 401K plan following 90 days of continuous employment.

Job Summary

We are seeking a highly skilled Senior Database Administrator / Database Architect with deep expertise in Microsoft SQL Server and Azure cloud database platforms to lead the design, administration, and optimization of our data environment.

This role combines hands-on database administration, data architecture leadership, and support for data integration pipelines. You will partner closely with our Enterprise Architect, developers, product teams, and customer onboarding teams to ensure our data platform is secure, scalable, performant, and aligned with evolving business needs.

A key aspect of this role includes working with new customers during onboarding to ingest historical data, design and implement data pipelines, and support successful go-live readiness. This requires the ability to understand external data structures, map and transform data into our platform, and ensure data quality, integrity, and performance from initial ingestion through production use.

As a small and highly collaborative organization, this role requires someone who is comfortable wearing multiple hats—balancing strategic architecture with hands-on execution across database operations, performance optimization, and data integration.

Duties & Responsibilities

Azure SQL & Infrastructure Management

• Administer and manage Azure SQL Database and Azure SQL Managed Instances (MI) across multiple environments (dev/test/prod)
• Design and maintain secure, scalable, and highly available database architectures in Azure
• Configure and manage replication and data movement between Managed Instances and Azure SQL Database
• Ensure optimal connectivity, networking, and access controls across Azure environments

Database Architecture & Strategy

• Partner with the Enterprise Architect and engineering teams to define and evolve data architecture standards and best practices
• Lead design and governance of: Database schema, Data models, Naming conventions and database object standards
• Define and implement multi-tenant database strategies, including: Tenant isolation models (shared vs isolated architectures), Cross-tenant data sharing and access patterns, Data partitioning and scalability approaches.
• Establish best practices for data lifecycle management, governance, and consistency
• Evaluate and recommend new Azure data services and architectural patterns

Data Pipelines & Integration (ETL Support)

• Support and contribute to data integration pipelines and ETL processes for both operational and analytical workloads
• Partner with engineering teams to ensure efficient, reliable, and scalable data movement
• Assist in troubleshooting and optimizing data ingestion, transformation, and loading processes
• Help define best practices for data quality, validation, and pipeline performance
• Collaborate on integration of external and internal data sources

Customer Data Onboarding & Migration

• Own (or lead) end-to-end data onboarding and migration for new customer implementations
• Work directly with customers and project managers to define data requirements and drive execution
• Map, transform, and validate incoming data into the platform
• Troubleshoot and resolve data issues during onboarding
• Ensure successful delivery and go-live of customer data

Security & Compliance

• Implement and manage: Transparent Data Encryption (TDE) with Customer Managed Keys (CMK)
• Design and enforce secure data access patterns, including: Data masking, Data de-identification strategies, Role-based access controls (RBAC)
• Ensure compliance with applicable data security and regulatory requirements

Performance Tuning & Query Optimization

• Analyze and optimize complex T-SQL queries, stored procedures, and database workloads
• Collaborate with developers to identify and resolve performance bottlenecks from APIs and services
• Implement and maintain performance strategies such as: Read Committed Snapshot Isolation (RCSI), Indexing and partitioning strategies, Execution plan analysis, Database Maintenance Plans
• Proactively monitor and improve system performance
• Leverage tools such as Query Store, DMVs, and Azure monitoring to analyze and optimize performance

Automation & Job Management

• Design and manage Elastic Jobs and automated database operations
• Develop scripts (T-SQL, PowerShell, etc.) to automate maintenance and operational tasks
• Standardize and streamline database management processes

Database Operations & Reliability

• Monitor database health, performance, and availability across environments
• Troubleshoot and resolve production issues and incidents
• Manage: Backup and restore strategies, Disaster recovery and failover configurations, High availability and business continuity.

Collaboration & Technical Leadership

• Work closely with developers, DevOps, product, and data teams
• Provide guidance and mentorship on database and data best practices
• Participate in design reviews and architectural discussions
• Contribute to a culture of continuous improvement and shared ownership
• Document standards, processes, and architectural decisions
• Support and influence CI/CD processes for database deployments, schema management, and release automation

Financial Responsibilities

Includes tracking and monitoring actual labor hours associated with projects to ensure labor costs stay within approved project budget.

Supervisory Responsibilities

There are no supervisory responsibilities for this position.