Overview
On Site
USD 125,000.00 - 145,000.00 per year
Full Time
Skills
Streaming
Access Control
Scalability
Database Administration
FOCUS
PostgreSQL
Scripting
Bash
Python
Perl
Replication
Failover
Backup
Recovery
Git
Version Control
Ansible
Configuration Management
System On A Chip
Regulatory Compliance
Linux
Database
Management
Finance
Accounting
Marketing
Legal
Customer Support
Online Training
Artificial Intelligence
Insurance
.NET
Job Details
Description
We are looking for a skilled Database Administrator II to join our team in Richfield, Ohio. In this role, you will manage and optimize PostgreSQL databases while ensuring their reliability and performance. The ideal candidate will bring expertise in database administration, scripting, and troubleshooting within Linux environments.
Responsibilities:
Install, configure, and maintain PostgreSQL databases to ensure optimal performance and availability.
Set up and manage replication mechanisms, including streaming and logical replication, as well as failover strategies.
Design and implement robust backup solutions using tools like pg_dump, pg_basebackup, or pgBackRest, and execute point-in-time recovery when needed.
Enforce role-based access control to secure database environments.
Partition and manage large datasets to enhance database efficiency and scalability.
Utilize PostgreSQL extensions to extend database functionality.
Automate administrative tasks through scripting in Bash, Python, or Perl.
Analyze database logs to identify and resolve errors, slow queries, and deadlocks.
Diagnose and address performance issues such as memory bottlenecks and disk I/O challenges.
Work within Linux environments to manage systems and troubleshoot database-related issues.
Requirements
At least 5 years of experience in database administration, with a focus on PostgreSQL.
Proficiency in scripting languages such as Bash, Python, or Perl for task automation.
Strong knowledge of replication techniques and failover configurations.
Expertise in backup strategies, recovery processes, and database partitioning.
Familiarity with database extensions and their applications.
Experience with tools like Git for version control and Ansible for configuration management.
Understanding of SOC2 Type II compliance standards and basic security principles.
Solid experience working in Linux-based environments for database and system management.
Technology Doesn't Change the World, People Do.
Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.
Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more.
All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.
2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking "Apply Now," you're agreeing to Robert Half's Terms of Use.
We are looking for a skilled Database Administrator II to join our team in Richfield, Ohio. In this role, you will manage and optimize PostgreSQL databases while ensuring their reliability and performance. The ideal candidate will bring expertise in database administration, scripting, and troubleshooting within Linux environments.
Responsibilities:
Install, configure, and maintain PostgreSQL databases to ensure optimal performance and availability.
Set up and manage replication mechanisms, including streaming and logical replication, as well as failover strategies.
Design and implement robust backup solutions using tools like pg_dump, pg_basebackup, or pgBackRest, and execute point-in-time recovery when needed.
Enforce role-based access control to secure database environments.
Partition and manage large datasets to enhance database efficiency and scalability.
Utilize PostgreSQL extensions to extend database functionality.
Automate administrative tasks through scripting in Bash, Python, or Perl.
Analyze database logs to identify and resolve errors, slow queries, and deadlocks.
Diagnose and address performance issues such as memory bottlenecks and disk I/O challenges.
Work within Linux environments to manage systems and troubleshoot database-related issues.
Requirements
At least 5 years of experience in database administration, with a focus on PostgreSQL.
Proficiency in scripting languages such as Bash, Python, or Perl for task automation.
Strong knowledge of replication techniques and failover configurations.
Expertise in backup strategies, recovery processes, and database partitioning.
Familiarity with database extensions and their applications.
Experience with tools like Git for version control and Ansible for configuration management.
Understanding of SOC2 Type II compliance standards and basic security principles.
Solid experience working in Linux-based environments for database and system management.
Technology Doesn't Change the World, People Do.
Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.
Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more.
All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.
2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking "Apply Now," you're agreeing to Robert Half's Terms of Use.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.