Crox Consulting Inc
This listing was posted on hirist.
Cloud Database Architect - Business Intelligence (8-15 yrs) Bangalore (DevOps)
Location:
Bangalore
Description:
Role : Cloud Database ArchitectAbout 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 technologiesPrior Experience : - Must-Haves : MUST-HAVE : Overall technology experience of 8+ yearsMUST-HAVE : Minimum experience of 5 years in data modelling and database designMUST-HAVE : Minimum experience of 7 years in designing, implementing, and supporting medium to large scale database systemsMUST-HAVE : Minimum experience of 5 years in designing, developing, and supporting solutions using S3, Redshift, DynamoDB and any of the Managed RDSMUST-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 plusDay-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 PythonSuccess Factors : - Critical thinking, analytical & logical mind with a problem-solving aptitude- Strong desire to learn, experiment and iterate new solutions- Possess excellent fluency in English and excellent oral and written communication skills- Be able to clearly explain the design and the design decisions rooted in logic and core requirements- Be able to function in an environment where the team is virtual and geographically dispersed (ref:hirist.tech)
Visit Our Partner Website
This listing was posted on another website. Click here to open: Go to hirist
Important Safety Tips
- Always meet the employer in person.
- Avoid sharing sensitive personal and financial information.
- Avoid employment offers that require a deposit or investment.
To learn more, visit the Safety Center or click here to report this listing.
More About this Listing: Cloud Database Architect - Business Intelligence (8-15 yrs) Bangalore (DevOps)
Cloud Database Architect - Business Intelligence (8-15 yrs) Bangalore (DevOps) is a Technology Database Architect Job at Crox Consulting located in India. Find other listings like Cloud Database Architect - Business Intelligence (8-15 yrs) Bangalore (DevOps) by searching Oodle for Technology Database Architect Jobs.
Cloud Database Architect - Business Intelligence (8-15 yrs) Bangalore (DevOps) is a Technology Database Architect Job at Crox Consulting located in India. Find other listings like Cloud Database Architect - Business Intelligence (8-15 yrs) Bangalore (DevOps) by searching Oodle for Technology Database Architect Jobs.