Oracle Developer/DBA

Job Purpose

The successful candidate will be part of the ICE Bonds Database Dev/DBA team with a focus on design, development, performance tuning, analysis, implementation, and support in a dynamic and vibrant environment. This role requires strong technical, analytical and organizational skills. You 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

• Deep knowledge of Oracle database
• Conduct PL/SQL or SQL development to solve business problem
• Good knowledge of Unix shell programming
• Working knowledge in Python programming
• Conduct database administrative work to support for production system
• Ability to work under pressure and excellent problem-solving skills
• Provide support for QA and Development systems.
• Identify opportunities to fine-tune and optimize database systems
• Team player with good attitude
• Weekend on call participation

Knowledge and Experience

• 5+ years of experience in Oracle database development
• Extensive knowledge on developing database applications in PL/SQL-Triggers, Packages, Functions, Procedures, Complex SQL, Oracle Collection, Object Types knowledge and experience
• 2+ years of experience in Unix shell programming
• RAC experience is a plus
• Some Python and Perl programming experience
• Experience with managing and troubleshooting databases in high performance, multi-user applications
• SQL Query tuning using different tools. Clear understanding of query plan
• Excellent problem solving, issue identification, analytical and technical documentation skills
• Professionalism, positive outlook, respect and courtesy to customers and all associates and excellent team player
• Strong written and verbal communication skill
• Understand SDLC process and tools, agile program management concepts and version control