Lead Database Engineer - Bengaluru, India - KreditBee

Description

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.

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 dataOversee real-time business metric aggregation, data warehousing and querying, schema and data management, and related dutiesMaintain security controls in supported databasesEstablish relationships with internal customers and team members to drive collaboration.

Primary owner of 24x7 on-call external DB support teamDatabase 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, HBaseExperience 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 QualificationsAutomation using Python , Shell scripts and PowerShellAutomation using Chef/Puppet would be a plusExperience with config management systemsStrong analytical and problem solving skillsExperience operating under SOX/PCI/PII governanceExperience 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, Data durability, 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 innoDB engine.