Cloud Database Architect - Bengaluru, Karnataka, India - Phygital Insights

Phygital Insights
Phygital Insights
Verified Company
Bengaluru, Karnataka, India

1 month ago

Deepika Kaur

Posted by:

Deepika Kaur

beBee Recuiter
Description
Full time- |- Work From Office***
Department:
ARCHITECT

  • Listed on Apr 16, 2024

BANGALORE
7 to 8 Years Relevant Experience

  • Understand the business domain, core data objects, data entities. Model the relationships between the various entities.
  • Design the data warehouse, data mart and transactional databases including all facets of load parameters.
  • Induct aspects of high performance, security, usability, operability, maintainability, traceability, observability, evolvability into the systems design.
  • Assess performance influencing parameters like normalization, denormalization, most executed transactions, record count, data size, I/O parameters at the database and OS level in the database and table designs.
  • Maintain a catalog of meta, master, transactional and reference data.
  • Tune the transactions and queries and determine the use of appropriate client libraries and fetch mechanism (like query vs stored procedures).
  • Design the system for resilience, failover, selfhealing and institute rollback plans.
  • Develop and test database code and other core and helper utilities in Python.
  • Develop and profile queries, triggers, indices, and stored procedures.
  • Monitor the health of queries and identify patterns leading to bottlenecks in the system before the customer finds it.
  • Own the DevOps and release mgmt. Practices pertaining to the database solutions.
  • Estimate the cost of AWS services usage and look to continuously optimize the cost.
  • Design and develop data REST API layer on Python.
  • Solid knowledge of data modeling and database design
  • Solid knowledge of workings of a distributed database models including SQL, No-SQL and performance optimization
  • Solid knowledge of data structures and algorithms.
  • Solid knowledge of AWS database and data technologies.
  • Prior experience with designing, developing, and supporting solutions using database technologies like MySQL, PostgreSQL, Cassandra is a plus.
  • Experience with designing, developing, and supporting solutions using Map Reduce, Kafka, & Streaming technologies is a plus.
  • Advanced python programming skills are a plus.
Must Have Skills

  • Overall technology experience of 8+ years
  • Minimum experience of 5 years in data modelling and database design.
  • Minimum experience of 7 years in designing, implementing, and supporting medium to large scale database systems
  • Minimum experience of 5 years in designing, developing, and supporting solutions using S3, Redshift, DynamoDB and any of the Managed RDS
  • Minimum experience of 4 years designing, developing, and tuning solutions using AWS database and storage technologies.

Required Skills:


AWS

REST API layer on Python

SQL

Kafka

Hiring Process:

-
Screening (HR round)
-
Technical Round 1
-
Technical Round 2
- ** Final HR round
More jobs from Phygital Insights
See all jobs of Phygital Insights