Apply Now





   

 

Thank you for Applying!



Your application has been successfully submitted. You will also receive an email with more information.


Close
PL/SQL Developer
Job ID:24443
Horsham, Pennsylvania

RESOLVIT

Bringing Solutions That Make Business Better

Join Resolvit as a PL/SQL Developer and be part of a creative, forward-thinking team. Our success at deploying skilled, highly knowledgeable experts has landed us on the Inc. 5000 list of America’s fastest-growing companies four times – and we’re just getting started.

As the PL/SQL Developer, you will leverage significant professional PL/SQL development experience to design, build, enhance, and maintain new and existing applications and automations. You will solve problems and make things go in a small, dynamic environment. You will also identify, develop, and implement process improvements, especially via automation to improve business efficiency and revenue growth. Additionally, you will:

  • Develop stored procedures, functions, and packages
  • Document work details for sharing knowledge with team 
  • Perform data architecture and design
  • Train other personnel as needed on database components or processes
  • Perform fine tuning of existing PL/SQL code
  • Diagnose and solve technical issues involving Oracle database procedures and performance
  • Evaluate new products or learn existing systems to provide support for the reporting and business intelligence needs of the organization
  • Provide after-hours support for releases and production support issues or for urgent tasks

What You’ll Need to be Successful:

  • At least 7 years of professional Oracle PL/SQL programming experience
  • At least 10 years of technology development experience
  • Bachelor's degree in computer science or equivalent combination of education, professional training, and experience 
  • Experience working with Oracle 11g, Oracle, Toad, SQL Navigator, and Subversion
  • Experience developing shell scripts from scratch and maintaining existing shell scripts
  • Experience performance tuning PL/SQL queries
  • Experience understanding AWR reports and ability to point to bottlenecks and suggest ideas to improve performance
  • Experience building packages/procedures from scratch
  • Strong experience with performance tuning for Oracle and PLSQL coding
  • Ability to translate business requirements into technical design documents
  • Good knowledge of cursors, functions, views, materialized views indexes, collections, and triggers
  • Good knowledge of best practices for database design and development
  • Ability to work well with BAs, software engineers, and quality assurance personnel
  • Ability to multi-task and adhere to prioritized needs
  • Ability to communicate effectively with business users, gauge their needs, and develop sound solutions to complete work as requested

Great Additional Skills:

  • Knowledge of other technologies including MySQL, SQL Server, Hibernate, Spring, GWT, Java, J2EE, JSPs, and jQuery
  • Experience working with applications involved in clinical trials or pharmaceutical drug development 

Benefits:

At Resolvit, you’ll be given the support you need to grow in your consulting career. In addition to opportunities for advancement, we offer:

  • Medical, dental, and vision insurance
  • Life insurance coverage
  • Long-term and short-term disability coverage
  • 401(k) retirement plan with matching
  • Professional support from our Client & Employee Optimization Specialist

We currently have more than 100 open career opportunities across the country, so be sure to mention the appropriate Job Code with any correspondence!

About Resolvit:

Resolvit is an international technology consulting firm with industry-leading customers in the financial services, high tech, manufacturing, retail, life sciences, and government sectors. Through its partnerships, Resolvit delivers highly impactful, innovative solutions across five core areas: Infrastructure Modernization, Application Development Services, Enterprise Data Management & Analytics, Knowledge & Content Management, and Strategic Staffing.