Database Administrator (MongoDB & PostgreSQL)

Job Requirements

• 6–10 years of experience in MongoDB and PostgreSQL database administration in enterprise environments.
• Strong hands on experience with database installation, configuration, patching, upgrades, migrations, and maintenance.
• Expertise in MongoDB Replica Sets, Sharding, Cluster Management, and Performance Optimization.
• Experience with PostgreSQL Replication, Partitioning, High Availability, and Disaster Recovery solutions.
• Strong knowledge of database backup, restore, recovery procedures, and business continuity planning.
• Experience with query tuning, indexing strategies, capacity planning, and performance troubleshooting.
• Strong understanding of database security, access control, encryption, auditing, and compliance requirements.
• Experience with Linux administration, Shell/Python scripting, and automation of database operations.
• Experience managing databases in AWS, Azure, or GCP cloud environments.
• Strong analytical, troubleshooting, and problem solving skills in production support environments.

Key Responsibilities

• Install, configure, administer, and maintain MongoDB and PostgreSQL databases across development, testing, and production environments.
• Monitor database performance, availability, storage utilization, and proactively address system bottlenecks.
• Configure and manage replication, clustering, sharding, failover, and high availability architectures.
• Perform database backup, restoration, recovery testing, and disaster recovery activities.
• Optimize database performance through query tuning, indexing, configuration improvements, and capacity planning.
• Manage user access, database security policies, encryption standards, and compliance controls.
• Troubleshoot production database issues, perform root cause analysis, and implement preventive measures.
• Collaborate with application development, infrastructure, DevOps, and cloud teams for database support activities.
• Develop and maintain database operational procedures, architecture documentation, and runbooks.
• Participate in production support rotations and contribute to continuous improvement initiatives.