Lead PL/SQL Developer

Lead PL/SQL Developer Job Category: Information Technology Department: IT Solutions Delivery Location: Los Angeles, CA, US, 90017 Position Type: Full Time Requisition ID: 11466 Salary Range: $121,056.00 (Min.) - $160,400.00 (Mid.) - $199,742.00 (Max.) Established in 1997, L.A. Care Health Plan is an independent public agency created by the state of California to provide health coverage to low-income Los Angeles County residents. We are the nations largest publicly operated health plan. Serving more than 2 million members, we make sure our members get the right care at the right place at the right time. Mission: L.A. Cares mission is to provide access to quality health care for Los Angeles County's vulnerable and low-income communities and residents and to support the safety net required to achieve that purpose. Job Summary The Lead PLSQL Developer is responsible for the architecture, development & integration, implementation and support of Enterprise-wide business critical applications. This individual will work closely with application developers (Oracle ML and PLSQL, JAVA/J2EE & PICK) and business analysts in creating functional and scalable applications from design and development through implementation for business clients. This position will support development and integration of new and existing business critical applications using primarily Structured Query Language (SQL), PLSQL, JAVA and Oracle RDBMS. The Lead PLSQL Developer is responsible for ensuring that all applications are robust, user friendly, well secured and seamless for expansion. This position has responsibility to provide technical leadership to the development team, assist the Accountable Manager in managing the technical risks for the overall program/ projects, and establish guidelines, best practices and standards that need to be followed by all members of the development team. This position ensures that documentation is created for system designs and modifications, and assist collaboratively in following the established software development life cycle procedures to develop, test and modify system software, utilities; support integrations with other applications by coding, reviewing, preparing test data, testing and debugging, in order to ensure that the developed software is robust and meets user functional and performance requirements. This position is responsible for the daily workflow and leading the work of assigned staff. This role will mentor, coach, act as a resource and provide feedback on performance of assigned staff. Duties Mentor and guide other development team staff members, in mission application design, development, deployment, modification and enhancements, and operational capabilities utilizing SQL, PLSQL on back-end Oracle and other Databases. Provide leadership and support for development/maintenance on Oracle Database & Web based Portal applications which include configuration, planning, deployment, tuning, database connections, security, monitoring, and troubleshooting. Prepare short and long term plans to address infrastructure projects as well as support to and technical leadership for internal/external stakeholders. Role model the importance of knowledge sharing and continuous learning through the following critical responsibilities. Work closely with other Leads and recommend schedules for application server and database upgrades; assist in the planning and implementation of major software upgrades; adhere to change management procedures and methodologies. Recommend schedules for database upgrades; assist in the planning and implementation of major software upgrades; adhere to change management procedures and methodologies. Evaluate and seek solutions to production issues as well as new projects. Work closely with application developers in addressing Help Desk Tickets & production issues. Manages complex projects, engaging and updating key stakeholders, developing timelines, leads others to complete deliverables on time and ensures implementation upon approval. Leads the work of assigned staff; regularly assigns and checks the work of others, providing guidance, training and feedback on performance to department management. Oversees the daily office workflow, develops and recommends enhancements to process and procedures. Perform other duties as assigned. Duties Continued Education Required Bachelor's Degree in Information Technology or Business Administration In lieu of degree, equivalent education and/or experience may be considered. Education Preferred Experience Required: Minimum of 6 years of experience in a technical function creating and maintaining databases for software applications. At least 3 years of lead experience (process, program, or staff). Experience in development and implementation of Integration solutions for business application across multiple platforms on Windows, UNIX O/S and Linux environments. Extensive Oracle database and Application Server development experience with specific hands-on practices. Must acquire and enhance technological expertise by becoming current with evolving systems, programming, analysis and database technology. Preferred: Experience and understanding of Managed Health-care Information systems, subsystems and applications. Skills Required: Ability to accurately set and adhere to deadlines. Must have a very high ability to learn new things, especially about new technology developments. Ability to prioritize projects and workload; High level of independent judgment. Must be flexible, organized and able to handle multiple tasks simultaneously. Strong project management skills. Must develop, foster and maintain an open, professional relationship with other team members within IT and also with other departments to enhance customer satisfaction. Must understand Managed Health Care Information systems, subsystems and applications. Knowledge in SQL, PLSQL, Oracle Database Architecture, design, development, performance tuning. Apply learned knowledge in software applications development and database administration. Familiarity in the following areas: Develop application software that is robust and meets users' functional and performance requirements. Licenses/Certifications Required Licenses/Certifications Preferred Required Training Physical Requirements Light Additional Information Salary Range Disclaimer: The expected pay range is based on many factors such as geography, experience, education, and the market. The range is subject to change. L.A. Care offers a wide range of benefits including Paid Time Off (PTO) Tuition Reimbursement Retirement Plans Medical, Dental and Vision Wellness Program Volunteer Time Off (VTO)