Database Administrator (DBA)

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).