More jobs:
Oracle PL/SQL Developer
Job in
Hicksville, Nassau County, New York, 11815, USA
Listed on 2025-12-01
Listing for:
Gain America
Full Time
position Listed on 2025-12-01
Job specializations:
-
IT/Tech
Database Administrator, IT Consultant
Job Description & How to Apply Below
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.).
- 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).
- 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 Type: Full-time
- Schedule:
Monday to Friday - COVID-19 considerations:
Option to work remotely
- Basic understanding of industry practices and tools
- General planning/organizational skills, problem solving, and communication skills
- Interpersonal skills and developing professional credibility
Gain Am 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
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×