PL/SQL Developer

Location: Wilkes Barre, PA
Date Posted: 04-11-2018
CareNational
PL/SQL Developer
Wilkes-Barre, PA
  
PL/SQL Developer Job Summary: 
 
  • The PL-SQL Developer, modifies, develops, writes and implements software programming Applications and components.
  • Works from written specifications and pre-established guidelines to perform the functions of the job and maintains documentation of process flow.
 
PL/SQL Developer Background:   
 
  • 4-year Bachelor degree in business, Information Technology, or related field (or equivalent experience)
  • 7 years of SQL development experience including but not limited to the creation of packages, procedures, tables views, functions, etc.
  • 7 years of experience in Database Star Schema and or Snow flake schema in First, Second and Third normal form.
  • Must have knowledge on how to build/maintain efficient database tables structure for both transactional and warehouse data.
  • 6 years of experience in PL/SQL tuning including knowledge of Explain Plans AWR, ASH and TKPROF
  • Knowledge of oracle partitioning practices and data archival structures and processes.
  • Knowledge of Oracle 11g and 12c with use of tools such as SQLDeveloper, TOAD and ERWIN.
  • Must have the ability to work with the system analysts to translate business requirements to database structure as well has communicate the design to the front end development staff.
  • Experience in the Agile programming framework.
  • Position qualifications are as follows:  
    • Data analysis experience with solid background in SQL
    • Experience writing complex queries to uncover data discrepancies.
    • Ability to respond to ad hoc requests for data and information.
    • Strong skills in reporting, business intelligence and metrics.
    • Strong data quality and analysis skills are necessary.
    • Ability to manipulate large amounts of data, mainly in Microsoft Excel and Oracle12C.
    • Solid experience in Excel for data analysis and visualization.
    • Ability to work effectively with clients, data managers and other technical
    • Ability to present complex information in an understandable manner.
    • Ability to recognize problems, take initiative, solve problems, and work independently.
    • Programming knowledge in a scripting language.
    • Strong organizational skills and attention to detail.
    • Very good interpersonal skills, self-motivated, communicative, responsible.
#CNT
PL-SQL Developer
Wilkes-Barre, PA
  
PL-SQL Developer Job Summary: 
 
  • The PL-SQL Developer, modifies, develops, writes and implements software programming Applications and components.
  • Works from written specifications and pre-established guidelines to perform the functions of the job and maintains documentation of process flow.
 
PL-SQL Developer Background:   
 
  • 4-year Bachelor degree in business, Information Technology, or related field (or equivalent experience)
  • 7 years of SQL development experience including but not limited to the creation of packages, procedures, tables views, functions, etc.
  • 7 years of experience in Database Star Schema and or Snow flake schema in First, Second and Third normal form.
  • Must have knowledge on how to build/maintain efficient database tables structure for both transactional and warehouse data.
  • 6 years of experience in PL/SQL tuning including knowledge of Explain Plans AWR, ASH and TKPROF
  • Knowledge of oracle partitioning practices and data archival structures and processes.
  • Knowledge of Oracle 11g and 12c with use of tools such as SQLDeveloper, TOAD and ERWIN.
  • Must have the ability to work with the system analysts to translate business requirements to database structure as well has communicate the design to the front end development staff.
  • Experience in the Agile programming framework.
  • Position qualifications are as follows:  
    • Data analysis experience with solid background in SQL
    • Experience writing complex queries to uncover data discrepancies.
    • Ability to respond to ad hoc requests for data and information.
    • Strong skills in reporting, business intelligence and metrics.
    • Strong data quality and analysis skills are necessary.
    • Ability to manipulate large amounts of data, mainly in Microsoft Excel and Oracle12C.
    • Solid experience in Excel for data analysis and visualization.
    • Ability to work effectively with clients, data managers and other technical
    • Ability to present complex information in an understandable manner.
    • Ability to recognize problems, take initiative, solve problems, and work independently.
    • Programming knowledge in a scripting language.
    • Strong organizational skills and attention to detail.
    • Very good interpersonal skills, self-motivated, communicative, responsible.
#CNT
 
KARI HANNA
Division Vice President - I.T.
CareNational Healthcare Services
Kari@CareNational.com
480.681.0168 (CALL – TEXT – FAX)
CareNational.com
Sign-Up for Job Alerts
or
this job portal is powered by CATS