Job
Description
As a technologically driven company, Praval believes in the transformative power of technology to enhance businesses and lives. Our team is dedicated to creating cutting-edge software applications, designing user-friendly interfaces, building collaborative systems, and exploring new technologies to redefine possibilities. We are committed to delivering top-notch IT solutions that address intricate challenges and fuel our clients' success in the digital era. At Praval, we value exceptional performance and offer a competitive compensation package that includes benefits, flexible work arrangements, and a healthy work-life balance. If you are enthusiastic about technology, excel in a dynamic environment, and aspire to make a significant impact in the IT sector, Praval welcomes you to join us on our journey of technological revolution and shaping the future together. **Responsibilities:** - **Azure Database Management** - Manage and administer Azure SQL Database, Azure SQL Managed Instance, Azure Synapse SQL Pools, and Azure PostgreSQL/MySQL services. - Implement backup/restore strategies, point-in-time recovery, retention policies, and geo-replication. - Monitor performance, optimize queries, indexes, resource allocation, and scaling. - **Data Analytics Platform Operations** - Manage storage layers like Azure Data Lake Storage (ADLS Gen2), SQL DBs, and Warehouse systems. - Support data engineering pipelines (ADF, Synapse Pipelines, Data Flows) to ensure data availability and reliability. - Maintain metadata systems, schema evolution, and data cataloging. - **Security, Governance & Compliance** - Implement and maintain access control through Azure AD, RBAC, and least-privilege models. - Configure data security measures (TDE, Always Encrypted, masking, firewall, private endpoints). - Ensure compliance with governance standards and maintain audit logs. - **Performance Monitoring & Optimization** - Utilize Azure Monitor, Log Analytics, and Query Store for proactive performance tuning. - Identify slow queries, deadlocks, failed jobs, and optimize workloads. - Implement automated alerts and health checks. - **Operational Support** - Manage database refreshes, deployments, version upgrades, and patching. - Provide production support for analytics workloads (Power BI, Fabric, Synapse, external applications). - Troubleshoot ingestion failures, job delays, schema conflicts, and compute/storage bottlenecks. Come be a part of our team at Praval and contribute to our innovative journey in technology! As a technologically driven company, Praval believes in the transformative power of technology to enhance businesses and lives. Our team is dedicated to creating cutting-edge software applications, designing user-friendly interfaces, building collaborative systems, and exploring new technologies to redefine possibilities. We are committed to delivering top-notch IT solutions that address intricate challenges and fuel our clients' success in the digital era. At Praval, we value exceptional performance and offer a competitive compensation package that includes benefits, flexible work arrangements, and a healthy work-life balance. If you are enthusiastic about technology, excel in a dynamic environment, and aspire to make a significant impact in the IT sector, Praval welcomes you to join us on our journey of technological revolution and shaping the future together. **Responsibilities:** - **Azure Database Management** - Manage and administer Azure SQL Database, Azure SQL Managed Instance, Azure Synapse SQL Pools, and Azure PostgreSQL/MySQL services. - Implement backup/restore strategies, point-in-time recovery, retention policies, and geo-replication. - Monitor performance, optimize queries, indexes, resource allocation, and scaling. - **Data Analytics Platform Operations** - Manage storage layers like Azure Data Lake Storage (ADLS Gen2), SQL DBs, and Warehouse systems. - Support data engineering pipelines (ADF, Synapse Pipelines, Data Flows) to ensure data availability and reliability. - Maintain metadata systems, schema evolution, and data cataloging. - **Security, Governance & Compliance** - Implement and maintain access control through Azure AD, RBAC, and least-privilege models. - Configure data security measures (TDE, Always Encrypted, masking, firewall, private endpoints). - Ensure compliance with governance standards and maintain audit logs. - **Performance Monitoring & Optimization** - Utilize Azure Monitor, Log Analytics, and Query Store for proactive performance tuning. - Identify slow queries, deadlocks, failed jobs, and optimize workloads. - Implement automated alerts and health checks. - **Operational Support** - Manage database refreshes, deployments, version upgrades, and patching. - Provide production support for analytics workloads (Power BI, Fabric, Synapse, external applications). - Troubleshoot ingestion failures, job delays, schema conf
