Job Description :
Role: Oracle Developer(PL/SQL)
Location: Lake Oswego, OR
Duration: 6-12+ months
Job description:
Bachelors in Computer Science or equivalent work experience
6+ 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, SQL Navigator or SQL Developer
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