Req ID- 19737 (8377)
Job Summary
We are seeking a highly skilled and experienced
Database Administrator (DBA)
with strong expertise in Microsoft SQL Server, NoSQL (MongoDB), and AWS cloud services. The ideal candidate will have 5+ years of experience managing enterprise-scale SQL and NoSQL databases, optimizing performance, ensuring security, and supporting highly available, cloud-based database architectures.
Key Responsibilities
- Design, implement, and maintain Microsoft SQL Server (on-prem and cloud) and AWS-managed databases (RDS, Aurora, DynamoDB, Managed Instance).
- Perform SQL Server and NoSQL (MongoDB) installations, upgrades, patches, migrations, and configuration management.
- Implement High Availability (HA) and Disaster Recovery (DR) solutions (Always-On, clustering, replication, multi-AZ/sharding).
- Monitor, analyze, and optimize database performance, indexing, query execution plans, and resource utilization.
- Troubleshoot and remediate database-related incidents, including participation in on-call support.
- Develop and implement robust backup, recovery, and archiving strategies to ensure data integrity and minimal downtime.
- Ensure database security and compliance by managing user access, encryption, IAM roles, and audit readiness.
- Collaborate with application development and DevOps teams to support schema design, database requirements, and automated deployments.
- Automate provisioning, patching, and monitoring tasks using scripts (Python, Bash, PowerShell) and IaC tools (Terraform, CloudFormation).
- Stay current with SQL Server, AWS, MongoDB, and emerging database/cloud technologies; recommend best practices for adoption.
- Develop and maintain procedures, standards, runbooks, and documentation for repeatability and compliance.
Required Qualifications
- Bachelor’s degree in Computer Science, Engineering, or related field.
- 5+ years of hands-on experience as a SQL Server DBA with expertise in installation, upgrades, migrations, backup/recovery, security, and performance tuning.
- Proven experience with NoSQL databases (MongoDB), including sharding, replication, and performance optimization.
- Strong experience managing databases on AWS (RDS, Aurora, DynamoDB, EC2, S3, CloudWatch, IAM).
- Solid knowledge of Microsoft SQL Server High Availability (Always-On) and clustering solutions.
- Strong knowledge of Windows Server, SQL Server internals, and AWS/Azure cloud platforms (Managed Instance, Storage, and security fundamentals).
- Proficient in SQL; working knowledge of Python (preferred) or other scripting languages.
- Strong problem-solving, troubleshooting, and analytical skills with the ability to resolve complex database issues.
- Excellent communication skills and ability to work both independently and in a collaborative team environment.
Preferred Qualifications
- Certifications: Microsoft SQL Server DBA, AWS Certified Database – Specialty, or equivalent.
- Hands-on experience with MongoDB Atlas and hybrid/multi-cloud environments.
- Familiarity with Infrastructure-as-Code (Terraform, Ansible, or CloudFormation).
- Experience in DevOps-oriented environments, supporting CI/CD pipelines and automated testing.
- Strong initiative, leadership, and ownership mindset.
