Database Administrator - Plex

Rockwell Automation is a global technology leader focused on helping the world's manufacturers be more productive, sustainable, and agile. With more than 25,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 the work 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 Description

In support of our ongoing growth, we are looking for a Database Administrator within our Plex Cloud Operations. The Plex Cloud Operations department takes great pride in being a part of a continuous improvement culture, and as a data service team member, you will play a key role in operationalization of state of the art, leading edge software and adoption of open-source technologies. You will be responsible for running scalable, reliable, and secure applications while helping improve the delivery of our products. You will join a team that will ensure that issues are resolved in an organized manner as quickly and efficiently as possible, with minimal customer impact.

Essential Functions

• Installing and configuring SQL server
• Participating in On-Call rotations
• Troubleshooting a variety of database issues
• Access management
• Maintaining backups and integrity checks
• Participating in off hours Maintenance windows
• Routine preventative maintenance
• Performance monitoring and tuning
• Participate in a variety of projects involving data services
• Working within a global team environment or independently to carry out tasks as needed

Basic Qualifications

• 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- we will not sponsor individuals for employment visas, not now or in the future, for this job opening

Preferred Qualifications

• Typically requires 5+ years' experience managing a production system that is highly available and reliable, preferably 24/7
• Experience managing Microsoft SQL server in public cloud
• 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 any of the following:
  • PowerShell
  • Open-source technologies and cloud services: Azure, AWS, and/or GCP, Kubernetes, Docker, and/or Terraform; Chef, Puppet and/or Ansible
  • SQL Sentry or any other SQL monitoring toll
  • External monitoring services like PRTG and Dynatrace
  • Hashi Corp Consul;
  • OpsGenie
  • Prometheus and Alert Manager

This position is part of a job family. Experience will be the determining factor for position level and compensation.

#LI-MG4

#LI-Remote

We 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.