Senior Database Administrator

• Jan 2022 - Present

Senior IT Operations Specialist

• Dec 2020 - Feb 2022

Database Administrator, Oracle, Postgresql, MS SQLServer, Exadata, RAC, Dataguard, Performance tuning, backup (Commvault). Database Administrator, Oracle, Postgresql, MS SQLServer, Exadata, RAC, Dataguard, Performance tuning, backup (Commvault).

Project Lead, Oracle Apps DBA

• Jan 2017 - Dec 2020

Oracle Certified Professional 12c, Oracle certified RAC implementation specialist. AWS certified solution architect associate.Oracle OCI Architect Professional 2019.Oracle EBS (install, upgrade 12.0.x to 12.2.x, patch), ADOP, adpatch.Weblogic 12c.OEM 13c.RAC 12c, DataGuard,Golden Gate 12c,Oracle Database on AWS cloud (IaaS).

Oracle Apps DBA

• Jul 2012 - Dec 2020

Install, maintenance, patching, upgrade, troubleshooting and other managed services for Oracle Database (9i,10g,11g), Oracle RAC, Oracle E-Business Suite (11i, R12), Oracle Application server (forms and Report - 10g/11g). Install Weblogic Server (11g).

Oracle DBA

• Jan 2010 - Jun 2012

• Installing Oracle 9i/10g/11g on Linux/Windows Platform. • Creation of Databases • Creating roles and Managing roles. • Monitoring databases for OS space, db files sizes, Listeners etc. • Monitoring alerts (session lock, space issues, backup job, archives). • Creating and monitoring the tablespaces and Datafiles., allocating tablespaces for users. • Cloning of Databases by using hot & cold backup. • Exporting and Importing database backups using Exp & Imp and EXPDP/IMPDP utilities. • Creating and managing database objects like tables, views, and indexes. • Creating users with restricted access with required privileges. . • Managing user privileges, schema management. • Creating profiles and attaching them with users and monitoring the users. • Configuring and managing backup & recoveries through RMAN utility. • Performing offline and online backup & recoveries. • Strong understanding of UNIX concepts • Applying of various Patches • Upgrading the Database from one release to another and from one version to another • Installation of Data guard standby database • OEM Grid control installation and administration. • Oracle Grid infrastructure / RAC 10g/11g administration and Installation and Upgradation. • Adding/Removing Nodes to Cluster, Migrating Single node to RAC database and vice-versa. • Oracle Applications Installation (single node and multi-node), cloning and Patching • Code migration • Have good knowledge of Unix Shell Scripting • Migration of Database from MS SQL Server 2008 / 2008 R2 to Oracle 10g/11g • Have good knowledge of Red Hat Enterprise Linux administration. Show less