algoleap
Website:
algoleap.com
Job details:
DBA Lead
Roles and Responsibilities:
Database Design And Architecture
â Design and implement scalable, secure, and high-performance database solutions using Azure services like PostgreSQL, Azure SQL Database, Cosmos DB etc.
â Create data models and schemas tailored for cloud-based apps.
â Proficiency in database schema design, normalization, and data modelling techniques.
Performance Tuning And Troubleshooting
· Analyze database queries using Query Store and Performance Insights.
· Optimize indexes, partitions, and caching strategies.
· In-depth knowledge of query optimization, caching ,indexing, Partitions strategies,
· performance monitoring tools.
· Ability to develop and implement long-term database strategies that align with the organization’s goals.
· Expertise in conducting thorough investigations to determine the root cause of recurring problems and preventing future occurrences
Automation And Monitoring
â Set up Azure Monitor/Grafana, Log Analytics, and Alerts to track database performance and failures.
â Automate backups, scaling, and maintenance tasks
â Proficiency in scripting languages (e.g., PowerShell, Python, Bash) for automation of routine database tasks.
Security And Compliance
â Familiarity with database security measures, including encryption, authentication, and role-based access control.
â Implement Transparent Data Encryption (TDE), Always Encrypted, and Row-Level Security.
â Ensure databases comply with GDPR, HIPAA, etc., using Azure Policy and Microsoft Defender for Cloud.
High Availability And Disaster Recovery (HA/DR)
â Strong understanding of backup strategies, disaster recovery planning, and high-availability (HA) solutions.
â Design geo-replication strategies and failover groups.
â Plan RTO (Recovery Time Objective) and RPO (Recovery Point Objective) using Azure Site Recovery.
Cost Optimization
â Analyze and suggest right-sizing of databases using Azure Cost Management + Billing.
â Understanding of budget constraints and cost management, especially in cloud environments.
Collaboration And Mentorship
â Work closely with application developers to fine-tune DB interactions.
â Mentor junior DBA s and DevOps teams about Azure’s database services.
Click on Apply to know more.