Database Architect
RED Global
Tech stack mentioned
Role overview
Formatting this description...
Looking for an experienced **Database Architect** to design, implement, and optimize enterprise‑grade database solutions. The ideal candidate will have deep expertise in **SQL Server, PostgreSQL**, and **Azure cloud database services**, with a proven ability to support mission‑critical applications, ensure scalability, and maintain high availability. ## Key Responsibilitie s- **Database Design & Architecture* *- Design and implement scalable database solutions across SQL Server, PostgreSQL, and Azure SQL Database .- Define data models, schemas, and standards for structured and unstructured data .- Develop strategies for database partitioning, indexing, and query optimization .- **Cloud & Infrastructure* *- Architect and manage databases in **Azure** (Azure SQL, Cosmos DB, PostgreSQL on Azure) .- Ensure seamless integration with cloud services, security policies, and compliance requirements .- Support hybrid environnements (on‑premises + cloud) . - **Performance & Optimization **- Monitor and tune database performance, queries, and stored procedure s.- Implement caching, replication, and clustering strategie s.- Conduct capacity planning and ensure high availability/disaster recover y. - **Security & Complianc e**- Define and enforce database security standards (encryption, access control, GDPR complianc e).- Implement backup and recovery strategi es. - **Collaboration & Leadersh ip**- Work closely with application developers, DevOps, and data engineers to align database solutions with business ne eds.- Provide technical leadership and mentoring to junior DBAs and develop ers.- Document architecture, standards, and best practi ces. ## Required Skills & Qualific ations- **Technical Exper tise**- Strong proficiency in **SQL Server** and **PostgreSQL** (schema design, query optimization, stored proced ures).- Hands‑on experience with **Azure SQL Database, Cosmos DB, PostgreSQL on Az ure**.- Knowledge of database migration tools and strategies (e.g., from on‑prem to c loud). - **Exper ience**- 10+ years in database design, administration, or archit ecture.- Proven track record of architecting large‑scale, high‑availability s ystems.- Experience with ETL processes, data warehousing, and BI tools is a plus. - **Soft Skills**- Strong analytical and problem‑solving skills.- Excellent communication and documentation ab ilities.- Ability to work cross‑functionally with business and technica l teams. ## Preferred Quali fications- Certifications: **Microsoft Certified: Azure Database Administrator Associate** or **Azure Solutions Architect Expert**.- Experience with **NoSQL databases** (MongoDB, Cassandra) i s a plus.- Familiarity with **DevOps pipelines** and Infrastructure‑as‑Code (Terraform, ARM te mplates).- B.Tech or equal technical education- Fluent English and Excelleant communicati on skills Salary is 40 to 45 LPA . Hybrid, onsite 3x/week in Whitefield, Bangalore.