GLOOMZI ENTERPRISES

VK-11157-Data Architect

Job Type: Contract
Notice Period: Immediate
Experience Req: 10 Yrs
Location: Pune
Type: Hybrid
Country: India

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.

Apply Now!

Drop files here or click to uploadMaximum allowed file size is 3 GB.
Allowed Type(s): .pdf, .doc, .docx
Scroll to Top