EXPERIENCE SUMMARY:

• Expertise in Oracle EBS R12.2.4/R12.1.x/11i, Oracle database 9i/10g/11g/12c, Oracle Application Server 10g installations, upgrades, patching (11i & ADOP), cloning, troubleshooting, performance monitoring and tuning, Confidential and User Security management.
• Hands - on experience in installation and administration of Fusion Middleware 10g/11g including SOA, WebLogic 10g/11g/12c, OID, OHS 11g, SSO integration with EBS 11i.
• Strong understanding of RDBMS concepts, normalization, Oracle Database 12c/11g/10g/9i architecture, OLTP and Data Ware-house concepts (OLAP) & solutions.
• Hands-on experience in Oracle database installation and upgrades, database design, OPatch, PSU patching, migration, Tablespace management, partitioning, index management etc.
• Experience in Oracle Database Administration (DBA), Oracle RAC, Performance Tuning, Security Administration, Replication, Distributed Databases, Enterprise Manager, Database Design, Data Modeling, PL/SQL, Pro*C, C, UNIX, NT, Shell Scripting.
• Hands-on experience in implementation and configuration of Physical standby database 10g and Oracle Active Data guard 11g, Data guard broker, Active-Active and active-passive setups.
• Experience as an ORACLE DBA with 12c, 11g and 10g on different UNIX environments like AIX, Sun Solaris, Linux, HP-UX, and Windows 2000/NT.
• Proficient in Backup/Recovery using RMAN, Flex clone, Snapshot, Commvault, data pump, transportable tablespaces.
• Experience and proficient with Oracle Grid Control 12c/13c, RMAN and Data Guard. Proficient with Oracle 12c/11G database features.
• Handled Administration of SQL Server 7.0, SQL 2000, SQL 2005, and SQL 2008, Migrated Data from SQL Server to Oracle, Migrated Data from SQL Server/Oracle to Confidential Web Services (AWS) cloud platform.
• Hands on experience in Oracle 10g/11g RAC administration.
• Worked on Oracle Enterprise Manager (OEM 11g/12c) installation and configuration.
• Good experience in Performance tuning using native SQL tools, TOAD, EXPLAIN PLAN, SQLTRACE, Confidential, Confidential, AWR and ADDM.
• Experience in MS SQL Server 2005/2008/2012 administration, Confidential, backup and restore.
• Strong working experience with Relational Database Management Systems (RDBMS) like Oracle, SQL Server, MS SQL, MySQL, PostgreSQL, and DB2…etc. and NOSQL Databases like MongoDB, Cassandra, Dynamo DB…etc.
• Strong exposure to OBIEE 10.1.3, Hyperion 9, Informatics, Business Objects, Agile administration, patching and Confidential activities.
• Hands-on experience in installation and administration of Astea, Cast-iron, Synchro, Clear Orbit.
• Conceptual knowledge of Golden Gate 11g.
• Experience of Installing, Upgrading, Patches, TAR support. Duties included database creation, tuning/reorganization, cloning, backup/recovery, user and security management, auditing, general troubleshooting, and configuring servers.
• Strong in Unix Shell Scripting, Perl Scripting, PL/SQL Development and procedures.
• Good knowledge in Configuring Golden Gate unidirectional and bi-directional, Oracle RAC Administration with ASM, Data guard and Golden gate setups and Implemented Bi-directional replication between Oracle-Oracle Golden Gate setup.
• Expertise in Oracle Enterprise Manager (OEM), Grid Control and configuring metrics and alerts, Management of schemas, objects &Partitioning the tables & indexes, AWR, ADDM and 10g OEM Grid Monitoring.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN with VERITAS Net Backup & IBM TSM.
• Experienced in using 11g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, Recycle Bin.
• Experience in Upgrade and Migration of oracle database to higher version and other platforms using Oracle Data Migration Assistant and Migration of oracle database to cloud platform like Confidential Web Services (AWS).
• Clear understanding of Operating Systems (Linux, AIX, Windows, Solaris), Client/Server Architecture, Middleware and storage technologies (Servers, SAN, NAS)
• Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning, Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, Confidential, Confidential, SQL TRACE, ORADEBUG, 11gOEM Grid Monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
• Experienced in Oracle Support processes for technical requests through Metal ink and other Support Procedures
• Good experience in SQL, PL/SQL, Shell Scripting, Perl Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Proficient in Oracle 11g R2, 10g R2, 10.1.0.x design, installation, administration, management, performance tuning, upgrades, disaster recovery strategies, and high-availability solutions on Sun Solaris 10, 9, 8, HP Unix 11.x, Red hat Enterprise Linux 4.0, Windows-2003, Windows-2000, Windows NT 4.0 environments.
• Experience in design, deployment, administration, management of Disaster Recovery solutions, proficient in Business continuity and High availability solutions, using Data-Guard, RAC, ASM and RMAN.
• Expert with planning, creation, administration, and troubleshooting of ORACLE 12c/11g/10g OLTP (multiple instances)/OLAP databases in production.
• Strong knowledge in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and BIDIRECTIONAL REPLICAT issues.
• Hands on experience with Installation, Configuration, Migrations, Oracle Data Guard, Backup and Recovery using RMAN, Disaster Recovery and Patching, upgrading and administering 6 Terabytes of Oracle Database on Oracle 12c/11g/10g/9i.
• Provided 24*7 project and operational support for multiple ERP/Non-ERP applications in production and non-production environments.
• Knowledge on 12c PDB and Non PDB databases administration, shell scripting, PL/SQL Development and Oracle Application Express.
• Extensive services in Core Database Administration, Grid/Cloud computing, Virtualization, High Availability, Performance, Disaster Recovery, Migration, Data Modeling, Data Analysis, Business analysis and Management in Banking, Financial, Telecom and Data Services domains.
• Collaborated with cross functional teams to design key technical solutions. Experience in Requirement Analysis, Project Management, Reporting, Audit/SOX activities.
• Managed on-site and offshore teams. SPOC for all DBA activities.

TECHNICAL SKILLS:

Hardware/OS: MS Windows (95/ 98/ 2000/ XP/ Vista/ NT),IBM AIX 5/ 6, Linux (Red Hat, Ubuntu, SUSE, Fedora, Debi an, Mint), Sun Solaris, HP-UX, IBM RS 6000 servers, Sun spark E 4500/ 5000/ 450 with EMC symmetric 8530, Raid 1 disk storage, HP 9000/ E39, DELL Edge 2550/ 4500

Applications: Oracle Apps EBusiness Suite R12.2.4/ R12.1/ 11i, GRC 8.6.5 (AACG 8.6.5 & PCG 7.3) FWM 10g/ 11g, SOA, WebLogic 10g/ 11g, Discoverer 11g/ 10g, 10gAS, OID, Oracle Data guard 10/ 11g, Apex, OBIEE 10.1.3, Hyperion 9, Informatics, Business Objects, Agile, Astea, Cast-iron, Synchro, Clear Orbit

Networking: TCP/IP, UDP, OSI, DHCP, LAN, WAN

Databases: Oracle 9i/10g/11g/12c, SQL Server 2005/08/12/14 , MS SQL, MySQL, PostgreSQL, DB2, MongoDB, Cassandra, Dynamo DB, Exudate, AWS RDS

DB Dev: Toad, SQL Navigator, SQL Developer, PL/SQL Developer

Database features: Replication, Streams, ASM, PQO, AWR, Partitioning, RMAN, Oracle Text, Oracle Spatial, Internals, OEM, Grid Control, Cloud Control

Data Modeling: ERWin

Languages/Scripts: C, Java/J2EE, SQL, PLSQL, UNIX Shell Scripting, Perl

Database Tuning Tools: Confidential, EXPLAIN PLAN, Confidential, AWR, ADDM, ASH, SQL Trace, SolarWind

High Availability: Oracle RAC, Active Data Guard, Golden Gate

BI Tools: Micro strategy, plunk, MS SSRS, MS SSAS, Oracle OBIEE

ETL tools: OS Talen DI, Data Junction, Informatics, SSIS, DTS

Tools: SQL, Quintana, CVS, VSS, VNC, OEM 11g/12c, OEM 12c Release5, DB Artisan, SQL* Loader, Crystal reports, Informatics 7, Congo’s, Toad, BMC Patrol, Oracle grid control, Cloning, Migrations, Export/Import, Query Builder

Servers: IIS Server, Apache Tomcat Server

Cloud/Virtualization: Confidential Web Services (AWS), Google Cloud, Windows/ Microsoft Azure Cloud, Rackspace Cloud, Cloud Foundry

AWS Services: EC2, S3, VPC, RDS, Aurora, Glacier, Auto Scaling, Cloud Watch, Dynamo DB, EBS, ELB, Lambda, Redshift, Migration, IAM, Cloud Formation, Cloud Trail, Cloud Front, OpsWorks

Storage: Veritas, Compaq SAN, Tape library, SCSI/SATA DAS, NAS, Cloud Storage

Testing Tools: Win Runner, Load Runner, Microsoft Test Manager

PROFESSIONAL EXPERIENCE:

Confidential, Fort Worth, TX

Sr. Oracle Database Administrator

Responsibilities:

• Worked closely with Architect, PM and offshore team to decide the database size, tablespace layout, init parameters, database growth and help in database process like refresh, cloning, data loading etc.
• Involved in the Design of Backup and Recovery Strategies using RMAN, and Configuring Oracle Data Guard.
• Setup Oracle Streams and Golden Gate for Site to Site Replication.
• Migrated Oracle Databases from 11G to 12c, Installed and migrated OEM 11g to OEM 12c, 13c.
• Database performance tuning in order to improve application and database performance give recommendation to application team e.g. Index Scan or Full table scan. Run ADDM, AWR report etc.
• Worked with NetApps Snap Manager for Backup and Recovery for the database.
• Troubleshoot critical issue on call like resolving ORA errors in production, check alert log file, trace file etc.
• Installation and Configuration of Oracle 12c Rel1 & Rel 2,11g Real Application Clusters (RAC) on different nodes with Automatic Storage Management (ASM), GPFS File system and VERITAS Cluster File system to support large volume.
• Strong expertise in performance tuning, backup recovery, Architecture, Capacity Planning and troubleshooting.
• Performed role switchover in Exadata RAC environment with Golden Gate HA running on the servers.
• Familiar with calculi command line interface in Exadata environments
• Troubleshooting Exadata smart scan/offloading issues and experience working with Exadata Storage Server software, managing cell disks, grid disks and ASM disks.
• Configured RMAN backups in OEM and corn for development databases along with scheduling weekly full backups, Daily Incremental and Archive log backups.
• Cloned environments to create patch test, development and Stage environments
• Created and monitored Virtual Private Database (VPD) policies for securing sensitive data in PI tables
• Installed and configured Oracle Audit Vault and Database firewall in non-production environment as a proof of concept
• Involved in AWS VPC design, Cloud formation scripts, AMI, Consolidated Billing for multiple AWS accounts, Design Audit compliance through Trusted Advisor, and Design logging framework for cloud watch for all deployed apps.
• Backup and Recovery - Taking Hot Backup, Cold Backup, Data pump, Export, Import, Incremental backups and recovery scenarios.
• Involved in designing and deploying a multitude applications utilizing almost all of the AWS stack
• Migrated the current Linux environment to AWS/RHEL Linux environment and used auto scaling feature
• Install and configure chef server/workstation and nodes via CLI tools to AWS nodes
• Database Performance checks using Oracle OEM Grid Control, BMC Patrol, Quest DBA Expert and scripts help to design a database and database size and configure Database parameter according to requirements of the application.
• Installed and administered knowledge modules for BMC Patrol monitoring of Oracle databases and UNIX servers.
• Worked on Database 11G, 12C. Worked on almost all different flavors of an OS like AIX, SUN Solaris, Linux, Win NT etc.
• Setup OMS server for 12c grid control to monitor various database and server load and do the performance tuning.
• Setup all Database environments like DEV, QA, UAT, and Production.
• Used UNIX Shell Scripting, Perl scripting.
• Help customer in deployment process, like data loading process, oracle partitioning, help customer to take an advantage of partitioning.
• Designed logical and physical Data Models using ERWIN forward-engineered into DDL and executed on large scale to create database.
• Responsible for Build Work in various servers which has 2 Node RAC & Non - RAC, High Availability, Golden Gate Technologies.
• Install, Configure and Automate Active Standby/Data Guard for the production billing Oracle server
• Setup Alerts to DBA Manager, Stats report on space metrics, availability daily.
• Tune and optimize PL/SQL procedures and packages.
• Help customer with their query related problem and give a physical DBA support 24/7.
• Migration activities like moving from DEV to production, Clone the database for testing purpose.
• RMAN Hot Backups Using Catalog and No catalog.
• Performance Tuning Using 10G Grid control, Stats pack, Explain plan, SQL Trace, Confidential .
• Identify problem using ADDM and 11g Grid control.
• Projects and 24/7 production support Remote and at onsite.

Environment: Linux (RHEL), Windows, Unix, AIX, SUN Solaris, Windows NT/Servers, AWS, VPC, AMI, Erwin, Golden Gate, ExaData, VPD, RMAN, OEM 11g/12c/13c, Quest DBA Expert, Oracle12c, 11g, Grid Control 12c, BMC Patrol, RAC, Non-RAC, PL/SQL, ADDM, AWR, ASM, GPFS, UNIX Shell Scripting, Perl, Rel 1/2, Grid control, Stats pack, Explain plan, SQL Trace, Confidential .

Confidential

Sr. Oracle Database Administrator

Responsibilities:

• Performed Oracle server software installation, database creation, system configuration and upgrades.
• Ensured the availability, performance and scalability of the production database infrastructure.
• Capacity planning, auditing, and database/application performance optimization.
• Performed backup/disaster recovery planning and execution.
• Implemented automation of ongoing administration and maintenance tasks.
• Tuned and improve application SQL code, database configuration parameters and system disk configurations.
• Recommend and enforced database best practices and standards.
• Generated UNIX shell and SQL /PL/SQL scripts.
• Designed and implemented backup and recovery strategies. Hot and cold backups were used. Also used RMAN, methods like PITR and full/ partial export/import and Data Pump.
• Configured and Maintained Physical Data Guard for High Availability and offline reporting.
• Installed oracle 10g Data Guard Physical Standby at DR site for production nodes.
• Maintained and monitored various production servers with Oracle 11g R1, 11g R2, and 10g.
• Upgraded oracle 10g databases to oracle 11g R1 (11.1.0.6, 11.1.0.7) and 11g R2 (11.2.0.2).
• Upgraded oracle RAC databases from 10g to 11g.
• Implemented RMAN Image Copy Backup Strategy for very large Databases in minimizing the downtime for recovery.
• Experience on working with Database Monitoring tool like TOAD. Responsible for upgrading Oracle 10g RAC to 11g RAC.
• Worked on Installation and maintenance of Oracle 11g, 12C RAC databases including Golden gate, ASM and CRS.
• Responsible for installation of Oracle Cluster ware (CRS) also referred as Grid Infrastructure from 11g and creating the RAC databases.
• Upgraded the RAC and standalone databases from 11g (11.2.0.2 and 11.2.0.3 and 11.2.0.4) as part of performance improvement by utilizing the new features.
• Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold).
• Provide 24/7 support for critical situations and took rotated on call coverage.
• Implementing upgrade, migration, security, management, performance tuning, backup & recovery, patch management, shell scripting, 24/7 technical support of Oracle 10.2.0.x, 10.1.0.x, 9.2.0.8, 9.2.0.7.0 databases, on UT,SIT,UAT,PROD environments.
• Responsible for installing and configuring Golden Gate 9.5 on Oracle Servers
• Responsible for upgrading Golden Gate 9.5 to Golden Gate 10.0.
• Scripts for Cold Backups, Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption)
• Installation and configuration of Oracle Client software and Tools, Also manipulating the various databases using different kind of automation tools like OEM, TOAD.
• Database monitoring using Grid control and BMC Patrol.
• Provide complete documentation on developed recommendations and solutions.
• Implemented migration plan to migrate Oracle Databases from HP to Solaris.
• Defined Validation process to validate migrated database.

Environment: Windows, Linux, AIX, Unix, Solaris, SQL, PL/SQL, Oracle (10g/11g), SQL Server 2000/2005/2008 , Golden Gate, HP-UX (11i), Solaris, Shell Scripting, Weblogic11g, BMC Patrol, Unix Shell Script, RMAN, RAC, TOAD, CRS, OEM.

Confidential, Wilmington, DE

Senior Oracle DBA

Responsibilities:

• Planning, Implementing and Validating various versions of Oracle Databases to 10g Release 2(10.2.0.1, 10.2.0.2 and 10.2.0.4)& 11g Release 2(11.2.0.2,11.2.0.3) install and upgrade on all the environments (in a procedural approach Dev, Test, Stage and Production) also Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 11gR2 upgrades.
• Checking Backup and Restore validity periodically on databases about 12TB in size, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups
• Responsible for installing, supporting the oracle stand alone, RAC (2node) and RAC (2node) with databases of the version 11g, 10g and 9i on AIX 6.1/5.3/5.2, Sun Solaris 10, and Windows 2008.
• Used Veritas Cluster File System (VCFS), ASM file system and SCAN LISTENER in installing Oracle 11g RAC and also installed oracle grid agents on standalone and RAC databases.
• Worked with maintaining the OCR and VOTING DISK in normal and external redundancies and also worked with cluster ready services (CRS) and used CRSCTL for maintaining CRS.
• Optimization and tuning SQL queries using TRACE FILE, Confidential, EXPLAIN PLAN. Extensive usage of ADDM, AWR, ASSM, features of 10g/11gR2.
• Worked on installing the data guard on RAC databases for disaster recovery and setup the broker.
• Tested the switchover on the RAC databases manually and also using broker.
• Worked on resolving the gap between primary and standby databases in by registering the missing archive logs in the standby database of about 8TB
• Worked on setting up the flashback and restore point on the databases and also flashbacked the databases to restore point when required.
• Worked with different utilities like broker ( Confidential ), Confidential, CRSCTL and Confidential .
• Configured OEM 12c Grid control to monitor database performance, SQL query tuning, create monitor block, and deployed plugins.
• Implemented and administered Oracle Golden Gate (v10) for Database Replication between production and reporting node.
• Performed Initial load, extract, replica, trial files and exporting data onto Repository Database using Golden Gate tool.
• Experience with Confidential, OCR and Voting Disk of 10g, 11g RAC.
• Database Maintenance, Data warehousing, and Data Modeling using Erwin.
• Prepared test environments for backup/recovery using RMAN and Recovering Databases when there is any physical or Logical Corruption.
• Involved & performed Production Change Requests for PRD major DB changes. New DB creation, Existing DB deletion, various DB Housekeeping activities.
• Kept tracking the database performance using oracle enterprise manager and checking the user’s sessions consuming more CPU and taken the necessary steps to reduce the CPU usage.
• Worked on refreshing the tables, schemas using exp & imp and also using expdp & impdp.
• Refreshed the databases from PROD to lower environments using RMAN.
• Performance tuning of oracle databases using SQL Access Advisor, SQL Performance Analyzer, SQL Tuning Advisor.
• Worked on DR tests using Data guard and VVR, resolved the issues during switch over and switch back.
• Migrated the databases from 9i and 10g to 11g from SunOS to AIX.
• Upgraded the databases from 9i and 10g to 11g and resolving the issues during upgrade.
• Worked on RMAN backup and recovery. Recovered the databases (full recovery) during database upgrade and point in time recovery as per the user request using RMAN.
• Created the blinks (private and public), synonyms (private and public) and views. Validated the views and compiled the views which are invalid.
• Have used different tools like DB Artisan (8.7.2), EXPLAIN PLAN, Confidential, and Confidential to solve the performance issues.
• Helped developer in installing Oracle Client, troubleshoot and establish the connection to Oracle database through JDBC.
• Responsible for monitoring the daily jobs and resolving and finding reasons for failed jobs.
• Responsible for creating the sizing documents for databases as per storage provided by application team. Documented all the necessary work for future reference
• Installed and administered SQL server 2000/ 2005/2008/2012 databases including migration from MS SQL server to oracle, MS SQL Server 2005, 2008 to 2012.

Environment: Solaris, Windows, UNIX, Linux, AIX, SunOS, Oracle 11g/10g, Oracle Golden Gate, RMAN, RAC, OCR, SQL, TRACE FILE, Confidential, EXPLAIN PLAN, ADDM, AWR, ASSM, Confidential, OCR, SQL Server, KPOF, Confidential, JDBC.

Confidential

Oracle Database Administrator

Responsibilities:

• Supported 100+ databases including RAC Production database, a Data warehouse database and lot of Development and Test databases.
• Primary DBA for 1GB - 2.5TB database for 24/7 support.
• Installed and configured Oracle 10g databases on HP-Unix 10.x and AIX 5.2.
• Installed and configured Oracle RDBMS on UNIX and Windows environments. Created primary database storage structures (table spaces etc.).
• Create and maintain Fusion, Oracle EBS Suite environments, DB templates, RAC environments,
• Involved in database administration including 10g RAC Database cloning, tuning, patching and monitoring concurrent manager processing.
• Creating data modeling for new developments using Erwin modeler.
• Initiated 10g new feature implementations such as Automatic Storage Management, Flashback features, DBMS Scheduler, ASMM to improve performance and manageability.
• Integrating Oracle Applications with OID/SSO.
• Setting up Physical Standby Database environment using Data guard in Oracle 9i and 10g.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Created Dimensional and Relational Physical & logical data modeling fact and dimensional tables using Erwin.
• Handling Golden Gate replication issues which are responsible for out of sync in Test environment.
• Created, Configured and Set up RMAN Catalog databases and registered target databases with the Catalog.
• Perform daily incremental backup and full weekly backup using Oracle backup utility RMAN.
• Migrated standalone databases on AIX/Solaris/Windows and file system to Linux RAC on ASM.
• Setup and configure Standby database (Physical & Logical) for high availability.
• Integrating Oracle Utilities Applications with Spatial GIS database.
• Oracle Database and Oracle Applications cloning/refresh.
• Assisted in integration of Exudate applications into current IT actionable events and solutions.
• Create and troubleshoot DB Link’s issues in Oracle for communicating with external databases.
• Done performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Managed undo segments, processes, memory, online redo log files, data files.
• Installed and Configured Oracle Applications e-business suite using Rapid Install.
• Integrated the backup status, reporting for the entire database in the enterprise to enable the web reporting using oracle, SQL, PL/SQL, UNIX shell scripting.
• Configured and installed one to one replication using Golden Gate between heterogeneous environments.
• Performing all daily maintenance tasks. Interacting with Oracle Customer service as and when required.
• Maintained documents of Oracle database operations. Prepared documentation of database backup and recovery standards.

Environment: HP-UNIX, AIX, Windows, RAC, DBCA, OEM Grid Control, Exudate, Data Guard, TOAD, SOA Suite 11.1.1.3, ASM, VERITAS Net Backup, RMAN, Solaris 10, Oracle E-Business Suite (EBS), Golden Gate, Confidential, SQL* Loader, SQL/PLSQL, UNIX Shell Script.

Confidential

Oracle Database Administrator

Responsibilities:

• Installed and configured Oracle Database Software 10g on Sun Solaris and Linux-4x, 5x.
• Upgraded the database from Existing Oracle 9i to Oracle 10g and Migration of database.
• Created Oracle partition tables and applied patches as per the requirements of the partitioning module and applied patches for DBMS software.
• Installed, configured and managed OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning.
• Configured initial and incremental load using Golden Gate.
• Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database.
• Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios using RMAN.
• Involved in NoSQL and relational data modeling.
• Installed, configured, supported and troubleshoot databases on VERITAS Cluster on top of Solaris 9.
• Worked with database export & import scripts to backup database structures and automation procedures.
• Monitored and troubleshot top CPU/memory consuming processes.
• Scheduling Automatic scripts for Golden Gate reboot.
• Performed Table space Management and Rollback table space Management.
• Provided maintenance of user accounts, privileges, profiles and roles.
• Converting single instance database to Real Application Cluster (RAC).
• Created Dimensional and Relational Physical & logical data modelling fact and dimensional tables using Erwin.
• Transaction Management and Security Management.
• Plan, coordinate, and implement network security measures.
• Supported Developers and end-users in troubleshooting issues.
• Provided System support for both development and 24*7production environments.

Environment: Sun Solaris 9, Linux-4x,5x, Windows, RAC, OEM, Oracle Streams, Golden Gate, RMAN, Stats Pack, SQL*Loader, SQL/PLSQL, ASM, Grid Control, Veritas.