MySQL Database Administrator

Oracle - RightNow Employees work in a dynamic, fast paced environment. The Cloud Delivery department maintains both the software and hardware infrastructure that delivers our SaaS (Software as a Service) platform. Our database infrastructure consists of: Over 300 MySQL instances, 84TB of data, and thousands of unique schemas. Additionally, our platform can serve 1+ billion page turns per month. Our MySQL environment utilizes a unique replication setup combined with a large suite of Python code for server automation.

As a MySQL Database Administrator for Oracle - RightNow your role would be to design, install, monitor, maintain, and performance tune production databases while ensuring high levels of data availability. You would also be responsible for developing automation processes, benchmarking, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software in the Oracle - RightNow Cloud environment.
Essential Knowledge and Background
A current UK citizenship is necessary for this position
College diploma or University degree in the field of Computer Science and/or three years equivalent work experience
Working technical experience with designing, building, installing, configuring and supporting database servers, including MySQL and Oracle Database
Strong Systems Administration skillset, including Linux and network troubleshooting
Assisting MySQL DBA team in supporting operations
Hands-on database tuning and troubleshooting experience
Preferred Knowledge and Skillsets
Ability to troubleshoot difficult issues until problem is resolved, including digging into code and finding logic errors or inefficiencies
Enjoys finding and fixing tough problems
Very familiar with benchmarking techniques and implementation
Strong understanding of database structures, theories, principles, and practices
Ability to learn complex systems
Strong coding background with ability to maintain large projects
Ability to program in Python
Ability to read C/C++ and PHP code and pinpoint bugs and inefficiencies
MySQL or Oracle certification
Understands and has implemented the concept of horizontal scaling
Reads planet.mysql.com and has tested and implemented ideas discovered from reading this site
Additional Skillsets
Project Management experience
Good understanding of the organization's goals and objectives
Knowledge of applicable data privacy practices and laws
Good written and oral communication skills
Strong technical documentation skills
Good interpersonal skills
Ability to conduct research into database issues, standards and products as needed
Ability to present ideas in user-friendly language
Highly self motivated and directed
Keen attention to detail
Proven analytical and problem-solving abilities
Ability to effectively prioritize and execute tasks in a high-pressure environment
Strong customer service orientation
Experience working in a team-oriented, collaborative environment

Detailed Description and Job Requirements
Work with a world class team to provide enterprise-wide, Oracle Database Administration support for production systems and provide DBA services to application development teams, including database design, database generation, coding, and database production support. Provide DBA support with a high degree of customer service, technical expertise, and timeliness. Provide accurate and creative solutions to user problems of moderate nature to ensure user productivity.

Provide Development and/or Production support. This includes creating primary database storage structures, designing and creating primary objects, modifying database structure as necessary for enhancements or performance, creating documentation, designing interfaces, database objects, and creating plans. Monitor and optimize performance of the database, plan for backup and recovery of the database, and allocate system storage and plan future storage needs. Create database-related scripts and programs to support development and production environments. Research, evaluate, design, test, recommend, and plan implementation of new or improved RDBMS, ETL and database tools.

Job duties are varied and complex utilizing independent judgment. May have project lead role. 5 years of experience supporting relational databases as a DBA, with multiple distributed relational DBSM*s or a depth and focus in Oracle and related tools. Exposure and practice at using the DBMS to optimize performance of large databases for enterprise use is preferred. Experience with an organization with a key 24 X 7 reliance on its database is desirable. BS or equivalent desired.