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.

Required 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