Mssql)

Opeeka•Folsom, CA

8d•Onsite

About The Position

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.

Requirements

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.
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,
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.
Knowledge of healthcare interoperability concepts (HL7, FHIR, or similar), if applicable to customer integrations.
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.
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

Nice To Haves

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
Familiarity with Azure data tools (e.g., Data Factory or similar) is a plus
Understanding of Azure networking and security (VNETs, private endpoints, firewalls)
Familiarity with Confluence, Jira, BitBucket, and/or Azure DevOps is a plus.

Responsibilities

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
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
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
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
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
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
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
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.
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
Includes tracking and monitoring actual labor hours associated with projects to ensure labor costs stay within approved project budget.