Apply for Cloud Database Architect Job

7 to 10 Years Relevant Experience

• 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.
• 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 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 are a plus.

Must Have Skills

• 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, Dynamo DB and any of the Managed RDS.
• Minimum experience of 4 years designing, developing, and tuning solutions using AWS database and storage technologies.