Apps Associates - Database Administrator -

Key Responsibilities :

- Database Installation & Configuration : Install, configure, and upgrade MySQL and Oracle database software across various environments.

- Backup & Recovery : Implement, test, and manage comprehensive backup and recovery strategies for both MySQL and Oracle databases to ensure data integrity and business continuity.

- Performance Tuning : Monitor database performance, identify bottlenecks, and perform expert-level tuning for both MySQL and Oracle to optimize query execution and overall system responsiveness.

- Monitoring & Troubleshooting : Set up and maintain database monitoring tools, proactively identify issues, and rapidly troubleshoot and resolve database-related problems.

- High Availability & Disaster Recovery : Implement and maintain high availability solutions (e.g., Oracle Data Guard, MySQL Replication, AlwaysOn) and disaster recovery procedures.

- Security Management : Implement and enforce database security best practices, user access controls, and auditing policies.

- Patching & Upgrades : Plan and execute database patching, version upgrades, and migration activities with minimal downtime.

- Capacity Planning : Monitor database growth and provide recommendations for capacity planning.

- Scripting & Automation : Develop and maintain scripts for database automation, routine tasks, and reporting.

- Collaboration : Work closely with development teams, system administrators, and application support to ensure database support for critical business Skills & Qualifications :

- Bachelor's degree in Computer Science, Information Technology, or a related field.

- 3 to 5 years of hands-on experience as a Database Administrator for both MySQL and Oracle RDBMS.

- Strong expertise in MySQL database administration, including replication (Master-Slave, Group Replication), performance tuning, and troubleshooting.

- Strong expertise in Oracle RDBMS administration, including Oracle RAC, Data Guard, ASM, RMAN, and performance tuning (AWR, ADDM).

- Proficiency in SQL and PL/SQL for Oracle.

- Experience with database monitoring tools.

- Familiarity with cloud database services (e.g., AWS RDS, Azure Database for MySQL/Oracle) is a plus.

- Strong scripting skills (Shell, Python, or Perl).

- Excellent analytical and problem-solving skills

(ref:hirist.tech)