Job Oracle PL/SQL Consultants Oregon Oracle PL/SQL

Oracle PL/SQL Consultants

Skills:Oracle PL/SQL       |  Location:Oregon  ,  United States Of America

Views:286


Need: Oracle PL/SQL Consultants
Location: Carrolton TX/ Lake Oswego, OR
Duration: 6-12 Months Contract
Job Description:


Please verify the authenticity of the profiles and specifically check if they
areworking on Oracle 11g/12C in the last project.


Job Responsibilities include:
You will be responsible for designing and implementing product enhancements,
creating and modifying PL/SQL packages, redesign of existing product functions,
trouble-shooting and resolving product defects, unit and integration testing.
Active interaction with off-shore team in India, internal customers, other
developers, Quality Assurance, Business System Analysts, Tax Research,
Professional Services, and Customer Support counterparts is an integral part of
the role.

Some of the key tasks you will perform include:
- Designing database schema that produce high performance software solutions
in service-oriented architectures
- Programming and unit testing of code based upon design sessions with
internal software users, customer-reported issues, and input from Business
System Analysts, Marketing, Professional Services, and Support
- Unit and performance testing of design as part of development cycle
- Developing and re-factoring existing products, providing product
enhancements and resolving product defects to meet customer issues
- Providing technical expertise and peer code reviews to other team members
- Providing architectural input on new and existing solutions
- Writing technical specifications, program documentation, and unit test
plans for all work performed
- Maintaining solid relationships with cross-functional peers and offshore
team
- Assisting in Quality Assurance process and customer issue resolution
- Partnering with Quality Assurance to drive high-quality, on-time
deliverables.

Job and work experience requirements:
- Bachelors in Computer Science or equivalent work experience
- 3+ years? experience with Oracle 11g/12c database design and data
architecture experience
- Experience with PL/SQL, packages, stored procedure development and data
modeling
- Experience in debugging and understanding complex, unfamiliar PL/SQL code
- Practical experience with large databases containing tables with billions
of rows and terabytes of data
- Experience using Oracle packages (dbms, ctx, utl etc.), procedures, views,
materialized views,
- Experience working with XML and JSON
- Familiarity with third party tools such as TOAD, SQLNavigator or
SQLDeveloper
- Experience with nested tables, user defined functions, packages and
triggers, external and partition tables, bulk processing
- Experience with ETL processing and patterns, implementations and tools
along with writing scripts to load/manipulate data between different databases
- Should be able to perform ETL processes using PL/SQL with/without third
party tools
- Database performance tuning and job scheduling in oracle
- Additional experience working with other databases such as MySQL and SQL
Server is also desirable
- Demonstrated ability to work as part of a team, as well as independently
- Solid work ethic, self-driven with the ability to work with minimal
supervision
- Experience using Agile-based methodologies within a software development
function
- Experience with full life cycle development: requirements gathering,
analysis, design, coding, unit testing, and acceptance testing
- Strong working knowledge with Object-Oriented Analysis, Design, and
Implementation


Experience in any of the following is considered a plus:
- Linux/Unix Bash, Perl or Python script writing is a plus

-Non-relational database technologies (NoSQL)
- Experience working with Java/J2EE and web technologies is a plus
- Big Data frameworks and implementations (Hadoop, MongoDB, etc.) is not
mandatory but would be a plus
- Applying Design Patterns and Enterprise Application Integration Patterns
- Prior work experience in a fast-paced, high-energy environment
- Performance testing, analysis, and tuning experience
- IntelliJ IDEA IDE

Other specialized knowledge and skills required:
- Proven strong analytical design and trouble-shooting skills
- Highly accountable for meeting all commitments and deadlines
- Effective communication skills, both written and verbal for technical and
non-technical audiences
- Must be able to work independently as well as collaboratively
- Drive for continuous process improvement


--

Name
Email @
Skills
Resume

Save me for future


Check Similar Jobs



Create Job Alerts



Recent Gigs

Reviews-($10)
I will write excellent product reviews for any company..
Not rated
Post job ad to 10 job boards-($3)
I will post your job ad to 10 free job boards including this.
Not rated
Find list of job seekers-($8)
I will research and find list of job seekers based on skills.
Not rated
Review resume and provide feedback-($0)
I have good experience with handling USA, Canada, UK resume .
Not rated
Virtual Assistant With HR And Recruitment-($9)
With this gig, I will work for 3 hours as a virtual assistan.
Not rated



Recent Projects

Field service technician -($100-$1000)
Field Service Technicians compensation:$15- 18/hr Local Te
We need 4 Aspiring Bloggers/Social Media Influencers-($0-$0)

We have teamed up with chic fashion brand Nude Couture
WORK FROM HOME ON YOUR FREE TIME AND EARN 9K 30K WITH GENUINE PAYMENT-($10000-$50000)
We Need Passionate People For Customer Service (Work From Ho
Sri Lanka B+block Vac-($0-$10)
This is136 grandson of the cabinet. Lancer Corp the drill pr
Affiliate Marketing Opportunity -($0-$0)
Looking for a work from home opportunity? This opportunity m