Database Administrator

5 - 7 Years
- 1 Opening
- Trivandrum

**Role description**:
Database Administrator (MongoDB, MySQL, PostgreSQL)

**Job Summary**:
**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.
- 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
- 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.

**Skills**:
Database Administration,Mongodb,Mysql,Postgresql, Database Administrator - MongoDB, MySQL, PostgreSQL

**About UST**:
UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world’s best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future-proof philosophy, UST embeds innovation and agility into their clients’ organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact—touching billions of lives in the process.