Description :
Role : Senior Consultant DBA / Database Engineer (Semantic Layer)
Experience : 10+ Years
Location : Pune / Chennai / Hyderabad
NP : Immediate Joiner
Job Overview :
We are looking for an experienced Senior Consultant DBA / Database Engineer to design, implement, and maintain complex database systems, bridging the gap between database administration and data engineering.
The role focuses on performance optimization, data security, disaster recovery, and building data pipelines to ensure data quality across critical business systems.
Mandatory : Cosmos DB + Semantic Layer expertise.
Key Responsibilities :
- Lead design and implementation of robust, scalable, and high-performance database architectures.
- Assess client requirements and translate them into optimal database models.
- Monitor database performance, identify bottlenecks, and implement tuning strategies.
- Analyze usage patterns and recommend improvements to data access and retrieval.
- Implement data security measures including access controls and encryption.
- Advise on data governance best practices to ensure compliance and data quality.
- Diagnose and resolve complex database issues including performance degradation, data corruption, and application errors.
Skills Required :
Deep expertise in DBMS : Oracle, SQL Server, PostgreSQL, MySQL.Data Warehousing & Modeling : Dimensional modeling, star / snowflake schemas.Data Engineering : ETL tools, data pipelines, data integration techniques.Strong programming skills : SQL, PL / SQL, Python, Java.Cloud Database Services : AWS RDS, Azure SQL Database, GCP Cloud SQL.Mandatory : Cosmos DB + Semantic LayerPreferred Skills :
Cloud database management, data warehousing, ETL processing.(ref : hirist.tech)