Oracle + MySQL - Chennai, Tamil Nadu, India - GAVS Technologies

GAVS Technologies

Verified Company

Chennai, Tamil Nadu, India

2 weeks ago

Posted by:

Deepika Kaur

beBee Recuiter

Description

Job Posted On

:02:55

Experience Required

7 years

Location

Chennai, Tamil Nadu, India (CHN)

Job Summary

MySQL + Oracle

SQL / MySQL Database Administration:
Deploy, configure, and manage MySQL database servers in high availability environments, ensuring optimal performance and reliability.

Design and implement database schema, indexing strategies, and partitioning to optimize query performance and enhance scalability.

Develop and maintain database backup and recovery procedures, including regular backups, point-in-time recovery, and disaster recovery planning.

Perform database performance tuning and optimization, including query optimization, resource utilization analysis, and database cache management.

Monitor database health and performance metrics, identify bottlenecks, and implement corrective actions to ensure optimal database performance.

Implement and manage database security measures, including user access controls, authentication mechanisms, and data encryption.

Provide expert support for production Application databases with respect to availability, reliability, and integrity.

Provide expert support for Applications databases in the development and test environments.

Work with Application developers and their logical data models, create physical Application database designs which conform to industry standards (e.g., data normalization), optimize performance, and efficiently utilize disk space, size tables, and indexes for production implementation based on projected row counts provided by Applications.

Create complex new databases and Application database objects (e.g., tables, indexes, procedures), and as requirements change, update data structures/objects in existing databases.

Coordinate production database deployment including tasks to promote database objects between environments (e.g., test to production) in support of Application requirements.

Provide technical leadership to Application developers in database capabilities and features, build efficient queries, database design, Application database Problem Resolution, and the use of database utilities.

Determine and implement appropriate Application database backup and recovery strategies, including decisions regarding frequency of backup and procedures for recovering Application database changes.

Perform production database recovery when necessary.

Key Responsibilities:
Lead, mentor, and manage a team of database engineers, promoting a culture of

excellence.

Design, implement, and manage Oracle databases, ensuring their

performance, availability, and security.

Conduct performance tuning, backup, and disaster recovery operations.

Collaborate with other teams to optimize database performance and integration.

Establish and enforce database development standards and best practices.

Monitor database performance metrics and adjust configurations as necessary.

Provide technical leadership in database strategy, including architecture, design, and

scalability.

Stay updated on the latest industry trends and technologies related to Oracle databases.