DBA / SQL Developer (Folsom)

DBA / SQL Developer

Job Location: Opeeka Headquarters - Folsom, CA 95630
Position Type Full Time
Travel Percentage Negligible
Education Level 4 Year Degree
Salary Range $125,000.00 - $175,000.00 Salary/year
Job Shift Day
Job Category Engineering

Description

Sacramento Region applicants only please. This position is not eligible for out of area remote work. Local area remote work may be allowed on a limited basis, depending on business needs.

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

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 all Federal Holidays and the day after Thanksgiving.

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

Works closely with the Opeeka development team and is responsible for designing, developing, administering, and evolving SQL Server databases that support data collection, analytics, and reporting for Opeeka’s Person Centered Intelligence System (P-CIS). This role partners with internal stakeholders to capture requirements and to design, build, document, and maintain reliable, performant data solutions including operational databases, analytics models, and reporting structures.

Collaborates with development teams in a code-first environment to support application data needs, review database-related pull requests, and guide the implementation of SQL logic, migrations, and performance best practices. Acts as an advocate for appropriate placement of business logic within the database to promote reuse, consistency, and data integrity across platforms.

Works with internal and external customers to define, design, and develop data pipelines, data stores, and ETL processes for both operational and analytical use cases. Contributes to the architecture and evolution of data strategies that enable secure, scalable, and high-performance use of the data platform for Power BI and other business intelligence, analytics, and querying solutions.

Collaborates with team members to analyze user needs and enhance existing systems, applying principles of computer science, engineering, and data architecture. May work with cloud engineering teams to integrate cloud and software systems, define performance requirements, and support database solutions in Azure environments. Provides hands-on expertise in database design, development, performance tuning, and administration, working independently or as part of a cross-functional team.

Duties & Responsibilities

• Assist in the design, implementation, and maintenance of database systems.
• Develop, test, and optimize SQL queries and scripts.
• Monitor database performance and troubleshoot issues.
• Ensure data integrity and security.
• Collaborate with internal stakeholders to support data-related needs.
• Participate in database backup and recovery processes.
• Document database configurations, processes, and procedures.

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.

Qualifications

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

• Advanced SQL development, analytics development, report development, and relational database design.
• Strong experience with MS SQL Server and T-SQL in production environments.
• Ability to support and collaborate with code-first development teams 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 champion]]>