PROFESSIONAL SUMMARY:

• Extensive knowledge on database administration for Oracle 9i, 10g, 11g and 12c with experience in very large scale database environment and mission critical large OLTP and OLAP systems
• RAC Installation and Maintenance, setting up and configuring Dataguard, performing all kinds of Backups and Recoveries, Cloning databases.
• Hands on experience in Oracle 10g and 11g RAC implementation & administration (Oracle Cluster - ware setup and configuration, RAC Installation using ASM, Grid Installation.), Patching, RAC Backup, adding a node to this cluster database for High Availability and Recovery.
• Migrated Single Instance databases to RAC Environment.
• Extensive experience in Dataguard Configuration, Implementing and Maintaining Standby Databases.
• Sound knowledge of database patching (PSU, CPU, bugfix, Rolling patching) methods in RAC and non RAC DB’s.
• Good experience in UPGRADATION from 10.2.0.x to 11.2.0.x & 11.2.0.x to 12.1.0.x
• Installed and configured Golden Gate in a prod and non-prod env, configured extract, data pump and replicate.
• Standby/Failover Administration. Creating standby database, data guard and performing DR simulation.
• Have good knowledge about Physical and Logical structure of a database.
• Configured and Maintained RMAN Catalog Database and schemas and involved in registering the Databases to RMAN Catalog.
• Experience in Performance Tuning, Tuned various large critical OLAP and OLTP databases of Terabytes size using various tools like STATSPACK, AWR, SQL-TRACE, TKPROF, ADDM and Explain Plan Methods.
• Developed database monitoring/health checkup alerts for database uptime/downtime status, and sizing issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance and maintenance.
• Extensive knowledge in Database Backup and Recovery concepts using RMAN utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN).
• Experience in Database migration using tools like DATA PUMP, Export/Import and Transportable Tablespaces and RMAN Duplication.
• Cross platform migration 11g to 11g and 11g to 12c.
• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB, Flash-Back Technology, Log Miner.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) / Network Attached Storage (NAS).
• Experience in database cloning with RMAN, Database Refresh and Patch management.
• Used oracle configuration assistants like Database Configuration Assistant (DBCA) for creating databases, Database Upgrade Assistant (DBUA) for upgrading databases and Network Configuration Assistant (NETCA) for creating a Listener, TNS names to establish a Client-Server environment.
• Experienced in maintaining databases on large Production, Testing and DEV environments.
• Experience as On-Call 24x7 production DBA support, application/development DBA.
• Proficient in working with Oracle Support and using Meta-link to resolve the bottlenecks in the database environments.
• Up-gradation and patching of oracle home for SAP DB’s.
• Accountable for Database Servers Administration including DB binaries installation, post installation and troubleshooting. Supporting more than 200 Database’s, as primary DBA, including both Production and Development ranging from 500 GB to 90TB.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery.
• Cloning and refresh of Oracle Database.
• Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.
• Good work exposure on Remedy/Innotas, a ticketing tool for Incident / Request / Change Tickets.
• Good Analytical and Strong interpersonal and excellent communication skills
• Excellent oral and written Communication skills, co-ordination and Communication with system administrators, business data analysts and development teams

TECHNICAL SKILLS:

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

Data Bases: Oracle 12c/11g/10g/9i, Oracle 12c, 11g Real Application Cluster (RAC),ASMLanguages: SQL, PL/SQL, UNIX Shell Scripting

Tools: /Utilities: RAC, SQL* Loader, ASM, Export/Import, RMAN, NETCA, DBCA, TOAD,, Patch Management, SQLNET, Export/Import, Data pump, Data-Guard, VERITAS Net Backup, OEL, BMC remedyTuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

PROFESSIONAL EXPERIENCE:

Confidential, Richardson

Sr. Oracle DBA

Responsibilities:

• Installed Oracle DB 10g, 11g RDBMS, RAC on ASM, Applying Oracle Critical patch updates, Implementing and Managing Data Guard, Replication, Backup and Recovery support and performance tuning etc.
• Administration of Oracle 11g/12c RAC (2 Nodes) databases.
• Responsible for installation of Oracle Clusterware (CRS) also referred as Grid Infrastructure from 11g, and 12c Oracle Re-start (standalone grid Infrastructure) and creating the RAC and Standalone databases.
• Applying Quarterly patches and Version change patch bundles.
• Applied the Clusterware (GI), Database (RDBMS) Patches i.e. PSU patches and one-off patches (for Bug resolution) using opatch.
• Building Oracle Stand by databases, both Active Dataguard for real-time replication and normal Dataguard for disaster recovery also referred as BCP clone purposes.
• Worked on Disaster Recovery by converting physical standby databases to Snapshot standby database and opened in the read/write mode for testing purposes without interrupting the primary production database.
• Also tested disaster recovery with database failover and switchover also tested Golden gate (OGG) replication using DBFS Filesystem and ACFS for GG binaries.
• Responsible for Backup and recovery of the databases using RMAN Tool (Recovery Manager), and Database Flashback using GRP ( Guaranteed Restore Point ) and Export and Import (Datapump and Normal ) for restoring the specific objects at the database level.
• Upgraded the RAC and standalone databases from 10g (10.2.0.4 and 10.2.0.5) to 11g (11.2.0.2, 11.2.0.3 and 11.2.0.4). As part of performance improvement by utilizing the new features.
• Migration of databases from Non-ASM (filesystem also referred as Logical Volumes) to ASM i.e. Automatic Storage Management.
• Monitoring of databases using OEM 12c Grid Control.
• Closely Worked with Oracle support in identifying some long standing issues. Also extensively used oracle Metalink.
• Cross platform Migration of databases using Datapump, GG and TTS/XTT.
• Providing the Go-live and Post - go live Support for the database performance related issues and ensure that all the work is documented for future reference.
• Upgraded production and all test databases from Oracle 9.2.0.8 to 10.2.0.3 to 11.2.0.4 to 12.1.0.2
• Configuration of Oracle Standby Databases(Active Data Guard) for high availability /Disaster Recovery Solution from Production Server to the DR Server
• Experience on Oracle GoldenGate for data replication for enterprise data centers including installation, configuration, administration, performance monitoring.
• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.

Environment: Oracle 10g, 11gR1, 11gR2, Linux 5.5, RHEL, Sun Solaris, IBM AIX, DBUA, RMAN, RAC,ASM, Grid, Dataguard, Goldengate, Net-Backup, Team quest tool .

Confidential

Sr. Oracle DBA

Responsibilities:

• Installed Grid Infrastructure Software on new Linux Servers for 2 node and 3 node RAC and Failover environments and Oracle Grid Control (OEM) Installation.
• Migrated Non-ASM databases to ASM environment for high availability using RCONFIG.
• Worked in troubleshooting RAC and implemented ASM features.
• Addition and removal of nodes to RAC.
• Applied necessary Patches during installation and also in up-gradation of databases.
• Configured and tested backup and recovery using RMAN.
• Having good experience in user management, Table space Management, Session Management, undo Management issues.
• Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and disaster recovery databases.
• Involved and Upgraded Databases from 10g to 11g.
• 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.
• Closely Worked with Oracle support in identifying some long standing issues. Also extensively used oracle Metalink.
• Migrating databases from Aix to Exadata and c3 cloud
• Migrating on premises databases to Amazon RDS and EC2 using AWS DMS
• Monitoring AWS RDS databases using AWS cloud watcher and SNS
• Configuration of Oracle Standby Databases(Active Data Guard) for high availability /Disaster Recovery Solution from Production Server to the DR Server
• Worked on Active Standby Database and snapshot standby database
• Perform DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.
• Database refresh, schema refresh, database creation, Implement table partitioning
• Co-ordinate with application team and developers in resolving issues and prepare deployment plans
• Cloning of production database to the test environment using Recovery Manager (RMAN).
• Restoring the databases on the test server with the backed up files of live server.
• Provide support on production server to the clients after the live upgrade till the transition.

Environment: Oracle Database 11g, 10g, Golden Gate, AIX, Oracle Linux 6, RHEL, OEM, EMC Storage

Oracle DBA

Responsibilities:

• Involved in Installation and customization of Databases (11g &10g).
• Cloning of databases from production to test environments.
• Periodic data refresh from production to testing environments, Re-organizing database structures.
• Involved in Schema management, Table space Management, User Creation.
• Involvement in space management, rectification of lock problems, managed quotas for tablespaces as per needed.
• Implemented Data-Guard 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.
• Upgraded and applied patches as and when required. Database Refreshes from Prod to Dev. Troubleshooting Day-to-Day Users Issues in various modules.
• Evaluated the hardware requirements before upgrading/migrating the database.
• Good experience with recovery managed backups i.e. RMAN
• Cloning of Databases using RMAN.
• Scheduling the databases backup using Crontab.
• 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.

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