SUMMARY

• 9.6 years of experience in Information Technology as an Oracle Database Administrator.
• Handling Oracle 10g/11g/12C and 19c database installation, duplication, Migration, upgrade, cloning and patching,
• Performing High Availability using Oracle Data Guard configuration, Active Dataguard, VCS and RAC on Linux servers
• Supervised DBA Team of 10 and oversaw database operations.
• Coordinator and ‘Point of Contact’ for Database Migrations, Oracle Quarterly Patching implementations, Disaster recovery Planning, Shipping Vessel DB administration and Offshore - Onshore coordinator.
• Coordinator for SOX Database compliance and maintenance.
• Active member in Technical panel of TechMahindra Talent Acquisition Board.
• Strong interpersonal, time management and organizational skills. Proven team player with strong ability to multitask.
• Maintain databases on RAC, Veritas Cluster Server (OS Cluster) and Active Dataguard for High Availability purpose.
• Handling database on ASM(Automatic storage management).
• Performance and load testing of databases, resolve performance issues as needed.
• DBA support for ODI, Sieble and EBS application databases.
• Knowledge on MS SQL Server Database Administration.
• 24x7 on-call Production support for database activities.

TECHNICAL SKILLS

Databases: Oracle 10g, 11g and 12C, 19C

Languages: SQL, PL/SQL and C++

Operating Systems: Linux, HP-UX and Sun Solaris.

Tools: & Utilities: OEM, SQLDeveloper, expdp/impdp,DataPump,Remedy,Exceed

Automation: Ansible, Shell scripting

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

RESPONSIBILITIES:

• Performing oracle software installations and cloning.
• Performing of Databases migration across platform from on-prem Linux servers to Linux servers on Microsoft Azure Cloud.
• Performing database version upgrade from OracIe11.x to 12.y, Oracle 12.x to 12.y and 12c to 19c databases.
• Performing databases creation and decommissioning of databases as per the need basis.
• Planning and implementing the Backup strategy using RMAN, Hot backup, Cold Backup
• Database cloning from Production to Test and Development environments.
• Migrating database across different platforms/servers using export, import, Datapump and RMAN utilities.
• Performing of Databases migration across platform (SUN to Linux, HP to Linux) and on same platform using datapump.
• Applying Patches (Oracle PSU) on 10g,11g, 12c and 19c oracle homes using Opatch utility on every quarter release.
• Performing database schema refreshes using exp/imp and Datapump from one to another database.
• Performing restore and recover database until time/sequence using cold/hot and RMAN backup.
• Performing DR site using OracIe11g, 12c and 19c Standby/Dataguard for high availability/disaster recovery purpose and working on DR snap mirroring concepts.
• Moving standby database from one server to another server as per the need basis.
• Monitoring and Resolving Performance Tuning issues as needed.
• Databasemonitoring and tuning, application and queries using AWR, ASH, ADDM, OEM and custom scripts.
• Oracle 10g/11i/12C/19c RAC, Standby Database, Advanced Replication, Oracle Streams, Clustering and Data Guard Setup, Automatic Storage Management and Configuration and Tuning and Materialized Views
• OEM maintenance and Upgrade on 13c cloud control.
• Checking Alert log, trace files to fix the issue encountered in the standalone/DG databases.
• Monitoring production Database and standby databases and ensuring DG is in sync.
• Conversion of Database in Archive Log / No Archive Log Modes.
• Registering databases with respective catalog recovery database.
• Adding additional space or datafiles to the existing tablespaces for resolving space issues.
• Provide support for new and existing applications and utilities.
• Performance and load testing of database as needed.
• Analysis and documentation of the current issues and architecture.

Confidential

Oracle DBA

RESPONSIBILITIES:

• Supporting more than 1000+ databases over 250+servers.
• Handling 24*7 Alerts and resolving the issues.
• Performing databases creation and decommissioning of databases.
• Participated in ‘Proof of Concept’ for Data Domain Configurations for database backups and implemented successfully in project by coordinating with Team.
• Participated in ‘Proof of Concept’ for ‘Veritas Cluster’ and implemented successfully in project by coordinating with Team.
• Dedicated DBA support for shipping Databases which is a separate wing of database support in Confidential .
• Point of Contact for SOX compliance databases maintenance.
• Participating in ‘Proof of Concept’ for Veeam backup configurations which is still in progress.
• Participating in ‘Proof of Concept’ for ‘Oracle Patch Automation using Ansible’ which is still in progress.
• Experienced in Planning and implementing the Backup strategy using RMAN, Hot backup, Cold Backup
• Database cloning from Production to Test and Development environments.
• Performing database version upgrade from 10.x to 10.y, 10.x to 11.y, 11.x to 11.y and 12.x to 12.y and 12c to 19c
• Migrating database across different platforms/servers using export, import, Datapump and RMAN utilities.
• Experience of Databases migration across platform (from SUN to Linux, HP to Linux) and also on same platform using datapump.
• Oracle 10g/11i/12C/19c RAC, Standby Database, Advanced Replication, Oracle Streams, Clustering and Data Guard Setup, Automatic Storage Management and Configuration and Tuning and Materialized Views
• Monitoring and Resolving Performance Tuning issues.
• Applying Patches (Oracle PSU) on 10x, 11x and 12C oracle homes using Opatch utility on every quarter release.
• Performing database schema refreshes using exp/imp and Datapump from one to another database.
• Performing restore and recover database until time/sequence using cold/hot backup.
• Implemented DR site using Oracle10g, 11g and 12C Standby/Dataguard for high availability/disaster recovery purpose and working on DR snap mirroring concepts.
• Moving standby database from one server to another server as per the need basis.
• Checking Alert log, trace files in order to fix the issue encountered in the standalone/DG databases.
• Monitoring production Database and standby databases and ensuring DG is in sync.
• Conversion of Database in Archive Log / No Archive Log Modes.
• Registering/Unregistering databases with respective catalog recovery database.
• Adding additional space or datafiles to the existing tablespaces for resolving space issues.
• Experience on doing recovery with offline and online backups as part of disaster recovery test for every quarter.
• Working with UNIX team for Health check of servers.
• Monitoring all reports on daily basis.
• Handling server outage working with UNIX team and application teams.
• Experience over oracle RDBMS relinking after OS maintenance.
• Regular monitoring of the database and Troubleshooting the errors and Space Management in the Database.
• Regular Monitoring of error logs, Database status, available free spaces to avoid the failure of applications.
• Interacting with the support teams so dat the database environment is always available without any downtime.
• Secure the database environment following the Information Security and Standards of client.

Confidential

Oracle DBA

Responsibilities:

• Created users & privileges with appropriate roles and levels of security.
• Creation of Database links.
• Maintaining the Cold and Hot backups of the databases.
• Performing Logical backups using Export utility and recovering specific object or schema using Import utility.
• Monitoring and performing daily incremental backups, weekly backups using RMAN.
• Troubleshooting performance issues reported by the Application Team.
• Backup of the Production & Development Databases based on business requirements.
• Schema, Table, Database refreshes on demand for development teams.
• Interaction with client/users on various issues.
• Extensive experience in supporting Production and Development environments.
• Creating and managing standby databases at remote location using Dataguard technology.
• Working under the environment of 24X7 DBA support.
• Monitoring the CPU usage, IO statistics, and CPU time to identify any OS level Performance killers.
• Resolving complex backup and recovery issues.
• Working under the environment of 24X7 DBA support.
• Provided Training to New bees to Confidential Satyam for Oracle DBAs.