SUMMARY

• 9+ years of hands - on experience on Oracle 9i, 10g, 11g and 12c database and Oracle EBS 11i and R12 administration.
• Excellent work ethic with ability to work alone and in a team environment.
• Good knowledge and experience in Upgrade of Oracle E-Business Suite from 11i to R12, last done was R12.2.4.
• Experience with 10g/11g/12c OEM, GRID Control and RAC Databases including installation, configuration, run-time monitoring and administration, patching and upgrading.
• Hands on experience of database performance tuning including RAC and SQL tuning experience with 10g R2 /11g/12c RAC scalability, HA, robustness and load balancing.
• Extensive working experience with 9i and 10g, 11g, 12c DATAGUARD/active DG to administrate both standby databases including installation, configuration, run-time monitoring and administration, performance tuning and troubleshooting.
• 6+ years of experience on Exadata administration experience including providing advice and guidance for Disaster Recovery strategies for Database machines. Providing and implementing performance and tuning recommendations. Providing upgrades and patching for Exadata storage servers and InfiniBand switches or so.
• 3 years hand-on experience for Oracle Golden Gate for data replication for enterprise data centers including installation, configuration, administration, performance monitoring.
• Extensive working experience on business continuality including setup of database redundancy with RAC, active DG, enterprise database replication with golden gate, database DR to provide backup recovery strategies using Oracle ZFS and NetApp DR backup/recovery strategies to practice database DR restore and recovery to achieve minimum system down time..
• Experience in Performing DB upgrades from 9i to 10g (10.2.0.4) and 11.2.0.2 to 11.2.0.4. Latest done to 12c.
• Proficient in shell and PL/SQL scripting to develop database administration tools for database protective maintenance, security, performance tuning, backup/recovery, SQL tuning.
• Extensive working experience with database migration experience involved in multiple platforms including AIX, Solaris to RHEL, database capacity planning, migration roadmap preparation and verification, performance evaluation and testing, storage analysis and space expectation, database design and optimization.
• Experience in configuring and monitoring OpCon for Application and Database servers.
• Very good exposure to Docker Technologies
• Worked extensively on DB and Application Patching and maintenance activities.
• Hands-on experiences in MySQL database administration, including design, development, implementation, migration, upgrading, maintenance and production support of complex database applications and huge data warehouse system

PROFESSIONAL EXPERIENCE

Sr. Oracle Financials DBA

Confidential, Irving TX

Responsibilities:

• Worked on Upgrading Oracle EBS databases and GI to 12c.
• Worked on Oracle E-Business Suite 12.1.3 Application.(Patching, Cloning)
• Added a Database node to a cluster for loading balancing and HA.
• Working on WebLogic patching and Administration.(FMW)
• Enabled TDE for EBS databases.
• Working with Oracle on benefits and POC on our Production Database Migration to Engineered systems.(Exadata X-7)

Environment: Oracle Database 11.2.0.4, 12.1, SAN, NAS, Oracle E-Business suite 12.1.3. OEM 13c

Sr. Oracle DBA/ Exadata DMA

Confidential, Plano TX

Responsibilities:

• Upgraded 3 node RAC Databases from 11.2.0.4 to 12.2.0.1 on Linux platforms.
• Successfully reconfigured NTP Servers on ILOMS, Cell Nodes, Compute nodes and IB Switches of EXADATAs (X2, X5, X6-2)
• Successfully applied the OMS Patches for Big Data Appliance Discovery.
• Successfully configured Dataguards(RAC) on new versions of Exadata(X6) for switchover as primary.
• Successfully Switched over all the production databases from Exadata X2(Quarter RACK) to Exadata X6( Eight RACK)
• Administering Exadata Cell Disks/Grid Disks for Disk health.
• Migrating databases from non-engineered systems to Exadata Machines.
• Daily maintenance checks, Backup validations, OEM12c Cloud Control Monitoring, Capacity Management.
• Activity monitoring Cloudera Manger for components of Hadoop Eco System( Yarn, HDFS, Zookeeper)
• Performing a comprehensive health check of Exadata Database Machine using EXACHK report.
• Replacing and configuring disks on Exadata Storage Servers and Big Data Appliance(Oracle BDA) in case of disk failures.
• Configured and Discovered Oracle Exadata(X6-2) whole RAC to EM 12c Cloud.
• Disk firmware upgrades on Exadata Compute Nodes.

Environment: Oracle Exadata X2-2, X5-2, X6-2 Half Rack, Oracle Database 11g, 12c, SAN, NAS, ISILON, Oracle Big Data Appliance(BDA), Cloudera Enterprise 5.9.0

Sr. Oracle Exadata DBA/ App DBA

Confidential, TX

Responsibilities:

• Installed and configured a 3 node RAC Database on Solaris 11 and Linux platforms.
• Resolution of day to day related issues, documentation of Oracle Apps DBA and DBA routine tasks
• Database platform migration from IBM-AIX to Solaris operating system using RMAN in Sun Super Clusters (T4-4) box.
• Identify training needs within support organization and proactively create and deliver training sessions to address these requirements.
• Hands on Experience in working on Shared and Non Shared APPL TOPS
• Configuring, maintaining and troubleshooting Exadata Cell Disks/Grid Disks
• Migrating databases to Exadata
• Maintaining Exadata Hardware
• Upgrade of E-Business Suite from 11i to R12.
• Execute the collection of requirements, product comparisons, product research, and architecture
• Implemented RDS protocol to be used over InfiniBand for low-overhead, low-latency and high-bandwidth.
• Maintenance of Oracle Applications using ad utilities like Autoconfig, adpatch, adop, adadmin etc.
• Cloning from single node to multi-node and multi-node to single node.
• Expert in using ADRCI to collect the data into an intermediate logical structure..
• Experienced in performing a comprehensive health check of Exadata Database Machine using EXACHK report
• Creating documentation during project planning, project execution and project maintenance phases.

Environment: Oracle E-Business 12.1.3, 12.2.4 Oracle Exadata X3-2 Half Rack, Oracle Database 10g, 11g, 12c, MS SQL Server 2005, SAN, MySQL, Postgres Grid Control, Shell Scripts, Linux 5.4, SSC, OpCon

Oracle Exadata DMA/DBA

Confidential

Responsibilities:

• Installed and Configured Oracle Database 11g and Grid 12.1 on Oracle Exadata X5-2 Database Machine.
• Successfully migrated Oracle Databases from Oracle Exadata V2 Half Rack to Oracle Exadata X4-2 Quarter Rack.
• Strong experience on Patching Oracle Exadata Database Machine components like Storage Server, Database Server, Infiniband.
• Installed and Configured Oracle 12c OEM and EM Agents and deployed Oracle Exadata Database Machine for monitoring.
• Strong experience on Monitoring and Troubleshooting Exadata Related Issues.
• Migration of Oracle 10g database to the Exadata X4-2 Database Machine.
• Resolved DR sync issues and maintained Standby stability.
• Completed the EPM activity on both X4-2 Exadata machines successfully.
• Implemented HCC on Exadata X4 -2 Database Machine..
• Provided recommendations for X4 Implementation and Configuration.
• Maintained High Availability even during acute hardware issues.

Environment: Oracle 4 Node RAC Databases 12c,11g on Exadata Machine X5-2, 12c OEM, Solaris, Oracle Linux 6, NetApp Storage, ZFS

Sr. Oracle Apps DBA/DBA

Confidential

Responsibilities:

• Provide technical leadership to the Applications Support Team, Developers and System Admins.
• Guided and mentored team members to support all production databases.
• Plans, coordinates and implements database management software installations and upgrades
• Performed and taken care of various node eviction issues
• Ensuring regular RMAN backups are in place
• Maintenance of Oracle Applications using ad utilities like Autoconfig, adpatch, adadmin etc.
• Application of CPU Patches, Application Patches and Database PSU patches
• Application of ATG RUP7, HRMS Family Pack, DST & Extended baseline patches
• Monitoring Concurrent Manager & its operations like starting, stopping the concurrent managers
• Monitoring the Oracle Applications threw OAM and Troubleshooting the issues
• Validating & Recreating grants & synonyms on Apps schema, Performed jar file/forms generation
• Monitoring, identifying and resolving user issues and gave support to development teams in general troubleshooting
• Upgradation of database from 10g to 11g to 12c and applying patches whenever required
• Cloned oracle production databases for development and testing
• Cross platform Migration of databases using export/import and datapump
• Daily health checkup of databases
• Cloning of Oracle Applications for Multi-node and Single-node instances.
• Configuring, maintaining and troubleshooting Exadata Cell Disks/Grid Disks
• Maintaining Exadata Hardware (Complete RACK)
• Created physical standby databases.
• Setup and maintained Golden Gate for oracle to oracle replication.
• Configuration of Oracle Disaster Recovery Solution (DR) from Production Server to the DR Server
• Resolution of day to day related issues, documentation of Oracle DBA routine tasks
• Creating documentation during project planning, project execution and project maintenance phases.
• Installed and modified the pgAdmin3 tool for postgreSQL from RPM and Source Code

Environment: Oracle RAC Database 11g,10g on Exadata Machine X2, 12c OEM, Solaris, Oracle Linux 6, NetApp Storage, ZFS

Database Engineer

Confidential

Responsibilities:

• Installed and configured the OEM 12C on Linux server.
• Configure the OEM12c agents in the servers and promote the databases across the server.
• Convert the stand alone database to RAC database in Sun Super Clusters (T4-4) server
• Provided 24 x 7 supports to maintain all Databases up and running in Production environment. In all there were more than 150 databases of Oracle and 40 of SQL Server
• Installed, configured and maintained Oracle 11g R2 on Linux also Upgraded from Oracle 10g to 11g Involved in implementing and managing Oracle 10g R2 RAC databases with ASM and enabled load- balancing feature client-server, server-server as Transparent Application Failover (TAF)
• Managing, troubleshooting and resolving RAC and application issues
• Configured and maintained Replication, Grid Control Repository and Deployed OMS Agents on different database servers
• Tested and Implemented different physical and logical Backup and Recovery methods like point in time, Media recovery, Full/partial export/import.
• Implemented new clusters to use Oracle 10g/11g RAC on HP-UX and Linux.
• Converted 1 node non ASM to 2 node RAC ASM using Data Guard
• Build and configure physical standby Data Guard as a high availability solution.
• Implemented and maintained full, incremental and cumulative RMAN back up’s on NAS storage
• Tuning SGA, I/O Tuning, Identifying contention, waits and tuning
• 24*7 production support and monitoring to ensure proactive problem recognition and resolution of various issues related
• Installed and configured a 2 node RAC databases on Solaris 11 and Oracle Linux 6.
• Performed and taken care of various node eviction issues
• Upgradation of database from 10g to 11g and applying patches whenever required
• Cloned oracle production databases for development and testing
• Cross platform Migration of databases using export/import and datapump
• Configuration of Oracle Disaster Recovery Solution (DR) from Production Server to the DR Server
• Resolution of day to day related issues, documentation of Oracle DBA routine tasks

Environment: Oracle 2 node RAC Database 11.2.0.4, 10.2.0.3, Solaris, AIX, Windows, Oracle ZFS

Oracle DBA/Oracle Apps DBA

Confidential

Responsibilities:

• Provided day-to-day operation DBA/APPS DBA support
• 24*7 production support and monitoring to ensure proactive problem recognition and resolution of various issues related
• Installed and configured a 2 node RAC on Solaris 11
• Configuration of Oracle Disaster Recovery Solution (DR) from Production Server to the DR Server
• Resolution of day to day related issues, documentation of Oracle DBA routine tasks
• Creating documentation during project planning, project execution and project maintenance phases.
• Supporting Exadata Systems, SUN Sparc Servers, Sun Blade Servers
• Maintenance of Oracle Databases as per the requirement
• Created databases for test and development
• Applying Patches, Patch sets to the existing RAC instances
• Experience in configuring ASM Disks & ASM database creation.
• Performing Maintenance task using AD Utilities
• Import and Export of user’s data across schemas and databases
• Frequent interaction with Developers, and working with them in developing the applications
• Changing Application user passwords using FNDCPASS utility as per need.
• Taking Physical and physical Incremental Backups using RMAN (Cold and Hot).
• Running ADCONFIG utility to maintain ORACLE APPLICATION
• Monitoring the scheduled backups, and referring the backups in case of failures

Environment: Oracle 4 node RAC Database 11.2.0.3, 10.2.0.3, Linux, AIX, Windows, Oracle ZFS

Oracle DBA

Confidential

Responsibilities:

• 24*7 production support and monitoring to ensure proactive problem recognition and resolution of various issues related
• Created instances and databases with appropriate initialization parameters and database structures
• Installed and configured Data Guard using physical-standby for high availability and reporting
• Performed and taken care of various node eviction issues
• Partitioned large tables and created indexes to improve the performance
• Ensuring regular RMAN backups are in place
• Configured tnsnames.ora, listener.ora for sqlnet.ora and connectivity
• Upgradation of database from 9i to 10g and applying patches whenever required
• Cloned oracle production databases for development and testing
• Cross platform Migration of databases using export/import and data pump
• Daily health checkup of databases
• Making sure that proper RMAN backups are in place as part of a daily job
• Cloning of database from production to development and test databases using RMAN
• Resolution of day to day issues, and routine tasks
• Creating databases in MS SQL Server.
• Very good knowledge on SQL Server Components and Tools.
• Resolution of day to day related issues, adhering to the service level agreement
• Management of security, granting and revoking permissions to users or roles when required
• Resolution of day to day related issues, documentation of Oracle DBA routine tasks

Environment: Oracle 9i, 10g, 11g, Oracle EBS 11i, RHEL 5, 6, Windows, Exadata, Solaris 10, 11, MS SQL SERVER