Database Developer (F2F Interview)

Job Description

Job Summary We are seeking a Senior/Lead 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 5+ 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. Skills 5+ 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. Skills: data integration,aws,database,oracle,sql