Database Architect - Architect - Chennai
Photon- Location
- India
- Workplace
- —
- Employment
- —
- Salary
- —
Posted 2y ago
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.
Skills
- AWS
- Azure
- GCP
- MySQL
- PostgreSQL
- Oracle Database
- MongoDB
- Cassandra
More jobs at Photon
All 822Full Stack Developer Berkely Heights, NJ | FTE Only
Photon · United States · today
Technical Architect_Tempe, AZ
Photon · United States · today
ETL Data Engineer | Onsite
Photon · United States · today
Sr. Java Developer | Onsite
Photon · United States · today
Sr. Developer Java/Angular | Cleveland, OH
Photon · OH, United States · yesterday