Database Administrator (MongoDB, MySQL, PostgreSQL)

Job Summary

We are seeking an experienced and versatile Database Administrator (DBA) to manage and optimize database systems across MongoDB, MySQL, and PostgreSQL platforms. The ideal candidate will ensure database availability, performance, security, and scalability while supporting business and application needs. This role requires expertise in all three database technologies and the ability to collaborate effectively with development and operations teams.

Key Responsibilities Database Administration

Install, configure, and upgrade MongoDB, MySQL, and PostgreSQL database systems.

Manage database instances, schemas, and objects (e.g., tables, indexes, views, collections).

Implement and enforce database standards and guidelines.

Monitor and optimize database performance, including query optimization, indexing strategies, and resource utilization.

Design, implement, and manage backup and recovery solutions.

Develop and test disaster recovery plans to ensure data integrity and availability.

Configure and maintain replication, clustering, and sharding setups for each database platform.

Plan and implement solutions for scalability and high availability.

Security and Maintenance

Implement database security measures, including authentication, access controls, and encryption.

Regularly apply updates and patches to address vulnerabilities.

Diagnose and resolve database-related issues, including connectivity, performance, and data integrity problems.

Set up and manage database monitoring tools and dashboards.

Develop automation scripts for routine maintenance tasks (e.g., Bash, Python).

Collaboration and Documentation

Collaborate with developers to design efficient database schemas and support application integration.

Review and optimize SQL and NoSQL queries.

Maintain detailed documentation for configurations, processes, and best practices.

Generate regular reports on database health, performance, and usage metrics.

Qualifications and Skills Required Skills

MongoDB:

Expertise in installation, sharding, replication, and monitoring.

Proficiency with tools like MongoDB Compass and Atlas.

Familiarity with NoSQL concepts and BSON data structures.

MySQL:

Experience with replication (master-slave, master-master) and clustering.

Proficiency with MySQL Workbench and related tools.

Strong understanding of InnoDB and MyISAM storage engines.

PostgreSQL:

Deep understanding of PostgreSQL architecture, including partitioning and parallel query execution.

Experience with extensions like PostGIS, PL/pgSQL, or logical replication.

Proficiency with tools like pgAdmin and psql.

General:

Strong skills in database query optimization, performance tuning, and index design.

Experience with backup, recovery, and disaster recovery solutions.

Knowledge of Linux/Unix systems and shell scripting.

Preferred Skills

Experience with database management in cloud environments (AWS RDS, Azure Database, GCP).

Familiarity with DevOps practices and infrastructure-as-code tools (e.g., Terraform, Ansible).

Education and Experience

Bachelor’s degree in Computer Science, Information Technology, or a related field.

7 to 11 years of hands-on experience managing MongoDB, MySQL, and PostgreSQL.

Relevant certifications (e.g., MongoDB Certified DBA, MySQL Database Administrator, PostgreSQL Professional Certification) are a plus.