Be an early applicantLess than 25 applicants

Company

One Identity · 1 day ago

Database Administrator (DBA)

Panama, NY

Full-time

Remote

Mid, Senior Level

5+ years exp

Maximize your interview chances

Fraud DetectionIdentity Management

Insider Connection @One Identity

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Manage, maintain, and optimize PostgreSQL databases in production, test, and development environments

Ensure high availability, reliability, and scalability of databases

Implement and maintain automated database monitoring, backups, and performance tuning processes

Troubleshoot and resolve database issues related to performance, capacity, and availability

Perform proactive performance analysis and tuning of queries, indexes, and schema design to ensure optimal database performance

Design and implement database partitioning, indexing, and optimization strategies for large-scale datasets

Continuously monitor database performance and make recommendations for improvements to system and query efficiency

Implement and enforce database security policies and best practices, including encryption, access control, and user management

Work with security and compliance teams to ensure databases meet regulatory standards (e.g., GDPR, SOC 2, etc.)

Maintain database disaster recovery plans and backup strategies, perform regular database backups, and ensure quick recovery in the event of failure

Provide on-call support and troubleshooting for production database issues

Assist in the migration of databases to new environments, patching to maintain database integrity and security, and upgrading PostgreSQL versions as necessary

Work closely with development, Quality Assurance, DevOps and other teams to support application deployments, infrastructure changes, and strategic initiatives

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

PostgreSQLDatabase AdministrationPerformance TuningDatabase SecurityDisaster RecoveryLinux/UnixShell ScriptingCloud DatabasesDatabase MigrationAWS AuroraMySQLNoSQL DatabasesTerraformGitCI/CD Pipelines

Required

5+ years of hands-on experience as a PostgreSQL Database Administrator or in a similar database management role

Expertise in PostgreSQL database architecture, performance tuning, and query optimization.

Experience with high-availability setups, replication, failover, and disaster recovery strategies in PostgreSQL.

Strong understanding of database security, backup/recovery strategies, and data integrity principles.

Familiarity with cloud-based databases (AWS Aurora, RDS)

Experience with database migration and version upgrade strategies.

Proficiency with Linux/Unix-based systems and shell scripting.

Excellent problem-solving skills and the ability to troubleshoot complex issues effectively under pressure

Good team collaboration skills with a pragmatic and positive attitude

Excellent written and verbal communication skills in English

Bachelor’s degree in a technology related field or equivalent work experience

Preferred

Familiarity with other database systems like MySQL, MariaDB, and/or NoSQL databases such as DynamoDB and Redis

Experience with monitoring tools (e.g., Datadog, CloudHealth, Sumologic) and PostgreSQL extensions (e.g., pg_stat_statements, pg_partman) is a plus.

Experience with infrastructure as code (IaC) tools such as Terraform, CloudFormation, Puppet and managing code via a Git version control system

AWS certifications such as AWS Certified Database – Specialty, or AWS Certified Solutions Architect, AWS Certified Cloud Practitioner

Exposure to continuous integration/continuous deployment (CI/CD) pipelines, and database script execution tools like Liquibase

Benefits

Health and wellness programs

Company

One Identity

One Identity, a subsidiary of Quest Software, is a leader in unified identity security and helps organizations strengthen their overall cybersecurity posture with solutions that protect the people, applications, and data essential to their business.

Founded in 2003

Utah, Tennessee, USA

501-1,000 employees