Job
Description
Job Title:MS SQL Server & MongoDB Database Administrator (AWS Cloud) Experience:Years Location:Bangalore : Key Responsibilities: Hands-on expertise in data migration between databases on-prem to Mongo Atlas. Experience in creating clusters, databases and creating the users. SQL Server AdministrationInstall, configure, upgrade, and manage SQL Server databases hosted on AWS EC2, RDS. AWS Cloud IntegrationDesign, deploy, and manage SQL Server instances using AWS services like RDS, EC2, S3, CloudFormation, and IAM. Performance TuningOptimize database performance through query tuning, indexing strategies, and resource allocation within AWS environments. High Availability and Disaster RecoveryImplement and manage HA/DR solutions such as Always On Availability Groups, Multi-AZ deployments, or read replicas on AWS. Backup and RestoreConfigure and automate backup strategies using AWS services like S3 and Lifecycle Policies while ensuring database integrity and recovery objectives. Security and ComplianceManage database security, encryption, and compliance standards (e.g., GDPR, HIPAA) using AWS services like KMS and GuardDuty. Monitoring and AutomationMonitor database performance using AWS CloudWatch, SQL Profiler, and third-party tools. Automate routine tasks using PowerShell, AWS Lambda, or AWS Systems Manager. CollaborationWork closely with development, DevOps, and architecture teams to integrate SQL Server solutions into cloud-based applications. DocumentationMaintain thorough documentation of database configurations, operational processes, and security procedures. Required Skills and Experience: 6+ years of experience in SQL Server database administration and 3+ years of experience in MongoDB administration. Extensive hands-on experience with AWS cloud services (e.g., RDS, EC2, S3, VPC, IAM). Proficiency in T-SQL programming and query optimization. Strong understanding of SQL Server HA/DR configurations in AWS (Multi-AZ, Read Replicas). Experience with monitoring and logging tools such as AWS CloudWatch, CloudTrail, or third-party solutions. Knowledge of cloud cost management and database scaling strategies. Familiarity with infrastructure-as-code tools (e.g., CloudFormation, Terraform). Strong scripting skills with PowerShell, Python, or similar languages. Preferred Skills and Certifications: Knowledge of database migration tools like AWS DMS or native backup/restore processes for cloud migrations. Understanding of AWS security best practices and tools such as KMS, GuardDuty, and AWS Config. Certifications such as AWS Certified Solutions Architect, AWS Certified Database Specialty, or Microsoft CertifiedAzure Database Administrator Associate. Educational Qualification: Bachelor’s degree in computer science, Information Technology, or a related field.
