Senior Database Developer

ICE; Atlanta (GA); On-site; USD 120,000 - 160,000; Full time

Job summary

Intercontinental Exchange, Inc. is seeking a Senior Database Developer to design and build the new platform supporting fixed income portfolio analytics. The platform uses a distributed services architecture with Oracle databases and Python/Java-centric development, focusing on scalable data models and robust ETL processes.

You will collaborate with stakeholders, implement PL/SQL procedures, optimize performance, and ensure quality through tests and documentation. AWS exposure is highly valued.

Qualifications

• 7+ years of applied work experience as a database developer on Oracle.
• Experience with Linux and Windows environments.
• ETL process development and automation experience.
• Desirable experience in cloud environments such as AWS.
• Strong focus on delivering quality, well-tested solutions.

Responsibilities

• Collaborate with business and technology stakeholders to define design.
• Design data models and implement PL/SQL procedures on Oracle/PostgreSQL.
• Develop, maintain and support data used by systems.
• Optimize access from Java and integrate Oracle solutions.
• Triage and remediate performance and system issues.
• Lead or participate in Agile project efforts.
• Create system and training documentation as needed.

Skills

SQL & PL/SQL

Data modeling

ETL development

Linux/Windows

Python basics

Java basics

Performance tuning

Education

Bachelor's degree in Computer Science or related field

Tools

Oracle

PostgreSQL

PL/SQL

AWS

Oracle tuning tools

Job description

Job Purpose

Several strategic and business-critical development initiatives are underway to developand extend our complex Fixed Income and Equity analytics using the latest technologies. We are also committed to leveraging the best practices in Object Oriented and Database Design and Development in this endeavor. To support rapid development, we continue to invest in developing the highest level of code quality and comprehensive test coverage.

Overview

Several strategic and business-critical development initiatives are underway to developand extend our complex Fixed Income and Equity analytics using the latest technologies. We are also committed to leveraging the best practices in Object Oriented and Database Design and Development in this endeavor. To support rapid development, we continue to invest in developing the highest level of code quality and comprehensive test coverage.

Job Purpose

The Senior Database Developer will play a key role in designing and developing the new platform to support our growth business in fixed income portfolio analytics. The platform is architected as a distributed system of services to manage data intensive computations of fixed income analytics across a large compute farm. We leverage the best-in-breed software, messaging systems, Oracle database tools, and development practices in a Python and Java-centric environment.

Responsibilities

• Collaborate with key business and technology stakeholders to define functional and technical design.
• Work closely with software engineering team and senior leadership to design and implement data solutions.
• Develop technical specifications for physical relational data models on Oracle database that demonstrate a keen awareness of RDBMS design principles and performance-tuning.
• Design data models, implement PLSQL procedures on the latest versions of Oracle and Postgress databases.
• Develop, maintain and support the data used by our systems
• Work with the development team to tailor the design and implement in Oracle for efficient access from Java.
• Triage, diagnose and remediate system and performance issues in a timely manner
• Lead and/or participate in project efforts using an Agile development methodology.
• Be a trusted expert in loading large volumes of data in an efficient manner.
• Develop system and training documentation as needed.
• Must be able to work flexible hours as needed to support project timelines and deliver efforts on time.
• Provide technical support or provide subject matter expertise to other team members as needed.

Knowledge And Experience

• 7+ years of applied work experience as a database developer on Oracle
• Enthusiastic advocate and expert in modern full software development lifecycle practices
• Must be devoted to delivering quality and well-tested solutions
• Excellent written and verbal communication skills.
• Good experience developing solutions for both Linux and Windows.
• Comprehensive knowledge of Oracle functionality: physical table design, normal forms, data partitions, integrity constraints, indexing strategies, performance tuning, execution plans, PLSQL and stored procedures, database monitoring tools, locking, deadlock detection and resolution
• Demonstrated experience in the development and automation of ETL processes for data loading and extraction
• Must be proficient in scripting languages. Basic understanding of Java and Python would be a plus.
• Experience developing and integrating solutions in cloud environments such as AWS is desirable
• A team player who collaborates effectively with other software engineers.
• Self-starter, who is both motivated, disciplined and accountable for delivering accurate and timely results
• The successful candidate will be adaptable, results-focused and can work individually or as part of a team.

Intercontinental Exchange, Inc. is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to legally protected characteristics.