Database Administrator - MySQL/MongoDB

Job Description :

Database Management :

- Monitor database performance and ensure its stability, reliability, and availability.

- Ensure data security, including user access and data encryption.

- Manage and monitor database backups and data restoration processes.

Performance Tuning :

- Optimize MongoDB and MySQL queries and database configurations to improve performance.

Data Restoration :

- Perform routine data restoration tests to ensure data recoverability.

Database Design and Development :

- Implement indexing and schema changes based on application requirements.

Security and Compliance :

- Ensure compliance with industry standards and regulations, including GDPR.

Documentation :

- Create and maintain disaster recovery plans and procedures.

Automation :

- Ensure automation is in place for daily DB archival and restoration along with relevant teams

- Develop ETL jobs for data management, fine tune ETL queries and have relevant alerts in place

Monitoring and Alerts :

- Respond to and resolve alerts related to database performance and security.

Database Upgrades :

- Plan and execute database system upgrades and patches.

Collaboration :

- Collaborate with cross-functional teams to support application development and deployment.

- Provide technical guidance and support to developers and stakeholders.

Qualifications :

- Proven experience as a Database Administrator (DBA) with expertise in MySQL and MongoDB.

- Strong knowledge of database design, implementation, and optimization.

- Experience with data backup and restoration techniques.

- Familiarity with database security and compliance standards.

- Proficiency in writing and optimizing SQL queries.

- Solid understanding of automation tools and scripting languages.

- Excellent problem-solving skills and attention to detail.

- Strong communication and collaboration abilities.

Education And Certifications :

- Bachelor's degree in Computer Science, Information Technology, or a related field (preferred).

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