Database Administrator

Role Overview

We are looking for highly motivated Database Administrators with strong expertise in PostgreSQL, MongoDB, and SQL Server to manage, optimize, and secure our production database environments.

The ideal candidate should have hands-on experience in database administration, performance tuning, replication, backup & recovery, cloud infrastructure, and automation. The role requires close collaboration with Engineering, DevOps, Product, and Infrastructure teams to ensure highly available, secure, and high-performing database systems.

Key Responsibilities

Database Administration

• Install, configure, upgrade, and maintain PostgreSQL, MongoDB, and SQL Server databases.
• Design, implement, and manage highly available database architectures, including replication, clustering, failover, and disaster recovery.
• Configure and manage PostgreSQL Streaming Replication, Logical Replication, MongoDB Replica Sets, and Sharded Clusters.
• Perform database migrations across versions and platforms, including SQL Server to PostgreSQL migrations.
• Plan and execute database upgrades, patches, and maintenance activities with minimal downtime.

Performance Tuning & Optimization

• Monitor and optimize database performance across production environments.
• Analyze and optimize complex SQL queries, stored procedures, indexes, execution plans, and database statistics.
• Identify and resolve slow queries, locking issues, deadlocks, blocking sessions, and I/O bottlenecks.
• Perform database housekeeping activities such as VACUUM, ANALYZE, index maintenance, and statistics updates.
• Design efficient database schemas and indexing strategies to improve application performance.

Backup, Recovery & High Availability

• Design and implement robust backup and recovery strategies.
• Manage backup tools such as:
• pgBackRest
• pg_basebackup
• MongoDB Backup/Ops Manager
• Perform periodic backup validation and disaster recovery drills.
• Define and maintain RPO/RTO objectives for critical databases.
• Ensure business continuity through automated backup and failover mechanisms.

Monitoring & Reliability

• Implement proactive database monitoring and alerting.
• Monitor database health, replication lag, storage utilization, CPU, memory, and query performance.
• Utilize monitoring platforms such as:
• Prometheus
• Grafana
• PMM
• Nagios
• Zabbix
• Conduct regular health checks, capacity planning, and database audits.

Database Security

• Implement database security best practices.
• Configure authentication, authorization, role-based access control (RBAC), SSL encryption, and auditing.
• Ensure secure database access following the principle of least privilege.
• Perform regular security reviews and compliance checks.

Cloud Database Administration

• Manage databases hosted on AWS infrastructure.
• Optimize AWS database infrastructure for performance and cost.
• Support cloud-native database deployments and migrations.
• Collaborate with the DevOps team for infrastructure automation and provisioning.

Automation & Continuous Improvement

• Automate routine database administration tasks using Shell, Bash, or Python scripting.
• Develop automation for backups, health checks, maintenance, monitoring, and reporting.
• Contribute to Infrastructure as Code (IaC) initiatives where applicable.
• Identify opportunities to improve database operations through automation and standardization.

Collaboration

• Work closely with:
• Software Development Teams
• DevOps Engineers
• Product Teams
• Infrastructure Teams
• Business Analysts
• Support application deployments and production releases.
• Participate in production support, root cause analysis (RCA), and incident management.

Technical Skills

Mandatory Skills

Databases: PostgreSQL, MongoDB, SQL Server

Installation and configuration

• Replication
• Query optimization
• Index optimization
• VACUUM / ANALYZE
• Partitioning
• Backup & Recovery
• Performance tuning

MongoDB

• Replica Sets
• Sharding
• Backup & Recovery
• Performance tuning
• Authentication & Authorization
• MongoDB Compass
• MongoDB Atlas
• Ops Manager (Good to have)

AWS

Hands-on experience with:

• Amazon EC2
• Amazon EBS
• Amazon RDS (PostgreSQL)
• IAM
• CloudWatch
• S3
• AWS Backup

Performance & Troubleshooting

Strong knowledge of:

• Query optimization
• Execution plans
• Index management
• Locking
• Deadlocks
• Isolation Levels
• Statistics
• Memory tuning
• I/O optimization
• Capacity planning

Monitoring Tools

Experience with one or more:

• Prometheus
• Grafana
• PMM
• Nagios
• Zabbix

Scripting

Knowledge of:

• Shell Scripting
• Bash
• Python

Good to Have

• Terraform
• Docker
• Kubernetes
• CI/CD pipelines
• Git
• Linux Administration

Required Qualifications

• Bachelor's Degree in Computer Science, Information Technology, Engineering, or related discipline.
• B.E. / B.Tech / MCA

Experience Requirements

Database Administrator (3+ Years)

• Hands-on experience with PostgreSQL and MongoDB administration.
• Good understanding of SQL performance tuning.
• Experience in backup and recovery.
• Production database support.

Desired Competencies

• Excellent analytical and troubleshooting skills.
• Strong ownership and accountability.
• Ability to work in a fast-paced production environment.
• Excellent communication and stakeholder management skills.
• Team player with a continuous learning mindset.
• Strong documentation and process orientation.
• Flexible to support critical production activities and planned maintenance windows.

What You'll Achieve

• Highly available and resilient database infrastructure.
• Improved database performance and reduced query response times.
• Optimized cloud database costs.
• Reliable backup and disaster recovery processes.
• Enhanced database security and compliance.
• Automated database operations with reduced manual effort.