SR DBA / DATABASE ARCHITECT (AZURE / MSSQL) in Folsom, California at Opeeka, Inc
Explore Related Opportunities
Job Description
Job Location: Opeeka Headquarters - Folsom, CA 95630
Position Type Full Time
Travel Percentage Negligible
Education Level 4 Year Degree
Salary Range $135,000.00 - $170,000.00 Salary/year
Job Shift Day
Job Category Engineering
Description
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.
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Skills and Abilities
- Strong analytical and problem-solving skills
- Comfortable operating in a dynamic, fast-paced, small-team environment
- Ability to balance strategic architecture with hands-on execution
- Strong communication skills across technical and non-technical audiences
- Self-starter with a mindset of ownership, curiosity, and adaptability
- Advanced SQL, analytics, and report development, along with strong relational database design principles.
- Ability to support and collaborate with code-first development teams (e.g., using Entity Framework).
- Ability to work with diverse data formats and transport methods, including CSV/XML/JSON flat files, SFTP exchanges, APIs, and structured database extracts.
- Experience reviewing pull requests and acting as a code owner for SQL migrations and database-related logic.
- Strong understanding of the Software Development Lifecycle and agile development practices.
- Ability to drive and advocate for the centralization of shared business logic within the database to enable reuse across applications and tools.
- Strong troubleshooting and performance-tuning skills.
- Strong communication and teamwork abilities, with comfort partnering closely with developers and architects.
- Ability to work independently, manage competing priorities, and provide technical leadership.
- High attention to detail and a strong commitment to data integrity, reliability, and security.
- Willingness to learn, adapt, and contribute to evolving tools, technologies, and methodologies.
Nice to Have
- Experience with Azure monitoring tools (Azure Monitor, Log Analytics, Query Store)
- Scripting (PowerShell, Python)
- Experience in regulated environments (e.g., healthcare)
- Exposure to analytics platforms or data warehousing concepts
- Team leadership experience
Knowledge
- Deep knowledge of: Azure SQL Database & Managed Instance architecture, High availability, disaster recovery, and scaling strategies, Indexing, partitioning, and query performance tuning
- Experience with: Elastic Jobs, RCSI (Read Committed Snapshot Isolation), Data masking and de-identification techniques, Familiarity with Azure data tools (e.g., Data Factory or similar) is a plus
- Understanding of Azure networking and security (VNETs, private endpoints, firewalls)
- Strong experience with Microsoft SQL Server and T-SQL in production environments
- Deep understanding of relational database design, data modeling, and SQL best practices
- Hands-on experience administering SQL Server environments, including database creation, access management, and security configuration.
- Understanding of data controls, constraints, and safeguards implemented at the database level.
- Familiarity with cloud data services and tooling (Microsoft Azure preferred).
- Knowledge of CI/CD concepts related to database deployments, schema changes, and release automation.
- Understanding of migration-based and state-based database object management approaches.
- Awareness of data security, compliance, and best practices.
- Familiarity with Confluence, Jira, BitBucket, and/or Azure DevOps is a plus.
- Knowledge of healthcare interoperability concepts (HL7, FHIR, or similar), if applicable to customer integrations.
Competencies
- Action Oriented - takes on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm.
- Manages Ambiguity - the ability to operate effectively when the path forward is not clear, or things are uncertain.
- Decision Quality – the ability to demonstrate superior judgment, separating facts from opinions, and ensuring decisions keep the organization moving forward.
- Interpersonal Savvy – the ability to employ a communication style to build trust and get things done by skillfully navigating social complexities and connecting with others authentically.
- Being Resilient – the ability to rebound from setbacks and adversity when facing difficult situations.
- Self-Development – ability to be initiative-taking in taking charge of personal and professional growth, rather than waiting for development to happen.
Education and/or Experience
- Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience)
- 8+ years of experience with Microsoft SQL Server (DBA and/or database architecture)
- 3+ years of experience with Azure SQL Database and/or Managed Instances
- Strong expertise in: T-SQL development and query optimization, Database performance tuning and troubleshooting, Experience designing and supporting multi-tenant database architectures
- Hands-on experience with: TDE and Customer Managed Keys (CMK), Replication across Azure database services
- Experience supporting or contributing to ETL/data pipeline processes
Physical Requirements
- Frequent on-site, team interaction.
- Frequent sitting, standing, and walking.
- Occasional to frequent repetitive motion.
- Frequent talking and listening in person and over the phone.
- Close up and distance vision requirements.
Emotional/Psychological Demands
Ability to cope with: long periods of concentration; pressure and deadlines; occasional long or irregular hours; occasional public contact; changing priorities
Work Environment
Open office environment; moderate temperatures; moderate noise levels