Database Architect - Architect - Chennai

Photon; India; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

Photon in India seeks a Senior Database Architect to analyze current database systems and lead a comprehensive re-architecture plan. You will design schemas, optimize queries, and migrate databases to cloud platforms (AWS/Azure/Google Cloud) with minimal downtime and strong data integrity.

You will collaborate with software, DevOps, and infra teams, implement scaling strategies for high availability, and document architectures and operational guides. 5+ years of experience required.

Qualifications

• 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 (MySQL, PostgreSQL, Oracle) and non-relational databases (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.

Responsibilities

• 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.

Skills

Database architecture

Relational databases

Non-relational databases

Cloud migrations

Performance tuning

Data security

High availability

Sharding

Education

Bachelor's or Master's degree in Computer Science, Information Systems, or related field

Tools

MySQL

PostgreSQL

Oracle

MongoDB

Cassandra

QLIK

GoldenGate

Job description

India

Trending

Job Description

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.