Talent.com
This job offer is not available in your country.
Lead Database Engineer

Lead Database Engineer

krazybeeINDIA
30+ days ago
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 processes, 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.
  • Locations

    Bengaluru, Karnataka

    Work Type

    Full Time

    Create a job alert for this search

    Database Engineer • INDIA