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

Job Description :

• Role: MS SQL Server & MongoDB Database Administrator (AWS Cloud)
• We are seeking a highly skilled SQL Server Database Administrator with expertise in AWS cloud environments.
• The ideal candidate will have a deep understanding of SQL Server database administration,
• Cloud-native technologies, and strong hands-on experience managing databases hosted on
• AWS. This role involves ensuring the performance, availability, and
• Security of SQL Server databases in a cloud-first environment.

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.

Skills

• PRIMARY COMPETENCY : Data Engineering
• PRIMARY SKILL : Microsoft SQL Server APPS DBA
• PRIMARY SKILL PERCENTAGE : 70
• SECONDARY COMPETENCY : Data Engineering
• SECONDARY SKILL : MongoDB APPS DBA
• SECONDARY SKILL PERCENTAGE : 30