Job Description :
Role: Senior MYSQL DBA
Loc: Emeryville, CA
Job Description:
Customer is looking for a Senior Database Administrator who wants to put their knowledge and experience to work building a database infrastructure which is the core of a new frontier. Customer are building applications which deliver TV to PC’s and mobile devices and they need someone who can drive our backend systems to evolve rapidly, support very high availability and perform with the efficiency necessary to support a system with over 2 million subscribers. When the going gets tough so customer need some serious DBA kung-fu to get them through the rough spots.
Skill:
Bachelor's degree or equivalent experience
10+ years DBA experience, 5+ years in a 24/7/365 environment
Strong proficiency in MySQL database management
Hands on experience with NoSQL databases such as Cassandra & Solr
Proficient in Database scaling and HA configurations and load balancing
Proficient with MySQL clustered and non-clustered configurations
Proficient in writing and optimizing SQL statements, performance tuning and query analysis
Understanding of MySQLs underlying storage engines, such as InnoDB, MyISAM and NDB clustering
Experience with upgrading MySQL community edition
Proficient in scripting languages such as BASH and Python
Experience with replication configuration in MySQL
Knowledge of de-facto standards and best practices in MySQL
Expertise in ensuring performance, security, and availability of databases
Capable of handling common database procedures, such as upgrades, backups, recovery, migration, etc.
Experience with profile server resource usage, optimize and tweaks as necessary
Proficient in writing and optimizing SQL statements, performance tuning and query analysis
Experience with integrating monitoring tools such as Icinga, Prometheus, Grafana
Proficient understanding of code versioning tools such as Bitbucket
REsponsibility:
Identification and resolution of hardware, software or database problems/outages in any of the MobiTV services
24x7 coverage and response to systems alerts during after-hour periods
Provide specific solutions and recommendations that make sure the system survives failures to the extent possible
Work closely with Systems Engineering to test planned databases upgrades, including definitions, structures, and/or documentation, as well as provide input into long-range database requirements and operational guidelines
You will work with Engineering to ensure applications are making efficient use of our database resources
Use best operating practices to establish and maintain security and integrity controls
Formulate and monitor policies, procedures and standards relating to database management; propose and implement enhancements that will improve the performance and reliability of the system; proactively research and locate necessary tools and processes to identify and proactively avert troublesome trends, as they develop in order to ensure a stable and high performance environment for the MobiTV production systems