Senior Consultant

8 years

0 Lacs

Posted:1 day ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Database Provisioning and ConfigurationSet up and configure new database instances (on-prem, cloud, hybrid).Automate provisioning using Infrastructure as Code - Azure CI/CDPerformance Monitoring and TuningMonitor database performance and resource usage.Analyze slow queries, optimize indexing, and tune configurations.Backup and RecoveryEstablish automated, reliable backup strategies.Perform routine recovery drills and ensure point-in-time recovery capability.High Availability and Disaster RecoveryImplement HA solutions (e.g., replication, clustering, failover).Maintain DR environments and test failover scenarios regularly.Security and ComplianceManage 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 IntegrationAutomate schema changes, migrations, and seeding as part of CI/CD pipelines.Use tools for version control of DB changes.Monitoring and AlertingSet up database observability using tools like Prometheus, Grafana, or New Relic.Configure alerts for anomalies, slow queries, and storage thresholds.Data Lifecycle ManagementArchive old data, purge based on retention policies.Support partitioning and sharding strategies for large datasets.Collaboration with Developers and DevOpsWork closely with application teams to review schema designs.Support dev/test environments with realistic data (with masking/anonymization if needed).Incident Response and Root Cause AnalysisRespond to outages or slowdowns quickly.Perform root cause analysis and implement long-term fixes.

Experience

Candidate should have minimum 8 years of experience with SQL Server, or other relational databasesHands-on experience with Azure Monitor, Log Analytics, and Application Insights for proactive monitoring and performance insights.Experience with DataDog Monitoring/Observability a plusExperience with database performance tuning and monitoring toolsExperience with cloud platforms such as Azure or AWSFamiliarity with database deployment and CI/CD practicesGood understanding of data security, integrity, and compliance practicesExperience with Azure Cosmos DB or other NoSQL databases is a plusExcellent problem-solving and communication skills

Mock Interview

Practice Video Interview with JobPe AI

Start DevOps Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Virtusa logo
Virtusa

Information Technology and Services

Southborough

RecommendedJobs for You

andhra pradesh, india

bengaluru, karnataka, india

pune, maharashtra, india

andhra pradesh, india

chennai, tamil nadu, india