Principal Cloud Engineer

Acesoft Labs; Bengaluru; On-site; INR 1,400,000 - 2,000,000; Full time

Job summary

Acesoft Labs in Bengaluru, India seeks a senior database architect to own the design of data warehouses, data marts, and transactional databases. You will model complex data relationships, optimize performance, and ensure security, observability, and resilience across AWS-based data platforms.

Ideal candidates bring extensive experience with S3, Redshift, DynamoDB and Managed RDS, plus Python for core utilities and data REST APIs.

Qualifications

• 8+ years overall technology experience.
• 5+ years in data modelling and database design.
• 7+ years in designing, implementing and supporting medium to large scale database systems.
• 5+ years designing, developing, and supporting solutions using S3, Redshift, DynamoDB and any Managed RDS.
• 4+ years designing, developing, and tuning solutions using AWS database/storage technologies.

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 Pytho

Skills

Overall tech experience

Data modelling

Large scale DB design

AWS database/Storage

AWS services cost optimization

Tools

AWS

S3

Redshift

DynamoDB

Managed RDS

Job description

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 candidate profile

• 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

Roles & 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 Pytho