Oracle Pl/Sql Developer Job, Oyster Bay

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 ****, growth has been organic with over 85% repeat customers and referrals.
Related Links
About Us
Social Commitment
Diversity & Inclusion
Privacy Policy
Blog
Get In Touch
#J-*****-Ljbffr