Dayal Singh

To work in a professional and challenging environment, while best utilizing my talent and keeping abreast with the latest technical advancement in Oracle Database Administration.

Having 4.8 years of experience as an Oracle database Administrator.

Having good knowledge in 10g,11g,12c & 19c Oracle Database Architecture.

Familiar with Tablespace level and user level Issues. Responsible for managing Storage/space (Tablespaces, Archive logs, FRA).

Experience in taking regular offline, online & logical backups. Experience in RMAN Backup & recovery skills.

Having experience in Performance tuning.

Experience in configuring Dataguard.

Switchover, Switchback, Failover, activating the standby to primary without data loss.

Database cloning using RMAN and manual method.

Experience in handling production support and maintenance as well.

Experience of database upgrading & migration.

Having experience in applying database patches.

Experience in working with ASM Instance & Disk Group.

Having expertise on installation & configuration Oracle Linux for Oracle Databases.

Installed, configured and maintained Oracle 11g & 19c Real Application Cluster RAC on Redhat Enterprise Linux.

• Oracle 10g/11g/12c/19c DBA, & Oracle RAC
• Windows 2008r2, Windows2012r2, OEL 5.x,6.x,7.x, Unix
• Oracle SQL, UNIX
• RMAN, expdp/impdp, Dataguard, NETCA, DBCA, Crsctl, Srvctl, Cluvfy, Asmca, DBUA

PROJEC0T-2, Oracle DBA,

Advanced Systems Laboratory (ASL) DRDO, Hyd India,

Om Systems & Services (P) Ltd. Hyderabad, 10/01/21, 04/01/24,

Supporting Database Server from Prod, Test, DEV, production system size varies from 5GB to 2TB.

Implementation, Administration, Maintains, Monitoring of operation database on different Oracle clusterware nodes.

Responsible for creating and efficiently managing large Database and its Application. Technical proficiency in handling Oracle DB related issues both in Production and non Production Environments. Configured listener by using NETCA. Having expertise schema user unlock / reset password.

Performing Logical Backups through Expdp and Impdp Utility.

Monitoring Database alerts and resolving as per SLA.

Planning and performing Daily, Weekly and monthly Cold and Hot Backups.

Excellent Team player with good communication.

Implement and maintain database security (Create and maintain users and roles, assign privileges.

Experience in refreshing oracle databases for development and testing.

Upgrade database using EXPDP/IMPDP from 11g to 19c.

Having expertise on oracle19c installation & configuration Oracle Linux for Oracle Databases.

Having experience on Installing Oracle Rac. Having experience on RAC.

PROJECT-1, Oracle DBA,

Telangana state government life insurance (TSGLI), Hyd,

Om Systems & Services (P) Ltd. Hyderabad, 08/01/17, 12/01/20,

Having experience an Oracle database Administrator.

Having expertise on installation & configuration Oracle Windows for Oracle Databases.

Having expertise on installation 11.1.0.7.0 database.

Having expertise on installation 11.2.0.1.0 database.

Having good knowledge in Oracle Database Architecture.

Experience in taking regular offline, online & logical backups.

Experience in handling production support and maintenance as well.

Monitoring Database alerts and resolving as per SLA.

Monitoring various database activities Alert log file, Trace files, Archive log files.

Performing Logical Backups through Expdp and Impdp Utility.

Adding datafiles to the tablespaces.

Managing tablespaces, users, roles.

Performing schema refresh as per user requirement.

Having expertise schema user unlock / reset password.

Configured listener by using NETCA.