Senior Database Administrator - MySQL, PostgreSQL (Plex)

Rockwell Automation - Houston, TX

Full-time - Mid Level

Houston, TX

10,001+ employees

Electrical Equipment, Appliance, and Component Manufacturing

About the position

The Senior Database Administrator will be responsible for managing and optimizing MySQL and PostgreSQL databases within the Plex Cloud Operations department. This role focuses on ensuring the reliability, scalability, and security of database applications while contributing to a culture of continuous improvement. The administrator will work closely with the data services team to resolve issues efficiently and minimize customer impact, while also participating in various projects and on-call rotations.

Responsibilities

• Implement and maintain database server KPI monitoring/alerting
• Chart database utilization over time to identify optimal scaling opportunities
• Identify database bottlenecks and take corrective action
• Suggest modifications/optimizations for tuning SQL statements and stored procedures
• Provide in-depth query execution plan expertise
• Lead regular weekly discussions regarding MySQL and PostgreSQL instances with the data services team
• Perform post-incident customer impact analysis and monthly application availability metrics
• Install and configure MySQL 5.7 and PostgreSQL 12.0 to current versions
• Implement database maintenance routines
• Participate in on-call rotations
• Troubleshoot a variety of database issues
• Manage access and maintain backups and integrity checks
• Participate in off-hours maintenance windows
• Engage in multiple projects involving data services
• Work within a global team environment or independently as needed

Requirements

• Bachelor's Degree in Computer Science or related area or equivalent years of relevant work experience
• Legal authorization to work in the US is required

Nice-to-haves

• 5+ years' experience managing a production system that is highly available and reliable, preferably 24/7
• Experience managing MySQL, PostgreSQL, Microsoft SQL server in private datacenters and in AWS and/or Azure
• Proven history building automated solutions that enable resiliency and self-healing of applications
• Operational experience working with data technologies and managing large volumes of data
• Experience troubleshooting performance and tuning queries and stored procedures
• Strong SQL skills for writing and reviewing scripts
• Experience setting up backup schedules and securing data
• Experience building automation scripts for database server builds using Terraform or Ansible
• Experience with Operations technologies: Server Operating Systems (Windows Server, Linux); Virtualization Environments
• Additional experience with MongoDB, PowerShell, Terraform, Ansible, Open-source technologies and cloud services (Azure, AWS, GCP, Kubernetes, Docker, Chef, Puppet), SQL Sentry or any other SQL monitoring tool, External monitoring services like PRTG and Dynatrace, HashiCorp Consul, OpsGenie, Prometheus and Alert Manager

Benefits

• Health Insurance including Medical, Dental and Vision
• 401k
• Paid Time off
• Parental and Caregiver Leave
• Flexible Work Schedule