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.
We are looking for an experienced IT Site & ERP Administrator to oversee and enhance the management of ERP systems and IT operations at our Solon, Ohio location. In this role, you will ensure system integrity, lead IT-related projects, and provide specialized user support. The ideal candidate will possess strong technical expertise and a proactive approach to problem-solving in a dynamic, regulated environment.<br><br>Responsibilities:<br>• Administer and manage the local ERP system (ERP BusinessOne), ensuring smooth operation and reliability.<br>• Diagnose, address, and resolve technical issues, including system errors and bugs, while documenting resolutions for future reference.<br>• Translate business needs into system configurations through effective communication and a structured change management process.<br>• Provide training and share expertise with users to support their roles and enhance system utilization.<br>• Develop, maintain, and improve data reports to meet business requirements.<br>• Implement new system configurations and update existing ones to optimize performance.<br>• Manage user access rights by defining and maintaining permissions.<br>• Lead and execute local IT projects aligned with the organization’s global IT strategy.<br>• Oversee IT adherence to best practices and compliance with procedures in a regulated manufacturing environment.<br>• Collaborate with external providers for issue escalation and resolution when necessary.
