SUMMARY:

• Over 2+ years of experience as an Oracle Database Administrator having hands on experience in database administration production support, installation, configuration, upgrades, backup and recovery, database security, cloning, migration, shell scripting and documentation, setting up and configuring Data - guard, replications using golden gate in high-availability environments.
• Providing DBA support to multiple Cluster, Non-cluster and ASM Database in production, development and Testing Servers on UNIX, Linux and Solaris Environments.
• Handful of experience in Oracle Installations, Upgrades, Patches, Critical Patch Updates (CPU) in various environment ranging from 10g/11g/12c.
• Excellent experience in Installation, administration and troubleshooting of Oracle 12c/11g/10g for OLTP (multiple instances)/ OLAP environment on Very Large or Highly Transactional Databases.
• Having Hands on experience working in both Application and Production support environment.
• Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager (OEM), TOAD, Oracle SQL Developer in various versions.
• Having good experience in configuring OEM 12C cloud control and monitoring databases using OEM 10g/11g/12c.
• Configuration and Management of Data Guard 10g/11g on RHEL, OEL and Sun-Solaris for Disaster Recovery.
• Expertise in setup/implementation/maintenance of Real-Application-Cluster (RAC) of 2/3 Node RAC on 10g/11g/12c.
• Installed and maintained Oracle 12c/11g/10g RAC with ASM & OCFS2 File systems.
• Experience of Oracle Golden Gate installation, configuration and troubleshooting Golden Gate Extract and Replicate issues.
• Performed Upgradation of databases from lower version (10g/11g) to higher version (12c).
• Implemented RMAN Backup and Recovery, Incomplete Recovery and disaster recovery using Data Guard.
• Have good experience in migrating data from Solaris, HP-Unix to Linux.
• Worked on disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental, cumulative backup and implementing backup and recovery strategies.
• System administration, Oracle Problem analysis & resolution and active cloning of databases between servers.
• Testing and implementing different physical (hot/cold), logical backup and recovery methods including point in time, media recovery, full/partial, and data pump export/import.
• Database refresh from production to QA, development and testing environments.
• Detecting and diagnosing production system performance problem by analyzing Oracle trace and log files, AWR, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• Experience in SQL Tuning, SQL Optimization, cost-based optimization and Hints.
• Set and tune System Parameters for MongoDB.
• Optimizing MongoDB CRUD Operations.
• Add / remove replica and shard nodes in MongoDB Cluster as needed.
• Setting up MongoDB Profiling to get slow queries.
• Proficient in raising TAR with Oracle Support and using Meta-link to resolve the bottlenecks in the database environments.
• Extensively used BMC Remedy, Pac 2000 ticketing systems.
• Worked proactively and gave 24/7 on-call production support and Weekend support for maintenance and server level patching.
• Good analytical and problem solving skills with ability to work independently and in a team environment.

TECHNICAL SKILLS:

Operating Systems: Red Hat Linux RHEL 3.x, 4.x, 5.x, 6.x, HP-UX 10.x, 11.x, Sun Solaris 9.0/10.0, AIX 5.1, 5.2

Data Bases: Oracle 12c/11g/10g, Oracle 12c, 11g/10g Real Application Cluster (RAC), ASM, MySQL, SQL SERVER 2008/2012, Mongo DB

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

Tools: RAC, OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, NETCA, DBCA, TOAD, Exadata, Patch Management, SQLNET, ODBC, Export/Import, Data pump, Data-Guard, Erwin, OEL, Log-miner, MS Visio, VERITAS Net Backup, BMC remedy, Pac 2000, VMware, Crontab

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR

Terminal Emulation: Putty, Telnet, FTP, TOAD

PROFESSIONAL EXPERIENCE:

Confidential, Belton, Tx

Oracle DBA

Responsibilities:

• Involved with installation and maintenance of Oracle 3 node RAC for high availability.
• Involved in change control process and Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.
• Worked extensively onmonitoring 10g/11g Grid Control and Configuration of error notifications, installing listeners, and adding them to the grid control.
• Involved in Migrating applications fromsingle instance databases to Exadata.
• Maintained 10g/11g RAC environment and troubleshooting issues.
• Responsible for implementing Load Balancing in RAC Database.
• Performed health checks in RAC instances.
• Having good experience in Migrating Single Instance database to RAC Environment.
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
• Involvement in space management, managed quotas.
• Performed Migration of databases 11gR2 on Unix to Oracle 12c on Linux.
• Involved in configuration of parameter files for extract process in primary and replica process in standby using Golden Gate.
• Installed Golden Gate for replication of database on 11gR2 RAC environment.
• Extensively used features such as Data Pump, Flash Back Recovery, ASM for Generating reports.
• Involved in 24x7 production database maintenance and on-call support.
• Conducted time-to-time analysis and monitoring of the software and hardware requirements and act accordingly.

Environment: Oracle 10g/11g, Linux, RMAN, Data Guard, Golden-Gate, Toad, Exadata, OEM, ASM

Confidential

Oracle DBA

Responsibilities:

• Worked under Sr. DBA to perform Oracle software installations.
• Served as key person in charge of ensuring full functionality of all Oracle databases and EBS instances.
• Installed patches, performed database version upgrades with the Sr.DBA support.
• Creating user accounts and appropriate privileges as well as maintaining Database security.
• Enabled the Database in Archive Log Mode / No archive log mode.
• Modifying the database structure, as necessary, to support activities of application developers
• Created Database storage structures Data Tablespace, Index Tablespace.
• Upgrade, patching Oracle databases.
• Experience in performing system backups and restoration using PL/SQL scripting.
• Involved in doing Hot, Cold backup with and without RMAN.
• Backups using export and import of schemas.
• Creation of development and test databases using export/import of full database.
• Managing user, resources and privileges.

Environment: Oracle 10g, PL/SQL, SQL Loader, TOAD, OEM, Linux, RMAN, Data Guard, ASM.