Technology Services Lead

Jobtailor; New Jersey; On-site; USD 120,000 - 160,000; Full time

Job summary

Jobtailor in New Jersey seeks a senior Database Administrator to lead PostgreSQL and CockroachDB operations, manage on-call support, and drive high availability across cloud platforms.

You will design schemas, optimize queries, implement security controls, and build automation with Python and shell scripts, mentoring a team of engineers.

Qualifications

• 8+ years of job-related experience
• PostgreSQL and CockroachDB administration
• Replication, observability and AIOps, clustering, and data modeling
• Query optimization, indexing, capacity planning, and database tuning
• Python and shell scripting
• Linux/Unix
• PostgreSQL Atlas on AWS, Azure, and GCP
• Backup and recovery
• Database security
• High availability architecture
• Financial industry experience desired

Responsibilities

• Manage day-to-day activities and functions for the assigned team
• Delegate work, supervise processes, and provide leadership, mentorship, and direction
• Manage on-call and support schedules
• Solve complex technical and analytical issues and communicate results to senior management and Line of Business partners
• Manage and prioritize team tasks, assignments, tickets, and service level agreements
• Participate in defect, incident, problem, and change review meetings and release activities
• Provide escalation support and leadership point of contact for high-priority incidents and consulting engagements
• Establish alerts, monitoring, dashboards, and processes for new projects and initiatives
• Support resource interviews and onboarding
• Perform access reviews and compliance activities
• Create on-call rotation schedules and ensure off-hours, weekend, and release-window support
• Administer and maintain PostgreSQL / CockroachDB production environments
• Design and implement database clusters and replication
• Define data models and schema designs
• Optimize performance through query tuning, indexing, and execution plan analysis
• Monitor performance and conduct capacity planning
• Troubleshoot database issues, replication errors, and production incidents
• Manage backup, recovery, and disaster recovery processes
• Implement database authentication, authorization, and encryption controls
• Develop Python and shell automation scripts
• Perform database upgrades, migrations, and cluster expansions

Skills

Leadership

Mentorship

Problem Solving

Communication

Tools

PostgreSQL Atlas

CockroachDB Atlas

AWS

Azure

GCP

Job description

• Manage day-to-day activities and functions for the assigned team
• Delegate work, supervise processes, and provide leadership, mentorship, and direction
• Manage on-call and support schedules
• Solve complex technical and analytical issues and communicate results to senior management and Line of Business partners
• Manage and prioritize team tasks, assignments, tickets, and service level agreements
• Participate in defect, incident, problem, and change review meetings and release activities
• Provide escalation support and leadership point of contact for high-priority incidents and consulting engagements
• Establish alerts, monitoring, dashboards, and processes for new projects and initiatives
• Support resource interviews and onboarding
• Perform access reviews and compliance activities
• Create on-call rotation schedules and ensure off-hours, weekend, and release-window support
• Administer and maintain PostgreSQL / CockroachDB production environments
• Design and implement database clusters and replication
• Define data models and schema designs
• Optimize performance through query tuning, indexing, and execution plan analysis
• Monitor performance and conduct capacity planning
• Troubleshoot database issues, replication errors, and production incidents
• Manage backup, recovery, and disaster recovery processes
• Implement database authentication, authorization, and encryption controls
• Develop Python and shell automation scripts
• Perform database upgrades, migrations, and cluster expansions

Requirements

• 8 years of job-related experience required
• PostgreSQL / CockroachDB database administration
• Replication, observability and AIOps, clustering, and data modeling
• Query optimization, indexing, capacity planning, and database tuning
• Python and shell scripting
• Linux/Unix
• PostgreSQL / CockroachDB Atlas on AWS, Azure, and GCP
• Backup and recovery
• Database security
• High availability architecture
• Financial industry experience desired

Core Competencies

Demonstrates extensive experience in PostgreSQL and CockroachDB database administration, including replication, query optimization, and performance tuning. Proven ability to lead teams, manage complex technical issues, and implement database security and disaster recovery processes.

Highest-signal resume keywords

• PostgreSQL Database Administration
• CockroachDB Administration
• Python Scripting
• Database Security
• High Availability Architecture

ATS Optimization Keywords

Hard Skills

• Database Clustering
• Data Modeling
• Query Optimization
• Capacity Planning
• Backup and Recovery
• Disaster Recovery Processes
• Database Tuning
• Replication
• Shell Scripting
• Linux/Unix

Soft Skills

• Leadership
• Mentorship
• Problem Solving
• Communication

Industry Keywords

• Financial Industry Experience
• AIOps
• Observability
• Service Level Agreements
• Incident Management

Tools & Technologies

• PostgreSQL Atlas
• CockroachDB Atlas
• AWS
• Azure
• GCP