Job
Description
Role:MSSQL 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 SystemsManager. 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 Bachelors 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
