Are you ready to explore a world of possibilities?
Scroll down to find the complete details of the job offer, including experience required and associated duties and tasks.
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
- Retirement benefits
- Paid Time Off and other leave of absence
- DTCC offers a flexible / hybrid model of 3 days onsite and 2 days remote (Onsite Tuesdays, Wednesdays and a third day of your choosing)
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 Principal Database Engineer is part of the Aurora PostgreSQL Database team and responsibilities include :
Develop standards and procedures for AWS Aurora PGS database in the CloudWork 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 basisMonitor, troubleshoot, and optimize PGS database to ensure high availability, performance, and securityOperate in an agile software delivery methodology environment that is highly passionate about developing, deploying, and improvising AWS Aurora Postgres database implementationCollaborate with support teams to fix and resolve AWS Aurora PGS database issuesImplement and test disaster recovery and business continuity architecture as it relates to the database implementationAlign risk and control processes into day-to-day responsibilities to supervise and mitigate riskContribute to Cloud strategy discussions and decisions on overall Cloud design and best approach for implementing Cloud Data solutionsKnow the latest industry trends and technologies to continuously improve the Database automation process (Jenkins / Gitlab, Python, Terraform etc)Enforce standard processes on Incident, Problem and Change managementResearch, design, document and implement new solutions independentlyNOTE : The Responsibilities of this role are not limited to the details above.
Qualifications :
Minimum of 8-10 years of related experienceBachelor's degree and / or equivalent experienceTalents Needed for Success :
Must have hands on experience with the following :AWS Aurora Postgres version 12 and above
Solid grasp of Postgres DB architectureProvisioning of Aurora Postgres regional and Global clustersCrafting additional reader instancesUser administration including audit, performance tuning using QPMDB upgrades and PatchingExperience implementing monitoring solution using AWS metrics and custom monitoring for Aurora PostgresExcellent troubleshooting and problem-solving skills in a fast-paced environmentKnowledge with Infrastructure as Code (IaC) tools like TerraformGood to have experience in developing scripts using PythonProven experience with CICD Pipelines (Jenkins, Gitlab etc)Good knowledge of operating systems (Unix / Linux)Solid Understanding of AWS Cloud architectureKnowledge of Oracle Database is a plusExperience automating Database provisioning in AWS Cloud environment is nice to haveAble to handle tasks and projects independently with minimum guidance and directionsDemonstrated ability to work in a sophisticated environment to seek out business and customer needs and provide the best solution neededJ-18808-Ljbffr
