Home
Jobs

BusinessNext - Database Architect - Performance Tuning

10 years

0 Lacs

Posted:2 weeks ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Key Architecture & Engineering Design and implement high-performance, scalable database architectures for transactional and analytical workloads. Architect hybrid solutions integrating on-premises, cloud (AWS/GCP/Azure), and serverless databases. Develop data models (logical/physical) for relational, NoSQL, and distributed systems. Performance Optimization & SQL Engineering Optimize SQL queries, indexing strategies, and schema designs for latency-sensitive applications. Troubleshoot performance bottlenecks using monitoring tools (Prometheus, Grafana) and tuning methodologies. Implement partitioning, sharding, and caching (Redis/Valkey) for petabyte-scale datasets. High Availability & Disaster Recovery Design HA/DR strategies including replication (Galera Cluster, MongoDB Atlas), failover automation, and multi-region deployments. Configure backup solutions (physical/logical) and validate recovery procedures. Cloud & DevOps Integration Automate database provisioning, scaling, and updates using Terraform, Ansible, and Kubernetes. Collaborate with SRE/DevOps teams to enforce CI/CD pipelines for schema changes and zero-downtime migrations. Optimize cloud-native services (AWS RDS, Aurora, Google AlloyDB) for cost and performance. Security & Compliance Enforce encryption (TLS, KMS), RBAC policies, and audit trails aligned with GDPR/HIPAA. Conduct vulnerability assessments and patch management for database ecosystems. Mentorship & Leadership Guide junior architects on best practices for data modeling and query optimization. Document architectures, incident postmortems, and operational playbooks. Required Qualifications 10+ years of experience in database architecture, engineering, or SRE roles. Expertise in PostgreSQL, MySQL, ClickHouse, and MongoDB internals (e.g., WAL, vectorized execution). Proficiency in SQL/NoSQL tuning, data partitioning, and distributed transaction management. Hands-on experience with AWS/GCP/Azure database services (e.g., RedShift, CloudSQL, Cosmos DB). Strong scripting skills in Python, Bash, or Go for automation and tooling. Bachelors/Masters in Computer Science, Data Engineering, or related field. Preferred Qualifications Certifications: AWS Certified Database Specialist, MongoDB Certified Architect, Google Cloud Database Engineer. Contributions to open-source projects (e.g., PostgreSQL extensions, ClickHouse optimizations). Experience with time-series databases (InfluxDB) and vector databases (Milvus) for AI/ML workflows. (ref:hirist.tech) Show more Show less

Mock Interview

Practice Video Interview with JobPe AI

Start Database Interview Now
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

BUSINESSNEXT
BUSINESSNEXT

Consulting

Business City

150 Employees

28 Jobs

    Key People

  • John Doe

    CEO
  • Jane Smith

    CFO

RecommendedJobs for You