Lead Database Engineer

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