Senior Oracle & PostgreSQL Database Engineer

The Depository Trust & Clearing Corporation (DTCC); Boston (MA); Hybrid; USD 130,000 - 180,000; Full time

Benefits offered by this job

Competitive compensation

Health & life insurance

Retirement benefits

Paid time off & family care

Hybrid onsite 3 days / remote 2 days

Job summary

DTCC in Boston seeks a Senior Software Engineer, Database Engineering to support Institutional Trade Processing apps such as CTM and SIM, designing scalable Oracle and PostgreSQL solutions for high-volume environments.

You will drive cloud-first modernization with AWS, implement robust data models, and collaborate across Agile teams to ensure performance, reliability, and data security. You’ll mentor peers and contribute to engineering excellence within a hybrid work model.

Qualifications

• 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.

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 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.

Skills

Oracle

PostgreSQL

SQL & PL/SQL

Java

AWS

Linux/Unix

Git & GitHub

Jira

Agile/Scrum

Data modeling

Education

Bachelor’s degree or equivalent experience

Tools

Liquibase

GitHub

Jenkins

Snowflake

OpenShift

ETL/ELT

Job description

Are you ready to make an impact at DTCC? 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.

Pay And Benefits

• 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).

The Impact You Will Have in This Role

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.

Qualifications

• 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.

Preferred Qualifications

• 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.

The salary range is indicative for roles at the same level within DTCC across all US locations. Actual salary is determined based on the role, location, individual experience, skills, and other considerations. We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.