What are the responsibilities and job description for the Oracle Developer/DBA position at ICE?
Overview
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
The expected base salary for this role, if located in New York, is between $150,000 - 200,000 USD. The base salary range does not include Intercontinental Exchange’s incentive compensation. While we provide this range as general guidance, at ICE we compensate employees based on the skillset and experience of the individual. Regular full-time ICE employees are eligible for a suite of competitive employee benefits, including healthcare coverage (medical, dental and vision), a 401(k) plan, life insurance, time off, and paid leave for qualifying circumstances.
Intercontinental Exchange, Inc. is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to legally protected characteristics.
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
- 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
The expected base salary for this role, if located in New York, is between $150,000 - 200,000 USD. The base salary range does not include Intercontinental Exchange’s incentive compensation. While we provide this range as general guidance, at ICE we compensate employees based on the skillset and experience of the individual. Regular full-time ICE employees are eligible for a suite of competitive employee benefits, including healthcare coverage (medical, dental and vision), a 401(k) plan, life insurance, time off, and paid leave for qualifying circumstances.
Intercontinental Exchange, Inc. is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to legally protected characteristics.
Salary : $150,000 - $200,000