KrazyBee - Database Administrator - MySQL

Description : We are looking for an outstanding Database Administrator-MySQL with deep knowledge of and experience with a variety of relational and non-relational database technologies in a highly scalable environment. The ideal candidate should demonstrate superb technical competency in delivering mission-critical database platforms and services while ensuring the highest levels of scalability, availability, performance, and Security Job Responsibilities • Design, implement, and manage database infrastructure on-premises and in the cloud. • Collaborate with developers, network/system engineers, vendors, and support staff in an open and creative environment. • Analyze procedures to control the access and allocation of data • Oversee real-time business metric aggregation, data warehousing and querying, schema and data management, and related duties • Maintain security controls in supported databases • Establish relationships with internal customers and team members to drive collaboration. • Primary owner of 24x7 on-call external DB support team • Database and SQL tuning, including reduction in I/Os, views and triggers. • Creating indexes where required while taking a look at the fill factor for existing ones. Skills And Qualifications • Proven experience building and supporting highly available database platforms and services at scale in a fast-paced environment. • Proficient in the following database technologies, MySQL, MongoDB, HBase Experience in performance tuning and optimization using native monitoring and troubleshooting tools. • Proficient at scripting in at least one common scripting language. Experience supporting managed database solutions (AWS RDS, Dynamo DB, AWS Document DB, Firestore). • Experience building/managing database platforms through Infrastructure as Code (IaC). Strong working knowledge of HA/DR best practice architecture. • Strong documentation/training/communication skills. Optional Skills And Qualifications • Automation using Python , Shell scripts and PowerShell • Automation using Chef/Puppet would be a plus • Experience with config management systems • Strong analytical and problem solving skills • Experience operating under SOX/PCI/PII governance • Experience with Cassandra, Redis and/or Elastic Cache. • Knowledge of Installation, configurations and maintenance of Mysql database. • Experience in Provisioning MySQL instances, both in clustered and non-clustered configurations. • Handle common database process, such as upgrade, backup, recovery, migration, etc. Set up monitoring / alarming for production DB environments. • Knowledge of High Availability (HA) and Disaster Recovery (DR) options. • Expertise in designing and maintaining MySQL . • Experience in Linux performance, memory management, I/O tuning, cluster management, Datadurability, security, networking, and system crash analysis. • Experience in setting up and operating Highly Available MySQL. • Knowledge of shell scripting. • Experience in working with Percona and in DB engine. (ref:hirist.tech)