One Identity · 1 day ago
Database Administrator (DBA)
Panama, NY
Full-time
Remote
Mid, Senior Level
5+ years exp
Maximize your interview chancesFraud DetectionIdentity Management
Insider Connection @One Identity
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.
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.
501-1,000 employees
Funding
Current Stage
Late StageTotal Funding
$3M2005-07-12Acquired· by Quest Software ($56.5M)
2004-07-27Series Unknown· $3M
Leadership Team
Mark Logan
President and CEO
Robert Sandri
Customer CTO - Federal
Company data provided by crunchbase
