Software Engineer-Oracle-MySQL

Prodapt Solutions; Chennai District; On-site; INR 800,000 - 1,500,000; Full time

Job summary

Prodapt Solutions seeks a skilled database administrator in Chennai, India, to manage MySQL and Oracle databases. This role requires expertise in installation, performance optimization, and security compliance. You'll ensure data integrity and efficient backup processes while collaborating with support and development teams for database solutions.

Key responsibilities include monitoring database performance, managing user access, and supporting incident resolution. The position offers opportunities for professional growth and a chance to work with cutting-edge technologies.

Qualifications

• Experience in managing MySQL and Oracle databases.
• Strong understanding of database backup and recovery processes.
• Ability to monitor and optimize database performance.

Responsibilities

• Assist in the installation and maintenance of MySQL databases.
• Monitor database health and performance metrics.
• Manage backup, recovery, and replication tasks.

Skills

MySQL

Oracle Administration

Database Optimization

AWS RDS

Security Compliance

Job description

Overview

My SQL:

Database Installation Maintenance

Assist in the installation, basic configuration, and patching of MySQL instances.

Perform routine database maintenance tasks, including index optimization and table defragmentation (OPTIMIZE TABLE).

Execute minor version upgrades and engine maintenance for AWS RDS instances.

Performance Monitoring Optimization

Monitor core database metrics (CPU, Memory, Connections, and I/O) to ensure high availability and scalability.

Identify slow-running queries using the Slow Query Log and provide initial analysis to developers for tuning.

Track storage growth and manage disk space to prevent Disk Full incidents in both on-premise and AWS environments.

Backup, Recovery Replication

Verify the success of daily backups (using mysqldump, mysqlpump, or Percona XtraBackup) and perform routine restore tests.

Monitor MySQL replication lag and status (SHOW REPLICA STATUS) to ensure data consistency across clusters.

Respond to automated alerts and incidents promptly to minimize downtime and meet SLAs.

Security Compliance

Manage user accounts, grants, and password policies to ensure data confidentiality and integrity.

Implement predefined security measures and audit user access in accordance with company standards.

Ensure SSL/TLS certificates are updated and encrypted connections are enforced where required.

Collaboration Documentation

Partner with L1/L2 Support teams to resolve escalated connectivity and performance tickets.

Document all configuration changes, incident post-mortems, and How-To guides for the internal knowledge base.

Collaborate with development teams to implement schema changes and basic database design improvements.

Oracle Administration Maintenance

• Install, configure, and upgrade Oracle database software.
• Apply quarterly patches for Grid and Oracle home
• Configure and maintain standby database.
• Monitor database performance and implement optimization strategies.
• Ensure database security and compliance with organizational policies.
• Perform regular backups and recovery operations.
• Collaborate with developers to design and implement database solutions.
• Troubleshoot and resolve database-related issues promptly.
• Develop and maintain database documentation and standards.
• Plan and execute database migrations and upgrades.
• Setup Oracle golden gate both uni-directional and bidirectional.
• Maintain Oracle Golden Gate synchronization with source.
• Identify the Oracle Golden Gate sync related issues and implement the best practices.
• Identify the performance issues and implement the best practices.
• User creation and access management.
• Storage capacity planning to ensure ASM and tablespace were maintained under threshold and avoided repetitive space related incidents.
• Create and maintain RAC with Data guard.
• Administration of RAC database.
• AWS RDS instance administration, Rehydration, engine upgrade and certificate renewal