What are the responsibilities and job description for the Senior Database Developer position at Intercontinental Exchange Holdings, Inc.?
Overview
Job Purpose
The selected Senior Database developer/DBA will be part of database team and play a 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
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
Schedule
This role offers work from home flexibility of 1 day per week.
Intercontinental Exchange, Inc. is an Equal Opportunity and Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity, national origin or ancestry, age, disability or veteran status, or other protected status.
