Associate Software Architect

Responsible for understanding and translating business requirements into efficient, scalable, and reliable database solutions through the design, development, implementation, and maintenance of database tables, schemas, stored procedures, functions, views, and other associated database objects. Ensure optimal data storage, retrieval, and processing capabilities to support business applications and operational requirements.

Drive database performance optimization and operational efficiency through effective indexing strategies, query optimization, execution plan analysis. Ensure data accuracy, integrity, availability, and retention in accordance with organizational compliance policies, regulatory requirements, and business needs. Manage scheduled database jobs, proactively monitor execution, troubleshoot failures, and provide timely production support to ensure high availability and business continuity.

Design, develop, and optimize Azure Databricks notebooks and data transformation workflows to extract, process, transform, and load data from enterprise data sources into respective portal databases for consumption by downstream applications. Ensure data quality, consistency, processing efficiency, and scalability while implementing appropriate validation, exception handling, and monitoring mechanisms.

Ensure controlled, reliable, and standardized deployment of database objects and related data engineering components across development, testing, and production environments through established CI/CD pipelines and release management processes. Adhere to version control, code review, testing, change management, and deployment governance standards to minimize production risks and maintain consistency across environments.

Take ownership of timely and high-quality delivery of database development and data engineering initiatives through effective collaboration with business stakeholders, application development teams, infrastructure teams, and other technology partners.