Plex Systems - Troy, MI
posted 2 months ago
Rockwell Automation is seeking a Senior Database Administrator with extensive experience in MySQL and PostgreSQL to support our ongoing growth. The Plex Cloud Operations department is dedicated to fostering a culture of continuous improvement, and as a member of the data services team, you will play a crucial role in operationalizing state-of-the-art software and adopting open-source technologies. Your primary responsibility will be to run scalable, reliable, and secure applications while enhancing the delivery of our products. You will work collaboratively with your team to ensure that issues are resolved efficiently, minimizing customer impact. In this role, you will implement and maintain database server KPI monitoring and alerting systems, chart database utilization over time to identify optimal scaling opportunities, and identify database bottlenecks while taking corrective action. You will also suggest modifications and optimizations to developers for tuning SQL statements and stored procedures, leveraging your in-depth expertise in query execution plans. Regular weekly discussions regarding MySQL and PostgreSQL instances will be a part of your responsibilities, along with performing post-incident customer impact analysis and monthly application availability metrics. You will be responsible for installing and configuring MySQL and PostgreSQL to current versions, implementing database maintenance routines, and participating in on-call rotations. Troubleshooting a variety of database issues, managing access, maintaining backups, and ensuring integrity checks will also be key aspects of your role. You will participate in off-hours maintenance windows and engage in multiple projects involving data services, working within a global team environment or independently as needed.