Job Description
Job Purpose
The candidate should be able to work independently, handle multiple simultaneous tasks and be adept at prioritizing their work. The candidate will be able to focus on the project priorities to deliver the required product at the scheduled time. They should be comfortable collaborating with business analysts, product managers, quality assurance groups and client services to refine requirements and plan implementation strategies.
The applicant will have experience in problem solving, planning, and estimating development efforts and have strong communication skills. Most importantly they should demonstrate the ability to show initiative and be able to move projects forward to completion with minimal supervision.
The candidate will be expected to be involved in the full life cycle of the systems development from requirement gathering through development and testing to on-going support and maintenance. The position will involve some on-call support outside of regular business hours, nights and weekends.
Responsibilities
- Use and review PL/SQL or SQL development to solve business problems
- Conduct database administrative work to support for production systems
- Provide support for QA and Development systems
- Identify opportunities to fine-tune and optimize database systems
Knowledge And Experience
- B.S. or higher in Computer Science, Information Systems, Engineering or related discipline or equivalent work experience
- At least 5+ years of experience developing database applications in PL/SQL-Triggers, Packages, Functions, Procedures, SQL, Analytical functions, Oracle Collection, Object Types knowledge and experience
- Must have experience working in Unix/Linux environment. RAC experience is a plus
- Some Shell scripting and Perl experience
- Frontend application development using Oracle Apex is a plus.
- SQL Query tuning and understanding of query plan management.
- Experience with partition management and parallel processing
- Experience with Oracle VPD is a plus.
- Oracle 19c experience a must
- Excellent problem solving, issue identification, analytical and technical documentation skills
- Strong interpersonal skills and ability to work well in a team environment
- Good written and verbal communication skill
- Familiarity with GIT and Bitbucket is a plus.
- Willing to take on-call rotation and occasional weekend work
