Database Developer Intern

About Femtosoft Technologies

Femtosoft Technologies, based in Chennai, India, is a software development firm with more than 18 years of experience. The company focuses on delivering bespoke software solutions across multiple sectors, with a strong emphasis on logistics. Their service offerings encompass web and mobile application development, UI/UX design, digital marketing, IT consulting, and cloud services. Femtosoft's proficiency covers various industries, including courier services, cargo, transport management, and warehouse management. The organization prioritizes solutions that are centered around the needs of its clients, utilizing cutting-edge technologies to create software that is not only robust and scalable but also user-friendly. Additionally, they offer continuous support to guarantee the sustained success of their clients' digital platforms over time.

Role Description

In this position, you will take on the responsibility of architecting, creating, and implementing the backend systems and services for Femtosoft Technologies. We seek an individual who possesses a deep enthusiasm for performance, reliability, and design, complemented by the relevant experience and qualifications that substantiate this fervor. As an integral member of the team, you will play a crucial role in supporting various high-impact projects at Femtosoft Technologies. You will collaborate with a group of innovative engineers who are dedicated to addressing intricate challenges with a sense of pride and professionalism. The optimal candidate for the Backend Developer Intern position should possess the capability to collaborate effectively with team members on both new and existing applications. This individual must demonstrate a strong understanding of project requirements, as well as the ability to design, code, and test technical solutions. Additionally, the candidate should be eager to learn from more experienced developers, thereby enhancing their skills and contributing to the overall success of the team.

Qualifications

• Currently pursuing a degree in Computer Science, Software Engineering, or a related field.
• Proficiency in MySQL database management systems is essential.
• Demonstrated aptitude for resolving complex issues, coupled with a meticulous approach to detail, is highly valued.
• The capacity to collaborate successfully within a team setting is crucial.
• A strong willingness to acquire new knowledge and adapt to emerging technologies and methodologies is also important.
• Effective communication skills, encompassing both oral and written forms, are necessary for success in this role.

Job Responsibilities

• Contribute to the creation and development of database structures, including schemas, tables, views, and indexes, to enhance data organization and accessibility.
• Engage in the process of data normalization to optimize storage solutions and improve data retrieval efficiency.
• Acquire knowledge and skills in database modeling methodologies to effectively apply these techniques in practical scenarios.
• Execute the processes of data importation, exportation, and migration across various databases or systems to facilitate seamless data transfer and integration.
• Assist in upholding data integrity and consistency throughout the system, ensuring that all data remains accurate and reliable.
• Manage extensive datasets by implementing effective storage solutions and organizational strategies to optimize data accessibility and usability.
• Develop SQL queries aimed at extracting, modifying, and generating reports from the database.
• Provide support in enhancing query efficiency to boost performance and minimize response times.
• Acquire skills in diagnosing and resolving issues related to slow or incorrect queries.
• Collaborate with software developers to ensure seamless integration of databases with various applications, enhancing overall functionality and performance.
• Engage with cross-functional teams to gather insights and clarify data requirements, ensuring that all needs are met effectively.
• Maintain comprehensive documentation of processes and regularly communicate progress and updates to team leaders or mentors for continuous improvement.

Skills Required

• Ability to write complex queries for data retrieval and manipulation.
• Knowledge of SQL commands like SELECT, INSERT, UPDATE, DELETE, JOIN, and UNION.
• Familiarity with advanced features like stored procedures, triggers, and indexing.
• Hands-on experience with databases such as MySQL and Oracle.
• Understanding database design concepts, including normalization and schema design.
• Familiarity with tools like ERD (Entity-Relationship Diagram) to design database structures.
• Ability to model relationships (one-to-one, one-to-many, and many-to-many).
• Basic understanding of how to optimize SQL queries for performance.
• Awareness of indexing, partitioning, and query execution plans.
• Knowledge of a programming language like Python, Java, or C# for database integration.
• Understanding how to connect applications to databases using libraries or frameworks.
• Exposure to tools like SQL Server Management Studio (SSMS), MySQL Workbench, or pgAdmin
• Familiarity with database backup, restore, and migration processes.
• Basic understanding of database security practices like role-based access control (RBAC)
• Awareness of data encryption and safe handling of sensitive information

Benefits

• Opportunity to become a full-time employee based on performance
• Dedicated mentors and opportunities at a fast pace.
• End-to-end ownership of your projects.
• Access to Industry-Leading Tools/Technologies.

Work Information