Job Description
Company: The Depository Trust & Clearing Corporation (DTCC)
Location: Boston, MA
Workplace Type: Hybrid
Employment Type: Full-time
About the Role
At DTCC, we are at the forefront of innovation in the financial markets. The Information Technology group delivers secure, reliable technology solutions that enable DTCC to be the trusted infrastructure of the global capital markets. 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.
What You’ll Do / Key Responsibilities
- Database Solution Design: Design, develop, and optimize enterprise database solutions using Oracle and PostgreSQL, building and supporting high-volume OLTP systems that process large transactional workloads.
- Data Modeling & Development: Develop data models, complex SQL queries, PL/SQL, stored procedures, views, and database objects.
- Cross-Functional Integration: Partner with application development teams to build integrated solutions using Java, JDBC, JMS, and related technologies.
- Cloud & Modernization: Support cloud-first modernization initiatives using AWS and cloud-native engineering practices.
- Change Management & Version Control: Implement database change management, schema deployments, and version control using tools such as Liquibase, Git, and GitHub.
- Performance Tuning & Troubleshooting: Perform database performance tuning, query optimization, troubleshooting, and root cause analysis.
- Data Integration: Support data integration through APIs, SFTP, batch processing, ETL/ELT, and replication technologies while ensuring data quality, security, and resiliency.
- Agile Collaboration & Mentorship: Participate in Agile/Scrum ceremonies using Jira, collaborate with cross-functional teams, and mentor junior team members to promote engineering best practices.
Requirements & Qualifications
- Bachelor’s degree or equivalent experience.
- 8+ years of experience in software engineering, database development, or related technical roles, supporting enterprise-scale applications in high-volume, transactional environments.
- 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.
- 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, along with familiarity with Git, GitHub, Jira, and Agile/Scrum delivery methodologies.
- Demonstrated ability to solve complex technical challenges in large-scale, mission-critical environments with strong analytical and communication skills.
Preferred / Bonus Qualifications (if applicable)
- 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.
Benefits & Perks (if applicable)
- 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.
- Flexible/hybrid work model of 3 days onsite and 2 days remote.
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.