Rockwell Automation
Senior Database Administrator - MySQL, PostgreSQL (Plex)
Rockwell Automation, Troy, Michigan, United States, 48083
Troy, Michigan, United StatesHouston, Texas, United StatesMayfield Heights, Ohio, United StatesMilwaukee, Wisconsin, United States
Rockwell Automation is a global technology leader focused on helping the world's manufacturers be more productive, sustainable, and agile. With more than 28,000 employees who make the world better every day, we know we have something special. Behind our customers - amazing companies that help feed the world, provide life-saving medicine on a global scale, and focus on clean water and green mobility -our people are energized problem solvers that take pride in how thework we do changes the world for the better.We welcome all makers, forward thinkers, and problem solvers who are looking for a place to do their best work. And if that's you we would love to have you join us!Job DescriptionTo support our ongoing growth, we are looking for a Database Administrator with extensive experience in MySQL and PostgreSQL. The Plex Cloud Operations department takes great pride in being a part of a continuous improvement culture, and as a data services team member, you will meaningfully contribute to operationalization of state-of-the-art , leading-edge software and adoption of open-source technologies. You will run scalable, reliable, and secure applications while helping improve the delivery of our products. You will join a team to ensure that issues are resolved as efficiently as possible, with minimal customer impact.You will report to the Manager, Data Services - Plex.Your Responsibilities:Implement and maintain database server KPI monitoring/alertingChart database utilization over time to identify optimal scaling opportunitiesDatabase bottleneck identification and corrective actionSuggest modifications/optimizations (to Developers) for tuning SQL statements and stored proceduresIn-depth query execution plan expertiseLead regular weekly discussions regarding MySQL and PostgreSQL instances with members of data services teamPerform post-incident customer impact analysis as well as monthly application availability metricsInstall and configure MySQL 5.7 to currentInstall and configure PostgreSQL 12.0 to currentImplement database maintenance routinesParticipate in On-Call rotationsTroubleshoot a variety of database issuesAccess managementMaintain backups and integrity checksParticipate in off hours Maintenance windowsParticipate in multiple projects involving data servicesWork within a global team environment or independently to carry out tasks as neededThe Essentials - You Will Have:Bachelor's Degree in Computer Science or related area or equivalent years of relevant work experienceLegal authorization to work in the US is required- we will not sponsor individuals for employment visas, not now or in the future, for this job openingThe Preferred - You Might Also Have:Typically requires 5+ years' experience managing a production system that is highly available and reliable, preferably 24/7Experience managing MySQL, PostgreSQL, Microsoft SQL server in private datacenters as well as in AWS and/or AzureProven history building automated solutions that enable resiliency and self-healing of applicationsOperational experience working with data technologies and managing large volumes of dataExperience troubleshooting performance and tuning queries and stored proceduresStrong SQL skills for writing and reviewing scriptsExperience setting up backup schedules and securing dataExperience building automation scripts for database server builds using terraform or ansibleExperience with Operations technologies: Server Operating Systems (Windows Server, Linux); Virtualization EnvironmentsAdditional experience with any of the following:MongoDBPowerShellTerraformAnsibleOpen-source technologies and cloud services: Azure, AWS, and/or GCP, Kubernetes, Docker, and/or Terraform; Chef, Puppet and/or AnsibleSQL Sentry or any other SQL monitoring tollExternal monitoring services like PRTG and DynatraceHashiCorp Consul;OpsGeniePrometheus and Alert ManagerWhat We Offer:Health Insurance including Medical, Dental and Vision401kPaid Time offParental and Caregiver LeaveFlexible Work Schedule where you will work with your manager to enjoy a work schedule that can be flexible with your personal life.To learn more about our benefits package, please visit at www.raquickfind.com.This position is part of a job family. Experience will be the determining factor for position level and compensation.We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, or veteran status. We are proud to be an equal opportunity workplace.#LI-MG4#LI-HybridWe are an Equal Opportunity Employer including disability and veterans.If you are an individual with a disability and you need assistance or a reasonable accommodation during the application process, please contact our services team at +1 (844) 404-7247.Rockwell Automation's hybrid policy aligns that employees are expected to work at a Rockwell location at least Mondays, Tuesdays, and Thursdays unless they have a business obligation out of the office.
Rockwell Automation is a global technology leader focused on helping the world's manufacturers be more productive, sustainable, and agile. With more than 28,000 employees who make the world better every day, we know we have something special. Behind our customers - amazing companies that help feed the world, provide life-saving medicine on a global scale, and focus on clean water and green mobility -our people are energized problem solvers that take pride in how thework we do changes the world for the better.We welcome all makers, forward thinkers, and problem solvers who are looking for a place to do their best work. And if that's you we would love to have you join us!Job DescriptionTo support our ongoing growth, we are looking for a Database Administrator with extensive experience in MySQL and PostgreSQL. The Plex Cloud Operations department takes great pride in being a part of a continuous improvement culture, and as a data services team member, you will meaningfully contribute to operationalization of state-of-the-art , leading-edge software and adoption of open-source technologies. You will run scalable, reliable, and secure applications while helping improve the delivery of our products. You will join a team to ensure that issues are resolved as efficiently as possible, with minimal customer impact.You will report to the Manager, Data Services - Plex.Your Responsibilities:Implement and maintain database server KPI monitoring/alertingChart database utilization over time to identify optimal scaling opportunitiesDatabase bottleneck identification and corrective actionSuggest modifications/optimizations (to Developers) for tuning SQL statements and stored proceduresIn-depth query execution plan expertiseLead regular weekly discussions regarding MySQL and PostgreSQL instances with members of data services teamPerform post-incident customer impact analysis as well as monthly application availability metricsInstall and configure MySQL 5.7 to currentInstall and configure PostgreSQL 12.0 to currentImplement database maintenance routinesParticipate in On-Call rotationsTroubleshoot a variety of database issuesAccess managementMaintain backups and integrity checksParticipate in off hours Maintenance windowsParticipate in multiple projects involving data servicesWork within a global team environment or independently to carry out tasks as neededThe Essentials - You Will Have:Bachelor's Degree in Computer Science or related area or equivalent years of relevant work experienceLegal authorization to work in the US is required- we will not sponsor individuals for employment visas, not now or in the future, for this job openingThe Preferred - You Might Also Have:Typically requires 5+ years' experience managing a production system that is highly available and reliable, preferably 24/7Experience managing MySQL, PostgreSQL, Microsoft SQL server in private datacenters as well as in AWS and/or AzureProven history building automated solutions that enable resiliency and self-healing of applicationsOperational experience working with data technologies and managing large volumes of dataExperience troubleshooting performance and tuning queries and stored proceduresStrong SQL skills for writing and reviewing scriptsExperience setting up backup schedules and securing dataExperience building automation scripts for database server builds using terraform or ansibleExperience with Operations technologies: Server Operating Systems (Windows Server, Linux); Virtualization EnvironmentsAdditional experience with any of the following:MongoDBPowerShellTerraformAnsibleOpen-source technologies and cloud services: Azure, AWS, and/or GCP, Kubernetes, Docker, and/or Terraform; Chef, Puppet and/or AnsibleSQL Sentry or any other SQL monitoring tollExternal monitoring services like PRTG and DynatraceHashiCorp Consul;OpsGeniePrometheus and Alert ManagerWhat We Offer:Health Insurance including Medical, Dental and Vision401kPaid Time offParental and Caregiver LeaveFlexible Work Schedule where you will work with your manager to enjoy a work schedule that can be flexible with your personal life.To learn more about our benefits package, please visit at www.raquickfind.com.This position is part of a job family. Experience will be the determining factor for position level and compensation.We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, or veteran status. We are proud to be an equal opportunity workplace.#LI-MG4#LI-HybridWe are an Equal Opportunity Employer including disability and veterans.If you are an individual with a disability and you need assistance or a reasonable accommodation during the application process, please contact our services team at +1 (844) 404-7247.Rockwell Automation's hybrid policy aligns that employees are expected to work at a Rockwell location at least Mondays, Tuesdays, and Thursdays unless they have a business obligation out of the office.