Cloud Database Architect

As a Cloud Database Architect, you will be responsible for the design, development, and maintenance of data warehouse, data mart, and transactional databases. Your key responsibilities will include: - Understanding the business domain, core data objects, and data entities, and modeling the relationships between them. - Designing databases with a focus on high performance, security, usability, and maintainability. - Assessing performance parameters and optimizing database and table designs. - Developing and testing database code and utilities in Python. - Profiling queries, triggers, indices, and stored procedures for performance optimization. - Implementing resilience, fail-over, and self-healing mechanisms in the system design. - Owning DevOps and release management practices related to database solutions. - Estimating and optimizing the cost of AWS services. - Designing and developing a data REST API layer in Python. - Demonstrating solid knowledge of data modeling, database design, distributed database models, data structures, algorithms, and AWS database technologies. - Prior experience with MySQL, PostgreSQL, Cassandra, Map Reduce, Kafka, and other database technologies is a plus. Qualifications required for the Cloud Database Architect role: - Overall technology experience of 8+ years. - Minimum 5 years of experience in data modeling and database design. - Minimum 7 years of experience in designing, implementing, and supporting medium to large scale database systems. - Minimum 5 years of experience in working with S3, Redshift, Dynamo DB, and Managed RDS. - Minimum 4 years of experience in designing, developing, and tuning solutions using AWS database and storage technologies. The company follows a hiring process consisting of screening (HR Round), Technical Round 1, Technical Round 2, and Final HR Round. Please note that the position for Cloud Database Architect is already filled.,