1. Writing complex and best-performing SQL Queries on Postgresql database
2. Writing stored procedures
3. Reviewing existing queries and optimizing them
4. Working on MIS reports and software usage reports
5. Indexing, data backups, and data migrations
6. Creating and maintaining documentation of all database objects

Prerequisites:

1. Must have formally learned Postgres SQL Development through demonstrable certifications or reputable courses
2. 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
3. You may also get to work on AWS, AWS Redshift, Redis, DynamoDB
4. You will also be judged for the following competencies in addition to the abilities required to perform your role

Note:

1. 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
2. R&D: The capability to research, find, try, and tweak community solutions into production-grade solutions
3. Creative Problem Solving: The ability to think critically and create initial designs, translating them into practical solutions that can be implemented by other developers
4. 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