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
Events • Food • Travel • Hospitality • Hotels & Resorts
Supervise the hotel operator team, manage schedules and performance, and ensure guest and internal calls are handled promptly. Coordinate guest requests across departments, train and coach staff, monitor communication systems, resolve escalated concerns, improve response times, and maintain service and performance reports. The role requires hotel operations or guest-service experience, strong leadership, proficiency with hotel communication systems and PMS, English fluency, and availability for varied shifts.
Top Skills:
Hotel Communication SystemsProperty Management Systems (Pms)
.jpeg)
Artificial Intelligence • Hardware • Information Technology • Machine Learning
Own semiconductor backend packaging assembly process development, optimization, and new product introduction. Define process records, windows, specifications, and capability targets while applying DOE, SPC, Six Sigma, FMEA, RCA, and structured problem solving to improve yield, reliability, cost, and process margins. Use MES, manufacturing data, analytics, and AI/ML for predictive control and anomaly detection. Introduce new materials and equipment, lead cross-functional execution, and coach process teams in a high-volume manufacturing environment.
Top Skills:
Ai/MlIndustry 4.0JmpMesPythonSemiconductor Packaging AssemblySQL
Security • Cybersecurity
Own global revenue recognition under ASC 606 and accounting processes including commissions, COGS, and leases. Review tax provisions, returns, transfer pricing, and subsidiary filings; support external audits and cross-functional reporting. Lead accounting projects, process improvements, and AI-driven workflow automation. Requires a CA, Big 4 high-tech experience, strong US GAAP and revenue recognition knowledge, ERP experience, advanced Excel skills, and excellent communication.
Top Skills:
Ai Automation ToolsAsc 340-40Asc 606ExcelMS OfficeNetSuiteUs Gaap
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.
