A.C. Coy

Oracle PL/SQL Developer

US-PA-Canonsburg
2 weeks ago
Job ID
2017-17314
# of Openings
1
Category
Information Technology

Overview

A strategic client of the A.C. Coy Company is seeking a contract to hire Oracle PL/SQL Developer/DBA.  This person will be responsible for application development, data modeling, developing PL/SQL procedures, application/SQP performance tuning, and data warehousing design. This is an Agile development environment and the candidate will be spending more time in application development teams versus providing operational support of the databases.

Responsibilities

  • Provide database development:  Develop application code using database programming languages and scripting languages to support application releases; analyze business requirements for application releases and, based on findings, provide recommendations for solution and estimates of work.
  • Provide database design:  Research and recommend optimal table and index design criteria balancing scalability, data integrity and maintainability; publish entity relationship and data flow diagrams, design standards and work with development staff; standardize environment and improve efficiency.
  • Provide first-level application support:  Resolve problems and answer questions related to the database and layered products; contact vendor support when necessary; facilitate application development and customer problem resolution with optimum speed and efficiency.
  • Database performance monitoring and tuning:  Closely monitor performance; identify problems and implement solutions; ensure the database is running at optimum speed and efficiency.
  • Maintain database backup/recovery environment:  Respond quickly to refresh data; verify implementation of correct backup strategy; develop recovery procedures; support recovery from loss of data caused by user or system error.
  • Install and upgrade databases and related products:  Keep databases at current release and maintenance levels, install supporting products; provide current, stable database environments.

Qualifications

  • Bachelor’s degree in Computer Science, Engineering, or related discipline preferred; equivalent experience is acceptable
  • Oracle Professional Database Administrator certification is preferred
  • At least three (3) years experience in the design, administration, programming, and support of Oracle databases in a distributed Unix (Solaris preferred) computing environment
  • Proficient Oracle PL/SQL and SQL coding skills with particular attention given to detail and accuracy
  • Proficient Oracle SQL performance tuning and optimization skills
  • Experience with Unix scripting languages (e.g., Korn shell, Perl)

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed