SUMMARY

• Around 8+ years of experience as an Oracle Database Administrator having hands on experience in database administration and performed different tasks like installation, configuration, upgrades, patches, performance tuning, backup and recovery, production support, cloning, space management, database security.
• Experience in Installation of Oracle Real Application Cluster (RAC) with ASM and manage RAC instances using CRSCTL and SRVCTL Utility.
• Configured multiple database instances using ASM instance.
• Troubleshoot performance issues for the RAC instances.
• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle clusterware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files. Also used the Merge backup for backing terabyte databases. Issues with block change tracking & also flash recovery area.
• Providing DBA support to multiple Cluster, Non Cluster and ASM Database in production, development and Testing Servers in UNIX, AIX & Windows Environments.
• Resolved/Diagnose Node Eviction.
• Upgrade of 11g R2 RAC to 12c R2 RAC
• Add or Remove Node from RAC.
• Implemented & configuring replication technology using Dataguard & Oracle Goldengate installation.
• Installation, Configuration and Maintenance of Logical/Physical standby databases in Data guard.
• Implemented Dataguard with maximum availability, protection and performance configurations and worked with Dataguard Fail over and Switch over cases.
• Database replication using snapshots, materialized views, import/export and advanced replication methods like Oracle Goldengate.
• Resolving the issues in conflicts between the target and source database in Goldengate.
• Implemented Bi - Directional replication in Goldengate.
• Experience in Installation, Configuration and Monitoring of Oracle Server on UNIX, Linux, AIX and Windows Environments.
• Experience in monitoring and managing of Oracle instances using Enterprise Manage Grid Control (OEM Grid) 10g/11g/12c
• Performed Migration and Upgradation of databases to 12c and 11g.
• Experience in Construction of Catalog Databases and developed scripts to perform Backups using RMAN.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery and disaster recovery.
• Installation and configuration of Recovery Catalog for multiple Databases.
• Experience in taking logical backup of the database using DATAPUMP (Expdp/Impdp).
• Experience in Oracle Patching for 10G, 11G and 12C.
• Supporting a production environment as necessary.
• Experience in SQL tuning using Explain Plans and Hints.
• Experience in Performance Tuning for better performance. Identifying bottlenecks with memory and disk contentions.
• SQL script creation and tuning.
• Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM) reports.
• Experience in UNIX Bash Shell Scripting.

TECHNICAL SKILLS

Databases: Oracle 12c, 11gR2, SQL Server 2005 and 2008

Oracle Products: OEM (Oracle EnterpriseManager), RMAN, OEM 12CSQL*Loader, Import and Export (EXPdp/IMPdp), ASM, TKPROF, SRVCTL, SQL* LoaderAnd SQL * Net.

Operating System: RHEL 4, RHEL 5, OEL 4, WIN NT/2003/2008, Solaris 10HP-UX Itanium, IBM AIX

Languages: SQL, PL/SQL, UNIX Shell Scripting.

Other Tools: TOAD, Putty, SQL Developer, Erwin.

PROFESSIONAL EXPERIENCE

Confidential, VA

Oracle DBA

Responsibilities:

• Ensure high availability and performance (24 hrs production support).
• Ongoing proactive database-level performance tuning and Pro-actively monitor database systems to ensure secure services with minimum downtime.
• Experience in setting up FLYWAY configuration.
• Worked and have experience on setting up the DELPHIX environment for the databases
• Monitored system resource availability and responded to system memory and data issues.
• Develop stored procedures, database triggers and SQL queries where needed.
• Interacting with development teams, business owners, and various levels of management
• Provide 24/7 support for the applications and taking the responsibility for ON CALL.
• Taking care of the production tickets/defects and solving problem with in time frame with accurate decisions and identifying the root cause and fixing the same.
• Enforced need of regular data purging processes from production, design and development, to deployment.
• Manage all database objects in a large mission critical system and able to provide end to end DBA support system and application side.
• Analyze and resolve complex technical problems regarding the integration of object-oriented applications and infrastructure with relational database technology.
• Changes were made dynamically whenever possible to fulfill high-availability requirements.
• Responsible for implementation and release of database changes as submitted by the development team.
• Working on the regular tickets as per the requirement.
• Experienced in managing space issues in the Database Level for table space and Regular file system cleanup at UNIX level.
• Responsible for monitoring database, diagnosing errors, building, deploy, maintain and trouble shoot database objects.
• Coordinate all Oracle system changes with the Operational DBA teams.
• Work with DBA’s and Data architects to plan and implementing appropriate data partitioning strategy for an Enterprise Data Warehouse.
• Managed appropriate use of free space within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.

Environment: Oracle /11g/12c RAC,GoldenGate,Exadata, RDBMS, RMAN, Data Guard, Erwin Data Modeler, shell scripting, 12c and 11G OEM Grid control.

Confidential, Dallas, TX

Oracle DBA

Responsibilities:

• Ensure high availability and performance (24 hrs production support).
• Ongoing proactive database-level performance tuning and Pro-actively monitor database systems to ensure secure services with minimum downtime
• Manage all database objects in a large mission critical system and able to provide end to end DBA support system and application side.
• Analyze and resolve complex technical problems regarding the integration of object-oriented applications and infrastructure with relational database technology.
• Work with DBA’s and Data architects to plan and implementing appropriate data partitioning strategy for an Enterprise Data Warehouse.
• Changes were made dynamically whenever possible to fulfill high-availability requirements.
• Responsible for implementation and release of database changes as submitted by the development team.
• Interacting with development teams, business owners, and various levels of management.
• Coordinate all Oracle system changes with the Operational DBA teams.
• Develop stored procedures, database triggers and SQL queries where needed.
• Enforced need of regular data purging processes from production, design and development, to deployment.
• Responsible for two critical online applications db’s performance which have a huge business/revenue impact.
• Taking care of the production tickets/defects and solving problem with in time frame with accurate decisions and identifying the root cause and fixing the same.
• Managed appropriate use of free space within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
• Monitored system resource availability and responded to system memory and data issues.

Environment: Oracle 10g/11g RAC,GoldenGate,Exadata, RDBMS, RMAN, Data Guard, Erwin Data Modeler, RHEL 4.x, 5.x, shell scripting, Oracle 9i, 10G, and 11G OEM Grid control.

Confidential, Dayton, OH

Oracle DBA

Responsibilities:

• Installed Oracle DB 10g, 11g RDBMS, RAC on ASM, Applying Oracle Critical patch updates, Implementing and Manage Data Guard, Replication, Backup and Recovery support and performance tuning etc.
• Installed Grid Infrastructure Software on new Linux Servers for 2 node and 3 node RAC and Failover environments and Oracle Grid Control11g Installation.
• Migrated Non-ASM databases to ASM environment for high availability using RCONFIG.
• Worked on OEM 12C grid for monitoring the Listeners present in the oracle environment.
• Worked in troubleshooting RAC and implemented ASM features.
• Applied necessary Patches during installation and also in up-gradation of databases.
• Applied necessary Patches during installation and also in up-gradation of databases.
• Installation and configuration of Goldengate on 11g database for the Bi-directional replication.
• Resolving the issues in conflicts between the target and source database in Goldengate.
• Well Experienced in taking Cold Backup for a very huge 15-Tb Database.
• Daily backups using RMAN.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities and Performed database refresh activities for business requirement and tuning purposes.
• Having good experience in user management, Table space Management, Session Management, undo Management issues.
• Installed 12c agents on hosts and discovered targets. Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and disaster recovery databases.
• Involved and Upgraded Analytical Databases from 10g to 11g.
• Installation and configuration of Goldengate on 11g database for the Bi-directional replication.
• Develop new and support existing ETL processes using industry leading ETL or customization tools.
• Resolving the issues in conflicts between the target and source database in Goldengate.
• Involved in deploying new application and setting up replication between the databases using Goldengate
• Handy in utilizing Datapump tool for exporting and importing the data between databases.
• Used Datapump for schema refresh, and RMAN for database refresh and used RMAN for backing up databases
• Well Experienced in taking Cold Backup for a very huge 15-Tb Database.
• Daily backups using RMAN.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities and Performed database refresh activities for business requirement and tuning purposes.
• Having good exposure in user management, Table space Management, Session Management, undo Management issues.
• Experienced in managing space issues in the Database Level for table space and Regular file system cleanup at UNIX level.
• Generated AWR, ADDM and ASH reports for database issues
• Installed 12c agents on hosts and discovered targets.
• Created new Groups, Templates, and Incident Rule sets in OEM 12C.
• Designed and tested patching through OEM 12C.

Environment: Oracle 10g, 11g, Oracle Enterprise Manager, EXADATA X2-2, ASM, AIX, Golden Gate, Database Control, TOAD, OEM 12c, ASM, AIX, Golden gate, Tivoli

Confidential, Pittsburgh, Pennsylvania

Oracle DBA

Responsibilities:

• Experience with Oracle 10g/11g grid control.
• Upgraded database from Oracle 9i to 10g and 10g to 11g, having a good exposure on Oracle11g.
• Prepared a step-by-step installation document for the 11g RAC on Linux operating system.
• Installation and configuration of Oracle 11g RAC 2 node on Linux.
• Experience with Oracle 10g/11g grid control.
• Migrated Non-ASM databases to ASM environment for high availability on 11g.
• Implemented Dataguard with maximum availability, protection and performance configurations and worked with Dataguard Fail over and Switch over cases.
• Configured and implemented Oracle Goldengate replication.
• Implemented Backup & Recovery using RMAN, Hot and Cold backups.
• Taking the RMAN incremental and cumulative backups.
• Scheduling the databases backup using Cron tab.
• Involved in Database and Transaction log Backups and Restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them as required and Create Database users and roles and implement appropriate user security.
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
• Monitoring the Oracle Instances, Users, Tables, Table spaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs and Alerts.
• Actively involved in validation of the data files using DB Verify Utility. In order to solve Block corruption Errors.
• Involvement in space management, rectification of lock problems, managed quotas.

Environment: Oracle 10g, 11g, SQL, Oracle Grid Control, Oracle Enterprise Manager, Database Control, TOAD, OEM 12c, ASM, AIX, Goldengate.

Confidential, New Orleans, LA

Oracle DBA

Responsibilities:

• Involved in gathering user Requirements, application design, and analysis of hardware requirements to meet business needs.
• Configuration of system to achieve High Availability, Load balancing and automatic fail over functionality.
• Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
• Taking the RMAN incremental and cumulative backups.
• Install, upgrade and maintain Oracle 10g on Sun Solaris and Windows 2003
• Implementing Database Security, Management of role-based security.
• Applying Patches 10.2.0.1 and applying Oracle DST Patches on Oracle database.
• Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup.
• Cloning of databases from production to test environments.
• Periodic data refresh from production to testing environments, Re-organizing database structures etc.
• Scheduling the databases backup using Cron tab.
• Extensive experience in RMAN recovery in RAC and stand alone database.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases.
• Implemented Dataguard with maximum availability, protection and performance configurations and worked with Dataguard Fail over and Switch over cases at the times of up-gradation and migration.
• Monitoring the Oracle Instances, Users, Tables, Table spaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs and Alerts.
• Creation of Users and granting them the required Roles and Privileges accordingly.
• Involvement in space management, rectification of lock problems, managed quotas.

Environment: Oracle 10g, 11g, SQL, Oracle Grid Control, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, Red Hat Enterprise Linux, ASM.

Confidential

Oracle DBA/Developer

Responsibilities:

• Involved in Installation and customization of Databases (10g&9i).
• Involved in Schema management, Table space Management, User Creation.
• Monitoring the Extraction and loading processes of Data.
• Upgraded and applied patches as and when required. Database Refreshes from Prod to Dev. Troubleshooting Day-to-Day Users Issues in various modules.
• Responsible for Oracle implemented backups like LOGICAL & PHYSICAL i.e. Export & import and also having experience with EXPDP & IMPDP
• Evaluated the hardware requirements before upgrading/migrating the database.
• Good experience with recovery managed backups i.e. RMAN
• Migrated the database from non-Oracle to Oracle i.e. SQL Server to Oracle.
• Maintained and audited Application and data servers.
• Documented the complete project including all pre installation, post installation and database configuration steps.
• Manage users, privileges, profiles, and schemas.
• Experiences in using automatic monitoring and management processes like batch processing using Crontab for processes like import, export databases.
• Used analyze table, analyze indexes to tune queries and increase performance.
• Tuning Oracle 9i database servers using tools dynamic, dictionary views, Stats pack, ADDM, AWR Diagnostic and tuning packages.

Environment: Toad, Oraclecle9i/10g, Linux, AIX5.1, Hp-UX, Sun Solaris, SQL, PL/SQL, Shell Scripting.

Confidential

Oracle DBA

Responsibilities:

• Involved in monitoring the Database related activities using Oracle Enterprise Manager 10g Grid Control (OEM Grid) and monitoring the backup jobs scheduled in OEM Grid.
• Configured and implemented Oracle 10g Dataguard for Database disaster recovery.
• Performed oracle Database data refreshes using export/import from production to test Servers.
• Involved in performance tuning by general health checks and maintenance for Database using AWR and ADDM reports by finding wait events.
• Performed logical backup of the database and Schemas using DATAPUMP (Expdp/Impdp) as per the requirement.
• Involved in implementation and support of 10g migrations and upgrades from Oracle 9i and 10g databases on HP-UX and Linux.
• Involved in applying CPU and PSU patches for Oracle Server.
• Involved in writing UNIX Shell Scripts for maintains tasks for oracle database.
• Worked on Data modeling Using Oracle SQL Developer Data Modeler.
• Configured and implemented Oracle Goldengate replication.
• Involved in PL SQL programming and Performance tuning for oracle Database by generating AWR and ADDM reports
• Performed Database activities using Integrated Development tools like SQL Developer and TOAD.
• Involved in creating Change Request and Service Requests and resolving database issues with Oracle support
• Configuration of Listener and Net Service names using NETCA.
• Created, monitoring database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Cloned schemas, objects and data on new server using Datapump.
• Created, monitoring database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Creation of Users and granting them the required Roles and Privileges accordingly.
• Configuration of Listener and Net Service names using NETCA.

Environment: Oracle 10g/11g, Linux, SQL Server 2008, Oracle Enterprise Manager Database Control, RDBMS, TOAD, PL/SQL, Shell Scripting, ASM, Data guard.