Locations : Experience : Experience : Skills : Data Modeling, Database Design, Dynamo to Evaluate : Data Modeling, Database Design, Dynamo : 7 to 10 : Description :
- Must-Haves :
- 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
Preferred :
Prior experience with designing, developing, and supporting solutions using database technologies like MySQL, PostgreSQL, Cassandra is a plusExperience with designing, developing, and supporting solutions using Map Reduce, Kafka, & Streaming technologies is a plusAdvanced python programming skills is a plusRoles & Responsibilities :
Understand the business domain, core data objects, data entities. Model the relationships between the various entitiesDesign the data warehouse, data mart and transactional databases including all facets of load parametersInduct aspects of high performance, security, usability, operability, maintainability, traceability, observability, evolvability into the systems designAssess 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 designsMaintain a catalog of meta, master, transactional and reference dataTune 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 plansDevelop and test database code and other core and helper utilities in PythonDevelop and profile queries, triggers, indices, and stored proceduresMonitor the health of queries and identify patterns leading to bottlenecks in the system before the customer finds itOwn the DevOps and release mgmt. practices pertaining to the database solutionsEstimate the cost of AWS services usage and look to continuously optimize the costDesign and develop data REST API layer on Pythonref : hirist.tech)