DTCC
Lead Database Engineer (Aurora PostgresSQL)
DTCC, Dallas, TX
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.
Pay and Benefits:
The Impact you will have in this role:
The Database Engineering team is responsible for handling the Distributed Databases, Automation, and Business intelligence technologies.
Your Primary Responsibilities:
The Lead Database Engineer is part of the Aurora PostgreSQL Database team and responsibilities include:
**NOTE: The Responsibilities of this role are not limited to the details above. **
Qualifications:
Talents Needed for Success:
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.
About Us
DTCC safeguards the financial markets and helps them run efficiently, in times of prosperity and crisis. We are uniquely positioned at the center of global trading activity, processing over 100 million financial transactions every day, pioneering industry-wide, post-trade solutions and maintaining multiple data and operating centers worldwide. From where we stand, we can anticipate the industry's needs and we're working to continually improve the world's most resilient, secure and efficient market infrastructure. Our employees are driven to deliver innovative technologies that improve efficiency, lower cost and bring stability and certainty to the post-trade lifecycle.
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.
About the Team
Enterprise Product & Platform Engineering transforms the way we deliver infrastructure to our business clients. A key construct of EP&PE will be the evolution of the IT Product Manager, who will partner with the Engineering organization, the Business Aligned Service Delivery organization, the DevSecOps organization as well as our operational support teams to ensure that this organization provides high quality, commercially attractive and timely solutions to support our business strategy.
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.
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:
The Database Engineering team is responsible for handling the Distributed Databases, Automation, and Business intelligence technologies.
Your Primary Responsibilities:
The Lead Database Engineer is part of the Aurora PostgreSQL Database team and responsibilities include:
- As a member of the DBA team, should be able to develop standards and procedures for AWS Aurora PGS database in the Cloud
- Work on all aspects of database administration (DBA) including life cycle management (Upgrades, Patching etc)
- Be available for production DBA on-call support on a rotation basis
- Monitor, troubleshoot, and optimize PGS database to ensure high availability, performance, and security
- Operate in an agile software delivery methodology environment that is highly passionate about developing, deployingimprovingancing AWS Aurora Postgres database implementation
- Collaborate with support teams to fix and resolve AWS Aurora PGS database issues
- Implement and test disaster recovery and business continuity architecture as it relates to the database implementation
- Aligns risk and control processes into day-to-day responsibilities to supervise and mitigate risk; calls out appropriately
- Contribute to Cloud strategy discussions and decisions on overall Cloud design and best approach for implementing Cloud Data solutions
- Know the latest industry trends and technologies to continuously improve the Database automation process (Jenkins/Gitlab, Python, Terraform etc)
- Enforce to standard processes on Incident, Problem and Change management
- Research, design, document and implement new solutions independently
**NOTE: The Responsibilities of this role are not limited to the details above. **
Qualifications:
- Minimum of 6-8 years of related experience
- Bachelor's degree and/or equivalent experience
Talents Needed for Success:
- Must have hands on experience with the following:
- AWS Aurora Postgres version 12 and above
- Solid understanding of Postgres DB architecture
- Provisioning of Aurora Postgres regional and Global clusters
- Crafting additional reader instances
- User administration including audit, performance tuning using QPM
- DB upgrades and Patching
- Experience implementing monitoring solution using AWS metrics and custom monitoring for Aurora Postgres
- Excellent troubleshooting and problem-solving skills in a fast-paced environment
- Knowledge with Infrastructure as Code (IaC) tools like Terraform
- Good to have experience in developing scripts using Python
- Proven experience with CICD Pipelines (Jenkins, Gitlab etc)
- Good knowledge of operating systems (Unix / Linux)
- Solid Understanding of AWS Cloud architecture
- Knowledge of Oracle Database is a plus
- Experience automating Database provisioning in AWS Cloud environment is nice to have
- Able to handle tasks and projects independently with minimum guidance and directions
- Demonstrated ability to work in a sophisticated environment to seek out business and customer needs and provide the best solution needed
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.
About Us
DTCC safeguards the financial markets and helps them run efficiently, in times of prosperity and crisis. We are uniquely positioned at the center of global trading activity, processing over 100 million financial transactions every day, pioneering industry-wide, post-trade solutions and maintaining multiple data and operating centers worldwide. From where we stand, we can anticipate the industry's needs and we're working to continually improve the world's most resilient, secure and efficient market infrastructure. Our employees are driven to deliver innovative technologies that improve efficiency, lower cost and bring stability and certainty to the post-trade lifecycle.
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.
About the Team
Enterprise Product & Platform Engineering transforms the way we deliver infrastructure to our business clients. A key construct of EP&PE will be the evolution of the IT Product Manager, who will partner with the Engineering organization, the Business Aligned Service Delivery organization, the DevSecOps organization as well as our operational support teams to ensure that this organization provides high quality, commercially attractive and timely solutions to support our business strategy.