About the Role
We are looking for a skilled SQL Developer with 4–6 years of experience in Microsoft SQL Server development and a good understanding of Healthcare IT systems. The ideal candidate should have strong SQL programming skills, experience working with large datasets, and the ability to develop efficient database solutions that support healthcare applications such as claims processing, member eligibility, provider management, and clinical or administrative systems.
This role requires close collaboration with application developers, business analysts, QA teams, and product owners to build scalable, high-performance database solutions.
Key Responsibilities
- Design, develop, and optimize SQL Server databases, stored procedures, functions, views, and triggers.
- Write complex SQL queries for data extraction, reporting, and application support.
- Optimize database performance through query tuning, indexing strategies, and execution plan analysis.
- Support healthcare applications by troubleshooting data-related issues and ensuring data integrity.
- Work closely with application development teams to design efficient database structures.
- Develop scripts for database deployments and version control.
- Participate in database design reviews and code reviews.
- Create technical documentation for database objects and processes.
- Assist in production support, issue investigation, and root cause analysis.
Required Technical Skills
- 4–6 years of hands-on experience with Microsoft SQL Server (2016/2019/2022).
- Strong expertise in:
- T-SQL
- Stored Procedures
- Functions
- Views
- Triggers
- CTEs
- Window Functions
- Dynamic SQL
- Experience with:
- Query Optimization
- Performance Tuning
- Indexing
- Execution Plans
- SQL Profiler
- Knowledge of SQL Server Agent Jobs.
- Experience working with large databases and high-volume transactional systems.
- Familiarity with SSIS or other ETL tools.
- Experience with Git or Azure DevOps for source control.
- Good understanding of database normalization and relational database design.
Healthcare Domain Experience (Preferred)
Experience in one or more of the following is highly preferred:
- Healthcare Claims Processing
- Member Eligibility & Benefits Verification
- Provider Management
- Prior Authorization
- Revenue Cycle Management (RCM)
- Electronic Health Records (EHR)
- Practice Management Systems
- HIPAA Compliance
- Healthcare Data Integration
- X12 Transactions (270/271, 276/277, 837, 835)
- Healthcare Data Warehousing
- Medicare, Medicaid, or Commercial Insurance workflows
Nice to Have
- Experience with C#/.NET applications interacting with SQL Server.
- Knowledge of Azure SQL Database or SQL Managed Instance.
- Exposure to Azure Data Factory.
- Power BI or SSRS reporting experience.
- Experience with database migration projects.
- Understanding of healthcare compliance and security standards.
Required Soft Skills
- Strong analytical and problem-solving skills.
- Excellent SQL debugging capabilities.
- Ability to work independently and as part of a distributed team.
- Good communication and documentation skills.
- Ability to understand business requirements and translate them into database solutions.
- Strong attention to detail.
The ideal candidate should have:
- Strong SQL programming and database optimization skills.
- Experience working in Healthcare IT environments.
- Ability to work on production support as well as new development.
- Experience handling complex healthcare data models.
- Good understanding of SDLC and Agile methodologies.
- A proactive attitude with the ability to take ownership of assigned work.
Bonus Skills
- Healthcare interoperability (FHIR, HL7)
- Azure DevOps
- CI/CD for database deployments
- Database security and auditing
- Data migration and reconciliation
- Experience working with large-scale healthcare payer or provider systems
Pay: $60,000.00 - $90,000.00 per year
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Flexible spending account
- Health insurance
- Health savings account
- Life insurance
- Paid time off
- Vision insurance
Application Question(s):
- This is 100% Work From Office Job. Please confirm you are fine for that.
Location:
- Simi Valley, CA 93065 (Required)
Ability to Commute:
- Simi Valley, CA 93065 (Required)
Work Location: In person