Database Architect - Bengaluru, India - FirstHive

FirstHive
FirstHive
Verified Company
Bengaluru, India

1 month ago

Deepika Kaur

Posted by:

Deepika Kaur

beBee Recuiter
Description

The Person:


  • Bring a passion for acquiring data and using data to improve the performance of the organization and the experience our customers receive.
  • Have a strong analytical background coupled with an ability to relate results to the business and make recommendations which add value.
  • Have a strong technical background on deploying large cloud for product and migrate from one cloud to another.

Key Responsibilities/Technical and Professional Expertise:


  • Design, implement and manage multitenant database infrastructure (MySQL, Redis, MongoDB and Redshift) in AWS and Azure.
  • Good understanding of AWS managed services like RDS, EC2, EMR, S3 etc.
  • Drive best practices that promote stability and operational efficiency.
  • Expertise in Database High availability features & Partitioning.
  • Strong experience in Monitoring, DB Performance Tuning, DB Availability, DR, Security, Storage.
  • Strong experience on Backup and Recovery of large databases.
  • Build policy on Archive and purge data in secure storage.
  • Work with the release team to ensure there is no risk and impact on database clusters post changes.
  • Ensure that the right indexes are created, analyze longrunning queries, and help engineering teams to rewrite, manage and monitor the database performance.
  • Identify blocked transactions and deadlocks and work with the engineering team to resolve them.
  • Monitor the performance of database clusters and proactively identify scalability and availability needs.
  • Rigor on continuous monitoring of memory and CPU usage of database clusters.
  • Strong analytical skills & Problemsolving attitude.
  • Solid expertise in SQL Tuning using Explain Plan and other techniques.
  • Experience in reviewing queries written for MySQL and guiding developers to write optimized queries. Must have experience in identifying slow queries and fixing them.
  • Exposure of deployment activities through CI/CD tools like Gitlab, Jenkins etc is desirable.

Job Types:
Full-time, Regular / Permanent


Salary:
₹500, ₹1,500,000.00 per year


Schedule:

  • Monday to Friday

Ability to commute/relocate:

  • Bengaluru , Karnataka: Reliably commute or planning to relocate before starting work (required)

Experience:


  • Redis: 4 years (preferred)
  • My

SQL:
4 years (preferred)

  • MongoDB: 4 years (preferred)

Speak with the employer
More jobs from FirstHive
See all jobs of FirstHive