The #1 Site for IT and Engineering Jobs - search all IT and Engineering  jobs.
Mxf2ly6689r56wwlyjq

Sr. PL/SQL Developer (AMER)

Job Description

Job Req: 19-09863
Job Title: Sr. PL/SQL Developer
Job Location: Horsham, PA - 19044
Job Type: Contract 

Purpose:
Leverages significant professional PL/SQL development experience to design, build, enhance and maintain new and existing applications and automations. Solves problems and make things go in a small, dynamic environment.

Essential Job Functions/Responsibilities:
  • Develops stored procedures, functions, and packages.
  • Document work details for sharing knowledge with team
  • Identify, develop and implement process improvements, especially via automation to improve business efficiency and revenue growth.
  • Performs Data architecture and design.
  • Train other personnel as needed on database components or processes.
  • Performs fine tuning of existing PL/SQL code.
  • Diagnoses and solves 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.

Qualifications:
(Minimum bona fide occupational qualifications necessary to perform the essential functions of the job at a satisfactory level, consistently applied to all incumbents and applicants.)

Minimum Required Education and Experience:
  • Bachelor's degree in Computer Science or equivalent combination of education, professional training, and experience that provide the individual with the required knowledge, skills, and abilities
  • 7+ years of professional Oracle PL/SQL programming experience.
  • 10+ years of technology development experience.
  • Experience working with Oracle 11g, Oracle, Toad, SQL Navigator. Subversion.
  • Experience developing shell scripts from scratch and maintain existing shell scripts.
  • Experience in performance tuning of PL/SQL queries.
  • Experience in understanding AWR reports, point to bottlenecks and suggest ideas to improve performance.
Required Knowledge, Skills and Abilities:
  • 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, triggers.
  • Knowledge of other technologies including MySQL, SQL Server, Hibernate, Spring, GWT, Java, J2EE, JSPs, jQuery are strongly preferred.
  • Good knowledge of best practices for database design and development.
  • Ability to work well with BA’s, 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.
  • Provide after-hours support for releases and production support issues or for urgent tasks.
  • Experience working with applications involved in clinical trials or pharmaceutical drug development is preferred.

Job Requirements

 

Job Snapshot

Location US-PA-Horsham
Employment Type Contractor
Pay Type Hour
Pay Rate N/A
Store Type IT & Technical
Apply

Company Overview

Ascent

The Ascent Services Group (ASG) is a leading national technology consulting and professional services firm that focuses on tactical and strategic consulting. ASG’s fundamental business is providing staffing services to Large Enterprise clients in our core market verticals: Financial Services, Healthcare, and Life Sciences. We focus the majority of our efforts in Staff Augmentation support of Large Enterprise Clients who utilize a Vendor Management System. Learn More

Contact Information

US-PA-Horsham
Lucas Moulder
Icon-social-facebookIcon-social-linkedinIcon-social-twitter
Snapshot
Ascent
Company:
US-PA-Horsham
Location:
Contractor
Employment Type:
Hour
Pay Type:
N/A
Pay Rate:
IT & Technical
Store Type:

Job Description

Job Req: 19-09863
Job Title: Sr. PL/SQL Developer
Job Location: Horsham, PA - 19044
Job Type: Contract 

Purpose:
Leverages significant professional PL/SQL development experience to design, build, enhance and maintain new and existing applications and automations. Solves problems and make things go in a small, dynamic environment.

Essential Job Functions/Responsibilities:
  • Develops stored procedures, functions, and packages.
  • Document work details for sharing knowledge with team
  • Identify, develop and implement process improvements, especially via automation to improve business efficiency and revenue growth.
  • Performs Data architecture and design.
  • Train other personnel as needed on database components or processes.
  • Performs fine tuning of existing PL/SQL code.
  • Diagnoses and solves 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.

Qualifications:
(Minimum bona fide occupational qualifications necessary to perform the essential functions of the job at a satisfactory level, consistently applied to all incumbents and applicants.)

Minimum Required Education and Experience:
  • Bachelor's degree in Computer Science or equivalent combination of education, professional training, and experience that provide the individual with the required knowledge, skills, and abilities
  • 7+ years of professional Oracle PL/SQL programming experience.
  • 10+ years of technology development experience.
  • Experience working with Oracle 11g, Oracle, Toad, SQL Navigator. Subversion.
  • Experience developing shell scripts from scratch and maintain existing shell scripts.
  • Experience in performance tuning of PL/SQL queries.
  • Experience in understanding AWR reports, point to bottlenecks and suggest ideas to improve performance.
Required Knowledge, Skills and Abilities:
  • 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, triggers.
  • Knowledge of other technologies including MySQL, SQL Server, Hibernate, Spring, GWT, Java, J2EE, JSPs, jQuery are strongly preferred.
  • Good knowledge of best practices for database design and development.
  • Ability to work well with BA’s, 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.
  • Provide after-hours support for releases and production support issues or for urgent tasks.
  • Experience working with applications involved in clinical trials or pharmaceutical drug development is preferred.

Job Requirements

 
M0z7hj6l4qd6vywwmj7
Sologig Advice

For your privacy and protection, when applying to a job online: Never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction.Learn More

By applying to a job using sologig.com you are agreeing to comply with and be subject to the workinretail.com Terms and Conditions for use of our website. To use our website, you must agree with theTerms & Conditionsand both meet and comply with their provisions.
Sr. PL/SQL Developer (AMER) Apply now