FOX Factory, Inc., a fast-growing and dynamic company in Scotts Valley, CA (95066) has an exciting opportunity for an Oracle Tech Analyst.
The Oracle Tech Analyst will design, develop, and deliver database components of software applications using PL/SQL and other Oracle tools and technology, and troubleshoots any problems with them. This individual will also execute trial runs of software applications, review programs, and perform system analysis.
Responsibilities include but not limited to :
- Coordinates the full life cycle of IT projects using SQL Developer, Toad, Work Flow Builder, JDeveloper for OAF and BI/XML Publisher Desktop, PL/SQL, Web Services and Unix.
- Coordinates the development and implementation of dashboard solutions using Oracle ADF.
- Oversees the implementation of test validations of the application.
- Ensures the optimization of the developed applications.
- Participates in application walk throws with users.
- Implements user controls.
- Produces project documentation.
- Interacts with business teams to clarify requirements and business needs.
- Collaborates with other developers, architects, and quality assurance teams to determine optimal solution architecture, efficiency, maintainability, and scalability.
- Troubleshoots, corrects errors in programs, and optimizes code to ensure performance and security requirements.
- Writes complex queries, stored procedures, software packages, and triggers.
- Implements the data model that the required applications requirement, the rules for data integrity, and the specified functions for accessing and manipulating the application data.
- Prepares and maintains documents, code documentation, workflow charts, and diagrams as needed to describe the program’s intended functionality, the data flow, the logic used, and any significant considerations made.
- Experience with Oracle Demantra