Database Architect - Architect - Chennai
Photon · India
What we want:
- Analyze current database systems, including relational and non-relational databases, to identify inefficiencies, bottlenecks, and scalability issues.
- Develop a comprehensive re-architecture plan that includes database schema redesign, index optimization, query optimization, and improved data models.
- Lead initiatives to migrate databases to cloud platforms (AWS, Azure, Google Cloud, etc.) or hybrid cloud solutions, ensuring minimal downtime and data integrity.
- Optimize the database for performance, ensuring faster query execution times, efficient indexing, and improved data access speed.
- Ensure that all database re-architecture efforts comply with industry best practices for data integrity, privacy, and security, including encryption and backup strategies.
- Work closely with software engineering teams, DevOps, and infrastructure teams to align database re-architecture efforts with overall system architecture and application goals.
- Implement strategies for scaling the database to handle increasing load, and design systems for high availability and disaster recovery.
- Create detailed documentation for the new database architecture, including data flow diagrams, schema changes, indexing strategies, and operational guides.
- Stay updated with the latest database technologies and methodologies, recommending continuous improvements to the database architecture.
- Provide guidance and support to internal teams on best practices for database design, performance tuning, and cloud-based database solutions.
What you offer:
- Bachelor's or Master's degree in Computer Science, Information Systems, or related field.
- 5+ years of experience in database architecture, design, and administration.
- Proven track record of leading large-scale database re-architecture projects.
- Expertise in relational databases (e.g., MySQL, PostgreSQL, Oracle) and non-relational databases (e.g., MongoDB, Cassandra). QLIK, Goldengate
- Hands-on experience with cloud platforms such as AWS, Azure, or Google Cloud, specifically in migrating and managing databases.
- Deep understanding of database performance tuning, query optimization, and indexing strategies.
- Strong knowledge of data security and privacy standards.
- Experience with database replication, sharding, and high availability strategies.
- Excellent problem-solving and communication skills.