Lead DBA

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.