Sign in

PL/SQL Oracle Developer

Company:
CareWorks Technologies
Location:
Columbus, Ohio, United States
Posted:
December 05, 2018

Description:

For more than 18 years, CareWorks Tech has been delivering technology solutions that drive results. As your advocate, the common thread across our associates is crafting the right tech-savvy solutions. Whether it’s IT Consulting, Infrastructure Services, Security, Enterprise Service Management or Interactive, we’re all about finding solutions that advance your career aspirations. Our ongoing client relationships speak to our long-term collaborative partnerships.

Job Description: In this role, it is expected that you bring a solid technical background in design, development and testing of Oracle PL/SQL programs to include packages, functions, triggers, etc. Your code should be well organized and modular in design as you will be be responsible for the development of interfaces and workflows using APIs, reports, forms, enhancements, SQL and PL/SQL programs. This position requires hands-on experience of PL/SQL and Oracle package programming, data modeling, DB performance tuning and operating Oracle Databases. It is required that you have strong Oracle PL/SQL experience with advanced concepts like partitioning, parallel pipe line functions, dynamic SQL, tuning SQL, tuning PL/SQL, and data modelling exposure including Shell/Perl scripting. You must have the ability to design solutions and conduct data analysis and data mapping as required. You will verify program logic by overseeing the preparation of test data, testing and debugging of programs and you must be able to conceptualize, design and write complex SQL queries and PL/SQL stored procedures and functions as you will support refactoring of existing database schemas to support consolidation roadmaps with senior architects to help architect new designs.

Responsibilities

Perform ongoing support of systems, including documentation, troubleshooting and testing

Develop the standards and features that business requires; analyze, test and deploy the program to production environment

Prioritize business system change orders for enhancement or project requests

Develop conversions, upgrades, interfaces, reports, forms, and workflow

Provide support to existing Oracle applications in the form of troubleshooting

Business Experience

7+ years experience with major DBMS

5+ plus years experience with coding, testing, and design

5+ years experience with software development methodologies

Wants

Ability to work in a fast paced “Agile” environment

Ability to work in a team environment where team conducts code and design reviews prior to implementation

The CareWorks Family of Companies is committed to providing career opportunity and growth to all Associates without regard to race, color, religion, sex, national origin, age, marital or veteran status, medical condition or disability.

CareWorks Tech Strategically-Led Technology Solutions

5555 Glendon, CT

Dublin, OH 43016

614-789-3767

david.horvay@careworkstech.com

Thank you for considering CareWorks Tech for your next career opportunity. CareWorks Tech is not your typical technology company. We are part of the CareWork’s family of companies which is one of Ohio’s largest managed care organizations, serving over 115,000 employers and owned by York Risk Services Group. We have 4 guiding principles: (1) Customer Commitment (2)Attitude of Service (3) Respect for the Individual and Team and (4) Exceeding Expectations. We invest in your training, professional development, benefits (medical, 401k, paid holidays/vacation, etc.) and personally focus on your career success. We have operations in 85 locations worldwide and employ 5,000+ people.