Job Title      : MS SQL Server & MongoDB Database Administrator (AWS Cloud) 
Experience  :  Years
Location      : Bangalore

Job Description :

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 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.

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 Certified: Azure Database Administrator Associate.

Educational Qualification:
•    Bachelor’s degree in computer science, Information Technology, or a related field.