Cloud Architect

Company : Crox Consultant

Position : Contract To Hire

Total Experience : 8 Year

Relevant experience : 5 Year

Location : Bangalore

Rotational : Morning ,Evening and Night Shift

**Role: Cloud Database Architect**

**About the role**:

- This is a HANDS-ON engineering position for individuals with a passion for analyzing, designing, developing, and operationalizing database and analytics solutions using AWS database and data technologies.
- The role is 70% focused on new projects & enhancements and 30% focused on providing operations support.

**Education**:

- A university bachelor's degree in Computer Science or Business Intelligence or Data Analytics is a must-have.
- 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**:

- **Must-Haves**:

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

- 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 is a plus

**Day-to-day responsibilities**:

- 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, de-normalization, 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, fail-over, self-healing 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

**Job Type**: Temporary
Contract length: 12 months

Pay: ₹890,627.19 - ₹2,387,098.20 per year

Schedule:

- Evening shift
- Morning shift
- Night shift
- Rotational shift

**Experience**:

- total work: 8 years (preferred)

Work Location: In person