Oracle PL/SQL Developer 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. Related Links About Us Social Commitment Diversity & Inclusion Privacy Policy Blog Get In Touch #J-18808-Ljbffr