Job Description:Position Summary:This job is responsible for managing the day-to-day activities and functions for the assigned team. Key responsibilities include delegating work to team members, supervising work processes, providing informal leadership of sub teams or technology silos, managing on call and support schedules, and providing leadership, mentorship, and direction to team members. Job expectations include solving complex technical and analytical issues and effectively communicating results to senior management and Line of Business partners. Experienced PostgreSQL / CockroachDB Database Administrator with strong expertise in designing and managing highly scalable, distributed database systems. Proven ability to implement geo-distributed and hybrid clusters, replication, and performance tuning strategies, along with advanced troubleshooting and automation using Python and shell scripting. Adept at optimizing database performance, ensuring high availability, and supporting mission-critical applications in enterprise environments.
Responsibilities:- Manages and prioritizes multiple tasks and assignments for the team including tracking tasks and tickets in system(s) of record, ensuring enterprise service level agreements are met, and participating in defect, incident, problem, and change review meetings and release activities
- Provides point of escalation for team members, peers, and partner teams, and shares the leadership Point of Contact for triage of high priority incidents or consulting engagements
- Performs all responsibilities of team members from applicable teams
- Works with appropriate teams to ensure alerts, monitoring, dashboards, and processes are established appropriately for new projects and initiatives
- Participates and helps with resource interviews and onboarding processes
- Performs access reviews, conducts compliance activities, and serves as a delegate for administrative processes
- Creates the on call rotation schedule and ensures support for off hours, weekends, and release windows
- Administer and maintain PostgreSQL / CockroachDB production environments, ensuring high availability, scalability, and reliability.
- Design and implement PostgreSQL / CockroachDB clusters and replication, enabling horizontal scalability and fault tolerance.
- Define efficient data models and schema designs aligned with application requirements and performance goals.
- Optimize database performance through query tuning, indexing strategies, and execution plan analysis.
- Monitor system performance and conduct capacity planning to support growing workloads.
- Troubleshoot and resolve database performance issues, replication errors, and production incidents, ensuring minimal downtime. Manage backup, recovery, and disaster recovery processes to ensure data integrity and business continuity.
- Implement and manage PostgreSQL / CockroachDB security controls, including authentication, authorization, and encryption.
- Develop and maintain automation scripts using Python and Shell scripting to streamline database maintenance, backups, and monitoring.
- Perform database upgrades, migrations, and cluster expansions with minimal impact on production systems.
Required 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
Desired Qualifications- Financial industry experience desired .
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
Shift:1st shift (United States of America)
Hours Per Week: 40
Pay Transparency detailsUS - NJ - Jersey City - 101 Hudson St - 101 Hudson (NJ2101)
Pay and benefits information
Pay range
$92,100.00 - $160,100.00 annualized salary, offers to be determined based on experience, education and skill set.
Discretionary incentive eligible
This role is eligible to participate in the annual discretionary plan. Employees are eligible for an annual discretionary award based on their overall individual performance results and behaviors, the performance and contributions of their line of business and/or group; and the overall success of the Company.
Benefits
This role is currently benefits eligible. We provide industry-leading benefits, access to paid time off, resources and support to our employees so they can make a genuine impact and contribute to the sustainable growth of our business and the communities we serve.
