Gain America

Oracle PL/SQL Developer job

Gain America, WorkFromHome

Save Job

Overview

Gain America – Oracle PL/SQL Developer

Location: New York, NY

Job #164 | Date Posted: 06/03/2024 | Salary: $70,000

Responsibilities

Must perform troubleshooting of production issues such as deadlocks, waits, and slow queries.
Be able to utilize Unix user experience (connect to remote servers, navigate file system, run scripts from the command line, write simple shell scripts, understand background jobs, nohup, etc.).

Qualifications

Strong Oracle 10g or above with 5+ years of experience developing. Skills in data modeling, including logical and physical schema design, parent-child relationships, many-to-many relationships, normalization, demoralization, clusters, indexes and IOTs.
Advanced SQL and PL/SQL skills in an Oracle RDBMS environment, including stored procedures, functions, packages, triggers, and views. Performance tuning and query optimization.
Understanding of the Oracle optimizer, ability to tune statements using hints, read explain plan output, and profile SQL.
Experience with diverse SQL constructs (joins, ANSI syntax, nested sub-queries, hierarchical queries, analytic functions).

Job Description / Experience

Must perform troubleshooting production issues such as deadlocks, waits, slow queries.
Unix experience: connect to remote servers, navigate file systems, run scripts, write simple shell scripts, understand background jobs.
Preferred education: Typically a Bachelor\'s Degree or global equivalent in related discipline.

Job Details

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

General Skills & Competencies

Basic understanding of industry practices and tools
General planning/organizational skills, problem solving, and communication skills
Interpersonal skills and developing professional credibility

Company Note

GainAm is a US-based enterprise headquartered in New York with over 15+ years of technology experience. Since 2006, growth has been organic with over 85% repeat customers and referrals.