Senior Oracle & PostgreSQL Database Engineer

Socket.dev; Boston (MA); Hybrid; USD 140,000 - 190,000; Full time

Benefits offered by this job

Flexible work model

Health insurance

Pension / Retirement benefits

Paid Time Off & family care

Job summary

DTCC is seeking a Senior Software Engineer, Database Engineering to design, develop, and optimize enterprise database solutions across Oracle and PostgreSQL. You will work with Java-based applications, modernize with cloud-first initiatives on AWS, and mentor peers in best practices.

The role emphasizes scalable OLTP systems, data modeling, performance tuning, and collaboration with cross-functional teams in an Agile environment.

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.
• Develop data models, SQL, PL/SQL, and stored procedures.
• Collaborate with teams using Java, JDBC, JMS.
• Support cloud-first modernization with AWS.
• Perform database performance tuning and troubleshooting.
• Mentor junior engineers and promote engineering best practices.
• Participate in Agile/Scrum ceremonies using Jira.

Skills

Oracle DB development

PostgreSQL in production

SQL & PL/SQL

Data modeling

Java development

AWS cloud

Git / GitHub

Jira / Agile

Linux shell scripting

Education

Bachelor's degree or equivalent experience

Tools

Liquibase

Git

Jira

CI/CD pipelines

Snowflake

OpenShift

Oracle GoldenGate

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.

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.