Highly skilled and experienced Database Administrator with a proven track record of
successfully managing and optimizing Oracle, MySQL, and SQL Server databases. Proficient in database design, implementation, maintenance, and troubleshooting. Adept at developing and implementing robust backup and recovery strategies, ensuring data integrity and system reliability. Strong analytical and problem-solving skills and a commitment to delivering exceptional database solutions.
Oracle Database Management includes (installation, configuration, backup, and recoveryvia RMAN, Data Guard, RAC, Database Security, Database Upgrade, Database migration,troubleshooting, and developer end support etc).
MySQL Database Management includes (installation, configuration, backup, and recoveryvia mysqldump,xtrabackup, and mysqlbackup, Database Security, Database replicationusing Binary log position or using GTID, and developer end support, etc).
SQL Database Management includes (installation, configuration, backup, and recovery viaMaintenance plan or T-SQL, Database Security (login, users, server roles, database roles),Database replication, and developer end support, etc).
EBS Administration R12.2 with DB 11g to 19c includes ( installation, Application patchingvia ADOP utility, Cloning, Upgrading, Backup/ Recovery, Performance issues andTroubleshooting). SSO implementation on EBS (OUD, OAM, DIP, MSAZURE AD).
Oracle Utilities Application Framework (OUAF) based environments (WAM, C2M, MDM,CCB) installation, administration, patching, cloning, upgradation, backup and recovery, andtroubleshooting.
Oracle Cloud Infrastructure: OCI Identity and Access Management, OCI Storagemanagement, Instance OS Hardening (Vulnerabilities scanning), Configuring NLB (NetworkLoad Balancer) for instances, Configuring Bastion Host for instances, JCS (Java CloudInstance) provision, instance patching, instance start/stop, and Troubleshooting JCSstartup issues. Analytics instance provisioning, Configuring PAC (Private Access Channel)for OAC, PAC connectivity issues with private end data sources for Analytics instance. VCN(Virtual Cloud Network) provision and ManagingSL (Security List) of subnets for instanceaccess. OCI notification and alarm services. Oracle Integration instance administration etc.
· Oracle 11g/12c/18c/19c Database installation & Administration on Linux & Windows
· EBS Administration R12.1. R12.2 with DB 11g to 19c
· Oracle Data Guard Configuration and Management
· Oracle OBIEE 12.2.1.3/12.2.1.4 Installation and Management
· Application patching via ADOP utility, Patching and Issue resolutions
· Installation, Cloning, Patching, Upgrading, Backup/ Recovery
· Core Database Management (Installation, Backup Recovery, Upgrade)
· Apache Tomcat Installation and Management
· Database Health check reports like AWR, ADDM
· OBIEE Installation and Configuration
· Samba configuration with Linux
· Shell Scripting
· Data pump (import & export)
· Virtualization ESXI
· Connecting Oracle to no-oracle databases (Gateways)
· SQL Server Installation, management, backup etc.
· Oracle Apex 5.1 & 11gR1, Oracle Apex 19.2 & 12c
· Oracle APEX+ BI+ Apache Tomcat + ORDS Configuration for HIMS,
· Support to Custom Build Health Management Information System
· Oracle Apex with ORDS configuration
· Assisting Technical and Functional Team Over ERP & Apex Development
· Plan and implement the synchronization of data across several developments, testing and production environments; evaluate the merits/ benefits of available system upgrades and enhancements.
· Monitor performance and manage parameters to provide fast query responses to 'front end' users.