Lead Database Engineer

India·Bengalurulead

Database EngineerData & AI

0 views0 saves0 applied

Apply Now

Quick Summary

Overview

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.

Technical Tools

awsbashcassandramongodbmysqlpythonredissqllinuxnetworkingperformance-optimization

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.