Job Title: Database Architect
Job Location: Hinjewadi, Pune (Work from Office)
Shift: 24*7 Rotational
Job Description
We are seeking an experienced Database Architect with 10–14 years of expertise in designing, implementing, and governing enterprise database platforms across heterogeneous environments. The role involves defining database architecture strategies, ensuring scalability, high availability, performance optimization, and driving modernization initiatives across databases such as MySQL, MariaDB, PostgreSQL, MongoDB, and Oracle.
The Database Architect will play a key role in establishing best practices, guiding DBA teams, and aligning database platforms with business and application requirements across Development, QA, UAT, and Production environments.
Key Responsibilities
Database Architecture & Strategy
Design and implement end-to-end database architecture frameworks aligned with enterprise IT strategy.
Define standards for data modeling, schema design, and database governance.
Evaluate and recommend database technologies (RDBMS/NoSQL) based on use cases.
Lead database modernization initiatives including cloud adoption, containerization, and microservices architectures.
Performance & Scalability Engineering
Define and implement performance tuning strategies across databases.
Architect solutions for high throughput, low latency, and large-scale data workloads.
Conduct deep-dive analysis of query execution plans, indexing strategies, and workload distribution.
Design capacity planning frameworks and forecasting models for scaling systems.
High Availability & Disaster Recovery
Architect HA/DR strategies including replication, clustering, failover automation, and geo-distributed setups.
Design systems for zero/near-zero downtime deployments.
Ensure robust backup, recovery, and data protection mechanisms, including point-in-time recovery.
Lead disaster recovery drills and ensure compliance with RTO/RPO objectives.
Monitoring, Automation & Observability
Define and implement enterprise-wide monitoring and alerting frameworks.
Integrate observability tools such as Prometheus, Grafana, ELK, Nagios, PMM.
Drive automation of database operations (provisioning, patching, failover, scaling).
Establish proactive monitoring and predictive analytics for performance and failures.
Security & Compliance
Define and enforce database security standards, encryption, and access control policies.
Ensure compliance with industry standards and regulatory requirements.
Conduct periodic security audits, vulnerability assessments, and remediation plans.
Cloud & DevOps Integration
Architect database solutions for cloud platforms (AWS, Azure, GCP) including managed services.
Enable CI/CD pipelines for database deployments and schema versioning.
Support containerized environments using Docker, Kubernetes, and orchestration tools.
Leadership & Stakeholder Collaboration
Provide technical leadership and mentorship to DBA teams (L1/L2/L3).
Collaborate with application architects, developers, and infrastructure teams.
Review and approve database designs and changes across projects.
Drive knowledge sharing, documentation, and best practices adoption.
Operational Excellence
Oversee production database environments and ensure stability and reliability.
Guide incident management and root cause analysis for critical issues.
Establish SOPs, standards, and governance frameworks for database operations.
Required Skills & Experience
10–14 years of experience in database administration and architecture.
Strong hands-on expertise in MySQL, MariaDB, PostgreSQL, MongoDB, and Oracle.
Proven experience in database architecture design, performance tuning, and HA/DR implementations.
Deep understanding of SQL/NoSQL data models, replication, sharding, and clustering.
Experience with monitoring, automation, and performance optimization tools.
Strong knowledge of database security, encryption, and compliance frameworks.
Excellent problem-solving, analytical thinking, and communication skills.
Preferred Skills
Experience with cloud-native database services (AWS RDS/Aurora, Azure DB, GCP Cloud SQL).
Exposure to big data platforms (Hadoop, Spark) is a plus.
Hands-on experience with DevOps and Infrastructure-as-Code (Terraform, Ansible).
Knowledge of data warehousing and analytics platforms.
Relevant certifications (Oracle, PostgreSQL, MongoDB, AWS/Azure/GCP) preferred.
Educational Qualification
Bachelor’s or Master’s degree in Computer Science, Information Technology, or related field.
