We are looking for an experienced Database Administrator to join our team in Richfield, Ohio. This position requires an experienced, detail-oriented individual with a strong background in managing PostgreSQL databases and related technologies. As this is a Contract to permanent role, it offers an excellent opportunity for long-term career growth and development.<br><br>Responsibilities:<br>• Install, configure, and maintain PostgreSQL databases to ensure optimal performance and reliability.<br>• Implement and manage streaming replication, logical replication, and failover mechanisms for high availability.<br>• Design and execute comprehensive backup strategies using tools like pg_dump, pg_basebackup, and pgBackRest, including point-in-time recovery.<br>• Configure role-based access control to enhance database security and user management.<br>• Partition and oversee large datasets to improve scalability and efficiency.<br>• Utilize extensions to expand database functionality.<br>• Develop automation scripts using Bash, Python, or Perl to streamline database maintenance and monitoring.<br>• Analyze PostgreSQL logs to detect errors, resolve slow queries, and address deadlocks effectively.<br>• Diagnose and troubleshoot issues related to memory bottlenecks and disk I/O to optimize system performance.<br>• Manage Linux environments for system administration and troubleshooting tasks.
