Database Administrator (DBA)

Mostedge; Ahmedabad District, Vadodara; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Mostedge is seeking an experienced Database Administrator to design, implement, and optimize relational (MSSQL, PostgreSQL) and NoSQL (MongoDB) databases, on‑premises and in cloud environments.

You will ensure data integrity, security, availability, and performance across platforms, with cloud services (AWS/Azure/GCP), automation scripts, and close collaboration with DevOps and software teams. Experience with backup/DR, monitoring, and scripting (PowerShell, Bash, Python) is preferred.

Qualifications

• Bachelor's degree in CS/IT or related field.
• 5+ years of production DBA experience.
• Experience with MSSQL, PostgreSQL, MongoDB.
• Cloud DB services experience (AWS RDS, Azure, GCP).

Responsibilities

• Install, configure, and upgrade database servers (MSSQL, PostgreSQL, MongoDB).
• Monitor performance, optimize queries, and tune databases.
• Implement clustering, replication, and high availability.
• Manage cloud DB services and automate backup, failover, patching, scaling.
• Ensure secure access, encryption, and compliance in the cloud.
• Develop scripts for automation and DevOps/CI-CD pipelines.
• Collaborate with developers and operations; provide 24/7 support for critical issues.

Skills

DBA experience

On-call support

Collaboration with DevOps

Performance tuning

Scripting/automation

Education

Bachelor's degree in CS/IT or related field

Tools

MSSQL Server

PostgreSQL

MongoDB

MongoDB Atlas

AWS RDS

Azure SQL

GCP Cloud SQL

Terraform

Ansible

Kubernetes

Git

CI/CD pipelines

PowerShell

Bash

Python

Prometheus

Datadog

New Relic

Zabbix

Job description

Job Summary

We are seeking an experienced and highly motivated Database Administrator (DBA) to join our team. The ideal candidate will be responsible for the design, implementation, performance tuning, and maintenance of relational (MSSQL, PostgreSQL) and NoSQL (MongoDB) databases, both on-premises and in cloud environments (AWS, Azure, GCP). You will ensure data integrity, security, availability, and optimal performance across all platforms.

Key Responsibilities

Database Management & Optimization

• Install, configure, and upgrade database servers (MSSQL, PostgreSQL, MongoDB).
• Monitor performance, optimize queries, and tune databases for efficiency.
• Implement and manage database clustering, replication, sharding, and high availability.

Cloud Database Administration

• Manage cloud-based database services (e.g., Amazon RDS, Azure SQL Database, GCP Cloud SQL, MongoDB Atlas).
• Automate backup, failover, patching, and scaling in the cloud environment.
• Ensure secure access, encryption, and compliance in the cloud.
• ETL and Dev Ops experience is desirable.

Backup, Recovery & Security

• Design and implement robust backup and disaster recovery plans.
• Regularly test recovery processes to ensure minimal downtime.
• Apply database security best practices (roles, permissions, auditing, encryption).

Scripting & Automation

• Develop scripts for automation (using PowerShell, Bash, Python, etc.).
• Automate repetitive DBA tasks using DevOps/CI-CD tools (Terraform, Ansible, etc.).

Collaboration & Support

• Work closely with developers, DevOps, and system admins to support application development.
• Assist with database design, indexing strategy, schema changes, and query optimization.
• Provide 24/7 support for critical production issues (on-call rotation may apply).

Key Skills & Qualifications

• Bachelors degree in computer science, Information Technology, or related field.
• 5+ years of experience as a DBA with production experience in:
• o MSSQL Server (SQL Server 2016 and above)
• o PostgreSQL (including PostGIS, logical/physical replication)
• o MongoDB (including MongoDB Atlas, replica sets, sharding)
• Experience with cloud database services (AWS RDS, Azure SQL, GCP Cloud SQL).
• Strong understanding of performance tuning, indexing, and query optimization.
• Solid grasp of backup and restore strategies, disaster recovery, and HA setups.
• Familiarity with monitoring tools (e.g., Prometheus, Datadog, New Relic, Zabbix).
• Knowledge of scripting languages (PowerShell, Bash, or Python).
• Understanding of DevOps principles, version control (Git), CI/CD pipelines.

Preferred Qualifications

• Certification in any cloud platform (AWS/Azure/GCP).
• Microsoft Certified: Azure Database Administrator Associate.
• Experience with Kubernetes Operators for databases (e.g., Crunchy Postgres Operator).
• Experience with Infrastructure as Code (Terraform, CloudFormation).