Sofia Bhanu Pattan

• Working in a 24x7 production environment with a team of 8+ members.
• Worked on various database versions of Oracle (10g/11g/12c) on Linux/windows platform.Working experience in Oracle 12c, 19c DATAGUARD, ASM, and RAC.
• Configuring the database parameters, creation, reorganization, extending tablespaces, network services, administer database security, create users, grants/revoke roles, privileges, extended database storage capacity, performance, and monitor, reduce db fragmentation, manage database-related files (datafiles, onlinelogs, controlfiles & archive logs), rebuilding indexes.
• RMAN configuration (Backups, Cloning, Catalog, Auxiliary, Recovery etc.).
• Planning and scheduling Backups Logical Backups (Datapump utilities), RMAN.
• Perform database cloning based on schedules (RAC to RAC, non-RAC to RAC).
• Dumping the data from Prod to Dev or Test environments using Data pump and Database Links.
• Applying security patches like PSU, CPU, RU patches using Opatch utility.
• Hands-on experience in configuring Physical Standby Servers.
• Worked on archive gap issues.
• Perform DR-Drill (Switchover & Switchback) activity (Between Production & Standby).
• Perform role transactions using the manual method, Dataguard broker.
• Monitoring/Administrating RAC instances using SRVCTL, CRSCTL and OCRCONFIG.
• Performed ASM alias creation and adding disks to existing diskgroups.
• Troubleshooting various database level errors with the help of Oracle support.
• Resolving any performance issue related to the database & instances.
• Monitoring and tuning of databases using AWR, ASH, ADDM, tkprof and other utilities.
• Working with application teams in order to enhance the performance of the database with the help of AWR, Explain plan and other performance reports.
• Implementing new environments and changes as per the change management process.
• Installed, configured and maintained PostgreSQL 11,12 and 13 versions.
• Creation of databases, Tablespaces, schemas, users.
• Experience on database creation manually and DBCA.
• Experience in handling of tablespace management, user management and Undo management
• Supported the OS patching on Sybase
• Worked on Blocking and log utilization
• Installing and configuring sybase servers
• Adding users and giving /modifying permissions
• DBCC checks
• Patching activity on failover mode and start and stop the services on server level
• Granting and revoking permissions to the users.
• Taking backup of the system tables (bcp in/out)
• Transaction log full , backups, reorgs, troubleshooting the issues based on the alert.
• Designation: DBA
• Operating system: Linux, windows
• Databases: 12c, 19c, UDB, SYBASE, SQL

Organization 2:

Designation : DBA

Operating system : Linux,windows

Databases : 12c,19c, UDB,SYBASE,SQL

Responsibilities:

v Working in a 24x7 production environment with a team of 8+ members.

v Worked on various database versions of Oracle (10g/11g/12c) on Linux/windows platform.Working experience in Oracle 12c, 19c DATAGUARD, ASM, and RAC.

v Configuring the database parameters, creation, reorganization, extending tablespaces, network services, administer database security, create users, grants/revoke roles, privileges, extended database storage capacity, performance, and monitor, reduce db fragmentation, manage database-related files (datafiles, onlinelogs, controlfiles & archive logs), rebuilding indexes.

v RMAN configuration (Backups, Cloning, Catalog, Auxiliary, Recovery etc.).

v Planning and scheduling Backups Logical Backups (Datapump utilities), RMAN.

v Perform database cloning based on schedules (RAC to RAC, non-RAC to RAC).

v Dumping the data from Prod to Dev or Test environments using Data pump and Database Links.

v Applying security patches like PSU, CPU, RU patches using Opatch utility.

v Hands-on experience in configuring Physical Standby Servers.

v Worked on archive gap issues.

v Perform DR-Drill (Switchover & Switchback) activity (Between Production & Standby).

v Perform role transactions using the manual method, Dataguard broker.

v Monitoring/Administrating RAC instances using SRVCTL, CRSCTL and OCRCONFIG.

v Performed ASM alias creation and adding disks to existing diskgroups.

v Troubleshooting various database level errors with the help of Oracle support.

v Resolving any performance issue related to the database & instances.

v Monitoring and tuning of databases using AWR, ASH, ADDM, tkprof and other utilities.

v Working with application teams in order to enhance the performance of the database with the help of AWR, Explain plan and other performance reports.

v Implementing new environments and changes as per the change management process.

v Installed, configured and maintained PostgreSQL 11,12 and 13 versions.

v Creation of databases, Tablespaces, schemas, users.

v Experience on database creation manually and DBCA.

v qExperience in handling of tablespace management, user management and Undo management

v Supported the OS patching on Sybase

v Worked on Blocking and log utilization

v Installing and configuring sybase servers

v Adding users and giving /modifying permissions

v DBCC checks

v Patching activity on failover mode and start and stop the services on server level

v Granting and revoking permissions to the users.

v Taking backup of the system tables (bcp in/out)

Transaction log full , backups, reorgs, troubleshooting the issues based on the alert

• Working in a 16x5 production environment with a team of 12+ members.
• Managed over 200+ Oracle databases (including production and non-production environments) from 2 GB to 80 TB in size.
• Working experience in Oracle 19c DATAGUARD, ASM, and RAC.
• Configuring the database parameters, creation, reorganization, extending tablespaces, network services, administer database security, create users, grants/revoke roles, privileges, extended database storage capacity, performance, RMAN monitor, reduce db fragmentation, manage database-related files (datafiles, onlinelogs, controlfiles & archive logs), rebuilding indexes.
• RMAN configuration (Backups, Cloning, Catalog, Auxiliary, Recovery etc.).
• Planning and scheduling Backups Logical Backups (Datapump utilities), RMAN.
• Perform database cloning based on schedules (RAC to RAC, non-RAC to RAC).
• Dumping the data from Prod to Dev or Test environments using Data pump and Database Links.
• Applying security patches like PSU, CPU, RU and Combo patches using Opatch utility and opatchauto.
• Hands-on experience in configuring Physical Standby Servers for high availability.
• Worked on archive gap issues.
• Perform DR-Drill (Switchover & Switchback) activity (Between Production & Standby).
• Perform role transactions using the manual method, Dataguard broker.
• Monitoring/Administrating RAC instances using SRVCTL, CRSCTL and OCRCONFIG.
• Performed ASM alias creation and adding disks to existing diskgroups.
• Performed storage migrations as per schedules and monitor rebalance operations.
• Troubleshooting various database level errors with the help of Oracle support.
• Resolving any performance issue related to the database & instances.
• Monitoring and tuning of databases using AWR, ASH, ADDM, tkprof, explain plan and other utilities.
• Working with application teams in order to enhance the performance of the database with the help of AWR, Explain plan and other performance reports.
• Implementing new environments and changes as per the change management process.
• Managing snapshot backups and restore if needed.
• Worked on OEM agents install and upgrades and fixing issues with agent and targets configuration.
• Worked on defragmentation and released space from ASM to save storage cost to client as a cost saving activity and performance improvements.
• Worked on performance issues which faced by application team and do recommend best methods to improve performance.
• Designation: Oracle Database Administrator
• Operating system: Linux
• Client: TCS