What are the responsibilities and job description for the Oracle Developer position at Avant Tech?
The Senior Oracle DBA/Developer will join a team focused on the development and maintenance of various database applications. The successful candidate will have extensive experience in database design, PL/SQL development, a good working knowledge of end-user and server-side data processing techniques, a good understanding of SDLC and agile development methodologies, and the ability to work with minimal oversight. Excellent written and verbal communication skills are necessary as the position requires authoring datamodels, system designs, diagrams, and user and technical documentation.
RESPONSIBILITIES
- 90% PL/SQL development work and 10% Database Administration work
- Develop business requirements into implementable architecture and designs
- Create operations and technical documentation for developed systems and applications
- Utilize advanced Oracle features and techniques where appropriate to develop robust, reliable, and high-performance solutions
- Maintain awareness of new Oracle features and techniques and develop an understanding of how and where they can best be applied
- Participate in and support QA and user-acceptance test procedures and environments
- Willing to take on-call rotation and occasional weekend work
REQUIREMENTS
- B.Sc. Degree in Computer Science, Mathematics, Physics, Engineering or other relevant subject or equivalent experience
- Minimum of 5 years experience developing database applications in PL/SQL using Triggers, Packages, Functions, Procedures, and Complex SQL
- Oracle 11g experience a must
- Must have work experience working in Unix/Linux environment. RAC experience.
- Oracle Advanced Queuing must
- Excellent problem-solving, issue identification, analytical, and technical documentation skills.
- SQL Query tuning using different tools. Clear understanding of query plan.
- Oracle Application Express (APEX) must
- Experience with JavaScript/jQuery must
- Some Unix scripting experience.
- Understanding of messaging middleware a
- Strong interpersonal skills and ability to work well in a team environment
- Excellent written and verbal communication skills.
- Understand SDLC processes and tools, agile program management concepts, and version control.
