We are currently on the lookout for a highly capable and results-driven PL/SQL Developer to join our dynamic team. This is an excellent opportunity to work on impactful client reporting and internal program analytics initiatives across care management product lines. You will be embedded within a team that sits at the intersection of Product, Data Science, and Engineering, and your work will directly contribute to driving data-backed business decisions and improving customer outcomes.
This is a contractual role with a duration of up to one year, with strong potential for extension based on performance and business needs. Candidates who can onboard quickly will be prioritized, and interview slots will be fast-tracked for applicants who reach out via LinkedIn with their updated resume.
Key Responsibilities
Efficient Data Handling & Optimization
- Design and implement bulk data load processes using advanced PL/SQL features like BULK COLLECT, FORALL, and direct-path inserts to ensure performance and scalability.
- Tune and optimize data load processes for large-scale datasets, ensuring minimal downtime and high availability.
Robust Exception Handling
- Develop reliable exception handling mechanisms, leveraging both predefined and custom exceptions to ensure error-resilient applications.
- Incorporate detailed logging and diagnostic tracking to simplify debugging and maintenance.
Dashboard & Reporting Development
- Create dynamic and interactive dashboards using Oracle BI Publisher and Oracle APEX, aimed at delivering actionable insights to stakeholders.
- Collaborate closely with data visualization teams and business users to understand reporting needs and translate them into scalable data solutions.
Advanced Data Transformation
- Use advanced PL/SQL date and string functions to manipulate and transform data across complex use cases.
- Implement reusable functions and procedures to handle frequent data formatting and parsing scenarios.
Technical and Collaborative Expectations
- Collaborate cross-functionally with data engineers, data scientists, and subject matter experts to design and build backend structures that support business intelligence efforts.
- Translate documented technical requirements into efficient and maintainable database objects including procedures, packages, and functions.
- Participate in peer reviews, contributing to the continuous improvement of coding standards, development practices, and system performance.
- Develop comprehensive unit test cases to validate each module and ensure high-quality deliverables.
- Work within Agile teams, leveraging version control systems and participating in sprint planning and retrospectives.
Key Qualifications
- Bachelor’s degree in Computer Science, Information Technology, or a related discipline.
- Demonstrated professional experience as a PL/SQL Developer, preferably in data-rich and performance-sensitive environments.
- Deep understanding of Oracle Database Architecture and PL/SQL programming, with a strong emphasis on query optimization and performance tuning.
- Proficient in SQL/PLSQL, and experienced with ETL processes and data warehousing concepts.
- Hands-on experience with tools like Oracle APEX, Oracle BI Publisher, and version control tools such as Git.
- Comfortable working in Agile/Scrum teams with frequent deliverables and evolving requirements.
Why Join Us?
This is more than just a development role. It’s an opportunity to make a real-world impact through data, helping shape the way we serve our clients and improve outcomes for end-users. You’ll be part of a collaborative and highly skilled team, empowered to explore ideas, take ownership of projects, and bring innovation to the table.
If you're passionate about clean, performant code, love working with data, and want to be part of a mission-driven team, we’d love to hear from you!