Oracle database developer in Memphis, TN at Vaco

Date Posted: 7/19/2019

Job Snapshot

Job Description

Primary Requirements

  • Exceptional communication skills a must
  • Local to Memphis area preferred

Secondary requirements

  • Ability to collect requirements from and work closely with a team of 30+
  • Minimum 1-2 years web experience

Technical

  • 5+ years of experience with Oracle Relational Database development
  • Very good working knowledge of Oracle Relational Database structures and objects
    • Good working knowledge of Oracle dictionary tables
    • Good working knowledge creating/altering Oracle database objects such as tables, constraints, indexes, views, procedures, functions, triggers, synonyms, etc.
  • Very good working knowledge with database development tools such as Oracle SQL Developer or Toad for Oracle
  • Very good working knowledge with Oracle SQL syntax (Joins, Unions, Grouping, Sorting, etc.)
  • Good working knowledge tuning SQL queries (Analyzing and Implementing tuning solutions via Hints, Indexes, Restructuring queries, etc.)
  • Very good working knowledge creating Oracle database relational Views
  • Very good knowledge with the Oracle PL/SQL programming language
    • Creating/Changing PL/SQL blocks to perform specific tasks
    • Creating/Changing Oracle Packages and Stored Procedures
    • Creating/Changing Oracle Functions
    • Creating/Changing Oracle Triggers
  • Good working knowledge of Oracle Synonyms

Good working knowledge with managing Oracle Grants and Privileges