Senior Database Administrator - MySQL, PostgreSQL

November 26

Apply Now

Receive Emails with Similar Jobs

Rockwell Automation

WebsiteLinkedInAll Job Openings

Industrial Automation • manufacturing • safety products • automation systems • drives

10,000+ employees

Founded 1903

🔧 Hardware

💰 $1M Debt Financing on 2006-09

Description

• Implement and maintain database 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 SQL statements and stored procedures • In-depth query execution plan expertise • Lead regular weekly discussions regarding MySQL and PostgreSQL instances with members of data services team • Perform post-incident customer impact analysis as well as monthly application availability metrics • Install and configure MySQL 5.7 to current • Install and configure PostgreSQL 12.0 to current • Implement database maintenance routines • Participate in On-Call rotations • Troubleshoot a variety of database issues • Access management • Maintain backups and integrity checks • Participate in off hours Maintenance windows • Participate in multiple projects involving data services • Work within a global team environment or independently to carry out tasks 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- we will not sponsor individuals for employment visas, not now or in the future, for this job opening • Typically requires 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 as well as 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

Benefits

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