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
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.
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
Must-Haves:o MUST-HAVE: Overall technology experience of 8+ years
o MUST-HAVE: Minimum experience of 5 years in data modelling and database design
o MUST-HAVE: Minimum experience of 7 years in designing, implementing, and supporting medium to large scale database systems
o MUST-HAVE: Minimum experience of 5 years in designing, developing, and supporting solutions using S3, Redshift, DynamoDB and any of the Managed RDS
o MUST-HAVE: Minimum experience of 4 years designing, developing, and tuning solutions using AWS database and storage technologies
Preferred: o Prior experience with designing, developing, and supporting solutions using database technologies like MySQL, PostgreSQL, Cassandra is a plus
o Experience with designing, developing, and supporting solutions using Map Reduce, Kafka, & Streaming technologies is a plus
o 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,
- 19 - 2,387,098.20 per year
Schedule: - Evening shift
Morning shift
* Rotational shift
Experience:
- total work: 8 years (Preferred)
Work Location: In person
