Job Requirements & Summary:
Experience in writing Packages for data loads.
Experience creating and maintained Stored Procedure (Packages, Procedures, Function, and anonymous block) with Oracle PL/SQL
Experience using Cursors to pull data from the Database.
Experience with performance tuning, query optimization, explain plan etc
Experience with external tables, and high volume data import into Oracle DB
At least 8 years of experience as an Oracle PL/SQL Developer.
Strong skills in Oracle server side programming which includes SQL, SQL*Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Temporary tables, Object Oriented PL/SQL Programming, Job, Schedulers, PL/SQL Web-services, Java Stored Procedures and Oracle AQ.
Hands on experience on XML generation inside PL/SQL components.
Strong Skills in data analysis, data modeling, development, testing and documentation.
Strong skills on automating jobs using UNIX Shell scripts to run all the SQL files in a directory by invoking SQL *Plus.
Hands on writing Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming for generating worksheets, Arrays & Queues.
Strong Skills in Exception Handling extensively debug PL/SQL Code, DDL, DML and display the error messages in the application.
Experience in creating Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
Experience in SQL Tunning to improve the query performance by identifying key fields, adding/removing tables/fields, and use of indexes.
Good understanding of Oracle Explain Plan.
PRIMARY PURPOSE:
To design and maintain robust, scalable software architecture for one or more elements of CMS software systems; to oversee programming, implementation and maintenance revisions of specified projects; and to evaluate technologies and provide consultation regarding applications and systems needs related to these elements.
ESSENTIAL FUNCTIONS and RESPONSIBILITIES
Ensures software scalability and data integrity throughout all claims-related applications. Ensures software compatibility and alignment with overall business, IT and infrastructure strategies. Identifies and directs implementation of strategies for maintaining JURIS data and application integration. Collaborates with management and colleagues throughout CMS and develops overall designs and defines projects for implementation of strategic technology initiatives. Consults with project managers to keep informed of active and future projects and to identify areas of overlap. Assists as needed in implementation of large client programs involving numerous interfaces or system modifications. Manages analyst/programmers as needed. Reviews software change requests to identify duplication, similarities, and feasibility and recommends specific actions needed. Provides recommendations toward prioritization of tactical and strategic change requests. Assists in projecting software and hardware requirements for claims-related applications.
Performs other duties as assigned. Supports the organization's quality program(s).
SUPERVISORY RESPONSIBILITIES Administers company personnel policies in all areas and follows company staffing standards and training recommendations. Interviews, hires and establishes colleague performance development plans; conducts colleague performance discussions. Provides support, guidance, leadership and motivation to promote maximum performance.
QUALIFICATIONS
Education & Licensing Bachelor's degree with major in Information Systems or Management from an accredited college or university preferred. Masters degree strongly preferred. Experience Ten (10) years of related experience or equivalent combination of education or experience required to include seven (7) years of software and development experience. Five (5) years hands-on programming experience in database and data driven applications strongly preferred.
Skills & Knowledge
High level knowledge of software development areas including software development life cycle methodologies, specification development, security, application modularization and logic specifications
Strong oral and written communication, including technical writing skills and presentation skills
PC literate, including Microsoft Office products
Leadership/management/motivational skills
Analytical and interpretive skills
Strong organizational skills
Excellent interpersonal skills
Excellent negotiation skills
Ability to work in a team environment
Ability to meet or exceed Performance Competencies
WORK ENVIRONMENT When applicable and appropriate, consideration will be given to reasonable accommodations.
Mental: Clear and conceptual thinking ability; excellent judgment, troubleshooting, problem solving, analysis, and discretion; ability to handle work-related stress; ability to handle multiple priorities simultaneously; and ability to meet deadlines Physical: Computer keyboarding, travel as required Auditory/Visual: Hearing, vision and talking
NOTE: Credit security clearance, confirmed via a background credit check, is required for this position. The statements contained in this document are intended to describe the general nature and level of work being performed by a colleague assigned to this description. They are not intended to constitute a comprehensive list of functions, duties, or local variances. Management retains the discretion to add or to change the duties of the position at any time.
Nesco Resource offers a comprehensive benefits package for our associates, which includes a MEC (Minimum Essential Coverage) plan that encompasses Medical, Vision, Dental, 401K, and EAP (Employee Assistance Program) services.
Nesco Resource provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.
Quick Apply
No resume? Create a new profile
Experience in writing Packages for data loads.
Experience creating and maintained Stored Procedure (Packages, Procedures, Function, and anonymous block) with Oracle PL/SQL
Experience using Cursors to pull data from the Database.
Experience with performance tuning, query optimization, explain plan etc
Experience with external tables, and high volume data import into Oracle DB
At least 8 years of experience as an Oracle PL/SQL Developer.
Strong skills in Oracle server side programming which includes SQL, SQL*Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Temporary tables, Object Oriented PL/SQL Programming, Job, Schedulers, PL/SQL Web-services, Java Stored Procedures and Oracle AQ.
Hands on experience on XML generation inside PL/SQL components.
Strong Skills in data analysis, data modeling, development, testing and documentation.
Strong skills on automating jobs using UNIX Shell scripts to run all the SQL files in a directory by invoking SQL *Plus.
Hands on writing Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming for generating worksheets, Arrays & Queues.
Strong Skills in Exception Handling extensively debug PL/SQL Code, DDL, DML and display the error messages in the application.
Experience in creating Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.
Experience in SQL Tunning to improve the query performance by identifying key fields, adding/removing tables/fields, and use of indexes.
Good understanding of Oracle Explain Plan.
PRIMARY PURPOSE:
To design and maintain robust, scalable software architecture for one or more elements of CMS software systems; to oversee programming, implementation and maintenance revisions of specified projects; and to evaluate technologies and provide consultation regarding applications and systems needs related to these elements.
ESSENTIAL FUNCTIONS and RESPONSIBILITIES
Ensures software scalability and data integrity throughout all claims-related applications. Ensures software compatibility and alignment with overall business, IT and infrastructure strategies. Identifies and directs implementation of strategies for maintaining JURIS data and application integration. Collaborates with management and colleagues throughout CMS and develops overall designs and defines projects for implementation of strategic technology initiatives. Consults with project managers to keep informed of active and future projects and to identify areas of overlap. Assists as needed in implementation of large client programs involving numerous interfaces or system modifications. Manages analyst/programmers as needed. Reviews software change requests to identify duplication, similarities, and feasibility and recommends specific actions needed. Provides recommendations toward prioritization of tactical and strategic change requests. Assists in projecting software and hardware requirements for claims-related applications.
Performs other duties as assigned. Supports the organization's quality program(s).
SUPERVISORY RESPONSIBILITIES Administers company personnel policies in all areas and follows company staffing standards and training recommendations. Interviews, hires and establishes colleague performance development plans; conducts colleague performance discussions. Provides support, guidance, leadership and motivation to promote maximum performance.
QUALIFICATIONS
Education & Licensing Bachelor's degree with major in Information Systems or Management from an accredited college or university preferred. Masters degree strongly preferred. Experience Ten (10) years of related experience or equivalent combination of education or experience required to include seven (7) years of software and development experience. Five (5) years hands-on programming experience in database and data driven applications strongly preferred.
Skills & Knowledge
High level knowledge of software development areas including software development life cycle methodologies, specification development, security, application modularization and logic specifications
Strong oral and written communication, including technical writing skills and presentation skills
PC literate, including Microsoft Office products
Leadership/management/motivational skills
Analytical and interpretive skills
Strong organizational skills
Excellent interpersonal skills
Excellent negotiation skills
Ability to work in a team environment
Ability to meet or exceed Performance Competencies
WORK ENVIRONMENT When applicable and appropriate, consideration will be given to reasonable accommodations.
Mental: Clear and conceptual thinking ability; excellent judgment, troubleshooting, problem solving, analysis, and discretion; ability to handle work-related stress; ability to handle multiple priorities simultaneously; and ability to meet deadlines Physical: Computer keyboarding, travel as required Auditory/Visual: Hearing, vision and talking
NOTE: Credit security clearance, confirmed via a background credit check, is required for this position. The statements contained in this document are intended to describe the general nature and level of work being performed by a colleague assigned to this description. They are not intended to constitute a comprehensive list of functions, duties, or local variances. Management retains the discretion to add or to change the duties of the position at any time.
Nesco Resource offers a comprehensive benefits package for our associates, which includes a MEC (Minimum Essential Coverage) plan that encompasses Medical, Vision, Dental, 401K, and EAP (Employee Assistance Program) services.
Nesco Resource provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.