Senior Database Administrator - Plex

Rockwell Automation; Troy (OH); Hybrid; USD 80,000 - 120,000; Full time

Job summary

An established industry player is seeking a Senior Database Administrator to join their dynamic team. This role involves managing SQL Server and other database technologies, ensuring high availability and performance of critical systems. You will contribute to the operational excellence of cutting-edge software while working in a collaborative environment that values innovation and problem-solving. If you have a passion for data management and thrive in a fast-paced setting, this is the perfect opportunity for you to make a significant impact and help shape the future of technology in manufacturing.

Benefits

Health Insurance

401k

Paid Time Off

Parental Leave

Flexible Work Schedule

Qualifications

• 5+ years of experience in database administration or operations.
• Strong SQL skills for writing and reviewing scripts.
• Experience with cloud technologies and automation.

Responsibilities

• Implement and maintain database server and SQL Server KPI monitoring.
• Troubleshoot database issues in private datacenters and cloud environments.
• Participate in on-call rotations and perform preventative maintenance.

Skills

SQL Server Administration

T-SQL

Database Optimization

Performance Tuning

Cloud Technologies (Azure, AWS)

Data Backup and Recovery

Automation Scripting

Database Monitoring

PostgreSQL

MongoDB

Education

Bachelor's Degree

Tools

Terraform

Ansible

Docker

Kubernetes

SQL Sentry

Job description

Senior Database Administrator - Plex

Senior Database Administrator - Plex

Apply remote type Hybrid locations Troy, Michigan, United States Mayfield Heights, Ohio, United States Milwaukee, Wisconsin, United States time type Full time posted on Posted 3 Days Ago job requisition id R25-359

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 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!

Position Overview:

To support our ongoing growth, we are looking for a Senior Database Administrator with experience in SQL Server Administration and other data platform technologies (Preferred).

The Plex Cloud Operations team 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 that ensures issues are resolved as quickly and efficiently as possible, with minimal customer impact.

You will report to the Manager, Data Services - Plex.

Your Responsibilities:

• Implement and maintain database server and SQL Server KPI monitoring/alerting
• Chart database use over time to identify scaling opportunities
• Database bottleneck identification and corrective action
• Suggest modifications/optimizations (to Developers) for tuning T-SQL statements and stored procedures
• In-depth query execution plan expertise
• Experience using SQL Server query store for performance related analysis
• Perform post-incident customer impact analysis and monthly application availability metrics
• Perform annual database related audit evidence gathering and response
• Install, configure, and support SQL server, PostgreSQL, MySQL, and MongoDB
• Participate in On-Call rotations
• Troubleshoot a variety of database issues that occur in private datacenters, Azure, and AWS
• Access management
• Maintain backups and integrity checks
• Participate in off hours Maintenance windows
• Routine preventative maintenance
• Participate in many projects involving data services
• Work within a global team environment or to accomplish multiple tasks

The Essentials - You Will Have:

• Bachelor's Degree 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

The Preferred - You Might Also Have:

• Typically requires 5+ years of relevant experience in database administration or operations
• Experience managing a production system that is highly available and reliable 24/7/365
• Experience managing Microsoft SQL server in public cloud
• Experience writing complex T-SQL and SQL Server stored procedures
• Experience building automated solutions that promote resiliency and self-healing of applications
• Operational experience working with different 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, PostgreSQL, MongoDB, MySQL, Kafka, Druid, Terraform, Ansible, 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 tool, External monitoring services like PRTG and Dynatrace, Hashi Corp Consul; OpsGenie, Prometheus and Alert Manager.

What We Offer:

• Health Insurance including Medical, Dental and Vision
• 401k
• Paid Time off
• Parental and Caregiver Leave
• Flexible 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.