Lead Database Engineer (Aurora PostgresSQL)

Depository Trust Clearing Corporation - Tampa, FL

Full-time - Mid Level

Tampa, FL

Credit Intermediation and Related Activities

About the position

The Lead Database Engineer at DTCC will be responsible for managing and optimizing AWS Aurora PostgreSQL databases, ensuring high availability, performance, and security. This role involves developing standards and procedures for database administration, providing on-call support, and collaborating with various teams to resolve database issues. The position requires a strong understanding of database architecture and cloud strategies, with a focus on continuous improvement and automation in database processes.

Responsibilities

• Develop standards and procedures for AWS Aurora PostgreSQL database in the Cloud.
• Manage all aspects of database administration including lifecycle management (upgrades, patching, etc.).
• Provide production DBA on-call support on a rotation basis.
• Monitor, troubleshoot, and optimize PostgreSQL databases for high availability, performance, and security.
• Operate in an agile software delivery environment focused on AWS Aurora PostgreSQL implementation.
• Collaborate with support teams to resolve AWS Aurora PostgreSQL database issues.
• Implement and test disaster recovery and business continuity architecture related to database implementation.
• Align risk and control processes into daily responsibilities to mitigate risk.
• Contribute to Cloud strategy discussions and decisions on Cloud Data solutions.
• Stay updated on industry trends and technologies to improve database automation processes.
• Enforce standard processes on Incident, Problem, and Change management.
• Research, design, document, and implement new solutions independently.

Requirements

• Minimum of 6-8 years of related experience.
• Bachelor's degree and/or equivalent experience.
• Hands-on experience with AWS Aurora PostgreSQL version 12 and above.
• Solid understanding of PostgreSQL database architecture.
• Experience with provisioning Aurora PostgreSQL regional and global clusters.
• User administration including audit and performance tuning using QPM.
• Experience with database upgrades and patching.
• Experience implementing monitoring solutions using AWS metrics and custom monitoring for Aurora PostgreSQL.
• Excellent troubleshooting and problem-solving skills in a fast-paced environment.
• Knowledge of Infrastructure as Code (IaC) tools like Terraform.
• Experience in developing scripts using Python is a plus.
• Proven experience with CI/CD pipelines (Jenkins, GitLab, etc.).
• Good knowledge of operating systems (Unix/Linux).
• Solid understanding of AWS Cloud architecture.

Nice-to-haves

• Knowledge of Oracle Database is a plus.
• Experience automating database provisioning in AWS Cloud environment is nice to have.

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 well-being.
• Flexible/hybrid model of 3 days onsite and 2 days remote.