• Optimized database operations for multiple projects, ensuring optimal performance and high availability across non-production and production environments.• Led the administration, design, and support of multiple Oracle databases (12c, 19c) and NoSQL clusters (Cassandra, Redis, Elasticsearch) on Linux platforms within hybrid and multi-cloud environments (AWS, Azure, Mirantis, RedHat Cloud), including ASM administration.• Successfully managed and maintained a complex database infrastructure, leading migrations between cloud platforms with minimal downtime, ensuring seamless business operations.• Streamlined database maintenance processes, including ASM storage management, resulting in a 20% reduction in overall downtime and enhanced efficiency in routine tasks such as backups, (PSU/RU) patching, and upgrades.• Achieved high availability, data protection, and maximum availability by installing and maintaining physical dataguard with DG broker and fast-start failover.• Successfully implemented Goldengate replication from Oracle to Oracle and Oracle to Big Data.• Improved database performance using AWR, ADDM, and AWR SQL reports, resulting in optimized system performance.• Established and managed Cassandra, Redis, and Elasticsearch database clusters, including backup processes, node decommissioning and commissioning, and node upgrades.• Performed root cause analysis and deep impact analysis of problems, providing effective technical solutions.• Developed and enhanced procedures for monitoring and proactive intervention, preventing customer impact.• Collaborated with cross-functional teams to design and optimize database schemas and queries, enhancing application response time and user experience by 30%.• Configured crontab and wrote shell scripts to automate routine database activities, increasing operational efficiency.• Followed release management, change management, and quality assurance standards to maintain high-quality database operations.

Responsible for supervising Oracle databases across various versions, from 8i to 11g, on the Unix platform. Successfully conducted upgrades, including 2-Node RAC with ASM administration, physical dataguard, and single instances, transitioning from 10g to 11g across diverse platforms, collectively encompassing terabytes in size. Achieved recognition and recommendation from my Head of IT and my direct reports, leading to my promotion to Associate Vice President - ITKey Responsibilities:• Expertly created and maintained databases, ensuring optimal performance and reliability.• Applied Oracle software patches to maintain and enhance system integrity and security.• Monitored space usage, job schedules, and database performance to ensure efficient operations.• Conducted database tuning based on regular checks and monitoring, optimizing system performance.• Troubleshoot issues on a reasonable endeavor basis, minimizing downtime and ensuring smooth operations.• Performed proactive performance tuning using AWR Reports, significantly improving database speed.• Executed database reloads, export/import operations, and RMAN backups to safeguard data integrity.• Seamlessly replicated standby databases with live databases, ensuring high availability and data redundancy.• Installed and managed Dataguard (Physical) to ensure robust disaster recovery solutions.• Implemented, configured, and managed RAC (2-node) databases, enhancing system scalability and reliability.• Upgraded standalone and RAC Oracle databases, ensuring up-to-date and secure environments.• Configured crontab and developed shell scripts to automate routine activities, improving operational efficiency.• Applied patches to live databases, incorporating feature enhancements, bug fixes, and data corrections.• Assisted developers and other teams with Oracle database questions, fostering collaboration and knowledge sharing.

Tasked with overseeing AT&T Mobility and Telkom SA projects, involving the administration and management of Oracle databases (10g) for non-production and production environments. These databases, spanning multiple terabytes, operated on Unix platforms. Additionally, I was assigned to client sites in Dallas, USA, and Pretoria, South Africa, to carry out project responsibilities.Achievements:• Promoted to the position of Senior DBA by virtue of sheer hard work and perseverance.• Recognized and appreciated by the Team Leader and Project Manager for increasing the process compliance of the project.Key Responsibilities:• Created and maintained databases, ensuring optimal performance and reliability.• Applied Oracle software patches to maintain system integrity and security.• Monitored space usage, job schedules, and database performance to ensure efficient operations.• Conducted database tuning based on regular checks and monitoring.• Troubleshoot issues on a reasonable endeavor basis, minimizing downtime.• Managed tablespaces to ensure data availability and system efficiency.• Addressed alerts promptly, taking necessary actions to resolve issues.• Performed performance tuning on queries to enhance efficiency.• Executed backup and restore operations to safeguard data integrity.• Conducted remote RMAN backups to secure data offsite.• Configured crontab and wrote shell scripts to automate routine activities.• Assisted developers and other teams with Oracle database questions and issues, fostering collaboration and knowledge sharing.

Deployed at Client Side [ 3i-infotech Ltd, International Data Center Chennai ]. In charge of managing Oracle databases (10g), including Oracle RAC, and implementing physical dataguard configured on Solaris platform for projects - Oriental Insurance Company Ltd (OICL), Star health Insurance Ltd in International Data Center. Led the initial stages of critical projects for Shri Ram General Insurance Co. LTD (India), Amana Takaful Insurance (Sri Lanka), and Royal Insurance Corporation Bhutan Limited (Bhutan). Databases were of size ranging from gigabytes to terabytes.Key Responsibilities Across Projects:• Monitored space usage, job schedules, and database performance to ensure efficient operations.• Conducted database tuning based on regular checks and monitoring, optimizing performance.• Troubleshoot issues on a reasonable endeavor basis, minimizing system downtime.• Administered and troubleshot Oracle RAC environments and ASM storage, ensuring high availability and efficient resource utilization.• Performed proactive performance tuning using AWR Reports, enhancing database speed.• Managed database security, safeguarding sensitive information.• Documented database and system configuration changes for accurate records.• Analyzed weekly status, monitored trends, and provided actionable insights.• Executed backup and restore operations, ensuring data integrity and availability.• Replicated standby databases with live databases, ensuring high availability.• Applied patches to live databases, including feature enhancements, bug fixes, and data corrections.• Reloaded databases and performed export/import operations as necessary.• Conducted remote RMAN backups, securing data offsite.• Installed and managed Dataguard (Physical) for data redundancy and disaster recovery.• Configured crontab and developed shell scripts to automate routine activities.• Coordinated with clients, providing exceptional support and addressing their requirements.

As a PHP developer, developed e-commerce websites using PHP, JavaScript, HTML and MySQL database.