Software Engineer-Oracle-MySQL

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