Gain America · 3 months ago
Oracle PL/SQL Developer with knowledge of Linux or redhat job
Hicksville, NY
Full-time
Onsite
Mid, Senior Level
$110K/yr - $110K/yr
5+ years expGain America is a US-based enterprise headquartered in New York, specializing in technology solutions. They are seeking an Oracle PL/SQL Developer with strong experience in Oracle SQL/PL SQL and knowledge of Linux or Redhat to support reporting requirements and optimize queries.
Information Technology & Services
Responsibilities
Must have - Min 5 years IT experience
Strong Oracle SQL / PL SQL experience
Experience with Oracle 12c (Must have)
Knowledge of Linux or redhat Linux
Report development, or design & creation of tables & views that supports reporting requirements
Understanding of Cost Based Optimization (CBO)
Optimize and write a query
Production support experience, including correcting codes as a result of production issue
Knowledge of sqlloader
Good knowledge of CBO
Knowledge of pl/sql/stored procedures, triggers, etc
Knowledge of meta-data
Knowledge of AUTOSYS (Nice to have)
Should Posses hands on PL/SQL Skills
Should carry good communication skills and good Presentation skills
Ability to analyze business requirements / processes and system integration considerations to determine appropriate technology solutions
Should be able to ideate on innovation for research that can help transform businesses
Should have open communication standards, collaborative and team player
Must have strong interest in keeping oneself acquainted with latest technology trends and practices
Should be able to gather requirements, apply solution approaches and communicate with the other team members
Qualification
Required
Min 5 years IT experience
Strong Oracle SQL / PL SQL experience
Experience with Oracle 12c (Must have)
Knowledge of Linux or redhat Linux
Report development, or design & creation of tables & views that supports reporting requirements
Understanding of Cost Based Optimization (CBO)
Optimize and write a query
Production support experience, including correcting codes as a result of production issue
Knowledge of sqlloader
Good knowledge of CBO
Knowledge of pl/sql/stored procedures, triggers, etc
Knowledge of meta-data
Good communication skills
Good Presentation skills
Ability to analyze business requirements / processes and system integration considerations to determine appropriate technology solutions
Ability to ideate on innovation for research that can help transform businesses
Open communication standards, collaborative and team player
Strong interest in keeping oneself acquainted with latest technology trends and practices
Ability to gather requirements, apply solution approaches and communicate with the other team members
Preferred
Typically a Bachelor's Degree or global equivalent in related discipline
Knowledge of AUTOSYS (Nice to have)
Company
Gain America
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®.
51-200 employees
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 StageCompany data provided by crunchbase