Database Administrator

Role & responsibilities

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 Qualification

Bachelors 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 ability to resolve complex database issues. Excellent communication skills and ability to work both independently and in a collaborative team environment.

Preferred QualificationCertifications:

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. 

3 must haves

DBA 4/5

SQL 4/5

AWS 3/5