Akshay Kumar

Highly skilled Oracle Database Administrator with 15+ years of experience specializing in Oracle 19c, RAC, Data Guard, RMAN, and performance tuning, seeking to leverage expertise in ASM, OEM, and cloud technologies to enhance database operations within Oracle Corporation. Aiming to optimize database patching, migration, and monitoring strategies while driving efficiency and reliability.

Oracle Database Administrator - Tricore (Rackspace India Private Limited)

(2010-01)

• Administered Oracle databases, overseeing high-end customer projects and providing guidance to team members.
• Executed database upgrades from 11g to 12c, 18c, and 19c, ensuring seamless transitions and minimal downtime.
• Orchestrated database migrations across diverse platforms, enhancing flexibility and infrastructure compatibility.
• Performed in-depth troubleshooting and performance tuning, optimizing database responsiveness and stability.
• Engineered multiple standby databases with cascade configurations, fortifying data protection and disaster recovery capabilities.
• Directed storage migrations from ASM to non-ASM environments achieving zero downtime, demonstrating expertise in complex storage solutions.
• Oversaw patching, scaling, and maintenance operations on Exadata and OCI environments, enhancing platform performance and security.
• Managed Amazon RDS and EC2 instances, coordinating patching and upgrades to maintain system integrity.
• Configured and maintained backup solutions, ensuring data integrity and availability through robust backup and recovery strategies.
• Deployed and configured ScienceLogic monitoring solutions, enhancing proactive system oversight and alerting.
• Implemented OEM Grid Control in active/passive configurations, ensuring continuous monitoring and management capabilities.
• Instituted auditing and fine-grained auditing mechanisms, strengthening data security and compliance measures.
• Conducted RMAN refreshes and refined recovery strategies, ensuring rapid data restoration in case of failures.
• Configured Data Guard Broker, facilitating efficient failover and switchover processes to minimize downtime.
• Executed comprehensive database health checks and generated orachk reports, ensuring database stability and optimal performance.
• Reviewed load testing and AWR reports, providing actionable insights for performance enhancement.
• Collaborated with customers on planning migrations and upgrades, delivering strategic guidance and support.
• Orchestrated failover and switchover scenarios, ensuring business continuity and minimizing disruptions.
• Contributed to business intelligence projects in data warehousing to empower data-driven decision-making.
• Participated in DR drill projects to validate and improve disaster recovery readiness.
• Managed projects spanning telecom, pharmaceutical, and banking domains, showcasing versatility in handling diverse industry needs.
• Managed OCI cloud database environments, performing migrations and applying patches to maintain security and performance.
• Managed Exadata environments, executing patching and database administration tasks to ensure peak operational efficiency.
• Served as team lead and mentor for golden gate projects and migrations, fostering knowledge sharing and skill development.

Engineer - Database Administrator - Wipro Infotech

(2006-08 - 2010-12)

• Administered database operations at the Customs Office of India (Delhi), employing various views for robust database monitoring.
• Conducted vigilant monitoring of alert logs and trace files, promptly addressing critical database incidents.
• Implemented database object creation routines enhancing database functionality and supporting application requirements.
• Utilized shell scripting for effective Oracle session tracing and database performance analysis.
• Oversaw object backup administration ensuring data integrity and disaster preparedness.
• Managed and monitored database link creation and management to maintain seamless data connectivity.
• Conducted index monitoring and rebuilding operations to optimize query performance and efficiency.
• Applied application patches meticulously, ensuring stability and security of database systems.
• Resolved database errors promptly maintaining system availability and performance.
• Executed comprehensive health checks and analyzed OS scripts identifying and addressing potential issues.
• Installed multiple Oracle versions on Solaris and Linux platforms, ensuring compatibility and performance.
• Developed a module to connect and backup MySQL database in Oracle providing seamless integration capabilities.
• Managed Oracle 8i Parallel Server with 2 nodes, improving database performance and reliability.
• Configured and tested Oracle 10g RAC on Solaris 10 improving high availability and scalability.
• Installed Oracle 10g on Linux cluster in active-passive configuration meeting high availability requirements.
• Configured load balancer and switchover on RAC ensuring continuous operation and minimal downtime.
• Developed and implemented RMAN backup scripts with Veritas Netbackup streamlining backup and recovery processes.
• Hardened Oracle production servers enhancing security and preventing potential threats.
• Conducted performance tuning and monitoring improving database efficiency and responsiveness.
• Developed backup automation scripts for Oracle Clusterware ensuring reliable system backups.
• Monitored Cluster, ASM, and Oracle services maintaining system health and reliability.
• Upgraded Oracle 10g RAC database enhancing database functionality and security.
• Applied patches to CRS and Oracle RAC addressing vulnerabilities and improving system performance.
• Migrated standalone DB to ASM instance improving storage management and performance.
• Executed RAC migrations seamlessly ensuring data integrity and minimizing downtime.
• Managed database operations at Oriental Bank of Commerce (Mumbai), performing monitoring, backup, troubleshooting, and reporting.
• Managed database tasks at Vijaya Bank (Bangalore), including monitoring, backup, patch application, index rebuilding, and troubleshooting.
• Managed FINNACLE application and report generation empowering informed decision-making.

Database Administrator - Tacker Technologies LTD

(2005-01 - 2006-07)

• Configured and installed Oracle databases, guaranteeing peak performance and data integrity.
• Executed seamless database upgrades and migrations utilizing import/export and upgrade assistant methodologies.
• Managed tablespace operations, including creation, resizing, and relocation to optimize data storage according to business requirements.
• Implemented user and role management processes, ensuring robust security and optimal resource allocation.
• Deployed auditing mechanisms using triggers and the FGA package to meet compliance and security requirements.
• Engineered monitoring and automation scripts which streamlined maintenance tasks and improved efficiency.
• Managed troubleshooting using alert and trace files, resolving any arising challenges or issues.
• Load balanced data via SQL Loader streamlining data integration and reducing turnaround times.
• Implemented robust database security strategies to ensure data confidentiality, integrity and availability.
• Configured listeners, optimizing database connection management, minimizing latency and downtime.
• Oversaw user-managed backup and RMAN strategies, guaranteeing data integrity across time with point in time and block-level recoveries.
• Implemented data import/export functions, moving data between users, tables or tablespaces, maintaining data access.
• Conducted data export/import between Excel, Access, SQL, and Oracle via ODBC and DSN, assisting in seamless dataflow.
• Utilized Statspack to construct, manage, and analyze reports promoting data-driven, informed decision-making.
• Verified data integrity by making use of DBVERIFY improving performance through database integrity.
• Set up clone environments, establishing seamless testing environments and backups, meeting backup goals.
• Maintained database operations providing smooth operational service while resolving user problems quickly.

Master of Computer Applications - Computer Applications - Manipal

Bachelor in Information Technology - Information Technology - IGNOU

Higher National Diploma in Computing - Computing - Edexcel International, London, UK

Matriculation - C.B.S.E. board at Bokaro Ispat Vidyalaya

Intermediate - C.B.S.E. board at Bokaro Ispat Vidyalaya