Senior Database Lead - PostgreSQL & CockroachDB

Bank of America; Charlotte (NC); On-site; USD 92,000 - 160,000; Full time

Job summary

Bank of America is seeking an experienced PostgreSQL / CockroachDB Database Administrator to manage day-to-day team activities and lead complex database initiatives. You will design and maintain geo-distributed, hybrid clusters, implement replication, and optimize performance for mission-critical applications.

The role requires strong scripting in Python and shell, along with security and high-availability expertise.

Qualifications

• 8 years of job related experience required.
• Databases: PostgreSQL / CockroachDB.
• Key Concepts: Replication, Observability & AIOps, Clustering, Data Modeling.
• Performance: Query Optimization, Indexing, Capacity Planning, Tuning.
• Automation: Python, Shell Scripting.
• Platform: Linux/Unix.
• Cloud: PostgreSQL / CockroachDB Atlas on AWS, Azure, & GCP.
• Other: Backup & Recovery, Security, High Availability Architecture.

Responsibilities

• Manages and prioritizes multiple tasks and assignments for the team, tracking tasks and tickets and ensuring SLAs are met.
• Provides escalation point for team members and partners, leading triage of high priority incidents.
• Performs all responsibilities of team members from applicable teams.
• Ensures alerts, monitoring, dashboards, and processes are established for new projects.
• Participates in resource interviews and onboarding processes.
• Performs access reviews and compliance activities, and delegates admin processes.
• Creates on-call rotation and ensures off-hours support and release windows.
• Administers PostgreSQL / CockroachDB production environments for high availability.
• Designs PostgreSQL / CockroachDB clusters and replication for scalability and fault tolerance.
• Defines data models and schemas aligned with performance goals.
• Optimizes queries, indexing, and execution plans.
• Monitors performance and performs capacity planning.
• Troubleshoots replication errors and incidents; manages backups and DR.
• Implements security controls including authentication and encryption.
• Develops automation scripts with Python and Shell for maintenance.
• Performs upgrades, migrations, and expansions with minimal impact.

Skills

Collaboration

Influence

Production Support

Risk Management

Solution Design

Analytical Thinking

Architecture

Innovative Thinking

Result Orientation

Stakeholder Management

Adaptability

Automation

DevOps Practices

Project Management

Solution Delivery Process

Tools

PostgreSQL

CockroachDB

Linux

Cloud (AWS/Azure/GCP)

Job description

Bank of America is seeking an experienced PostgreSQL / CockroachDB Database Administrator to manage day-to-day team activities and lead complex database initiatives. You will design and maintain geo-distributed, hybrid clusters, implement replication, and optimize performance for mission-critical applications.

The role requires strong scripting in Python and shell, along with security and high-availability expertise.