Lead Database Engineer

KreditBee; Bengaluru; On-site; INR 800,000 - 1,500,000; Full time

Job summary

A leading company is seeking a Database Engineer with strong expertise in relational and non-relational database technologies. The successful candidate will be responsible for designing database infrastructure, ensuring performance and security, and collaborating with cross-functional teams. Ideal for individuals eager to work in a fast-paced environment and support mission-critical database services.

Qualifications

• Proven experience in building highly available database platforms.
• Proficient in MySQL, MongoDB, and performance tuning.
• Strong communication skills and experience in automation.

Responsibilities

• Design and manage database infrastructure on-premises and in the cloud.
• Maintain security controls in databases and oversee data aggregation.
• Primary owner of external DB support team, providing 24x7 coverage.

Skills

Database infrastructure management

SQL tuning

Scripting proficiency

Automation skills

Data warehousing

Security controls

Problem solving

Tools

MySQL

MongoDB

HBase

AWS RDS

Dynamo DB

Cassandra

Redis

InnoDB

PowerShell

Shell scripting

Job 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 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, 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.