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 a skilled Technical Business Analyst to join our team on a contract basis in Cleveland, Ohio. In this role, you will collaborate directly with dispatchers, police officers, and supervisors to address critical operational challenges across multiple police districts. This position requires a hands-on approach and the ability to translate real-world public safety workflows into actionable technical solutions.<br><br>Responsibilities:<br>• Collaborate with end users, including dispatchers, officers, and supervisors, to identify and understand operational challenges.<br>• Document and translate user pain points into detailed technical and functional requirements.<br>• Analyze user interactions with Motorola systems and field reporting platforms to uncover inefficiencies.<br>• Investigate and determine the root causes of system and workflow breakdowns.<br>• Partner with leadership to communicate progress, set realistic expectations, and support system adoption and stabilization.<br>• Manage tickets, logs, and documentation for issue tracking and remediation.<br>• Provide real-time feedback to the task force regarding system performance and its impact on users.<br>• Support stabilization efforts by delivering tactical solutions to critical system issues.
