Description :

Job Summary :

We are seeking a database developer with expertise in SQL, data integration, and cloud technologies (AWS preferred) to design, develop, and optimize enterprise data solutions.

The ideal candidate should have 7+ years of experience working with health plan data (Enrollments, Claims, Payments), strong hands-on experience in SQL (Oracle, MS SQL), and the ability to troubleshoot data translation and performance issues.

The role also requires scripting, ETL processes, and experience in handling Sev1/Sev2 incidents.

Key Responsibilities :

Database Development & Optimization :

- Design, develop, and optimize complex SQL queries for Oracle, MS SQL.

- Develop and maintain stored procedures, triggers, and database scripts.

- Troubleshoot and resolve data translation issues between source and target systems.

- Ensure data integrity and performance optimization across various systems.

Data Integration & Development :

- Develop, test, and deploy data integration solutions for enterprise applications.

- Work with ETL processes to ensure smooth data movement across systems.

- Automate and optimize data workflows using scripting.

- Assist in defining system architecture, data models, and performance tuning strategies.

Incident Management & Troubleshooting :

- Support and troubleshoot Sev1/Sev2 incidents, ensuring quick resolution and minimal impact.

- Conduct root cause analysis and implement preventive measures for recurring data issues.

- Monitor and optimize system performance, ensuring high availability and scalability.

Collaboration & Documentation :

- Work closely with architects, technical leads, and business stakeholders to understand requirements.

- Document best practices, technical specifications, and integration workflows.

- Contribute to technical discussions, reviews, and knowledge-sharing sessions.

Cloud & Process Improvement :

- Collaborate with DevOps teams for CI/CD pipeline integration and deployment automation.

- Continuously explore process automation and efficiency improvements.

Required Skills :

- 7+ years of experience working with health plan data (Enrollments, Claims, Payments).

- Strong SQL expertise in Oracle, MS SQL.

- Experience developing and debugging stored procedures and SQL scripts.

- Good understanding of scripting for automation and troubleshooting.

- Experience in handling Sev1/Sev2 incidents and performing root cause analysis.

- Hands-on experience with ETL development and data integration.

- Strong problem-solving skills and ability to work in a fast-paced, time-sensitive environment.