Senior Consultant

Fresher

Save

Early Applicant

Job Description

Database Provisioning and Configuration
Set up and configure new database instances (on-prem, cloud, hybrid).
Automate provisioning using Infrastructure as Code - Azure CI/CD
Performance Monitoring and Tuning
Monitor database performance and resource usage.
Analyze slow queries, optimize indexing, and tune configurations.
Backup and Recovery
Establish automated, reliable backup strategies.
Perform routine recovery drills and ensure point-in-time recovery capability.
High Availability and Disaster Recovery
Implement HA solutions (e.g., replication, clustering, failover).
Maintain DR environments and test failover scenarios regularly.
Security and Compliance
Manage database access control (RBAC, least privilege).
Encrypt data in transit and at rest.
Ensure compliance with data regulations (e.g., GDPR, HIPAA).
Automation and CI/CD Integration
Automate schema changes, migrations, and seeding as part of CI/CD pipelines.
Use tools for version control of DB changes.
Monitoring and Alerting
Set up database observability using tools like Prometheus, Grafana, or New Relic.
Configure alerts for anomalies, slow queries, and storage thresholds.