Lead Database Developer

Job Purpose

The selected Lead Database Developer/DBA will be part of database team and play leadership role in the analysis, design, implementation, and support of a series of applications for ICE Clearing System.

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
• Work with business analysts in understanding new requirements
• Follow company software development processes and standards
• Mentor other team members and lead cross-functional efforts with other teams
• Assist PM's in creating schedules and ensuring developers assigned to them follow the schedule and processes;
• Ability to drive ongoing and new initiatives, and move projects to completion with little supervision

Knowledge and Experience

• 80% PL/SQL development work and 20% Database Administration work
• 8+ years 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
• Familiar with job scheduling tool and technique
• 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 skills
• Understand SDLC process and tools, agile program management concepts and version control