Intern SQL Developer
Duration: 2024-07-13 - 2025-07-14
Monthly Salary: ₹0.00 - ₹0.00
Job position: Intern SQL Developer
Microdynamic Software Private Limited
103, Vitthal Complex, Above Hotel Royal Pure Veg, near Selfy Point, Narhe, Pune, Maharashtra 411041

Job description
Selected Intern's Day-to-day Responsibilities
Include Writing complex and best-performing SQL Queries on Postgresql database
Writing stored procedures
Reviewing existing queries and optimizing them
Working on MIS reports and software usage reports
Indexing, data backups, and data migrations
Creating and maintaining documentation of all database objects
Prerequisites
Must have formally learned Postgres SQL Development through demonstrable certifications or reputable course.
Must be able to demonstrate a passion for writing complex SQL Queries, including JSON-based queries in Postgres, through personal projects completed in the last 3 months.
You may also get to work on AWS, AWS Redshift, Redis, DynamoDB You will also be judged for the following competencies in addition to the abilities required to perform your role
Note :
Passion for SQL Query Writing: A genuine enthusiasm for SQL Query Writing and a keen interest in staying up-to-date with the latest developments. in the field
R&D: The capability to research, find, try, and tweak community solutions into production-grade solutions
Creative Problem Solving: The ability to think critically and create initial designs, translating them into practical solutions that can be implemented by other developers
Excellent Communication Skills: Strong communication skills to understand requirements effectively and communicate with fellow developers, testers, and business analysts
Assignment :
If you are through to the interview round, you will be asked to write 5 complex queries on a Postgres database involving joins, JSON columns, and Postgres in-built functions.