Oracle Developer
Job Description Summary
The primary objective of the Oracle Developer is to design and develop Oracle jobs and procedures according to project requirements. This individual leverages their knowledge of analysis, design, coding, testing, and maintenance of software applications to develop, enhance, and modify CCC applications. The Oracle Developer works with the technical lead, other developers, and QA analysts to assist with the conceptualization of software solutions from the unit level through the integrated application level. This individual demonstrates an understanding of the latest development environments including development tools and applications.
Job Duties
- Work with other developers and QA analysts on design, development, and maintenance projects using SQL and PL/SQL
- Be familiar with these Oracle technologies: external tables, partitions, scheduled jobs, exception handling
- Use accepted performance tuning approaches for efficient processing of large data sets
- Understand existing multi-schema system architecture comprised of jobs, packages, procedures, views, and tables
- Prepare deployment scripts for Oracle code and DDL migration
- Prepare clear support documentation for operations and support personnel
- Analyze and troubleshoot production problems
- Follow established best practices for code documentation and svn version control management
- Participate in daily stand ups, sprint planning, and retrospectives meetings
Qualifications
- Bachelor's Degree in Computer Science, Information Systems, Engineering, or related field of study
- 5+ years of Oracle experience with SQL, PL/SQL, batch jobs, ETL, architecture, data design & modeling, and performance tuning
- Familiarity with Agile development methodology
- Strong knowledge of PL/SQL & SQL development best practices
- Basic knowledge of Unix scripts
- Experience with Pentaho a plus
- Experience with AWS hosted databases a plus