SQL Server & MongoDB DBA

Altumind Digital Consulting LLP; Bengaluru; On-site; INR 1,000,000 - 2,000,000; Full time

Job summary

Altumind Digital Consulting LLP is seeking a seasoned SQL Server DBA with hands-on experience in data migration from on-prem to cloud-based Mongo Atlas environments. The role emphasizes AWS-hosted SQL Server administration, performance tuning, and security/compliance management.

You will work with cross-functional teams to design, implement, and automate scalable database solutions, ensuring high availability and disaster recovery in AWS, while maintaining thorough documentation and best

Qualifications

• Experience migrating data from on-prem databases to Mongo Atlas.
• Experience with SQL Server administration on AWS infrastructure.
• Knowledge of HA/DR solutions in AWS.
• Experience with backup, security, and compliance (GDPR, HIPAA) on AWS.

Responsibilities

• Monitor database performance and tuning efforts within AWS environments.
• Collaborate with development, DevOps, and architecture teams to integrate SQL Server solutions into cloud-based applications.
• Document configurations, processes, and security procedures.
• Automate routine tasks using PowerShell, Lambda, or Systems Manager.

Skills

Data migration

SQL Server Administration

AWS Cloud Integration

Performance Tuning

HA/DR planning

Backup and Restore

Security and Compliance

Monitoring and Automation

Collaboration

Documentation

Tools

AWS EC2

RDS

S3

CloudFormation

IAM

KMS

GuardDuty

SQL Profiler

PowerShell

AWS Lambda

Systems Manager

AWS CloudWatch

Job description

Hands-onexpertisein data migration between databases on-prem to Mongo Atlas.

Experience in creating clusters, databases and creating the users.

SQL Server Administration:Install, configure, upgrade, and manage SQL Server databases hosted on AWS EC2, RDS.

AWS Cloud Integration:Design, deploy, and manage SQL Server instances using AWS services like RDS, EC2, S3, CloudFormation, and IAM.

Performance Tuning: Optimize database performance through query tuning, indexing strategies, and resource allocation within AWS environments.

High Availability and Disaster Recovery:Implement and manage HA/DR solutions such as Always On Availability Groups, Multi-AZ deployments, or read replicas on AWS.

Backup and Restore:Configure and automate backup strategies using AWS services like S3 and Lifecycle Policies while ensuring database integrity and recovery objectives .

Security and Compliance:Manage database security, encryption, and compliance standards (e.g., GDPR, HIPAA) using AWS services like KMS and GuardDuty .

Monitoring and Automation:Monitor database performance using AWS CloudWatch, SQL Profiler, and third-party tools. Automate routine tasks using PowerShell, AWS Lambda, or AWS Systems Manager.

Collaboration:Work closely with development, DevOps, and architecture teams to integrate SQL Server solutions into cloud-based applications.

Documentation: Maintain thorough documentation of database configurations, operational processes, and security procedures.