Stratus Technology Integration Services - Springfield, MO
posted 2 months ago
The position involves a comprehensive role in designing, planning, implementing, testing, and administering multiple databases, with a strong focus on security, access, and documentation. The successful candidate will manage and administer complex information technology systems to ensure that system design and operation align with business needs. This role requires providing guidance and experience on various projects or programs, serving as a team leader, and performing thorough analyses of issues and risks that may arise during operations. Daily administrative tasks are a significant part of this role, including backup and recovery processes, performance optimization, space management, database health monitoring, and troubleshooting to maintain multiple databases in support of client needs. The candidate will proactively monitor database performance and troubleshoot issues as they arise. Collaboration is key, as the role involves working cross-functionally with engineers, developers, and the user base to optimize queries, fix performance bottlenecks, improve existing schemas, and design new ones. Additionally, the position requires creating and maintaining change control and testing processes, conducting research, and making recommendations on products, services, protocols, and standards while planning for the future growth of data assets. The role also includes writing automation scripts to provision and manage PostgreSQL on Kubernetes, creating and maintaining SQL scripts for data extraction, migration, and maintenance, and reviewing development and deployment processes related to databases to identify areas for improvement. Documentation is crucial, as the candidate will be responsible for creating and maintaining troubleshooting playbooks, testing failover, and recovery plans.