Database Architect
Position Overview
We are seeking an experienced and highly skilled Database Architect with 8+ years of experience in designing, developing, optimizing, and managing enterprise-grade database solutions for Web Applications, Mobile Applications, Desktop Applications, SaaS Platforms, and Large-Scale Business Systems.
The ideal candidate will be responsible for designing scalable, secure, high-performance database architectures that support millions of records, real-time transactions, business intelligence, reporting, and future scalability requirements.
This role requires strong expertise in database architecture, data modeling, performance tuning, cloud databases, security, disaster recovery, and system integration.
Key Responsibilities
Database Architecture & Design
- Design and implement enterprise-level database architectures.
- Create logical and physical data models.
- Design scalable database solutions for:
- Web Applications
- Mobile Applications (Android & iOS)
- Desktop Applications
- SaaS Platforms
- Marketplace Systems
- CRM & ERP Systems
- Super Apps
- E-commerce Platforms
- Define database standards, naming conventions, and best practices.
Data Modeling
- Develop conceptual, logical, and physical data models.
- Design optimized database schemas.
- Establish relationships between complex entities.
- Ensure data consistency and integrity across systems.
- Create scalable multi-tenant database structures.
Database Optimization
- Analyze and improve database performance.
- Optimize queries, stored procedures, views, and indexes.
- Monitor database health and performance metrics.
- Reduce response times for high-traffic applications.
- Implement database partitioning and sharding strategies.
Cloud Database Management
- Design cloud-native database solutions.
- Work with:
- AWS RDS
- AWS Aurora
- Azure SQL
- Google Cloud SQL
- MongoDB Atlas
- Implement automated backup and recovery solutions.
- Configure replication and high-availability environments.
Security & Compliance
- Implement database security frameworks.
- Manage role-based access controls (RBAC).
- Ensure data encryption at rest and in transit.
- Maintain compliance with:
- GDPR
- Australian Privacy Act
- PCI-DSS
- ISO Security Standards
- Conduct database security audits.
Scalability & Reliability
- Design systems capable of handling high transaction volumes.
- Build fault-tolerant architectures.
- Plan disaster recovery and business continuity strategies.
- Implement database replication and failover mechanisms.
Data Integration
- Design integrations between databases and external systems.
- Support API-driven architectures.
- Develop ETL and data migration strategies.
- Integrate third-party systems and cloud services.
Reporting & Analytics
- Design data warehouses and reporting structures.
- Support business intelligence and analytics requirements.
- Create optimized reporting databases.
- Enable real-time dashboards and data insights.
Team Leadership
- Collaborate with:
- Product Managers
- Business Analysts
- Backend Developers
- DevOps Engineers
- QA Teams
- Solution Architects
- Mentor junior database developers and administrators.
- Participate in technical design reviews and architecture discussions.
Technical Skills Required
Relational Databases
- MySQL
- PostgreSQL
- Microsoft SQL Server
- Oracle Database
NoSQL Databases
- MongoDB
- Redis
- Cassandra
- DynamoDB
Database Technologies
- Database Replication
- Clustering
- Sharding
- Partitioning
- High Availability
- Load Balancing
Cloud Platforms
- AWS
- Microsoft Azure
- Google Cloud Platform
Data & Integration
- ETL Processes
- Data Migration
- API Integrations
- Data Warehousing
- Business Intelligence
Performance Optimization
- Query Optimization
- Index Tuning
- Database Monitoring
- Performance Troubleshooting
Required Qualifications
- Bachelor's Degree in Computer Science, Information Technology, Software Engineering, or related field.
- Minimum 8+ years of database architecture and design experience.
- Proven experience designing databases for enterprise applications.
- Strong understanding of scalable cloud infrastructure.
- Experience working in Agile development environments.
- Excellent analytical and problem-solving skills.
Preferred Experience
- Experience building Super Apps or Marketplace Platforms.
- Experience with large-scale Business Directory systems.
- Experience with Booking & Scheduling platforms.
- Experience with CRM, ERP, and SaaS products.
- Experience supporting Mobile Apps and Web Portals.
- Experience handling databases with millions of records and high concurrent users.
Success Metrics
- Database performance and response times.
- System scalability and uptime.
- Data integrity and security compliance.
- Successful implementation of disaster recovery plans.
- Reduced infrastructure and database costs.
- Support for business growth and future scalability.
Employment Type
Full-Time
Experience
8+ Years
Reports To
CTO / Head of Engineering
Location
Onsite
Pay: From ₹80,000.00 per month
Work Location: In person
