Job Title : Database : Type : Summary :
Database Administrator (DBA) with 3-5years of experience with strong expertise in MS SQL, MySQL and PostgreSQL, with a proven track record in database administration and 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 Skills :
- 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 inconsistencies
ref : hirist.tech)