Job Purpose
The candidate will be responsible for ongoing software development for a business line, interfacing with users and management in the planning of major functionality, analyzing business functional requirements to determine the scope of work, evaluating available application alternatives to support business needs, and managing resource planning/constraints. Discretion and independent judgment are required on a daily basis.
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
- 80% PL/SQL development work and 20% Database Administration work
- Experience developing database applications in PL/SQL-Triggers, Packages, Functions, Procedures, Complex SQL, Oracle Collection, Object Types knowledge and experience
- Must have work experience working in Unix/Linux environment. RAC experience is a plus
- Some Shell or Perl experience
- SQL Query tuning using different tools. Clear understanding of query plan management.
- Experience with partition management and parallel processing
- Oracle 12c or 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
- Understand SDLC process and tools, agile program management concepts and version control
- Willing to take on-call rotation and occasional weekend work
This role offers work from home flexibility of 1 day per week.
