VidPro Tech & Hr Solutions Private Limited

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 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-sharingsessions.  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. Skills: stored procedures,sql queries,data base development,aws,oracle,query optimization,sql scripts,performance tuning,azure