Job Responsibilities: Design and architect reliable, high-performance functional and technical specifications using extensive knowledge of SDLC database programming in PL/SQL environment, including Java and JSP. Take an active role, develop new functionality, design and implement Oracle PL/SQL solutions that satisfy complex business requirements, including migration scripts, Oracle collections, and BULK operations. Focus on system design and performance tuning for Oracle queries that increase stability and performance. Analyze user needs and software requirements to determine feasibility of design within time and cost constraints. Develop complex database objects using Dynamic SQL. Responsible for design and implementation of software solutions that understand the business domain (problems, activities, processes) and apply that understanding to strategic decision making to maximize technology value. Architect new procedures and practices in a team environment. Be aware of emerging technologies and champion them in our environment. Required Skills: Bachelor&39;s degree in a technical or related discipline with a minimum of seven (7) years of experience designing and developing applications using Oracle PL/SQL technology. Oracle collections and BULK operations. Dynamic SQL and exception handling. Self-starter with demonstrated initiative and a drive to deliver outstanding solutions. This is a software design role, not just development, so ideal candidates will need more than just coding skill set. Performance/security-oriented data modeling and data design, including large table partitions, different type of indexes, views, and most effective data management practices. Extensive knowledge of PL/SQL and PL/SQL performance tuning. Ability to code in Java or other languages is assumed at this skill level.
Prospect Infosys Inc. Horsham, PA
Adwait Algorithm Horsham, PA
Comcast Philadelphia, PA
WebMD Newtown Square, PA
Delaware Valley Regional Planning Commission Philadelphia, PA