Exp – 10+ yrs
Location – Pune
Aundh IT Park, Pune
they need to go to office 1-2 times in a month
Job Summary:
An expert SQL Developer DBA, who has worked on Redshift/warehousing concepts. Need extensive experience on reporting and performance tuning
Job Description:
Technical stack: SQL, Redshift, EMR, S3, AWS , MongoDB/AWS Document DB, MYSQL, Athena, Data Warehouse
Key Points:
Be able to create an efficient physical database design from a logical data model and application specifications.
Must possess in-depth SQL knowledge, understand SQL code
Proficient in tuning SQL queries to improve the database performance and availability.
Familiar with NoSQL database such as MongoDB or AWS Document DB.
Have experience with Linux operating system and MySQL.
Have experience in AWS services like AWS EC2, RDS, Redshift, Athena, Cloudwatch, etc.
Have expertise in managing AWS Redshift access privileges and creating roles, users, groups.
Have expertise in loading/unloading data from Amazon Redshift.
Proficient in maintaining and tuning AWS Redshift data warehouse to improve the cluster performance and availability.
Ability to use PowerBI and create basic dashboards.
Familiarity with database version control tools such as Flyway.
Let me know if you need any further details.