Lead analysis and re-architecture of relational and non-relational databases, optimize schemas, queries, and indexing, migrate databases to cloud, ensure security, HA and DR, collaborate with engineering and DevOps, document architecture, and support teams on database best practices.
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.
Photon Chennai, Tamil Nadu, IND Office
DLF IT Park 1/124 Mount Poonamallee Road Sivaji Gardens Manapakkam , Chennai, India, 600089
Similar Jobs
.jpeg)
Artificial Intelligence • Hardware • Information Technology • Machine Learning
Responsible for lab equipment maintenance, calibration, troubleshooting, and team leadership while ensuring compliance with regulations and conducting failure analysis.
Top Skills:
3D X-RayBend TesterCsamFibFtirHast ChamberIso/Iec 17025LinuxReflow OvenSemShock TesterSoak ChamberTemp CycleTemperature ChamberTesterThbWindowsX-Section
Artificial Intelligence • Hardware • Information Technology • Machine Learning
Responsible for setup, maintenance, calibration, and troubleshooting of lab equipment. Lead technician team and ensure compliance with safety and quality standards.
Top Skills:
3D X-RayBend TesterCsamFibFtirHast ChamberIso/Iec 17025LinuxReflow OvenSemShock TesterSoak ChamberTemp CycleTemperature ChamberTesterThbWindowsX-Section
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
Manage US sales and use tax compliance across jurisdictions, including preparing and filing returns, tax data extraction and reconciliations, month-end accruals and GL reconciliations, supporting state and local tax audits, improving tax processes and automation, and partnering with Tax, Accounting, IT, and business teams on tax treatment and reporting.
Top Skills:
AlteryxAvalaraClaudeExcelOnesourceOraclePower BISAPVertex
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
