Database Admin

Database

• RDS MySQL
• MongoDB on EC2
• RDS PostgreSQL
  
  

Purpose

Transactional DB

Metadata DB for JBPM tool

Metadata DB for FormIO tool

Key Responsibilities

Database Management:

Manage AWS RDS MySQL, PostgreSQL, and MongoDB(on EC2)

databases in development, testing, and production environments. Perform database

maintenance tasks, including performance tuning, HA, backups, and disaster recovery

planning.

Performance Monitoring and Optimization: Monitor database performance, implement changes

and apply new patches and versions when required. Optimize database systems for

performance efficiency.

Security Management

Implement and maintain database security protocols to ensure data

integrity. This includes managing user access, setting up firewalls, and maintaining data

confidentiality.

Troubleshooting: Identify and troubleshoot database issues; ensure that all database systems

run smoothly and securely.

Collaboration and Communication: Work closely with Dev team and management to provide

technical support and to develop strategies for data acquisitions, archive recovery, and

implementation of a database.

Documentation

Create and maintain comprehensive documentation of procedures,

configurations, and troubleshooting guides related to the AWS RDS MySQL, PostgreSQL, and

MongoDB databases.

Required Skills

• Proven experience as a Database Administrator.
• Proficiency with AWS RDS MySQL, PostgreSQL, and MongoDB.
• Understanding of data backup, recovery, security,
• integrity and SQL.
• Familiarity with database design, documentation, and
• coding.
• Problem-solving skills
• Excellent communication and organizational skills.