Senior Oracle & PostgreSQL Database Engineer

As a Senior Software Engineer, Database Engineering, you will support DTCC’s Institutional Trade Processing applications, including Central Trade Manager (CTM) and Settlement Instruction Manager (SIM), which are critical platforms within the post-trade processing lifecycle.

You will design, develop, and optimize scalable database and application solutions that support high-volume, high-transaction environments. You will also contribute to strategic modernization initiatives focused on cloud adoption, platform resiliency, and performance optimization.

This role is ideal for an engineer who enjoys working with complex data, building reliable enterprise solutions, and partnering across Agile teams to deliver business-critical technology outcomes.

Your Primary Responsibilities:

• Design, develop, and optimize enterprise database solutions using Oracle and PostgreSQL.
• Build and support high-volume OLTP systems that process large transactional workloads.
• Develop data models, complex SQL queries, PL/SQL, stored procedures, views, and database objects.
• Partner with application development teams to build integrated solutions using Java, JDBC, JMS, and related technologies.
• Support cloud-first modernization initiatives using AWS and cloud-native engineering practices.
• Implement database change management, schema deployments, and version control using tools such as Liquibase, Git, and GitHub.
• Perform database performance tuning, query optimization, troubleshooting, and root cause analysis.
• Support data integration through APIs, SFTP, batch processing, ETL/ELT, and replication technologies.
• Ensure data quality, security, access controls, resiliency, and operational reliability.
• Participate in Agile/Scrum ceremonies, sprint planning, design discussions, and delivery execution using Jira.
• Collaborate with engineers, architects, product owners, and business partners to deliver scalable technical solutions.
• Mentor junior team members and promote engineering best practices, documentation standards, and technical excellence.

• Bachelor’s degree or equivalent experience.
• 8+ years of experience in software engineering, database development, or related technical roles.
• Experience supporting enterprise-scale applications in high-volume, transactional environments.

Talent Needed for Success

• Strong experience with Oracle database development, preferably Oracle 19c or higher.
• Hands-on experience with PostgreSQL in production environments.
• Advanced SQL and PL/SQL development expertise.
• Strong experience with data modeling, database design, and OLTP systems.
• Experience supporting high-volume, high-performance transactional environments.
• Hands-on Java development experience, including JDBC and JMS.
• Experience with Linux/Unix environments and shell scripting.
• Experience with AWS cloud services and cloud-native data platforms.
• Strong expertise in database performance tuning, query optimization, and troubleshooting.
• Experience with database change management and deployment tools such as Liquibase.
• Familiarity with Git, GitHub, Jira, and Agile/Scrum delivery methodologies.
• Demonstrated ability to solve complex technical challenges in large-scale, mission-critical environments.
• Strong analytical, problem-solving, collaboration, and communication skills.
• Ability to communicate complex technical concepts effectively to both technical and non-technical stakeholders.
• Experience with database change management and deployment tools such as Liquibase.
• Familiarity with Git, GitHub, Jira, and Agile/Scrum delivery practices.
• Strong analytical, problem-solving, collaboration, and communication skills.
• Demonstrated ability to solve complex technical problems in large-scale, high-volume transactional environments.
• Ability to explain technical concepts clearly to both technical and non-technical stakeholders., * Experience supporting large-scale modernization, cloud transformation, or application migration initiatives.
• Financial services, capital markets, post-trade processing, or settlement experience.
• Experience with Snowflake.
• Experience with Red Hat OpenShift Container Platform.
• Experience with Jenkins or CI/CD pipelines.
• Knowledge of Oracle GoldenGate or other data replication technologies.
• Experience with Python, Perl, or other scripting languages.
• Familiarity with Oracle RAC, Toad, or Erwin Data Modeler.

• Competitive compensation, including base pay and annual incentive
• Comprehensive health and life insurance and well-being benefits, based on location
• Pension / Retirement benefits
• Paid Time Off and Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well-being.
• DTCC offers a flexible/hybrid model of 3 days onsite and 2 days remote (onsite Tuesdays, Wednesdays and a third day unique to each team or employee).

Do you want to work on innovative projects, collaborate with a dynamic and supportive team, and receive investment in your professional development? At DTCC, we are at the forefront of innovation in the financial markets. We are committed to helping our employees grow and succeed. We believe that you have the skills and drive to make a real impact. We foster a thriving internal community and are committed to creating a workplace that looks like the world that we serve.

The Information Technology group delivers secure, reliable technology solutions that enable DTCC to be the trusted infrastructure of the global capital markets. The team delivers high-quality information through activities that include development of essential, building infrastructure capabilities to meet client needs and implementing data standards and governance., With over 50 years of experience, DTCC is the premier post-trade market infrastructure for the global financial services industry. From 20 locations around the world, DTCC, through its subsidiaries, automates, centralizes, and standardizes the processing of financial transactions, mitigating risk, increasing transparency, enhancing performance and driving efficiency for thousands of broker/dealers, custodian banks and asset managers. Industry owned and governed, the firm innovates purposefully, simplifying the complexities of clearing, settlement, asset servicing, transaction processing, trade reporting and data services across asset classes, bringing enhanced resilience and soundness to existing financial markets while advancing the digital asset ecosystem. In 2024, DTCC’s subsidiaries processed securities transactions valued at U.S. $3.7 quadrillion and its depository subsidiary provided custody and asset servicing for securities issues from over 150 countries and territories valued at U.S. $99 trillion. DTCC’s Global Trade Repository service, through locally registered, licensed, or approved trade repositories, processes more than 25 billion messages annually. To learn more, please visit us at www.dtcc.com or connect with us on LinkedIn, X, YouTube, Facebook and Instagram.

DTCC proudly supports Flexible Work Arrangements favoring openness and gives people freedom to do their jobs well, by encouraging diverse opinions and emphasizing teamwork. When you join our team, you’ll have an opportunity to make meaningful contributions at a company that is recognized as a thought leader in both the financial services and technology industries. A DTCC career is more than a good way to earn a living. It’s the chance to make a difference at a company that’s truly one of a kind.

Learn more about Clearance and Settlement by clicking here.

Serves as a dedicated technology resource for advancing DTCC’s business opportunities and providing industry thought leadership for leveraging new technology. The goal of this new department is to partner internally with IT, our business and regulatory divisions and externally with clients, regulators, and fintech vendors, to help build new platforms and business models to advance DTCC’s mission to support the financial markets.