Akshay Aware

About Akshay Aware

A multi-faceted professional with proven technical skills, seeking challenging and rewarding opportunities in Database Administration, specializing in Oracle DB, PostgreSQL DB, DB2, and MongoDB DB, within a highly reputable organization. A competent professional with 3+ years of extensive experience in Database Administration and Operations. • Proficient in executing daily DBA activities, including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, and sequences), space management, monitoring, and scheduling jobs. • Skilled in utilizing Oracle tools such as Import/Export, Data Pump, RMAN, and OEM Grid Control. • Backup & Recovery Expertise: • Configuring database archiving modes. • Performing Hot, Cold, and Logical backups. • Executing complete or incomplete recovery using user-managed backups. • Developing and implementing backup and recovery procedures using RMAN, Export/Import, and Data Pump utilities. • Proficient in maintaining Oracle Data Guard and devising strategic disaster recovery solutions using diverse recovery methods. • Strong knowledge of Hot/Cold backup, database recovery, and cloning using RMAN. • Extensive experience managing Oracle database environments (Oracle 10g, 11g, 12c, and 19c) in large-scale, mission-critical OLTP and OLAP systems. • Hands-on expertise in creating users, granting privileges and roles, and ensuring compliance with business requirements. • Proficient in scheduling database backups using the pg_dump utility based on organizational needs. • Adept in capacity planning and forecasting Oracle database growth to ensure optimal resource allocation. • Strong technical troubleshooting skills with experience consulting development teams and liaising with Oracle MOS to resolve high-priority service requests. • Experienced in generating and analyzing AWR reports for performance optimization. • Demonstrates excellent interpersonal, verbal, and written communication skills. A decisive problem-solver and critical thinker with strong testing and decision-making abilities.

Experience

1. Database Administrator

   Infosys

   Dec 2021 — Present

   A competent professional with 3+ years of extensive experience in Database Administration and Operations. • Proficient in executing daily DBA activities, including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, and sequences), space management, monitoring, and scheduling jobs. • Skilled in utilizing Oracle tools such as Import/Export, Data Pump, RMAN, and OEM Grid Control. • Backup & Recovery Expertise: • Configuring database archiving modes. • Performing Hot, Cold, and Logical backups. • Executing complete or incomplete recovery using user-managed backups. • Developing and implementing backup and recovery procedures using RMAN, Export/Import, and Data Pump utilities. • Proficient in maintaining Oracle Data Guard and devising strategic disaster recovery solutions using diverse recovery methods. • Strong knowledge of Hot/Cold backup, database recovery, and cloning using RMAN. • Extensive experience managing Oracle database environments (Oracle 10g, 11g, 12c, and 19c) in large-scale, mission-critical OLTP and OLAP systems. • Hands-on expertise in creating users, granting privileges and roles, and ensuring compliance with business requirements. • Proficient in scheduling database backups using the pg_dump utility based on organizational needs. • Adept in capacity planning and forecasting Oracle database growth to ensure optimal resource allocation. • Strong technical troubleshooting skills with experience consulting development teams and liaising with Oracle MOS to resolve high-priority service requests. • Experienced in generating and analyzing AWR reports for performance optimization. • Demonstrates excellent interpersonal, verbal, and written communication skills. A decisive problem-solver and critical thinker with strong testing and decision-making abilities.

Education

• Savitribai Phule Pune University

  Master's degree

  2020 — 2022