Oracle PL/SQL Developer job jobs in United States
cer-icon
Apply on Employer Site
company-logo

Gain America · 4 months ago

Oracle PL/SQL Developer job

positionHicksville, NY
timeFull-time
remoteHybrid
seniorityMid, Senior Level
money$70K/yr - $70K/yr
date5+ years exp

Gain America is a US based enterprise headquartered in New York, with over 15+ years of combined technology experience. They are seeking an Oracle PL/SQL Developer to troubleshoot production issues and utilize Unix user experience.

Information Technology & Services
check
H1B Sponsor Likelynote

Responsibilities

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

Qualification

Oracle 10gAboveSQLPL/SQLData modeling skillsPerformance tuningUnix user experienceCommunication skillsProblem solving skills

Required

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
Must perform troubleshooting production issues such as deadlocks, waits, slow queries
Be able to utilize Unix user experience (connect to remote servers, navigate file system, run scripts from command line, write simple shell scripts, understand background jobs, nohup, etc)

Preferred

Typically a Bachelor's Degree or global equivalent in related discipline

Company

Gain America

twitter
company-logo
We provide Digital transformation, custom application development, cloud solution architecture, cloud migration services, and implementation services to design, deploy and operate your solution on public cloud platforms like amazon web services®, google cloud and microsoft azure®.
dateFounded in 2006
location
Hicksville, NY, US
people-size51-200 employees
web-link
https://www.gainam.com/

H1B Sponsorship

Gain America has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2021 (1)

Funding

Current Stage
Growth Stage
Company data provided by crunchbase