· Worked in a heterogeneous, large-scale and high transactional DB's environment.· Technical analysis and design, including database design, planning and database normalization in microservice architecture.· Served as 24/7 on-call production support.· Migrated Databases to Open Source Solutions based on (MySQL, PostgreSQL)· Implemented proactive monitoring and wrote many scripts for database automatization (improved downtime by 70%).• Led the design and implementation of Oracle and PostgreSQL databases for diverse projects, translating business requirements into efficient database structures. Collaborated closely with development teams to ensure seamless integration of applications with databases.• Spearheaded performance optimization initiatives for Oracle and PostgreSQL databases, conducting in-depth analysis of query execution plans, identifying bottlenecks, and applying indexing and caching strategies. Achieved notable improvements in query response times, enhancing overall system efficiency.• Managed robust backup and recovery strategies for critical data assets in Oracle and PostgreSQL databases. Developed and maintained comprehensive backup plans, routinely validating restoration procedures to minimize downtime and data loss risks in case of unforeseen incidents.• Implemented stringent security measures in Oracle and PostgreSQL environments, ensuring data confidentiality, integrity, and availability. Oversaw user access controls, data encryption, and auditing mechanisms to align with industry standards and regulatory requirements, thereby enhancing data protection.· Resolved various database performance issues in all the levels (hardware, OS, database parameters, queries, blocks, latch and etc).

· Diverse in a heterogeneous environment (Oracle, MySQL, SQL Server, Postgres and MongoDB) comprising of over 300 databases with the larger databases including cloud-hosted database solutions in Azure, AWS.· Performed periodic refreshing/cloning of production databases to development & testing databases.· Maintenance of Physical and Logical Standby, backups for Disaster recovery and cluster for High availability.· Maintenance of Cluster Databases.

· Extensively worked on complete & incomplete recoveries of the databases including point in time recovery.· Worked with application developers to address and clarify data requirements to resolve technical and functional issues.· Securing confidential and personal data in databases.• Performed periodic refreshing/cloning of production databases to development & testing databases• Maintenance of Physical and Logical Standby, backups for Disaster recovery and cluster for High availability.• Maintenance Cluster Databases