Database Architect

• *Job Description**

• *MSM Unify is looking for an experienced** Database Architect **with strong expertise in** cloud\-native database architectures on Microsoft Azure and AWS **. The role involves designing, governing, and optimizing** scalable, secure, and high\-availability database solutions **to support business\-critical applications and analytics platforms.**

• *Roles \& Responsibilities**

• *Database Architecture \& Design**

• **Design and maintain enterprise\-grade database architectures ensuring high availability, scalability, and performance**
• **Define database standards, governance frameworks, naming conventions, and best practices**
• **Choose appropriate relational and NoSQL database technologies based on performance, workload, and cost**
• **Design OLTP, OLAP, and hybrid data architectures**

• *Cloud Database Engineering (Azure \& AWS)**

• **Architect and manage databases on** Microsoft Azure **:**
• + **Azure SQL Database, SQL Managed Instance**

+ **Azure Database for MySQL/PostgreSQL**

+ **Cosmos DB**

• **Architect and manage databases on** AWS **:**
• + **Amazon RDS, Aurora, DynamoDB**

+ **Redshift (analytics workloads)**

• **Design multi\-region, fault\-tolerant, and disaster recovery solutions**

• *Performance, Security \& Reliability**

• **Optimize database performance using indexing, query tuning, partitioning, and caching**
• **Implement backup, recovery, replication, and failover strategies**
• **Ensure data security with encryption at rest and in transit, IAM/RBAC, VPC/VNet isolation**
• **Ensure compliance with data privacy and regulatory standards**

• *Data Migration \& Integration**

• **Lead on\-premise to cloud and cross\-cloud database migrations**
• **Plan schema design, data transformation, and migration strategies**
• **Integrate databases with applications, APIs, data pipelines, and BI tools**

• *Automation \& DevOps Enablement**

• **Automate database provisioning using** Terraform, ARM, CloudFormation
• **Enable CI/CD pipelines for database deployments**
• **Imple**

• *Key Skills**

• **Database Architecture**
• **Cloud Databases (Azure \& AWS)**
• **SQL \& Query Optimization**
• **MySQL, PostgreSQL, SQL Server, Oracle**
• **MongoDB, DynamoDB, Cosmos DB, Cassandra**
• **Azure SQL, Azure Cosmos DB**
• **Amazon RDS, Aurora, Redshift**
• **Data Migration \& Cloud Transformation**
• **High Availability \& Disaster Recovery**
• **Database Security \& Compliance**
• **Infrastructure as Code (Terraform, ARM, CloudFormation)**
• **CI/CD for Databases**
• **Performance Tuning \& Optimization**
• **Microservices \& Cloud\-Native Architecture**

• *Education \& Experience**

• **Bachelors or Master’s degree in Computer Science, Engineering, or related field**
• **7–12 years of experience in database engineering or architecture**
• **Experience designing databases for large\-scale, high\-traffic applications**