Oracle PL/SQL Developer required Oracle 10g or above job

GainAm

$90K — $130K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 5+ years of experience with Oracle 10g or above
  • Strong SQL and PL/SQL skills including stored procedures, functions, and packages
  • Proficient in performance tuning and query optimization
  • Advanced SQL knowledge, including various joins and analytic functions
  • Experience troubleshooting production issues like deadlocks and slow queries
  • Unix user experience, capable of navigating and running scripts from the command line
  • Bachelor's Degree in a related field preferred

Responsibilities

  • Perform database design and programming in PL/SQL
  • Develop logical and physical data models with parent-child relationships
  • Engage in query performance tuning and optimization
  • Utilize the Oracle optimizer effectively for SQL statements
  • Troubleshoot and resolve production database issues
  • Write and maintain efficient SQL and PL/SQL code
  • Interact with remote servers and manage shell scripts in Unix

Benefits

  • Option to work remotely
  • Standard Monday to Friday work schedule
  • Opportunity to develop problem-solving and decision-making skills
  • Exposure to industry practices and tools
  • Enhancement of presentation and communication skills
Full Job Description
Required Skills

Oracle 10g or above 5+ years experience developing Data modeling skills, including logical and physical schema design, parent-child relationships, many-to-many relationships, normalization, demoralization, clusters, indexes and IOTs! Strong SQL and PL/SQL skills in an Oracle RDBMS environment, including stored procedures, functions, packages, triggers, and views Performance tuning and query optimization Oracle 10g and 11g Advanced SQL knowledge including different types of joins, ANSI syntax, nested sub-queries, hierarchical queries and analytic functions Understands how the Oracle optimizer works, how to tune statements using hints, read explain plan output, and how to profile a piece of SQL in general Experience in troubleshooting production issues such as deadlocks, waits, slow queries Unix user experience (connect to remote servers, navigate file system, run scripts from command line, write simple shell scripts, understand background jobs, nohup, etc)!

Required Experience

Job Description: Must be able to perform Database design to programming in PLSQL

Preferred education:Typically a Bachelor's Degree or global equivalent in related discipline.

Job Type: Full-time
Schedule: Monday to Friday
COVID-19 considerations: Option to work remotely

General skills & competencies:

Basic understanding of industry practices.General proficiency with tools, systems, and procedures.Basic planning/organizational skills and techniques.Good decision making, analysis and problem solving skillsGood verbal and written communication skills.Basic presentation and public speaking skillsBasic interpersonal skillsDeveloping professional credibility

Similar Jobs

More Jobs at GainAm

More Information Technology Jobs

Find similar Oracle PL/SQL Developer required Oracle 10g or above job jobs: