Rosmerta Technologies - Database Administrator - MySQL PostgreSQL

Job Title : Database Administrator

Location : Gurugram

Job Type : Full-time

Job Summary

Database Administrator (DBA) with 5-7 years of experience with strong expertise in MS SQL, MySQL and PostgreSQL, with a proven track record in database administration and management.

Key Responsibilities

• Database Administration : Manage, maintain, and optimize MS SQL, MY SQL and PostgreSQL databases to ensure high availability and performance.
• Performance Monitoring : Continuously monitor database performance and implement tuning measures to enhance efficiency and reliability.
• Backup and Recovery : Develop and execute comprehensive backup and recovery strategies to safeguard data integrity.
• Security Implementation : Enforce database security protocols, including user access management and data encryption.
• Troubleshooting : Identify and resolve database-related issues, including performance bottlenecks and connectivity problems.
  
  

• Install, configure and maintain database of MS SQL, MySQL, PostgreSQL etc. and maintain required documentation.
• Thorough knowledge of SQL Server configuration, High availability configuration, and setting up the environment
• Plan, schedule and manage the implementation of new databases and modifications to existing databases in a manner that avoids disruption to production and development systems.
• Ensure that the database design supports the application requirements, including performance and scalability and is properly configured for optimal performance.
• Ensure the implementation of solutions for database replication, clustering, and high availability to ensure minimal downtime.
• Plan and design failover and load balancing for high-availability environments.
• Expertise in upgrading and migrating databases to Cloud environment
• Hands on experience in Performance Tuning and Query Optimization and should have good understanding on Indexing, Partitions, and different storage engines available under MySQL
• Implement backup strategies and ensure backups are performed regularly.
• Develop and test disaster recovery plans to restore data in case of failure or data corruption.
• Ensure databases are protected from data loss and downtime.
• Ensure monitoring database performance and proactively identifying performance issues, Optimize queries, indexes, and database structure to improve performance.
• Ensure Database Maintenance and regularly perform maintenance tasks such as reindexing, updating statistics, and purging old data.
• Ensure data integrity through routine checks and troubleshooting data (ref:hirist.tech)