Analyze and optimize relational and non-relational databases, support re-architecture and cloud migration efforts, improve query performance and indexing, ensure scalability, high availability and disaster recovery, document changes, and collaborate with engineering and DevOps teams.
Key Responsibilities:
- Analyze current database systems (relational and non-relational) to identify performance inefficiencies and opportunities for optimization.
- Assist in database re-architecture projects, focusing on schema design, query performance, and indexing improvements.
- Support efforts to migrate databases to cloud platforms (AWS, Azure, Google Cloud) while ensuring data accuracy and minimal downtime.
- Optimize database performance by improving query execution times and indexing strategies.
- Collaborate with cross-functional teams, including software engineering and DevOps, to ensure database alignment with overall system architecture.
- Assist in implementing strategies to ensure scalability, high availability, and disaster recovery.
- Document database architecture changes, including schema updates, indexing plans, and performance tuning techniques.
- Stay updated on emerging database technologies and recommend improvements to the existing database infrastructure.
Qualifications and Skills:
- Bachelor’s degree in Computer Science, Information Systems, or a related field.
- 2-4 years of experience in database management, design, or administration.
- Hands-on experience with Oracle DB and familiarity with Qlik for data analytics and visualization.
- Experience with relational databases (e.g., MySQL, PostgreSQL, Oracle) and non-relational databases (e.g., MongoDB).
- Basic experience with cloud platforms (AWS, Azure, Google Cloud) and database migration.
- Understanding of query optimization, indexing, and database performance tuning techniques.
- Familiarity with data security and privacy standards.
- Strong problem-solving and team collaboration skills.
Photon Chennai, Tamil Nadu, IND Office
DLF IT Park 1/124 Mount Poonamallee Road Sivaji Gardens Manapakkam , Chennai, India, 600089
Similar Jobs
Cloud • Information Technology • Security • Software
The Staff Quality Engineer will lead quality initiatives, engage in SDLC processes, architect testing strategies, and mentor teams in quality standards and automation.
Top Skills:
AWSCypressGherkinPytestPython
Cloud • Information Technology • Security • Software • Cybersecurity
Design and produce high-fidelity creative assets across print, digital, web, social, video, and events. Prepare production-ready artwork, perform photo retouching, build and maintain graphic files, and collaborate with creative, production, and stakeholder teams to ensure brand-aligned, high-quality deliverables.
Top Skills:
Adobe Creative SuiteAdobe IllustratorAdobe IndesignAdobe PhotoshopFigmaGoogle SlidesMS OfficeMicrosoft Powerpoint
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Senior SAS developer responsible for designing, developing, and optimizing SAS programs and ETL workflows. Work includes Base SAS, macros, PROC SQL, SAS DI Studio and EG, scheduling (LSF), Unix/shell scripting, performance tuning of SAS servers, and transforming banking data for enterprise data warehouses. Collaborate with clients, QA, DBAs and support teams.
Top Skills:
Base SasETLHadoopLsf Platform SuiteProc SqlSASSas Data Integration StudioSas EgSas MacroSas ServersShell ScriptingSQLUnix
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.
