United States of America Michigan (remote)United States of America Virginia (remote)United States of America Nevada (remote)United States of America Texas (remote)United States of America Illinois (remote)

　　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 Description

　　SummaryIn support of our ongoing growth, we are looking for a Senior Database Administrator with extensive experience in SQL Development and SQL Performance/Tuning. 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 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 as quickly and efficiently as possible, with minimal customer impact.

　　What you will do :

　　Implement and maintain database server and SQL Server KPI monitoring/alerting

　　Chart database utilization over time to identify optimal 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

　　Lead regular weekly performance related discussions with members of data services team

　　Perform post-incident customer impact analysis as well as monthly application availability metrics

　　Lead annual database related audit evidence gathering and response

　　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

　　Participate in a variety of projects involving data services

　　Working within a global team environment or to carry out tasks as needed

　　You will be remote in this role

　　You will be reporting into

　　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 8+ years' experience managing a production system that is highly available and reliable, preferably 24/7

　　Experience managing Microsoft SQL server in public cloud

　　Experience writing complex T-SQL and SQL Server stored procedures

　　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

　　Experienc